WorkType (type: esriFieldTypeSmallInteger, alias: Work Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Watermain Replacement], [1: Watermain Installation for Growth], [2: Watermain Rehabilitation], ... 24 more ...)
WorkTypeDetails (type: esriFieldTypeSmallInteger, alias: Work Type Details, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Requiring excavation / open cut], [1: Tunneling], [2: Trenchless / no excavation required])
WorkTypeDescription (type: esriFieldTypeSmallInteger, alias: Work Type Description, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Replacing the aging water pipe to improve the water system. The new pipe is installed by digging trenches.], [1: Replacing the aging water pipe to improve the water system. The new pipe is installed by tunneling underground.], [2: Installing a new water pipe to support growth and expand the capacity of the underground water system. The new pipe is installed by digging trenches.], ... 32 more ...)
UtilitiesImpacted (type: esriFieldTypeString, alias: Utilities Impacted and Status of Relocation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SpecialInfoForPWDCS (type: esriFieldTypeString, alias: Special info for PWDCS, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
RestorationResponsible (type: esriFieldTypeSmallInteger, alias: Restoration Responsible, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Region of Peel], [1: City of Mississauga], [2: City of Brampton], ... 1 more ...)
WorkType (type: esriFieldTypeSmallInteger, alias: Work Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Watermain Replacement], [1: Watermain Installation for Growth], [2: Watermain Rehabilitation], ... 24 more ...)
WorkTypeDetails (type: esriFieldTypeSmallInteger, alias: Work Type Details, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Requiring excavation / open cut], [1: Tunneling], [2: Trenchless / no excavation required])
WorkTypeDescription (type: esriFieldTypeSmallInteger, alias: Work Type Description, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Replacing the aging water pipe to improve the water system. The new pipe is installed by digging trenches.], [1: Replacing the aging water pipe to improve the water system. The new pipe is installed by tunneling underground.], [2: Installing a new water pipe to support growth and expand the capacity of the underground water system. The new pipe is installed by digging trenches.], ... 32 more ...)
AgencyResponsible (type: esriFieldTypeString, alias: Agency Responsible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Bell Canada], [2: City of Brampton], [3: City of Mississauga], ... 12 more ...)
RestorationResponsible (type: esriFieldTypeSmallInteger, alias: Restoration Responsible, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Region of Peel], [1: City of Mississauga], [2: City of Brampton], ... 1 more ...)
AsBuiltStatus (type: esriFieldTypeSmallInteger, alias: As-Built Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: To Be Prepared by Consultant], [1: To Be Prepared In-House], [2: Follow-up with PM], ... 8 more ...)
AsBuiltComments (type: esriFieldTypeString, alias: As Built Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InspectionLevel (type: esriFieldTypeSmallInteger, alias: Inspection Level, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Region Full Time Inspection with Region CA], [1: Region Full Time Inspection with Consultant CA], [2: Region Part Time Inspection], ... 2 more ...)
UtilitiesImpacted (type: esriFieldTypeString, alias: Utilities Impacted and Status of Relocation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DateOfFeedback (type: esriFieldTypeDate, alias: Date All Feedback Collected From Affected Residents / Businesses , SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
NextNotice (type: esriFieldTypeDate, alias: Anticipated Date Of Next Notice, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
NextUpcomingNotice (type: esriFieldTypeSmallInteger, alias: Next Upcoming Notice, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Air vent letter], [0: Advance notice], [2: Backyard easement letter - Sewer relining], ... 27 more ...)
TotalNumberAffectedUnits (type: esriFieldTypeSmallInteger, alias: Total Number Of Households/Businesses Affected Within Project Area , SQL Type: sqlTypeOther, nullable: true, editable: true)
WorkType_orig (type: esriFieldTypeString, alias: Work Type Old, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
TotalNumberAffectedUnits (type: esriFieldTypeSmallInteger, alias: Total Number Of Households/Businesses Affected Within Project Area , SQL Type: sqlTypeOther, nullable: true, editable: true)
DateOfFeedback (type: esriFieldTypeDate, alias: Date All Feedback Collected From Affected Residents / Businesses , SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CollaborativeCommunication (type: esriFieldTypeString, alias: Project Part Of Collaborative Communication, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BICPSurveyDate (type: esriFieldTypeDate, alias: Date BICP Survey Uploaded to e-Blast Application, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
NextUpcomingNotice (type: esriFieldTypeSmallInteger, alias: Next Upcoming Notice, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Air vent letter], [0: Advance notice], [2: Backyard easement letter - Sewer relining], ... 27 more ...)
EACompletionDate (type: esriFieldTypeDate, alias: Date of EA Completion, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DocNumForConsultant (type: esriFieldTypeString, alias: Document Number For Consultant, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InspectionLevel (type: esriFieldTypeSmallInteger, alias: Inspection Level, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Region Full Time Inspection with Region CA], [1: Region Full Time Inspection with Consultant CA], [2: Region Part Time Inspection], ... 2 more ...)
AsBuiltStatus (type: esriFieldTypeSmallInteger, alias: As-Built Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: To Be Prepared by Consultant], [1: To Be Prepared In-House], [2: Follow-up with PM], ... 8 more ...)