Name: CPIP Projects

Display Field: CapitalProjectNickName

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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ProjectID (type: esriFieldTypeString, alias: Project ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• CapitalProjectNickName (type: esriFieldTypeString, alias: Capital Project Nickname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Phase (type: esriFieldTypeSmallInteger, alias: Phase, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: DESIGN], [1: CONSTRUCTION], [2: WARRANTY], ... 1 more ...)
• DetailedDesignCompletedPerc (type: esriFieldTypeSmallInteger, alias: Percentage of Detailed Design Completed, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: 0 - 30%], [1: 30 - 60%], [2: 60 - 90%], ... 1 more ...)
• ContractNumber (type: esriFieldTypeString, alias: Document Number for Contractor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• WarrantyEndDate (type: esriFieldTypeDate, alias: Warranty Acceptance Period End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WarrantyEndDateStatus (type: esriFieldTypeSmallInteger, alias: Status of Warranty End Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• ProjectWebsite (type: esriFieldTypeString, alias: Project Website, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• 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 ...)
• ProjectStatus (type: esriFieldTypeString, alias: Project Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ConsultantRFPIssueDate (type: esriFieldTypeDate, alias: Consultant RFP Issue Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConsultantRFPIssueDateStatus (type: esriFieldTypeSmallInteger, alias: Status of Consultant RFP Issue Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• ConstructionTenderIssueDate (type: esriFieldTypeDate, alias: Construction Tender Issue Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ConstructionTenderDateStatus (type: esriFieldTypeSmallInteger, alias: Status of Construction Tender Issue Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• SubstantialCompletionDate (type: esriFieldTypeDate, alias: Substantial Completion Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SubstantialCompletionStatus (type: esriFieldTypeSmallInteger, alias: Status of Substantial Completion Date, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Target], [1: Actual])
• CS4CPDiscussionItems (type: esriFieldTypeString, alias: CS4CP Discussion Items, SQL Type: sqlTypeOther, length: 255, 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)
• CS4CPProjectLaunchDate (type: esriFieldTypeDate, alias: CS4CP Project Launch Date, 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)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• PrimaryContact (type: esriFieldTypeSmallInteger, alias: Primary Contact for Customer Inquiries, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Abid Al Hadi, Maad], [1: Abreu, David], [2: Alfalahi, Osama], ... 43 more ...)
• TeamResponsible (type: esriFieldTypeString, alias: Team Responsible, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [1: Contract Administration and Oversight], [2: Condition Assessment and Rehabilitation], [3: Development], ... 6 more ...)
• BICPSurvey (type: esriFieldTypeString, alias: BICP Survey Required, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BICPSurveyConducted (type: esriFieldTypeSmallInteger, alias: BICP Survey Conducted, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: BICP survey to be completed], [1: BICP survey completed], [2: BICP survey not required])
• 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 ...)
• IFCAvailable (type: esriFieldTypeSmallInteger, alias: IFC Available, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• AsBuiltComments (type: esriFieldTypeString, alias: As Built Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DeficiencyList (type: esriFieldTypeString, alias: Deficiency List, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ContractAdministration (type: esriFieldTypeSmallInteger, alias: Contract Administration, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: In-house], [1: Consultant])
• CS4CPNotes (type: esriFieldTypeString, alias: CS4CP Notes, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
• Consultant (type: esriFieldTypeSmallInteger, alias: Consultant, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: AECOM Canada Ltd.], [1: Ainley & Associates Ltd.], [2: Amec Foster Wheeler Americas Limited], ... 44 more ...)
• Contractor (type: esriFieldTypeSmallInteger, alias: Contractor, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Accurate HD Ltd.], [2: Alliance Verdi Civil Inc.], [3: Alwahesh Contracting Inc.], ... 108 more ...)
• CS4CPSupport (type: esriFieldTypeSmallInteger, alias: Receiving CS4CP Support, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• WaterTaking (type: esriFieldTypeSmallInteger, alias: Dewatering, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• Inspector (type: esriFieldTypeSmallInteger, alias: Inspector, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Arkaxhiu, Mirgjen ], [1: Barua, Tapan ], [2: Basi, Abhijeet ], ... 38 more ...)
• ProjectManager (type: esriFieldTypeSmallInteger, alias: Project Manager, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Abid Al Hadi, Maad], [1: Abreu, David], [2: Alfalahi, Osama], ... 43 more ...)
• ProjectInConsultantProg (type: esriFieldTypeSmallInteger, alias: Project in Consultant Program, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: CPIP Projects
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Relationships:

• DEVPUB.SDE.CPIP_Polygons_v2 (0) -- Related To: CPIP Polygons (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/13/2024 5:43:32 AM

Schema Last Edit Date: 8/13/2024 5:43:32 AM

Data Last Edit Date: 7/12/2024 2:37:55 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat