Name: Facility Status Report
Display Field: name
Type: Table
Has Views: true
Source Schema Changes Allowed: true
Views
Description:
Copyright Text: Esri
Max Record Count: 2000
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:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- name (type: esriFieldTypeString, alias: Name of Facility, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Closed: Closed], [Impacted: Impacted], [Open: Open])
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- facilityguid (type: esriFieldTypeGUID, alias: facilityguid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
- last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
- workoffice (type: esriFieldTypeInteger, alias: Number of staff working in the office, SQL Type: sqlTypeOther, nullable: true, editable: true)
- workremote (type: esriFieldTypeInteger, alias: Number of staff working remotely , SQL Type: sqlTypeOther, nullable: true, editable: true)
- essstaffonly (type: esriFieldTypeString, alias: Essential staff only?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- accessrest (type: esriFieldTypeString, alias: Access restricted?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- staffallow (type: esriFieldTypeString, alias: Staff allowed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- visitorallow (type: esriFieldTypeString, alias: Visitors allowed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- entstaff (type: esriFieldTypeString, alias: Entrance staffed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- buildsecure (type: esriFieldTypeString, alias: Building secured?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- openstate (type: esriFieldTypeString, alias: Status of working hours, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Normal: Normal], [Reduced: Reduced], [Suspended: Suspended])
- hoursop (type: esriFieldTypeString, alias: New hours of operations, SQL Type: sqlTypeOther, length: 600, nullable: true, editable: true)
- schtoclose (type: esriFieldTypeString, alias: Scheduled to closed?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- closedatetime (type: esriFieldTypeDate, alias: Closing date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- schtoopen (type: esriFieldTypeString, alias: Scheduled to open?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- opendatetime (type: esriFieldTypeDate, alias: Opening date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- adddetails (type: esriFieldTypeString, alias: Additional details, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- requirestay (type: esriFieldTypeString, alias: Are staff required to stay overnight?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- statuscomments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- govrestrict (type: esriFieldTypeString, alias: Are there any government restrictions?, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
- govrestdet (type: esriFieldTypeString, alias: Government restriction details, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- caretaker (type: esriFieldTypeString, alias: Who is checking on the property?, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- totalstaff (type: esriFieldTypeInteger, alias: Total staff accounted for, SQL Type: sqlTypeOther, nullable: true, editable: true)
- workabsent (type: esriFieldTypeInteger, alias: Number of staff absent, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Facility Status Report
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Relationships:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 3/28/2020 1:30:46 AM
Schema Last Edit Date: 3/28/2020 1:30:46 AM
Data Last Edit Date: 3/28/2020 1:30:46 AM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Related Records
Add Features
Update Features
Delete Features
Apply Edits
Calculate
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat