Name: Current_Occupancy_Details

Display Field: ISOLATION_WARD_ID

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• SNO (type: esriFieldTypeInteger, alias: SNO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISOLATION_WARD_ID (type: esriFieldTypeInteger, alias: ISOLATION_WARD_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QRO_OCCUPIED (type: esriFieldTypeDouble, alias: QRO_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QRO_CAPACITY (type: esriFieldTypeDouble, alias: QRO_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QRO_PROPOSED (type: esriFieldTypeDouble, alias: QRO_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QROH_OCCUPIED (type: esriFieldTypeDouble, alias: QROH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QROH_CAPACITY (type: esriFieldTypeDouble, alias: QROH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QROH_PROPOSED (type: esriFieldTypeDouble, alias: QROH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QRN_OCCUPIED (type: esriFieldTypeDouble, alias: QRN_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QRN_CAPACITY (type: esriFieldTypeDouble, alias: QRN_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QRN_PROPOSED (type: esriFieldTypeDouble, alias: QRN_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QRNH_OCCUPIED (type: esriFieldTypeDouble, alias: QRNH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QRNH_CAPACITY (type: esriFieldTypeDouble, alias: QRNH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• QRNH_PROPOSED (type: esriFieldTypeDouble, alias: QRNH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISO_OCCUPIED (type: esriFieldTypeDouble, alias: ISO_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISO_CAPACITY (type: esriFieldTypeDouble, alias: ISO_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISO_PROPOSED (type: esriFieldTypeDouble, alias: ISO_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISOH_OCCUPIED (type: esriFieldTypeDouble, alias: ISOH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISOH_CAPACITY (type: esriFieldTypeDouble, alias: ISOH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISOH_PROPOSED (type: esriFieldTypeDouble, alias: ISOH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISN_OCCUPIED (type: esriFieldTypeDouble, alias: ISN_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISN_CAPACITY (type: esriFieldTypeDouble, alias: ISN_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISN_PROPOSED (type: esriFieldTypeDouble, alias: ISN_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISNH_OCCUPIED (type: esriFieldTypeDouble, alias: ISNH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISNH_CAPACITY (type: esriFieldTypeDouble, alias: ISNH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ISNH_PROPOSED (type: esriFieldTypeDouble, alias: ISNH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICVC_OCCUPIED (type: esriFieldTypeDouble, alias: ICVC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICVC_CAPACITY (type: esriFieldTypeDouble, alias: ICVC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICVC_PROPOSED (type: esriFieldTypeDouble, alias: ICVC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICVH_OCCUPIED (type: esriFieldTypeDouble, alias: ICVH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICVH_CAPACITY (type: esriFieldTypeDouble, alias: ICVH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICVH_PROPOSED (type: esriFieldTypeDouble, alias: ICVH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICVR_OCCUPIED (type: esriFieldTypeDouble, alias: ICVR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICVR_CAPACITY (type: esriFieldTypeDouble, alias: ICVR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICVR_PROPOSED (type: esriFieldTypeDouble, alias: ICVR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICUC_OCCUPIED (type: esriFieldTypeDouble, alias: ICUC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICUC_CAPACITY (type: esriFieldTypeDouble, alias: ICUC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICUC_PROPOSED (type: esriFieldTypeDouble, alias: ICUC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICUH_OCCUPIED (type: esriFieldTypeDouble, alias: ICUH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICUH_CAPACITY (type: esriFieldTypeDouble, alias: ICUH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICUH_PROPOSED (type: esriFieldTypeDouble, alias: ICUH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICUR_OCCUPIED (type: esriFieldTypeDouble, alias: ICUR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICUR_CAPACITY (type: esriFieldTypeDouble, alias: ICUR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ICUR_PROPOSED (type: esriFieldTypeDouble, alias: ICUR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NIVC_OCCUPIED (type: esriFieldTypeDouble, alias: NIVC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NIVC_CAPACITY (type: esriFieldTypeDouble, alias: NIVC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NIVC_PROPOSED (type: esriFieldTypeDouble, alias: NIVC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NIVR_OCCUPIED (type: esriFieldTypeDouble, alias: NIVR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NIVR_CAPACITY (type: esriFieldTypeDouble, alias: NIVR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NIVR_PROPOSED (type: esriFieldTypeDouble, alias: NIVR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NICC_OCCUPIED (type: esriFieldTypeDouble, alias: NICC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NICC_CAPACITY (type: esriFieldTypeDouble, alias: NICC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NICC_PROPOSED (type: esriFieldTypeDouble, alias: NICC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NICR_OCCUPIED (type: esriFieldTypeDouble, alias: NICR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NICR_CAPACITY (type: esriFieldTypeDouble, alias: NICR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NICR_PROPOSED (type: esriFieldTypeDouble, alias: NICR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIVC_OCCUPIED (type: esriFieldTypeDouble, alias: PIVC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIVC_CAPACITY (type: esriFieldTypeDouble, alias: PIVC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIVC_PROPOSED (type: esriFieldTypeDouble, alias: PIVC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIVR_OCCUPIED (type: esriFieldTypeDouble, alias: PIVR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIVR_CAPACITY (type: esriFieldTypeDouble, alias: PIVR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PIVR_PROPOSED (type: esriFieldTypeDouble, alias: PIVR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PICC_OCCUPIED (type: esriFieldTypeDouble, alias: PICC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PICC_CAPACITY (type: esriFieldTypeDouble, alias: PICC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PICC_PROPOSED (type: esriFieldTypeDouble, alias: PICC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PICR_OCCUPIED (type: esriFieldTypeDouble, alias: PICR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PICR_CAPACITY (type: esriFieldTypeDouble, alias: PICR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PICR_PROPOSED (type: esriFieldTypeDouble, alias: PICR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DLSC_OCCUPIED (type: esriFieldTypeDouble, alias: DLSC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DLSC_CAPACITY (type: esriFieldTypeDouble, alias: DLSC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DLSC_PROPOSED (type: esriFieldTypeDouble, alias: DLSC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DLSR_OCCUPIED (type: esriFieldTypeDouble, alias: DLSR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DLSR_CAPACITY (type: esriFieldTypeDouble, alias: DLSR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DLSR_PROPOSED (type: esriFieldTypeDouble, alias: DLSR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PPCC_OCCUPIED (type: esriFieldTypeDouble, alias: PPCC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PPCC_CAPACITY (type: esriFieldTypeDouble, alias: PPCC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PPCC_PROPOSED (type: esriFieldTypeDouble, alias: PPCC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PPCR_OCCUPIED (type: esriFieldTypeDouble, alias: PPCR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PPCR_CAPACITY (type: esriFieldTypeDouble, alias: PPCR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PPCR_PROPOSED (type: esriFieldTypeDouble, alias: PPCR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PANC_OCCUPIED (type: esriFieldTypeDouble, alias: PANC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PANC_CAPACITY (type: esriFieldTypeDouble, alias: PANC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PANC_PROPOSED (type: esriFieldTypeDouble, alias: PANC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PANR_OCCUPIED (type: esriFieldTypeDouble, alias: PANR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PANR_CAPACITY (type: esriFieldTypeDouble, alias: PANR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PANR_PROPOSED (type: esriFieldTypeDouble, alias: PANR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CANC_OCCUPIED (type: esriFieldTypeDouble, alias: CANC_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CANC_CAPACITY (type: esriFieldTypeDouble, alias: CANC_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CANC_PROPOSED (type: esriFieldTypeDouble, alias: CANC_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CANR_OCCUPIED (type: esriFieldTypeDouble, alias: CANR_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CANR_CAPACITY (type: esriFieldTypeDouble, alias: CANR_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CANR_PROPOSED (type: esriFieldTypeDouble, alias: CANR_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LAST_UPDATE_TIME (type: esriFieldTypeDate, alias: LAST_UPDATE_TIME, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FORMATDATACOUNT (type: esriFieldTypeDouble, alias: FORMATDATACOUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FORMATDATA (type: esriFieldTypeDouble, alias: FORMATDATA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• APPROVALPENDING (type: esriFieldTypeDouble, alias: APPROVALPENDING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQRO_OCCUPIED (type: esriFieldTypeDouble, alias: PQRO_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQRO_CAPACITY (type: esriFieldTypeDouble, alias: PQRO_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQRO_PROPOSED (type: esriFieldTypeDouble, alias: PQRO_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQROH_OCCUPIED (type: esriFieldTypeDouble, alias: PQROH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQROH_CAPACITY (type: esriFieldTypeDouble, alias: PQROH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQROH_PROPOSED (type: esriFieldTypeDouble, alias: PQROH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQRN_OCCUPIED (type: esriFieldTypeDouble, alias: PQRN_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQRN_CAPACITY (type: esriFieldTypeDouble, alias: PQRN_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQRN_PROPOSED (type: esriFieldTypeDouble, alias: PQRN_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQRNH_OCCUPIED (type: esriFieldTypeDouble, alias: PQRNH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQRNH_CAPACITY (type: esriFieldTypeDouble, alias: PQRNH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PQRNH_PROPOSED (type: esriFieldTypeDouble, alias: PQRNH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISO_OCCUPIED (type: esriFieldTypeDouble, alias: PISO_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISO_CAPACITY (type: esriFieldTypeDouble, alias: PISO_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISO_PROPOSED (type: esriFieldTypeDouble, alias: PISO_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISOH_OCCUPIED (type: esriFieldTypeDouble, alias: PISOH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISOH_CAPACITY (type: esriFieldTypeDouble, alias: PISOH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISOH_PROPOSED (type: esriFieldTypeDouble, alias: PISOH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISN_OCCUPIED (type: esriFieldTypeDouble, alias: PISN_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISN_CAPACITY (type: esriFieldTypeDouble, alias: PISN_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISN_PROPOSED (type: esriFieldTypeDouble, alias: PISN_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISNH_OCCUPIED (type: esriFieldTypeDouble, alias: PISNH_OCCUPIED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISNH_CAPACITY (type: esriFieldTypeDouble, alias: PISNH_CAPACITY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PISNH_PROPOSED (type: esriFieldTypeDouble, alias: PISNH_PROPOSED, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Current_Occupancy_Details
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/20/2021 8:32:03 AM

Schema Last Edit Date: 10/20/2021 8:32:03 AM

Data Last Edit Date: 10/20/2021 8:32:03 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat