Name: Surveys
Display Field: pocname
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: globalid
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- resoverall (type: esriFieldTypeSmallInteger, alias: Overall Satisfaction, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Strongly Disagree], [2: Disagree], [3: Neutral], ... 2 more ...)
- resquality (type: esriFieldTypeSmallInteger, alias: Resolution Quality, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Strongly Disagree], [2: Disagree], [3: Neutral], ... 2 more ...)
- restime (type: esriFieldTypeSmallInteger, alias: Resolution Time, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Strongly Disagree], [2: Disagree], [3: Neutral], ... 2 more ...)
- resservice (type: esriFieldTypeSmallInteger, alias: Customer Service, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Strongly Disagree], [2: Disagree], [3: Neutral], ... 2 more ...)
- comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- cancontact (type: esriFieldTypeString, alias: Can Contact, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
- pocname (type: esriFieldTypeString, alias: Full Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- pocemail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
- pocphone (type: esriFieldTypeString, alias: Phone Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- activityglobalid (type: esriFieldTypeGUID, alias: Activity GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
- globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- currentwork (type: esriFieldTypeString, alias: Current Workflow, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- currentworker (type: esriFieldTypeString, alias: Current Worker Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- currentworkhrs (type: esriFieldTypeInteger, alias: Current Workflow Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- currenthrlywage (type: esriFieldTypeInteger, alias: Current Hourly Wage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- currentoccurence (type: esriFieldTypeInteger, alias: Current Annual Occurence, SQL Type: sqlTypeOther, nullable: true, editable: true)
- currentothrcost (type: esriFieldTypeInteger, alias: Current Other Costs, SQL Type: sqlTypeOther, nullable: true, editable: true)
- currentworkcost (type: esriFieldTypeInteger, alias: Current Workflow Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- currentannualcost (type: esriFieldTypeInteger, alias: Current Annual Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- newwork (type: esriFieldTypeString, alias: New Workflow, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- newworker (type: esriFieldTypeString, alias: New Worker Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- newworkhrs (type: esriFieldTypeInteger, alias: New Workflow Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- newhrlywage (type: esriFieldTypeInteger, alias: New Hourly Wage, SQL Type: sqlTypeOther, nullable: true, editable: true)
- newoccurence (type: esriFieldTypeInteger, alias: New Annual Occurence, SQL Type: sqlTypeOther, nullable: true, editable: true)
- newothrcost (type: esriFieldTypeInteger, alias: New Other Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- newworkcost (type: esriFieldTypeInteger, alias: New Workflow Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- newannualcost (type: esriFieldTypeInteger, alias: New Annual Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- benefits_org (type: esriFieldTypeString, alias: Organization Benefits, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- benefits_notorg (type: esriFieldTypeString, alias: Non-Organizational Benefits, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- prodhrs (type: esriFieldTypeInteger, alias: Production Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- prodhrlywage (type: esriFieldTypeInteger, alias: Production Hourly Rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
- productioncost (type: esriFieldTypeInteger, alias: Production Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
- inannlsav (type: esriFieldTypeInteger, alias: Initial Annual Savings, SQL Type: sqlTypeOther, nullable: true, editable: true)
- futannlsav (type: esriFieldTypeInteger, alias: Future Annual Savings, SQL Type: sqlTypeOther, nullable: true, editable: true)
- inyr_roi (type: esriFieldTypeInteger, alias: Initial Year ROI (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
- futyr_roi (type: esriFieldTypeInteger, alias: Future Annual ROI (%), SQL Type: sqlTypeOther, nullable: true, editable: true)
- reqactcategory (type: esriFieldTypeString, alias: Activity Category, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
Templates:
Name: GIS_SatisfactionSurveys
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 9/14/2026 12:44:45 PM
Schema Last Edit Date: 3/26/2025 2:52:19 PM
Data Last Edit Date: 9/14/2026 12:44:45 PM
Supported Operations:
Add Features
Apply Edits
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat