Name: Current Staffing Matrix

Display Field:

Type: Table

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

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: FID

Unique ID Field:

Name : FID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• Shift_ (type: esriFieldTypeString, alias: SHIFT, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Full_Compliment (type: esriFieldTypeInteger, alias: FULL COMPLIMENT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Short_Term_Sick (type: esriFieldTypeInteger, alias: SHORT TERM SICK , SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Medium_Term_Sick (type: esriFieldTypeInteger, alias: MEDIUM TERM SICK, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Long_Term_Sick (type: esriFieldTypeInteger, alias: LONG TERM SICK, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• WorkSafe (type: esriFieldTypeInteger, alias: WORKSAFE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Bereavment (type: esriFieldTypeInteger, alias: BEREAVMENT, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Family_Leave (type: esriFieldTypeInteger, alias: FAMILY LEAVE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Vacation (type: esriFieldTypeInteger, alias: VACATION, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Leave (type: esriFieldTypeInteger, alias: TOTAL LEAVE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Total_Staff_Available (type: esriFieldTypeInteger, alias: TOTAL STAFF AVAILABLE, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Overtime_Required_For_Minimum_Staffing_Of_16 (type: esriFieldTypeInteger, alias: OVERTIME (16), SQL Type: sqlTypeInteger, nullable: true, editable: true)
• FID (type: esriFieldTypeOID, alias: FID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)
• DATE_REPORTED (type: esriFieldTypeDate, alias: DATE, SQL Type: sqlTypeOther, length: 0, nullable: true, editable: true)
• OTHERS (type: esriFieldTypeInteger, alias: OTHERS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TIER (type: esriFieldTypeString, alias: TIER, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/19/2020 3:51:07 PM

Schema Last Edit Date: 3/19/2020 3:51:07 PM

Data Last Edit Date: 3/19/2020 3:51:07 PM

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