Name: WWDAllTasks

Display Field: JOBNAME

Type: Table

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:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• REQNUM (type: esriFieldTypeString, alias: REQNUM, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• STRTDATE (type: esriFieldTypeDouble, alias: STRTDATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CMPLDATE (type: esriFieldTypeDouble, alias: CMPLDATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CATCODE (type: esriFieldTypeString, alias: CATCODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• TASKCODE (type: esriFieldTypeString, alias: TASKCODE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• JOBODDESC (type: esriFieldTypeString, alias: JOBODDESC, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeString, alias: ADDRESS, SQL Type: sqlTypeOther, length: 43, nullable: true, editable: true)
• RECSTATUS (type: esriFieldTypeString, alias: RECSTATUS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• JOSTATUS (type: esriFieldTypeString, alias: JOSTATUS, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• JOCMPUSID (type: esriFieldTypeString, alias: JOCMPUSID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• UBCPLMTHD (type: esriFieldTypeString, alias: UBCPLMTHD, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• JONMWSID (type: esriFieldTypeString, alias: JONMWSID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• JOBNAME (type: esriFieldTypeString, alias: JOBNAME, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• REQNAME (type: esriFieldTypeString, alias: REQNAME, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• REQUSERID (type: esriFieldTypeString, alias: REQUSERID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• REQSTAT (type: esriFieldTypeString, alias: REQSTAT, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ASGNDATE (type: esriFieldTypeDouble, alias: ASGNDATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASGNUSRID (type: esriFieldTypeString, alias: ASGNUSRID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• REQDEPT (type: esriFieldTypeString, alias: REQDEPT, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• STARTDATE (type: esriFieldTypeDouble, alias: STARTDATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CMPLUSRID (type: esriFieldTypeString, alias: CMPLUSRID, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• DESCRIP (type: esriFieldTypeString, alias: DESCRIP, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• FACILID (type: esriFieldTypeString, alias: FACILID, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• BILLCUSTID (type: esriFieldTypeDouble, alias: BILLCUSTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PROJNUM (type: esriFieldTypeString, alias: PROJNUM, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• WORKTYPE (type: esriFieldTypeString, alias: WORKTYPE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• WRKREQGRP (type: esriFieldTypeString, alias: WRKREQGRP, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• ARNUM (type: esriFieldTypeDouble, alias: ARNUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CASENUM (type: esriFieldTypeDouble, alias: CASENUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ABAANB (type: esriFieldTypeString, alias: ABAANB, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• ABBDNB (type: esriFieldTypeDouble, alias: ABBDNB, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ABBENB (type: esriFieldTypeDouble, alias: ABBENB, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ELAPSEDT (type: esriFieldTypeDouble, alias: ELAPSEDT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssignedDate (type: esriFieldTypeDate, alias: AssignedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• StartedDate (type: esriFieldTypeDate, alias: StartedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CompletedDate (type: esriFieldTypeDate, alias: CompletedDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• TASKDESC (type: esriFieldTypeString, alias: TASKDESC, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• JOSTATUSDESC (type: esriFieldTypeString, alias: JOSTATUSDESC, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)

Templates:

Name: WWDAllTasks
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• AWL (0) -- Related To: Active Water Leaks (15)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/17/2026 7:05:02 AM

Schema Last Edit Date: 2/17/2026 7:00:58 AM

Data Last Edit Date: 2/17/2026 7:05:02 AM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat