Name: WORKFLOW

Display Field: DISTRICT

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 51c84284cc134872b67ac63df1e460ec

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
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 )
• DISTRICT ( type: esriFieldTypeString, alias: DISTRICT, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DISTRICT )
• PROGRAM ( type: esriFieldTypeString, alias: PROGRAM, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PROGRAM , Coded Values: [AirAsbestos: Air - Asbestos] , [AirDust: Air-Dust] , [AirMobileSrc: Air - Mobile Sources] , ...14 more... )
• SUB_PROGRAM ( type: esriFieldTypeString, alias: SUB_PROGRAM, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SUB_PROGRAM )
• STAFF_ASSIGNED ( type: esriFieldTypeString, alias: STAFF_ASSIGNED, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STAFF_ASSIGNED )
• STAFF_EMAIL ( type: esriFieldTypeString, alias: STAFF_EMAIL, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STAFF_EMAIL )
• DIVISION ( type: esriFieldTypeString, alias: DIVISION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DIVISION , Coded Values: [DAPC: Division of Air Pollution Control] , [DDAGW: Divison of Drinking and Ground Waters] , [DERR: Division of Environmental Response and Revitalization] , ...5 more... )
• CMPLNT_TYPE ( type: esriFieldTypeInteger, alias: CMPLNT_TYPE, editable: true, nullable: true, defaultValue: null, modelName: CMPLNT_TYPE , Coded Values: [1: Odor] , [2: Dust] , [3: Open Burning] , ...20 more... )
• REFERRED_TO ( type: esriFieldTypeString, alias: REFERRED_TO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REFERRED_TO , Coded Values: [BUSTR: Ohio Bureau of Underground Storage Tank Regulations] , [EMRG: OEPA Emergency Response] , [LocalAir: Local Air Authority] , ...9 more... )
• DAPC_JURISDICTION ( type: esriFieldTypeString, alias: DAPC_JURISDICTION, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DAPC_JURISDICTION , Coded Values: [ARAQ: Akron Regional Air Quality Management District] , [CANTN: Canton City Public Health Air Pollution Control Division] , [CDO: OEPA Central District] , ...10 more... )
• FINDINGS ( type: esriFieldTypeString, alias: FINDINGS, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: FINDINGS )
• STATUS ( type: esriFieldTypeInteger, alias: Follow up Status, editable: true, nullable: true, defaultValue: 1, modelName: STATUS , Coded Values: [1: In Progress] , [2: Referred to New Division] , [3: Investigated - Compliance Issues Identified] , ...3 more... )
• CLOSEDDATE ( type: esriFieldTypeDate, alias: Closed_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CLOSEDDATE )
• COMPLT_GUID ( type: esriFieldTypeGUID, alias: COMPLT_GUID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: COMPLT_GUID )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Templates:

• Name: WORKFLOW
  Description:
  Prototype:
  CLOSEDDATE: null
  COMPLT_GUID: null
  DISTRICT: null
  PROGRAM: null
  SUB_PROGRAM: null
  STAFF_ASSIGNED: null
  STAFF_EMAIL: null
  DIVISION: null
  CMPLNT_TYPE: null
  REFERRED_TO: null
  DAPC_JURISDICTION: null
  FINDINGS: null
  STATUS: 1
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• OEPA.TRAIN_TO_FOLLOWUP (1) -- Related To: FOLLOWUP (5)
• OEPA.TRAIN_COMPLAINTS (0) -- Related To: Complaints (0)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata