Name: SP_Employees

Display Field:

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FirstName (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• LastName (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• Email (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• Region (type: esriFieldTypeString, alias: Region, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [Region 1: Region 1], [Region 2: Region 2], [Region 3: Region 3], ... 2 more ...)
• RegionDivision (type: esriFieldTypeString, alias: Regional Division, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [Alegheny Plateau: Alegheny Plateau], [Northern Mountains: Northern Mountains], [West Branch: West Branch], ... 12 more ...)
• Username (type: esriFieldTypeString, alias: AGOL User ID, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• EsriLicenseUserType (type: esriFieldTypeString, alias: License User Type, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• Complex (type: esriFieldTypeString, alias: Complex, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [Archbald Pothole / Lackawanna / Prompton / Salt Springs: Archbald Pothole / Lackawanna / Prompton / Salt Springs], [Benjamin Rush / Neshaminy: Benjamin Rush / Neshaminy], [Big Pocono / Gouldsboro / Tobyhanna: Big Pocono / Gouldsboro / Tobyhanna], ... 31 more ...)
• StatePark (type: esriFieldTypeString, alias: State Park, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [Archbald Pothole State Park: Archbald Pothole State Park], [Bald Eagle State Park: Bald Eagle State Park], [Beltzville State Park: Beltzville State Park], ... 124 more ...)
• CODivision (type: esriFieldTypeString, alias: CO Division, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [DO: DO - Directors Office], [OPS: OPS - Outdoor Programming Services], [POMD: POMD - Park Operations &Maintenance], ... 2 more ...)
• DateModified (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: false, editable: true)
• CanEditWhere (type: esriFieldTypeString, alias: Area they can edit. (autopop based on edit level, archive, and park, complex... names), SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true)
• EditLevelNum (type: esriFieldTypeInteger, alias: Edit Level, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [1: State Park], [2: Complex], [3: Regional Division], ... 3 more ...)
• CentralOffice (type: esriFieldTypeString, alias: Located in Central Office?, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [Yes: Yes], [No: No])
• Archive (type: esriFieldTypeString, alias: Archive (autopop no's based on edit date), SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [Yes: Yes], [No: No])
• ArchiveReason (type: esriFieldTypeString, alias: Archive Reason, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• AssignedEsriLicense (type: esriFieldTypeString, alias: Are they currently assigned an Esri license?, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [Yes: Yes], [No: No])
• AbleToEditUntil (type: esriFieldTypeDate, alias: Able to edit until: (date), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TemporaryEmployee (type: esriFieldTypeString, alias: Is the SP employee an intern, seasonal, or temporary?, SQL Type: sqlTypeOther, length: 255, nullable: false, editable: true, Coded Values: [Yes: Yes], [No: No])
• EditLevel (type: esriFieldTypeString, alias: Edit Level, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• SPPosition (type: esriFieldTypeString, alias: Current Position held at SP:, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [00 - Administrative Assistant 1: Administrative Assistant 1], [Administrative Assistant 2: Administrative Assistant 2], [00 - Administrative Officer 3: Administrative Officer 3], ... 58 more ...)
• PayScaleGroup (type: esriFieldTypeString, alias: Pay Scale Group (based on pay to determine advancement), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [01: 01], [02: 02], [03: 03], ... 10 more ...)
• BoundaryGUID (type: esriFieldTypeGUID, alias: Boundary GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• label (type: esriFieldTypeString, alias: label, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Relationships:

• SP_Restricted_Editable_Areas_SP_Employees (0) -- Related To: SP_Restricted_Editable_Areas (0)

Is Data Versioned: false

Has Contingent Values: true

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/22/2025 5:36:54 PM

Schema Last Edit Date: 12/22/2025 5:36:51 PM

Data Last Edit Date: 12/22/2025 5:36:28 PM

Child Resources:   Field Groups   Contingent Values

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