Name: HDC_All_Components_table

Display Field: room_name

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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)
• activity (type: esriFieldTypeString, alias: activity, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• assets_type (type: esriFieldTypeString, alias: assets_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• site (type: esriFieldTypeString, alias: site, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_code (type: esriFieldTypeString, alias: property_code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property (type: esriFieldTypeString, alias: property, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• property_element_id (type: esriFieldTypeInteger, alias: property_element_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comp_group_code (type: esriFieldTypeString, alias: comp_group_code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comp_group (type: esriFieldTypeString, alias: comp_group, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comp_type_code (type: esriFieldTypeString, alias: comp_type_code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comp_type (type: esriFieldTypeString, alias: comp_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• component (type: esriFieldTypeString, alias: component, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• description (type: esriFieldTypeString, alias: description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• location (type: esriFieldTypeString, alias: location, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comp_code (type: esriFieldTypeString, alias: comp_code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• importance (type: esriFieldTypeInteger, alias: importance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• capex_opex (type: esriFieldTypeString, alias: capex_opex, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• constr_year (type: esriFieldTypeInteger, alias: constr_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• survey_year (type: esriFieldTypeInteger, alias: survey_year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• decommission_year (type: esriFieldTypeString, alias: decommission_year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• make (type: esriFieldTypeString, alias: make, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• model (type: esriFieldTypeString, alias: model, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• base_life (type: esriFieldTypeInteger, alias: base_life, SQL Type: sqlTypeOther, nullable: true, editable: true)
• base_conf_id (type: esriFieldTypeString, alias: base_conf_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• c1 (type: esriFieldTypeInteger, alias: C1, SQL Type: sqlTypeOther, nullable: true, editable: true)
• c2 (type: esriFieldTypeInteger, alias: C2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• c3 (type: esriFieldTypeInteger, alias: C3, SQL Type: sqlTypeOther, nullable: true, editable: true)
• c4 (type: esriFieldTypeInteger, alias: C4, SQL Type: sqlTypeOther, nullable: true, editable: true)
• c5 (type: esriFieldTypeInteger, alias: C5, SQL Type: sqlTypeOther, nullable: true, editable: true)
• rl_c1 (type: esriFieldTypeString, alias: rl_c1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• rl_c2 (type: esriFieldTypeString, alias: rl_c2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• rl_c3 (type: esriFieldTypeString, alias: rl_c3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• rl_c4 (type: esriFieldTypeString, alias: rl_c4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• rl_c5 (type: esriFieldTypeString, alias: rl_c5, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• appearance (type: esriFieldTypeInteger, alias: appearance, SQL Type: sqlTypeOther, nullable: true, editable: true)
• consequence (type: esriFieldTypeInteger, alias: consequence, SQL Type: sqlTypeOther, nullable: true, editable: true)
• safety (type: esriFieldTypeInteger, alias: safety, SQL Type: sqlTypeOther, nullable: true, editable: true)
• min_condition (type: esriFieldTypeInteger, alias: min_condition, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cond_conf_id (type: esriFieldTypeString, alias: cond_conf_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• quantity (type: esriFieldTypeDouble, alias: quantity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unit_id (type: esriFieldTypeString, alias: unit_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unit_rate (type: esriFieldTypeInteger, alias: unit_rate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• cost (type: esriFieldTypeDouble, alias: cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
• quantity_conf_id (type: esriFieldTypeString, alias: quantity_conf_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cost_conf_id (type: esriFieldTypeString, alias: cost_conf_id, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cmp_barcode (type: esriFieldTypeString, alias: cmp_barcode, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cmp_serialno (type: esriFieldTypeString, alias: cmp_serialno, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cmp_ownership (type: esriFieldTypeString, alias: cmp_ownership, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• cmp_management (type: esriFieldTypeString, alias: cmp_management, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• hprpm_link (type: esriFieldTypeString, alias: hprpm_link, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• udf_2 (type: esriFieldTypeString, alias: udf_2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• udf_3 (type: esriFieldTypeString, alias: udf_3, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• udf_4 (type: esriFieldTypeString, alias: udf_4, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• comment (type: esriFieldTypeString, alias: comment, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gps1 (type: esriFieldTypeString, alias: gps1, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• gps2 (type: esriFieldTypeString, alias: gps2, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created (type: esriFieldTypeDate, alias: created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• created_by (type: esriFieldTypeString, alias: created by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• modified (type: esriFieldTypeDate, alias: modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• modified_by (type: esriFieldTypeString, alias: modified by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• room_name (type: esriFieldTypeString, alias: room_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• room_number (type: esriFieldTypeString, alias: room_number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• floor_level (type: esriFieldTypeString, alias: floor_level, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: globalid, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• location_name (type: esriFieldTypeString, alias: location_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Name: HDC_All_Components_table
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/29/2023 11:57:17 PM

Schema Last Edit Date: 5/29/2023 11:57:17 PM

Data Last Edit Date: 5/29/2023 11:57:17 PM

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