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)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• 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)

Templates:

Name: DEI_CURRENT_EMP_IND
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/2/2025 11:45:43 PM

Schema Last Edit Date: 4/2/2025 11:45:43 PM

Data Last Edit Date: 4/2/2025 11:45:43 PM

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