Name: Code Grounds Services Tasks

Display Field: CATEGORY

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 65a62476ee70496cb0f4e6802d67e98f

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

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
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: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: TASK_TYPE_ID

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• CATEGORY ( type: esriFieldTypeString, alias: CATEGORY, length: 50 )
• INCIDENT_ID ( type: esriFieldTypeInteger, alias: INCIDENT_ID )
• INCIDENT_NUMBER ( type: esriFieldTypeString, alias: INCIDENT_NUMBER, length: 15 )
• 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: 15 )
• 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: 50 , Coded Values: [CW - Resend Mailer: CW - Resend Mailer] , [CW - Send Mailer: CW - Send Mailer] , [CW - Inspection: CW - Inspection] , ...4 more... )
• Task_Status ( type: esriFieldTypeString, alias: Task Status, length: 20 , Coded Values: [Accepted: Accepted] , [Assigned: Assigned] , [OnHold: On Hold] , ...1 more... )
• Task_Priority ( type: esriFieldTypeString, alias: Task Priority, length: 20 , Coded Values: [Low: Low] , [Medium: Medium] , [High: High] , ...1 more... )
• Task_Owner ( type: esriFieldTypeString, alias: Task Owner, length: 50 )
• Task_Assignee ( type: esriFieldTypeString, alias: Task Assignee, length: 255 , Coded Values: [One, GS Vendor Cutabove: A Cut Above Lawn Service Corp.] , [Coleman, Arthea: A. Coleman] , [One, GS Vendor Aitbrokerage: AIT Brokerage LLC] , ...58 more... )
• TASK_ASSIGNMENT_ID ( type: esriFieldTypeString, alias: TASK_ASSIGNMENT_ID, length: 20 )
• ASSIGNEE_STATUS ( type: esriFieldTypeString, alias: ASSIGNEE_STATUS *, length: 20 , Coded Values: [Open: Open] , [Unassigned: Unassigned] , [Assigned: Assigned] , ...6 more... )
• ASSIGNEE_TEAM ( type: esriFieldTypeString, alias: ASSIGNEE_TEAM, length: 50 )
• Task_Subject ( type: esriFieldTypeString, alias: Task Subject, length: 255 )
• Task_Notes ( type: esriFieldTypeString, alias: Task Notes, length: 255 )
• TRASH_YESNO ( type: esriFieldTypeString, alias: TRASH_YESNO, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, length: 100 )
• PARCEL_ID ( type: esriFieldTypeString, alias: PARCEL_ID, length: 20 )
• 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: esriFieldTypeInteger, alias: PLANNED_EFFORT )
• PLANNED_EFFORT_UOM ( type: esriFieldTypeString, alias: PLANNED_EFFORT_UOM, length: 10 )
• ACTUAL_EFFORT ( type: esriFieldTypeInteger, 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 )
• ASSIGNED_DATE ( type: esriFieldTypeDate, alias: ASSIGNED_DATE, length: 8 )
• INPROGRESS_DATE ( type: esriFieldTypeDate, alias: INPROGRESS_DATE, length: 8 )
• PAUSED_DATE ( type: esriFieldTypeDate, alias: PAUSED_DATE, length: 8 )
• DECLINED_DATE ( type: esriFieldTypeDate, alias: DECLINED_DATE, length: 8 )
• CONTRACT_INVOICE_NUMB ( type: esriFieldTypeString, alias: CONTRACT_INVOICE_NUMB, length: 20 )
• INVOICE_DATE ( type: esriFieldTypeDate, alias: INVOICE_DATE, length: 8 )
• INVOICE_CALCHOURS ( type: esriFieldTypeDouble, alias: INVOICE_CALCHOURS )
• INVOICE_BILLABLEHOURS ( type: esriFieldTypeDouble, alias: INVOICE_BILLABLEHOURS )
• INVOICE_AMOUNT ( type: esriFieldTypeDouble, alias: INVOICE_AMOUNT )
• INVOICE_YESNO ( type: esriFieldTypeString, alias: INVOICE_YESNO, length: 10 , Coded Values: [Yes: Yes] , [No: No] )
• INVOICE_COMMENTS ( type: esriFieldTypeString, alias: INVOICE_COMMENTS, length: 255 )
• INVOICE_CLERK ( type: esriFieldTypeString, alias: INVOICE_CLERK, length: 50 , Coded Values: [Coleman, Arthea Carlotta: A. Coleman] , [Collins, Briana N: B. Collins] , [Cole, Charity: C. Cole] , ...25 more... )
• REC_EDIT_MODE ( type: esriFieldTypeString, alias: Send to Oracle: Change to Manual, length: 20 , Coded Values: [AUTOMATIC: AUTOMATIC] , [MANUAL: MANUAL] , [PROCESSED: PROCESSED] , ...2 more... )
• REC_EDIT_MODE_COMMENTS ( type: esriFieldTypeString, alias: REC_EDIT_MODE_COMMENTS, length: 50 )
• RES_CODE ( type: esriFieldTypeString, alias: RES_CODE, length: 50 , Coded Values: [14 DAYS EXTENSION: 14 DAYS EXTENSION] , [7 DAYS EXTENSION: 7 DAYS EXTENSION] , [BACK TO MCSC: BACK TO MCSC] , ...33 more... )
• OLD_GUID ( type: esriFieldTypeString, alias: OLD_GUID, length: 50 )
• 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 )
• Number_Closing_Pics_Taken ( type: esriFieldTypeSmallInteger, alias: Number Closing Pics Taken , Coded Values: [1: 1] , [2: 2] , [3: 3] , ...2 more... )
• Rel_GUID ( type: esriFieldTypeGUID, alias: Rel_GUID, length: 38 )

Types:

ID: 11021
Name: CW - Resend Mailer
Domains:
• Task_Type:
  Inherited
• Task_Status:
  Inherited
• Task_Priority:
  Inherited
• Task_Assignee:
  Inherited
• ASSIGNEE_STATUS:
  Inherited
• TRASH_YESNO:
  Inherited
• INVOICE_YESNO:
  Inherited
• INVOICE_CLERK:
  Inherited
• REC_EDIT_MODE:
  Inherited
• RES_CODE:
  Inherited

---

ID: 11001
Name: CW - Send Mailer
Domains:
• Task_Type:
  Inherited
• Task_Status:
  Inherited
• Task_Priority:
  Inherited
• Task_Assignee:
  Inherited
• ASSIGNEE_STATUS:
  Inherited
• TRASH_YESNO:
  Inherited
• INVOICE_YESNO:
  Inherited
• INVOICE_CLERK:
  Inherited
• REC_EDIT_MODE:
  Inherited
• RES_CODE:
  Inherited

---

ID: 11003
Name: CW - Inspection
Domains:
• Task_Type:
  Inherited
• Task_Status:
  Inherited
• Task_Priority:
  Inherited
• Task_Assignee:
  Inherited
• ASSIGNEE_STATUS:
  Inherited
• TRASH_YESNO:
  Inherited
• INVOICE_YESNO:
  Inherited
• INVOICE_CLERK:
  Inherited
• REC_EDIT_MODE:
  Inherited
• RES_CODE:
  Inherited

---

ID: 11005
Name: CW - Assigned to Cutter
Domains:
• Task_Type:
  Inherited
• Task_Status:
  Inherited
• Task_Priority:
  Inherited
• Task_Assignee:
  Inherited
• ASSIGNEE_STATUS:
  Inherited
• TRASH_YESNO:
  Inherited
• INVOICE_YESNO:
  Inherited
• INVOICE_CLERK:
  Inherited
• REC_EDIT_MODE:
  Inherited
• RES_CODE:
  Inherited

---

ID: 11007
Name: CW - Followup Inspection
Domains:
• Task_Type:
  Inherited
• Task_Status:
  Inherited
• Task_Priority:
  Inherited
• Task_Assignee:
  Inherited
• ASSIGNEE_STATUS:
  Inherited
• TRASH_YESNO:
  Inherited
• INVOICE_YESNO:
  Inherited
• INVOICE_CLERK:
  Inherited
• REC_EDIT_MODE:
  Inherited
• RES_CODE:
  Inherited

---

ID: 11283
Name: CW - Weeds Admin office
Domains:
• Task_Type:
  Inherited
• Task_Status:
  Inherited
• Task_Priority:
  Inherited
• Task_Assignee:
  Inherited
• ASSIGNEE_STATUS:
  Inherited
• TRASH_YESNO:
  Inherited
• INVOICE_YESNO:
  Inherited
• INVOICE_CLERK:
  Inherited
• REC_EDIT_MODE:
  Inherited
• RES_CODE:
  Inherited

---

ID: 11501
Name: CW - Cutting
Domains:
• Task_Type:
  Inherited
• Task_Status:
  Inherited
• Task_Priority:
  Inherited
• Task_Assignee:
  Coded Values: [CrewOne, Grounds: CrewOne, Grounds] , [CrewTwo, Grounds: CrewTwo, Grounds] , [One, GS Vendor Aitbrokerage: AIT Brokerage LLC] , ...32 more...
• ASSIGNEE_STATUS:
  Inherited
• TRASH_YESNO:
  Inherited
• INVOICE_YESNO:
  Inherited
• INVOICE_CLERK:
  Inherited
• REC_EDIT_MODE:
  Inherited
• RES_CODE:
  Inherited

---

Relationships:

• PW_Code_GS_SRs_V2 (0) -- Related To: CGS Service Request All (0)
• PW_Code_GS_SRs_V2 (1) -- Related To: CGS Open Service Request (1)
• PW_Code_GS_SRs_V2 (2) -- Related To: CGS Active Comp Specialist SR (2)
• PW_Code_GS_SRs_V2 (3) -- Related To: CGS Violations (3)
• PW_Code_GS_SRs_V2 (4) -- Related To: CGS Follow Up Today (4)
• PW_Code_GS_SRs_V2 (5) -- Related To: CGS Active Inspection (5)
• PW_Code_GS_SRs_V2 (6) -- Related To: CGS All Over SLA (6)
• PW_Code_GS_SRs_V2 (7) -- Related To: CGS Inspections Over SLA (7)
• PW_Code_GS_SRs_V2 (8) -- Related To: CGS Cutting Tasks Over SLA (8)
• PW_Code_GS_SRs_V2 (9) -- Related To: CGS Contractor over SLA (9)
• PW_Code_GS_SRs_V2 (10) -- Related To: CGS Service Requests Open Over 30 Days (10)
• PW_Code_GS_SRs_V2 (11) -- Related To: CGS Open by SCF (11)
• PW_Code_GS_SRs_V2 (12) -- Related To: CGS Open by Grounds Services (12)
• PW_Code_GS_SRs_V2 (13) -- Related To: CGS Open by 311 (13)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata