Name: Personnel
Display Field: employeeid
Type: Table
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
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:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- employeeid (type: esriFieldTypeString, alias: Employee ID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- title (type: esriFieldTypeString, alias: Title, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- department (type: esriFieldTypeString, alias: Department, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Administration: Administration], [Assessor: Assessor], [Fire: Fire], ... 6 more ...)
- datehired (type: esriFieldTypeDate, alias: Date Hired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- race (type: esriFieldTypeString, alias: Race, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [American Indian or Alaska Native: American Indian or Alaska Native], [Asian: Asian], [Black or African American: Black or African American], ... 4 more ...)
- ethnicity (type: esriFieldTypeString, alias: Ethnicity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Hispanic or Latino: Hispanic or Latino], [Not Hispanic or Latino: Not Hispanic or Latino])
- gender (type: esriFieldTypeString, alias: Gender, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Female: Female], [Male: Male])
- resident (type: esriFieldTypeString, alias: Resident, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- appointed (type: esriFieldTypeString, alias: Appointed, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- annualsalary (type: esriFieldTypeDouble, alias: Annual Salary, SQL Type: sqlTypeOther, nullable: true, editable: true)
- employeestatus (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Full Time: Full Time], [Part Time: Part Time])
- age (type: esriFieldTypeInteger, alias: Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
- yearservice (type: esriFieldTypeInteger, alias: Years of Service, SQL Type: sqlTypeOther, nullable: true, editable: true)
Templates:
Name: Personnel
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 8/6/2020 9:09:48 PM
Schema Last Edit Date: 8/6/2020 9:09:48 PM
Data Last Edit Date: 8/6/2020 9:09:48 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat