Name: Staffing_Stats_Table

Display Field: Month

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 2c709ff69fc4401f9c812fded047f85c

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
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:

Fields:

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

Templates:

• Name: Staffing_Stats_Table
  Description:
  Prototype:
  SUPERVISORY: null
  Month: null
  Year: null
  Dept: null
  Div: null
  RPT_GRP_1: null
  RPT_GRP_2: null
  Home_Dept_Descr: null
  FTE_Status:
  num_row: null
  POS_NO: null
  Position: null
  home_dept: null
  EMPLOYMENT_STATUS: null
  STATUS: null
  Race: null
  Sex:
  Emp_Status:
  term_date: null
  SEP_POSTED: null
  SEP_EFF_DATE: null
  SEP_VOL_INVOL: null
  SEP_REASON_CODE: null
  SEP_reason: null
  Overhire:
  YRS_OF_SERVICE: null
  FTE: null
  Clinic_Visits: null
  Sick_Hrs: null
  Leave_without_Pay_Hrs: null
  FMLA_Used: 0
  Market_Step: 0
  Promotion: 0
  OBJECTID: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata