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:

Name : OBJECTID

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:

Attributes:

Relationships:

• Facilities (0) -- Related To: Facilities (0)

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