Name: Staffing_Turnover_Table

Display Field: Year

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 13a90d3f54da4063ad39dd3afcd17dc8

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:

• 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 )
• 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: true, length: 40, defaultValue: null, modelName: Overhire )
• Hires ( type: esriFieldTypeString, alias: Hires, editable: true, nullable: false, length: 1, defaultValue: null, modelName: Hires )
• cur_hire_date ( type: esriFieldTypeDate, alias: cur_hire_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: cur_hire_date )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )

Templates:

• Name: Staffing_Turnover_Table
  Description:
  Prototype:
  Hires:
  Year: null
  Dept: null
  Div: null
  RPT_GRP_1: null
  RPT_GRP_2: null
  Home_Dept_Descr: null
  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: null
  cur_hire_date: 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