Name: People Data

Display Field:

Type: Table

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:

• Month_Year (type: esriFieldTypeDate, alias: Month Year, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Month_FY (type: esriFieldTypeString, alias: Month FY, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Fiscal_Month (type: esriFieldTypeInteger, alias: Fiscal Month, SQL Type: sqlTypeInteger, nullable: true, editable: true, Coded Values: [1: July], [2: August], [3: September], ... 9 more ...)
• Fiscal_Quarter (type: esriFieldTypeString, alias: Fiscal Quarter, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Fiscal_Year (type: esriFieldTypeString, alias: Fiscal Year, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Month_Starting (type: esriFieldTypeDate, alias: Month Starting, SQL Type: sqlTypeTimestamp2, length: 8, nullable: true, editable: true)
• Red_Workload_Indicator (type: esriFieldTypeDouble, alias: Red Workload Indicator, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Red_Yellow_Workload_Indicator (type: esriFieldTypeDouble, alias: Orange Workload Indicator, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Yellow_Workload_Indicator (type: esriFieldTypeDouble, alias: Yellow Workload Indicator, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Yellow_Green_Workload_Indicator (type: esriFieldTypeDouble, alias: Yellow-Green Workload Indicator, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Green_Workload_Indicator (type: esriFieldTypeDouble, alias: Green Workload Indicator, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Staff_at_Start_Month (type: esriFieldTypeInteger, alias: Staff at Start Month, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Staff_at_End_Month (type: esriFieldTypeInteger, alias: Staff at End Month, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Separations (type: esriFieldTypeInteger, alias: Separations, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• F12_Month_Turnover__ (type: esriFieldTypeDouble, alias: 12-Month Turnover, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• New_Hires (type: esriFieldTypeInteger, alias: New Hires, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Average_Days_to_Hire (type: esriFieldTypeDouble, alias: Average Days to Hire, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• FID (type: esriFieldTypeOID, alias: FID, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/27/2024 8:15:32 PM

Schema Last Edit Date: 3/27/2024 8:15:32 PM

Data Last Edit Date: 3/27/2024 8:12:42 PM

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