Name: Staffing_Stats_Table

Display Field: Month

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 04cd24f082fb49729dd97598129629dc

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

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:

• Month ( type: esriFieldTypeInteger, alias: Month )
• Year ( type: esriFieldTypeInteger, alias: Year )
• Dept ( type: esriFieldTypeString, alias: Dept, length: 2 )
• Div ( type: esriFieldTypeString, alias: Div, length: 2 )
• RPT_GRP_1 ( type: esriFieldTypeString, alias: RPT_GRP_1, length: 30 )
• RPT_GRP_2 ( type: esriFieldTypeString, alias: RPT_GRP_2, length: 30 )
• Home_Dept_Descr ( type: esriFieldTypeString, alias: Home_Dept_Descr, length: 44 )
• FTE_Status ( type: esriFieldTypeString, alias: FTE_Status, length: 9 )
• num_row ( type: esriFieldTypeDouble, alias: num_row )
• POS_NO ( type: esriFieldTypeString, alias: POS_NO, length: 20 )
• Position ( type: esriFieldTypeString, alias: Position, length: 65 )
• home_dept ( type: esriFieldTypeString, alias: home_dept, length: 10 )
• EMPLOYMENT_STATUS ( type: esriFieldTypeString, alias: EMPLOYMENT_STATUS, length: 44 )
• STATUS ( type: esriFieldTypeString, alias: STATUS, length: 1 )
• Race ( type: esriFieldTypeString, alias: Race, length: 44 )
• Sex ( type: esriFieldTypeString, alias: Sex, length: 6 )
• Emp_Status ( type: esriFieldTypeString, alias: Emp_Status, length: 6 )
• term_date ( type: esriFieldTypeDate, alias: term_date, length: 8 )
• SEP_POSTED ( type: esriFieldTypeString, alias: SEP_POSTED, length: 1 )
• SEP_EFF_DATE ( type: esriFieldTypeDate, alias: SEP_EFF_DATE, length: 8 )
• SEP_VOL_INVOL ( type: esriFieldTypeString, alias: SEP_VOL_INVOL, length: 1 )
• SEP_REASON_CODE ( type: esriFieldTypeString, alias: SEP_REASON_CODE, length: 10 )
• SEP_reason ( type: esriFieldTypeString, alias: SEP_reason, length: 50 )
• Overhire ( type: esriFieldTypeString, alias: Overhire, length: 8 )
• YRS_OF_SERVICE ( type: esriFieldTypeSingle, alias: YRS_OF_SERVICE )
• FTE ( type: esriFieldTypeDouble, alias: FTE )
• Clinic_Visits ( type: esriFieldTypeDouble, alias: Clinic_Visits )
• Sick_Hrs ( type: esriFieldTypeDouble, alias: Sick_Hrs )
• Leave_without_Pay_Hrs ( type: esriFieldTypeDouble, alias: Leave_without_Pay_Hrs )
• FMLA_Used ( type: esriFieldTypeInteger, alias: FMLA_Used )
• Market_Step ( type: esriFieldTypeInteger, alias: Market_Step )
• Promotion ( type: esriFieldTypeInteger, alias: Promotion )
• SUPERVISORY ( type: esriFieldTypeString, alias: SUPERVISORY, length: 1 )
• OBJECTID ( type: esriFieldTypeDouble, alias: OBJECTID )
• ObjectID_1 ( type: esriFieldTypeOID, alias: ObjectID_1 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata