Name: Employee Details

Display Field: FIRSTNAME

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 36d60566904e4602bfdffcfb9e3036ad

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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

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: true
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: false
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:

Fields:

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

Templates:

• Name: Employee Details
  Description:
  Prototype:
  LOCATION_CODE: null
  EMAIL: null
  FIRSTNAME: null
  LASTNAME: null
  TITLE: null
  EMP_ID: null
  EMP_HASH_ID: null
  SUPERVISOR_ID: null
  SUP_HASH_ID: null
  AGE: null
  YEARS_WORKED: null
  CITY: null
  ZIP: null
  DEPARTMENT: null
  DROP_STATUS:
  DROP_BEGIN: null
  DROP_END: null
  RACE: null
  GENDER: null
  RET_PLAN: null
  FRS_YEARS: null
  FRS_TIER: null
  VETERAN: null
  WORK_STATUS: null
  SHORT_DIV: null
  LONG_DIV: null
  OPERATOR_311: null
  SHORT_DEG: null
  LONG_DEG: null
  LIC_TYPE: null
  LIC_LONG_TYPE: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Create,Update,Delete,Uploads,Editing

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

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata