Name: DEI_CURRENT_EMP_IND

Display Field: DEPARTMENT_NAME

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

Unique ID Field:

Name : objectid

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• file_date (type: esriFieldTypeDate, alias: FILE_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• load_date (type: esriFieldTypeDate, alias: LOAD_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• timestamp (type: esriFieldTypeDate, alias: TIMESTAMP, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• month (type: esriFieldTypeDouble, alias: MONTH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• calendar_year (type: esriFieldTypeDouble, alias: CALENDAR_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fiscal_year (type: esriFieldTypeDouble, alias: FISCAL_YEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• position_type (type: esriFieldTypeString, alias: POSITION_TYPE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sex (type: esriFieldTypeString, alias: SEX, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• race_ethnicity (type: esriFieldTypeString, alias: RACE_ETHNICITY, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• salary_range (type: esriFieldTypeString, alias: SALARY_RANGE, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hiring_department (type: esriFieldTypeString, alias: HIRING_DEPARTMENT, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• department_name (type: esriFieldTypeString, alias: DEPARTMENT_NAME, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• total_count (type: esriFieldTypeDouble, alias: TOTAL_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mayor_cabinet_count (type: esriFieldTypeDouble, alias: MAYOR_CABINET_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• senior_leadership_count (type: esriFieldTypeDouble, alias: SENIOR_LEADERSHIP_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• salary_sort (type: esriFieldTypeDouble, alias: SALARY_SORT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• hiring_dept_num (type: esriFieldTypeDouble, alias: HIRING_DEPT_NUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• base_salary (type: esriFieldTypeDouble, alias: BASE_SALARY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• year_month (type: esriFieldTypeString, alias: YEAR_MONTH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hiring_dept_label (type: esriFieldTypeString, alias: HIRING_DEPT_LABEL, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• objectid (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)

Templates:

Name: DEI_CURRENT_EMP_IND
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/2/2025 3:50:31 AM

Schema Last Edit Date: 7/2/2025 3:50:31 AM

Data Last Edit Date: 7/2/2025 3:49:10 AM

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