Name: SDEADM.TblHspPatientStatus

Display Field: HPTNAME

Type: Table

Geometry Type: N/A

Description: null

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• MRN ( type: esriFieldTypeString, alias: Medical Record Number, length: 75 )
• HPTNAME ( type: esriFieldTypeString, alias: Hospital Name, length: 50 )
• HOSPITALIZED ( type: esriFieldTypeString, alias: Hospitalized, length: 7 )
• ADMISSIONDATE ( type: esriFieldTypeDate, alias: Date of Admission, length: 8 )
• HSPADMIT ( type: esriFieldTypeDate, alias: Admit Date, length: 8 )
• HSPADMITDIAGNOSIS ( type: esriFieldTypeString, alias: Admit Diagnosis, length: 150 )
• ONSETDATE ( type: esriFieldTypeDate, alias: Date of Onset, length: 8 )
• HSPDISCHARGE ( type: esriFieldTypeDate, alias: Discharge / Transfer Date, length: 8 )
• HSPDISCHARGEDIAGNOSIS ( type: esriFieldTypeString, alias: Discharge Diagnosis, length: 150 )
• PHYSICIANNAME ( type: esriFieldTypeString, alias: Physician/Infection Prevention Name, length: 150 )
• PHYSICIANFACILITYNAME ( type: esriFieldTypeString, alias: Facility Name, length: 150 )
• REPORTDATE ( type: esriFieldTypeDate, alias: Date of Report, length: 8 )
• PATIENTFACILITYNAME ( type: esriFieldTypeString, alias: Facility Name (If not living at home), length: 150 )
• HSPSTATUS ( type: esriFieldTypeString, alias: HSPStatus, length: 25 )
• UPDATEDATE ( type: esriFieldTypeDate, alias: Update Date, length: 8 )
• GENERALNOTES ( type: esriFieldTypeString, alias: General Notes, length: 255 )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )

Supported Operations:   Query   Query Attachments   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata