Name: DBO.wwtpL2Electrical_ExportTable

Display Field: AssetID

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_2

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• AssetID (type: esriFieldTypeString, alias: AssetID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• FacilityID (type: esriFieldTypeInteger, alias: FacilityID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LegacyID (type: esriFieldTypeString, alias: LegacyID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• SCADAID (type: esriFieldTypeString, alias: SCADAID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• Nameplate (type: esriFieldTypeString, alias: Nameplate, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• AssetDesc (type: esriFieldTypeString, alias: Asset Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LifeCycleStatus (type: esriFieldTypeString, alias: LifeCycle Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [PRP: Proposed], [ACT: Active], [ABN: Abandoned], ... 2 more ...)
• SubType (type: esriFieldTypeInteger, alias: SubType, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AdministrativeArea (type: esriFieldTypeString, alias: Administrative Area, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [UNK: Unknown])
• AssetOwner (type: esriFieldTypeSmallInteger, alias: Owner of the Asset, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: CPG], [-1: RDFFG], [-2: Private], ... 3 more ...)
• AssetManager (type: esriFieldTypeSmallInteger, alias: Manager of the Asset, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Asset], [2: Bylaw], [3: Civic Facility], ... 21 more ...)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Boiler Room: Boiler Room], [Chlorine Contact Tank: Chlorine Contact Tank], [Compressor Room: Compressor Room], ... 28 more ...)
• InstallDate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• OperationalArea (type: esriFieldTypeString, alias: Operational Area, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• WarrantyDate (type: esriFieldTypeDate, alias: Warranty Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• BuildingGroup (type: esriFieldTypeString, alias: BuildingGroup, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [A1: Substructure], [A2: Structure], [A3: Exterior Enclosure], ... 7 more ...)
• ConditionDate (type: esriFieldTypeDate, alias: ConditionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AcquistionCost (type: esriFieldTypeDouble, alias: AcquisitionCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeprecationMethod (type: esriFieldTypeString, alias: DepricationMethod, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ExpectedLife (type: esriFieldTypeDouble, alias: ExpectedLife, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ResidualValue (type: esriFieldTypeDouble, alias: ResidualValue, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• SubType_TEXT (type: esriFieldTypeString, alias: SubTypeText, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Condition (type: esriFieldTypeDouble, alias: Condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CoFScore (type: esriFieldTypeDouble, alias: CoFScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CoFDate (type: esriFieldTypeDate, alias: CoFDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RiskScore (type: esriFieldTypeDouble, alias: RiskScore, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Link (type: esriFieldTypeString, alias: Link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• DF (type: esriFieldTypeString, alias: DF, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• UNIFORMAT (type: esriFieldTypeString, alias: UNIFORMAT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [A1011: A1011: SUBSTRUCTURE Foundations Standard Foundations Wall Foudations], [A1012: A1012: SUBSTRUCTURE Foundations Standard Foundations Column Foundations & Pie Caps], [A1013: A1013: SUBSTRUCTURE Foundations Standard Foundations Perimeter Drainage & Insulation], ... 347 more ...)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• GlobalID (type: esriFieldTypeString, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: true)
• GlobalID_2 (type: esriFieldTypeGlobalID, alias: GlobalID_2, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• 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: DBO.wwtpL2Electrical_ExportTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• GlobalID:
• LifeCycleStatus: ACT

Relationships:

• DBO.wwtpL2ExteriorEnclosure_ExportTable (1) -- Related To: DBO.wwtpL2ExteriorEnclosure_ExportTable (1)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/3/2026 2:44:27 AM

Schema Last Edit Date: 4/3/2026 2:44:24 AM

Data Last Edit Date: 4/3/2026 1:47:54 AM

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