Name: SiteDeficiency

Display Field: DeficiencyName

Type: Table

Has Views: true

Source Schema Changes Allowed: false

Views

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID_1

Unique ID Field:

Name : OBJECTID_1

IsSystemMaintained : True

Global ID Field: GlobalID_1

Type ID Field:

Fields:

• OBJECTID_1 (type: esriFieldTypeOID, alias: OBJECTID_1, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DeficiencyName (type: esriFieldTypeString, alias: Deficiency Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DeficiencyDescription (type: esriFieldTypeString, alias: Deficiency Description, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EstCost (type: esriFieldTypeInteger, alias: Est. Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ProjectTyp (type: esriFieldTypeString, alias: Project Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Major Maintenance : Major Maintenance], [Capital Improvement: Capital Improvement], [Routine Maintenance: Routine Maintenance], ... 5 more ...)
• DeficiencyCategory (type: esriFieldTypeString, alias: Deficiency Category, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Safety: Safety], [Damage/Wear-out: Damage/Wear-out], [Codes/Standards: Codes/Standards], ... 5 more ...)
• System (type: esriFieldTypeString, alias: System, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Building: Building], [Equipment: Equipment], [Fence: Fence], ... 5 more ...)
• Comments (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, 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)
• GlobalID_1 (type: esriFieldTypeGlobalID, alias: GlobalID_1, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ParentGuid (type: esriFieldTypeGUID, alias: ParentGuid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Deficiency Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Active: Active], [Complete: Complete], [No Longer Applicable: No Longer Applicable])
• DefPriority (type: esriFieldTypeString, alias: Project Priority, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Current Year: Current Year (Due Today)], [2-3 Years: 2-3 Years], [3-4 Years: 3-4 Years], ... 3 more ...)
• MAES_Priority (type: esriFieldTypeString, alias: MAES Project Priority, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Current Year: Current Year (Due Today)], [2-3 Years: 2-3 Years], [3-4 Years: 3-4 Years], ... 2 more ...)

Templates:

Name: SiteDeficiency
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• (0) -- Related To: SiteLocation (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/19/2025 8:17:35 PM

Schema Last Edit Date: 6/2/2023 7:54:23 PM

Data Last Edit Date: 5/19/2025 8:17:35 PM

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