Name: TDetector

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

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: FacilityID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LifeCycleStatus (type: esriFieldTypeString, alias: LifeCycleStatus, 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)
• AssetOwner (type: esriFieldTypeSmallInteger, alias: AssetOwner, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: CPG], [-1: RDFFG], [-2: Private], ... 3 more ...)
• AssetManager (type: esriFieldTypeSmallInteger, alias: AssetManager, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Asset], [2: Bylaw], [3: Civic Facility], ... 21 more ...)
• InstallDate (type: esriFieldTypeDate, alias: InstallDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WarrantyDate (type: esriFieldTypeDate, alias: WarrantyDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Manufacturer (type: esriFieldTypeString, alias: Manufacturer, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PrimaryImage (type: esriFieldTypeString, alias: PrimaryImage, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• Slot (type: esriFieldTypeString, alias: Slot, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: Code1])
• Harness (type: esriFieldTypeString, alias: Harness, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [1: Code1])
• Phase (type: esriFieldTypeInteger, alias: Phase, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 6 more ...)
• Delay (type: esriFieldTypeInteger, alias: Delay, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
• Extend (type: esriFieldTypeInteger, alias: Extend, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
• Channel (type: esriFieldTypeSmallInteger, alias: Channel, SQL Type: sqlTypeOther, nullable: true, editable: true)
• System (type: esriFieldTypeInteger, alias: System, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
• AuxDet (type: esriFieldTypeInteger, alias: AuxDet, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
• MountType (type: esriFieldTypeString, alias: MountType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Pad: Pad], [Pole: Pole], [R: Rack])
• ConditionDate (type: esriFieldTypeDate, alias: ConditionDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• AcquisitionCost (type: esriFieldTypeDouble, alias: AcquisitionCost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeprecationMethod (type: esriFieldTypeString, alias: DeprecationMethod, 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: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• SubType_TEXT (type: esriFieldTypeString, alias: SubType, 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)
• Enabled (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: TDetector
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AssetOwner: 1
• Delay: 0
• Extend: 0
• System: 0
• AuxDet: 0
• MountType: R

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/18/2025 3:58:49 AM

Schema Last Edit Date: 7/18/2025 3:58:49 AM

Data Last Edit Date: 7/18/2025 3:58:49 AM

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