Name: All Code Task Table
Display Field: CATEGORY
Type: Table
Geometry Type: N/A
Description: null
Definition Expression: N/A
Copyright Text: N/A
Default Visibility: false
MaxRecordCount: 1000
Supported Query Formats: JSON, AMF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
HasZ: false
HasM: false
Has Attachments: true
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field: N/A
Fields:
-
OBJECTID
(
type: esriFieldTypeOID
, alias: OBJECTID
)
-
CATEGORY
(
type: esriFieldTypeString
, alias: CATEGORY
, length: 150
)
-
INCIDENT_ID
(
type: esriFieldTypeInteger
, alias: INCIDENT_ID
)
-
INCIDENT_NUMBER
(
type: esriFieldTypeString
, alias: INCIDENT_NUMBER
, length: 100
)
-
INCIDENT_TYPE_ID
(
type: esriFieldTypeInteger
, alias: INCIDENT_TYPE_ID
)
-
TASK_TYPE_ID
(
type: esriFieldTypeInteger
, alias: Task Type ID
)
-
TASK_ID
(
type: esriFieldTypeInteger
, alias: Task ID
)
-
TASK_NUMBER
(
type: esriFieldTypeString
, alias: Task Number
, length: 30
)
-
CREATION_DATE
(
type: esriFieldTypeDate
, alias: Creation Date
, length: 8
)
-
CREATED_BY
(
type: esriFieldTypeInteger
, alias: Created By
)
-
LAST_UPDATE_DATE
(
type: esriFieldTypeDate
, alias: LAST_UPDATE_DATE
, length: 8
)
-
LAST_UPDATED_BY
(
type: esriFieldTypeInteger
, alias: LAST_UPDATED_BY
)
-
LAST_UPDATE_LOGIN
(
type: esriFieldTypeInteger
, alias: LAST_UPDATE_LOGIN
)
-
LAST_MODIFIED_DATE
(
type: esriFieldTypeDate
, alias: LAST_MODIFIED_DATE
, length: 8
)
-
TASK_TYPE
(
type: esriFieldTypeString
, alias: Task Type
, length: 100
)
-
TASK_STATUS
(
type: esriFieldTypeString
, alias: Task Status
, length: 50
)
-
TASK_PRIORITY
(
type: esriFieldTypeString
, alias: Task Priority
, length: 25
)
-
TASK_OWNER
(
type: esriFieldTypeString
, alias: Task Owner
, length: 255
)
-
TASK_ASSIGNEE
(
type: esriFieldTypeString
, alias: Task Assignee
, length: 255
)
-
TASK_ASSIGNMENT_ID
(
type: esriFieldTypeString
, alias: TASK_ASSIGNMENT_ID
, length: 50
)
-
ASSIGNEE_STATUS
(
type: esriFieldTypeString
, alias: Assignee Status
, length: 50
)
-
TASK_SUBJECT
(
type: esriFieldTypeString
, alias: Task Subject
, length: 255
)
-
TASK_NOTES
(
type: esriFieldTypeString
, alias: Task Notes
, length: 255
)
-
PLANNED_START_DATE
(
type: esriFieldTypeDate
, alias: Planned Start Date
, length: 8
)
-
PLANNED_END_DATE
(
type: esriFieldTypeDate
, alias: Planned End Date
, length: 8
)
-
SCHEDULED_START_DATE
(
type: esriFieldTypeDate
, alias: Scheduled Start Date
, length: 8
)
-
SCHEDULED_END_DATE
(
type: esriFieldTypeDate
, alias: Scheduled End Date
, length: 8
)
-
ACTUAL_START_DATE
(
type: esriFieldTypeDate
, alias: Actual Start Date
, length: 8
)
-
ACTUAL_END_DATE
(
type: esriFieldTypeDate
, alias: Actual End Date
, length: 8
)
-
PLANNED_EFFORT
(
type: esriFieldTypeDouble
, alias: PLANNED_EFFORT
)
-
PLANNED_EFFORT_UOM
(
type: esriFieldTypeString
, alias: PLANNED_EFFORT_UOM
, length: 10
)
-
ACTUAL_EFFORT
(
type: esriFieldTypeDouble
, alias: ACTUAL_EFFORT
)
-
ACTUAL_EFFORT_UOM
(
type: esriFieldTypeString
, alias: ACTUAL_EFFORT_UOM
, length: 10
)
-
DURATION
(
type: esriFieldTypeDouble
, alias: Days Old
)
-
DURATION_UOM
(
type: esriFieldTypeString
, alias: DURATION_UOM
, length: 10
)
-
ADDRESS
(
type: esriFieldTypeString
, alias: Address
, length: 255
)
-
PARCEL_ID
(
type: esriFieldTypeString
, alias: Parcel ID
, length: 100
)
-
REC_EDIT_MODE
(
type: esriFieldTypeString
, alias: Send to Oracle: Change to Manual
, length: 50
)
-
REC_EDIT_MODE_COMMENTS
(
type: esriFieldTypeString
, alias: REC_EDIT_MODE_COMMENTS
, length: 50
)
-
ASSIGNED_DATE
(
type: esriFieldTypeDate
, alias: ASSIGNED_DATE
, length: 8
)
-
CONTRACT_INVOICE_NUMB
(
type: esriFieldTypeString
, alias: CONTRACT_INVOICE_NUMB
, length: 20
)
-
DECLINED_DATE
(
type: esriFieldTypeDate
, alias: DECLINED_DATE
, length: 8
)
-
INPROGRESS_DATE
(
type: esriFieldTypeDate
, alias: INPROGRESS_DATE
, length: 8
)
-
INVOICE_AMOUNT
(
type: esriFieldTypeDouble
, alias: INVOICE_AMOUNT
)
-
INVOICE_BILLABLEHOURS
(
type: esriFieldTypeDouble
, alias: INVOICE_BILLABLEHOURS
)
-
INVOICE_CALCHOURS
(
type: esriFieldTypeDouble
, alias: INVOICE_CALCHOURS
)
-
INVOICE_CLERK
(
type: esriFieldTypeString
, alias: INVOICE_CLERK
, length: 50
)
-
INVOICE_COMMENTS
(
type: esriFieldTypeString
, alias: INVOICE_COMMENTS
, length: 255
)
-
INVOICE_DATE
(
type: esriFieldTypeDate
, alias: INVOICE_DATE
, length: 8
)
-
INVOICE_YESNO
(
type: esriFieldTypeString
, alias: INVOICE_YESNO
, length: 10
)
-
PAUSED_DATE
(
type: esriFieldTypeDate
, alias: PAUSED_DATE
, length: 8
)
-
RES_CODE
(
type: esriFieldTypeString
, alias: RES_CODE
, length: 50
)
-
Task_Assign_Status
(
type: esriFieldTypeString
, alias: Task_Assign_Status
, length: 50
)
-
Task_Days_Scheduled
(
type: esriFieldTypeSmallInteger
, alias: Task Days Scheduled
)
-
TRASH_YESNO
(
type: esriFieldTypeString
, alias: TRASH_YESNO
, length: 10
)
-
GlobalID
(
type: esriFieldTypeGlobalID
, alias: GlobalID
, length: 38
)
-
created_user
(
type: esriFieldTypeString
, alias: created_user
, length: 255
)
-
created_date
(
type: esriFieldTypeDate
, alias: created_date
, length: 8
)
-
last_edited_user
(
type: esriFieldTypeString
, alias: last_edited_user
, length: 255
)
-
last_edited_date
(
type: esriFieldTypeDate
, alias: last_edited_date
, length: 8
)
Relationships:
Supported Operations:
Query
Query Related Records
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata