Name: CODE_EGIS.CODECREATOR.PW_Code_EnvEnf_Tasks
Display Field: CATEGORY
Type: Table
Geometry Type: N/A
Description:
Definition Expression: N/A
Copyright Text:
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, AMF, geoJSON
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing Info:
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
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID
, alias: OBJECTID
, editable: false
, nullable: false
)
-
CATEGORY
(
type: esriFieldTypeString
, alias: CATEGORY
, editable: true
, nullable: true
, length: 150
)
-
INCIDENT_ID
(
type: esriFieldTypeInteger
, alias: INCIDENT_ID
, editable: true
, nullable: true
)
-
INCIDENT_NUMBER
(
type: esriFieldTypeString
, alias: INCIDENT_NUMBER
, editable: true
, nullable: true
, length: 100
)
-
INCIDENT_TYPE_ID
(
type: esriFieldTypeInteger
, alias: INCIDENT_TYPE_ID
, editable: true
, nullable: true
)
-
TASK_TYPE_ID
(
type: esriFieldTypeInteger
, alias: Task Type ID
, editable: true
, nullable: true
)
-
TASK_ID
(
type: esriFieldTypeInteger
, alias: Task ID
, editable: true
, nullable: true
)
-
TASK_NUMBER
(
type: esriFieldTypeString
, alias: Task Number
, editable: true
, nullable: true
, length: 30
)
-
CREATION_DATE
(
type: esriFieldTypeDate
, alias: Creation Date
, editable: true
, nullable: true
, length: 8
)
-
CREATED_BY
(
type: esriFieldTypeInteger
, alias: Created By
, editable: true
, nullable: true
)
-
LAST_UPDATE_DATE
(
type: esriFieldTypeDate
, alias: LAST_UPDATE_DATE
, editable: true
, nullable: true
, length: 8
)
-
LAST_UPDATED_BY
(
type: esriFieldTypeInteger
, alias: LAST_UPDATED_BY
, editable: true
, nullable: true
)
-
LAST_UPDATE_LOGIN
(
type: esriFieldTypeInteger
, alias: LAST_UPDATE_LOGIN
, editable: true
, nullable: true
)
-
LAST_MODIFIED_DATE
(
type: esriFieldTypeDate
, alias: LAST_MODIFIED_DATE
, editable: true
, nullable: true
, length: 8
)
-
TASK_TYPE
(
type: esriFieldTypeString
, alias: Task Type
, editable: true
, nullable: true
, length: 100
, Coded Values:
[EE - Inspection: EE - Inspection]
, [EE - Followup Inspection: EE - Followup Inspection]
, [EE - Mailer: EE - Mailer]
, ...2 more...
)
-
TASK_STATUS
(
type: esriFieldTypeString
, alias: Task Status
, editable: true
, nullable: true
, length: 50
, Coded Values:
[Accepted: Accepted]
, [Assigned: Assigned]
, [OnHold: On Hold]
, ...1 more...
)
-
TASK_PRIORITY
(
type: esriFieldTypeString
, alias: Task Priority
, editable: true
, nullable: true
, length: 25
, Coded Values:
[Low: Low]
, [Medium: Medium]
, [High: High]
, ...1 more...
)
-
TASK_OWNER
(
type: esriFieldTypeString
, alias: Task Owner
, editable: true
, nullable: true
, length: 255
)
-
TASK_ASSIGNEE
(
type: esriFieldTypeString
, alias: Task Assignee
, editable: true
, nullable: true
, length: 255
)
-
TASK_ASSIGNMENT_ID
(
type: esriFieldTypeString
, alias: TASK_ASSIGNMENT_ID
, editable: true
, nullable: true
, length: 50
)
-
ASSIGNEE_STATUS
(
type: esriFieldTypeString
, alias: Assignee Status
, editable: true
, nullable: true
, length: 50
)
-
TASK_SUBJECT
(
type: esriFieldTypeString
, alias: Task Subject
, editable: true
, nullable: true
, length: 255
)
-
TASK_NOTES
(
type: esriFieldTypeString
, alias: Task Notes
, editable: true
, nullable: true
, length: 255
)
-
PLANNED_START_DATE
(
type: esriFieldTypeDate
, alias: Planned Start Date
, editable: true
, nullable: true
, length: 8
)
-
PLANNED_END_DATE
(
type: esriFieldTypeDate
, alias: Planned End Date
, editable: true
, nullable: true
, length: 8
)
-
SCHEDULED_START_DATE
(
type: esriFieldTypeDate
, alias: Scheduled Start Date
, editable: true
, nullable: true
, length: 8
)
-
SCHEDULED_END_DATE
(
type: esriFieldTypeDate
, alias: Scheduled End Date
, editable: true
, nullable: true
, length: 8
)
-
ACTUAL_START_DATE
(
type: esriFieldTypeDate
, alias: Actual Start Date
, editable: true
, nullable: true
, length: 8
)
-
ACTUAL_END_DATE
(
type: esriFieldTypeDate
, alias: Actual End Date
, editable: true
, nullable: true
, length: 8
)
-
PLANNED_EFFORT
(
type: esriFieldTypeDouble
, alias: PLANNED_EFFORT
, editable: true
, nullable: true
)
-
PLANNED_EFFORT_UOM
(
type: esriFieldTypeString
, alias: PLANNED_EFFORT_UOM
, editable: true
, nullable: true
, length: 10
)
-
ACTUAL_EFFORT
(
type: esriFieldTypeDouble
, alias: ACTUAL_EFFORT
, editable: true
, nullable: true
)
-
ACTUAL_EFFORT_UOM
(
type: esriFieldTypeString
, alias: ACTUAL_EFFORT_UOM
, editable: true
, nullable: true
, length: 10
)
-
DURATION
(
type: esriFieldTypeDouble
, alias: Days Old
, editable: true
, nullable: true
)
-
DURATION_UOM
(
type: esriFieldTypeString
, alias: DURATION_UOM
, editable: true
, nullable: true
, length: 10
)
-
ADDRESS
(
type: esriFieldTypeString
, alias: Address
, editable: true
, nullable: true
, length: 255
)
-
PARCEL_ID
(
type: esriFieldTypeString
, alias: Parcel ID
, editable: true
, nullable: true
, length: 100
)
-
REC_EDIT_MODE
(
type: esriFieldTypeString
, alias: Send to Oracle: Change to Manual
, editable: true
, nullable: true
, length: 50
, Coded Values:
[AUTOMATIC: AUTOMATIC]
, [MANUAL: MANUAL]
, [PROCESSED: PROCESSED]
, ...1 more...
)
-
REC_EDIT_MODE_COMMENTS
(
type: esriFieldTypeString
, alias: REC_EDIT_MODE_COMMENTS
, editable: true
, nullable: true
, length: 50
)
-
created_user
(
type: esriFieldTypeString
, alias: created_user
, editable: false
, nullable: true
, length: 255
)
-
created_date
(
type: esriFieldTypeDate
, alias: created_date
, editable: false
, nullable: true
, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString
, alias: last_edited_user
, editable: false
, nullable: true
, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate
, alias: last_edited_date
, editable: false
, nullable: true
, length: 8
)
-
GlobalID
(
type: esriFieldTypeGlobalID
, alias: GlobalID
, editable: false
, nullable: false
, length: 38
)
Templates:
-
Name: CODE_EGIS.CODECREATOR.PW_Code_EnvEnf_Tasks
Description:
Prototype:
REC_EDIT_MODE: MANUAL
REC_EDIT_MODE_COMMENTS: null
CATEGORY: null
INCIDENT_ID: null
INCIDENT_NUMBER: null
INCIDENT_TYPE_ID: 0
TASK_TYPE_ID: 11001
TASK_ID: null
TASK_NUMBER: null
CREATION_DATE: null
CREATED_BY: null
LAST_UPDATE_DATE: null
LAST_UPDATED_BY: null
LAST_UPDATE_LOGIN: null
LAST_MODIFIED_DATE: null
TASK_TYPE: null
TASK_STATUS: Assigned
TASK_PRIORITY: Low
TASK_OWNER: null
TASK_ASSIGNEE: null
TASK_ASSIGNMENT_ID: null
ASSIGNEE_STATUS: null
TASK_SUBJECT: null
TASK_NOTES: null
PLANNED_START_DATE: null
PLANNED_END_DATE: null
SCHEDULED_START_DATE: null
SCHEDULED_END_DATE: null
ACTUAL_START_DATE: null
ACTUAL_END_DATE: null
PLANNED_EFFORT: null
PLANNED_EFFORT_UOM: null
ACTUAL_EFFORT: null
ACTUAL_EFFORT_UOM: null
DURATION: null
DURATION_UOM: HRS
ADDRESS: null
PARCEL_ID: null
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Create,Query,Update,Uploads,Editing
Sync Can Return Changes: false
Is Data Versioned: false
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: true
Supports ApplyEdits By Upload Id: 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
Supported Operations:
Query
Query Related Records
Apply Edits
Add Features
Update Features
Calculate
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata