Name: EDW_COVID19.VW_EM_RESOURCE_FACT

Display Field: FACILITY_NAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• FACILITY_NAME ( type: esriFieldTypeString, alias: FACILITY_NAME, length: 100 )
• CFI_ID ( type: esriFieldTypeString, alias: CFI_ID, length: 100 )
• EMR_ID ( type: esriFieldTypeString, alias: EMR_ID, length: 100 )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, length: 100 )
• RECORDUID ( type: esriFieldTypeString, alias: RECORDUID, length: 100 )
• DATEINSERTED ( type: esriFieldTypeString, alias: DATEINSERTED, length: 100 )
• STATUS_LAST_UPDATED ( type: esriFieldTypeString, alias: STATUS_LAST_UPDATED, length: 100 )
• RESOURCE_LAST_UPDATED ( type: esriFieldTypeString, alias: RESOURCE_LAST_UPDATED, length: 100 )
• VENTSUPPLY ( type: esriFieldTypeString, alias: VENTSUPPLY, length: 100 )
• SURGMASKSUPPLY ( type: esriFieldTypeString, alias: SURGMASKSUPPLY, length: 100 )
• SHORTTEMP ( type: esriFieldTypeString, alias: SHORTTEMP, length: 100 )
• SHORTRT ( type: esriFieldTypeString, alias: SHORTRT, length: 100 )
• SHORTPHYS ( type: esriFieldTypeString, alias: SHORTPHYS, length: 100 )
• SHORTPHAR ( type: esriFieldTypeString, alias: SHORTPHAR, length: 100 )
• SHORTOTHLIC ( type: esriFieldTypeString, alias: SHORTOTHLIC, length: 100 )
• SHORTOTH ( type: esriFieldTypeString, alias: SHORTOTH, length: 100 )
• SHORTNURSE ( type: esriFieldTypeString, alias: SHORTNURSE, length: 100 )
• SHORTENVSVC ( type: esriFieldTypeString, alias: SHORTENVSVC, length: 100 )
• SHIELDSUPPLY ( type: esriFieldTypeString, alias: SHIELDSUPPLY, length: 100 )
• OTHRESPSUPPLY ( type: esriFieldTypeString, alias: OTHRESPSUPPLY, length: 100 )
• N95MASKSUPPLY ( type: esriFieldTypeString, alias: N95MASKSUPPLY, length: 100 )
• GOWNSUPPLY ( type: esriFieldTypeString, alias: GOWNSUPPLY, length: 100 )
• GLOVESUPPLY ( type: esriFieldTypeString, alias: GLOVESUPPLY, length: 100 )
• VENTS_IN_USE_TOTAL ( type: esriFieldTypeString, alias: VENTS_IN_USE_TOTAL, length: 100 )
• VENTILATORS_IN_USE_PEDIATRIC ( type: esriFieldTypeString, alias: VENTILATORS_IN_USE_PEDIATRIC, length: 100 )
• VENTILATORS_AVAILPEDWHOLEBED ( type: esriFieldTypeString, alias: VENTILATORS_AVAILPEDWHOLEBED, length: 100 )
• VENTILATED_PATIENTS ( type: esriFieldTypeString, alias: VENTILATED_PATIENTS, length: 100 )
• TRIAGEYELLOW_CAP ( type: esriFieldTypeString, alias: TRIAGEYELLOW_CAP, length: 100 )
• TRIAGERED_CAP ( type: esriFieldTypeString, alias: TRIAGERED_CAP, length: 100 )
• TRIAGEGREEN_CAP ( type: esriFieldTypeString, alias: TRIAGEGREEN_CAP, length: 100 )
• SWABS_XPORT_MEDIA_BURN_RATE ( type: esriFieldTypeString, alias: SWABS_XPORT_MEDIA_BURN_RATE, length: 100 )
• DT_SWABS_XPORT_MEDIA_BURN_RATE ( type: esriFieldTypeString, alias: DT_SWABS_XPORT_MEDIA_BURN_RATE, length: 100 )
• SWABS_TRANSPORT_MEDIA ( type: esriFieldTypeString, alias: SWABS_TRANSPORT_MEDIA, length: 100 )
• DT_SWABS_TRANSPORT_MEDIA ( type: esriFieldTypeString, alias: DT_SWABS_TRANSPORT_MEDIA, length: 100 )
• SURGICAL_MASKS_ON_HAND ( type: esriFieldTypeString, alias: SURGICAL_MASKS_ON_HAND, length: 100 )
• DT_SURGICAL_MASKS_ON_HAND ( type: esriFieldTypeString, alias: DT_SURGICAL_MASKS_ON_HAND, length: 100 )
• STAFF_ABSENTEE_PERCENTAGE ( type: esriFieldTypeString, alias: STAFF_ABSENTEE_PERCENTAGE, length: 100 )
• PPE_STATUS ( type: esriFieldTypeString, alias: PPE_STATUS, length: 100 )
• DT_PPE_STATUS ( type: esriFieldTypeString, alias: DT_PPE_STATUS, length: 100 )
• NHSN_NUMBER ( type: esriFieldTypeString, alias: NHSN_NUMBER, length: 100 )
• NEDOCS ( type: esriFieldTypeString, alias: NEDOCS, length: 100 )
• N95_MASKS_INVENTORY ( type: esriFieldTypeString, alias: N95_MASKS_INVENTORY, length: 100 )
• DT_N95_MASKS_INVENTORY ( type: esriFieldTypeString, alias: DT_N95_MASKS_INVENTORY, length: 100 )
• N95_BURN_RATE ( type: esriFieldTypeString, alias: N95_BURN_RATE, length: 100 )
• DT_N95_BURN_RATE ( type: esriFieldTypeString, alias: DT_N95_BURN_RATE, length: 100 )
• ICUOCCUPIED ( type: esriFieldTypeString, alias: ICUOCCUPIED, length: 100 )
• HOSPITAL_ONSET_COVID ( type: esriFieldTypeString, alias: HOSPITAL_ONSET_COVID, length: 100 )
• HOSPITAL_INPATIENT_BEDS ( type: esriFieldTypeString, alias: HOSPITAL_INPATIENT_BEDS, length: 100 )
• HOSPITAL_INPATNT_BED_OCCUPANCY ( type: esriFieldTypeString, alias: HOSPITAL_INPATNT_BED_OCCUPANCY, length: 100 )
• GOWNS_ON_HAND ( type: esriFieldTypeString, alias: GOWNS_ON_HAND, length: 100 )
• DT_GOWNS_ON_HAND ( type: esriFieldTypeString, alias: DT_GOWNS_ON_HAND, length: 100 )
• GOWNS_BURN_RATE ( type: esriFieldTypeString, alias: GOWNS_BURN_RATE, length: 100 )
• DT_GOWNS_BURN_RATE ( type: esriFieldTypeString, alias: DT_GOWNS_BURN_RATE, length: 100 )
• GOGGLES_ON_HAND ( type: esriFieldTypeString, alias: GOGGLES_ON_HAND, length: 100 )
• DT_GOGGLES_ON_HAND ( type: esriFieldTypeString, alias: DT_GOGGLES_ON_HAND, length: 100 )
• GOGGLES_BURN_RATE ( type: esriFieldTypeString, alias: GOGGLES_BURN_RATE, length: 100 )
• DT_GOGGLES_BURN_RATE ( type: esriFieldTypeString, alias: DT_GOGGLES_BURN_RATE, length: 100 )
• GLOVES_ON_HAND ( type: esriFieldTypeString, alias: GLOVES_ON_HAND, length: 100 )
• DT_GLOVES_ON_HAND ( type: esriFieldTypeString, alias: DT_GLOVES_ON_HAND, length: 100 )
• GLOVES_BURN_RATE ( type: esriFieldTypeString, alias: GLOVES_BURN_RATE, length: 100 )
• DT_GLOVES_BURN_RATE ( type: esriFieldTypeString, alias: DT_GLOVES_BURN_RATE, length: 100 )
• FACILITYSTATUS ( type: esriFieldTypeString, alias: FACILITYSTATUS, length: 100 )
• FACE_SHIELDS_BURN_RATE ( type: esriFieldTypeString, alias: FACE_SHIELDS_BURN_RATE, length: 100 )
• DT_FACE_SHIELDS_BURN_RATE ( type: esriFieldTypeString, alias: DT_FACE_SHIELDS_BURN_RATE, length: 100 )
• EOC_STATUS ( type: esriFieldTypeString, alias: EOC_STATUS, length: 100 )
• ED_OVERFLOW_VENTILATED_COVID ( type: esriFieldTypeString, alias: ED_OVERFLOW_VENTILATED_COVID, length: 100 )
• ED_OVERFLOW_COVID ( type: esriFieldTypeString, alias: ED_OVERFLOW_COVID, length: 100 )
• CURRENTFACILITYCENSUS ( type: esriFieldTypeString, alias: CURRENTFACILITYCENSUS, length: 100 )
• CENSUS_ED ( type: esriFieldTypeString, alias: CENSUS_ED, length: 100 )
• CAP_ADULTICU ( type: esriFieldTypeString, alias: CAP_ADULTICU, length: 100 )
• COVID_HOSP ( type: esriFieldTypeString, alias: COVID_HOSP, length: 100 )
• COVID19_DEATHS ( type: esriFieldTypeString, alias: COVID19_DEATHS, length: 100 )
• AVAIL_VENTSTOTAL ( type: esriFieldTypeString, alias: AVAIL_VENTSTOTAL, length: 100 )
• AVAIL_SNF ( type: esriFieldTypeString, alias: AVAIL_SNF, length: 100 )
• AVAIL_PSYCHIATRIC ( type: esriFieldTypeString, alias: AVAIL_PSYCHIATRIC, length: 100 )
• AVAIL_PEDS_NONMON ( type: esriFieldTypeString, alias: AVAIL_PEDS_NONMON, length: 100 )
• AVAIL_PEDS_MON ( type: esriFieldTypeString, alias: AVAIL_PEDS_MON, length: 100 )
• AVAIL_PICU ( type: esriFieldTypeString, alias: AVAIL_PICU, length: 100 )
• AVAIL_OPERATINGROOM ( type: esriFieldTypeString, alias: AVAIL_OPERATINGROOM, length: 100 )
• AVAIL_OB_LABOR ( type: esriFieldTypeString, alias: AVAIL_OB_LABOR, length: 100 )
• AVAIL_NURSERY ( type: esriFieldTypeString, alias: AVAIL_NURSERY, length: 100 )
• AVAIL_NEGFLOW ( type: esriFieldTypeString, alias: AVAIL_NEGFLOW, length: 100 )
• AVAIL_NICU ( type: esriFieldTypeString, alias: AVAIL_NICU, length: 100 )
• AVAIL_MEDSURGENONMON ( type: esriFieldTypeString, alias: AVAIL_MEDSURGENONMON, length: 100 )
• AVAIL_MEDSURGEMON ( type: esriFieldTypeString, alias: AVAIL_MEDSURGEMON, length: 100 )
• AVAIL_LTC ( type: esriFieldTypeString, alias: AVAIL_LTC, length: 100 )
• AVAIL_BURN ( type: esriFieldTypeString, alias: AVAIL_BURN, length: 100 )
• AVAIL_ADULTICU ( type: esriFieldTypeString, alias: AVAIL_ADULTICU, length: 100 )
• ALL_HOSPITAL_BEDS ( type: esriFieldTypeString, alias: ALL_HOSPITAL_BEDS, length: 100 )
• REMDESIVIR_USED ( type: esriFieldTypeString, alias: REMDESIVIR_USED, length: 100 )
• DT_REMDESIVIR_USED ( type: esriFieldTypeString, alias: DT_REMDESIVIR_USED, length: 100 )
• REMDESIVIR_REMAINING ( type: esriFieldTypeString, alias: REMDESIVIR_REMAINING, length: 100 )
• DT_REMDESIVIR_REMAINING ( type: esriFieldTypeString, alias: DT_REMDESIVIR_REMAINING, length: 100 )
• PREVHOSPONSET ( type: esriFieldTypeString, alias: PREVHOSPONSET, length: 100 )
• PREADMSUSPECT ( type: esriFieldTypeString, alias: PREADMSUSPECT, length: 100 )
• PREADMCONFIRMED ( type: esriFieldTypeString, alias: PREADMCONFIRMED, length: 100 )
• NUMNICUBEDSOCC ( type: esriFieldTypeString, alias: NUMNICUBEDSOCC, length: 100 )
• NUMCONFC19PREVDIED ( type: esriFieldTypeString, alias: NUMCONFC19PREVDIED, length: 100 )
• NUMCONFC19OVERFLOWPATS ( type: esriFieldTypeString, alias: NUMCONFC19OVERFLOWPATS, length: 100 )
• NUMCONFC19OFMECHVENTPATS ( type: esriFieldTypeString, alias: NUMCONFC19OFMECHVENTPATS, length: 100 )
• NUMCONFC19HOPATS ( type: esriFieldTypeString, alias: NUMCONFC19HOPATS, length: 100 )
• NUMCONFC19HONEWPATS ( type: esriFieldTypeString, alias: NUMCONFC19HONEWPATS, length: 100 )
• NUMC19ICUPATS ( type: esriFieldTypeString, alias: NUMC19ICUPATS, length: 100 )
• MORGUECAPUNITS ( type: esriFieldTypeString, alias: MORGUECAPUNITS, length: 100 )
• FACE_SHIELDS_ON_HAND ( type: esriFieldTypeString, alias: FACE_SHIELDS_ON_HAND, length: 100 )
• DT_FACE_SHIELDS_ON_HAND ( type: esriFieldTypeString, alias: DT_FACE_SHIELDS_ON_HAND, length: 100 )
• CAP_NICU ( type: esriFieldTypeString, alias: CAP_NICU, length: 100 )
• COVID_ICU ( type: esriFieldTypeString, alias: COVID_ICU, length: 100 )
• COVID_ADMITS_SEVERE_RESP ( type: esriFieldTypeString, alias: COVID_ADMITS_SEVERE_RESP, length: 100 )
• COVID_19_ADMITS ( type: esriFieldTypeString, alias: COVID_19_ADMITS, length: 100 )
• SURGICAL_MASKS_BURN_RATE ( type: esriFieldTypeString, alias: SURGICAL_MASKS_BURN_RATE, length: 100 )
• CUM_DIAG_TESTS_ORDERED ( type: esriFieldTypeString, alias: CUM_DIAG_TESTS_ORDERED, length: 100 )
• DCS_LAST_MOD_DTTM ( type: esriFieldTypeDate, alias: DCS_LAST_MOD_DTTM, length: 8 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata