Name: Employee Details

Display Field: FIRSTNAME

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: a11a41f9aa684fc2b1a4be5f69cd1e89

Copyright Text: null

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Feature Draw Order:

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• FIRSTNAME ( type: esriFieldTypeString, alias: FIRSTNAME, length: 20 )
• LASTNAME ( type: esriFieldTypeString, alias: LASTNAME, length: 20 )
• TITLE ( type: esriFieldTypeString, alias: TITLE, length: 4000 )
• EMP_ID ( type: esriFieldTypeString, alias: EMP_ID, length: 12 )
• EMP_HASH_ID ( type: esriFieldTypeDouble, alias: EMP_HASH_ID )
• SUPERVISOR_ID ( type: esriFieldTypeString, alias: SUPERVISOR_ID, length: 4000 )
• SUP_HASH_ID ( type: esriFieldTypeDouble, alias: SUP_HASH_ID )
• AGE ( type: esriFieldTypeInteger, alias: AGE )
• YEARS_WORKED ( type: esriFieldTypeDouble, alias: YEARS_WORKED )
• CITY ( type: esriFieldTypeString, alias: CITY, length: 20 )
• ZIP ( type: esriFieldTypeString, alias: ZIP, length: 10 )
• DEPARTMENT ( type: esriFieldTypeString, alias: DEPARTMENT, length: 30 )
• DROP_STATUS ( type: esriFieldTypeString, alias: DROP_STATUS, length: 1 )
• DROP_BEGIN ( type: esriFieldTypeDate, alias: DROP_BEGIN, length: 8 )
• DROP_END ( type: esriFieldTypeDate, alias: DROP_END, length: 8 )
• RACE ( type: esriFieldTypeString, alias: RACE, length: 15 )
• GENDER ( type: esriFieldTypeString, alias: GENDER, length: 1 )
• RET_PLAN ( type: esriFieldTypeString, alias: RET_PLAN, length: 4000 )
• FRS_YEARS ( type: esriFieldTypeSingle, alias: FRS_YEARS )
• FRS_TIER ( type: esriFieldTypeSmallInteger, alias: FRS_TIER )
• VETERAN ( type: esriFieldTypeString, alias: VETERAN, length: 2 )
• WORK_STATUS ( type: esriFieldTypeString, alias: WORK_STATUS, length: 9 )
• SHORT_DIV ( type: esriFieldTypeString, alias: SHORT_DIV, length: 15 )
• LONG_DIV ( type: esriFieldTypeString, alias: LONG_DIV, length: 30 )
• OPERATOR_311 ( type: esriFieldTypeString, alias: OPERATOR_311, length: 12 )
• SHORT_DEG ( type: esriFieldTypeString, alias: SHORT_DEG, length: 4000 )
• LONG_DEG ( type: esriFieldTypeString, alias: LONG_DEG, length: 4000 )
• LIC_TYPE ( type: esriFieldTypeString, alias: LIC_TYPE, length: 4000 )
• LIC_LONG_TYPE ( type: esriFieldTypeString, alias: LIC_LONG_TYPE, length: 4000 )
• LOCATION_CODE ( type: esriFieldTypeString, alias: LOCATION_CODE, length: 8 )
• EMAIL ( type: esriFieldTypeString, alias: EMAIL, length: 70 )

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

  Iteminfo   Thumbnail   Metadata