Name: AUTO

Display Field: ASSET_TYPE

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: Asset_Type_Subtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• ASSET_TYPE_SUBTYPE ( type: esriFieldTypeSmallInteger, alias: Asset Type Subtype, editable: true, nullable: true, defaultValue: 0, modelName: Asset_Type_Subtype )
• ASSET_TYPE ( type: esriFieldTypeString, alias: Asset Type, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Asset_Type , Coded Values: [Access System: Access System] , [DDC Meter: DDC Meter] , [Building Automaion System JACE: Building Automaion System JACE] , ...7 more... )
• ASSET_TAG ( type: esriFieldTypeString, alias: Asset Tag, editable: true, nullable: false, length: 20, defaultValue: null, modelName: Asset_Tag )
• SITE ( type: esriFieldTypeString, alias: Site, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Site , Coded Values: [301 Building: 301 Building] , [310 W. Martin: 310 W. Martin] , [Alexander: Alexander] , ...261 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: false, length: 50, defaultValue: null, modelName: Location )
• LEGACYID ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LegacyID )
• FLOOR ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Floor , Coded Values: [Basement: Basement] , [1st Floor: 1st Floor] , [2nd Floor: 2nd Floor] , ...12 more... )
• ROOM_TYPE ( type: esriFieldTypeString, alias: Room Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Room_Type , Coded Values: [Attic: Attic] , [Break Room: Break Room] , [Classroom: Classroom] , ...43 more... )
• ROOM_ID ( type: esriFieldTypeString, alias: Room ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Room_ID )
• MAKE ( type: esriFieldTypeString, alias: Make, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Make )
• MODEL ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Model )
• INSTALL_CONTRACTOR ( type: esriFieldTypeString, alias: Install Contractor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Install_Contractor )
• TYPE ( type: esriFieldTypeString, alias: Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Type )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Install_Date )
• SECURITY_CONTROLS ( type: esriFieldTypeString, alias: Security Controls, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Security_Controls )
• FACILITYID ( type: esriFieldTypeString, alias: FacilityID, editable: true, nullable: false, length: 20, defaultValue: null, modelName: FacilityID )
• EXISTING ( type: esriFieldTypeString, alias: Existing, editable: true, nullable: false, length: 20, defaultValue: Yes, modelName: Existing , Coded Values: [Yes: Yes] , [No: No] )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 250, defaultValue: null, modelName: Notes )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• FO_ASSET_ID ( type: esriFieldTypeString, alias: FO_ASSET_ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FO_ASSET_ID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Types:

ID: 1
Name: Access System
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Altronix - Access Control Power Supply/Charger: Altronix - Access Control Power Supply/Charger] , [HID : HID ] , [Honeywell: Honeywell] , ...5 more...
• MODEL:
  Coded Values: [AL175ULX: AL175ULX] , [SEC-J-601: SEC-J-601] , [SEC-R2R: SEC-R2R] , ...3 more...
• INSTALL_CONTRACTOR:
  Coded Values:
• TYPE:
  Coded Values:
• SECURITY_CONTROLS:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: Access System
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 1
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  INSTALL_CONTRACTOR: null
  TYPE: null
  INSTALL_DATE: null
  SECURITY_CONTROLS: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 0
Name: Unknown
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• EXISTING:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 0
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  INSTALL_CONTRACTOR: null
  TYPE: null
  INSTALL_DATE: null
  SECURITY_CONTROLS: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 3
Name: Building Automaion System JACE
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [JACE 2: JACE 2] , [JACE 6: JACE 6] , [Other: Other]
• MODEL:
  Coded Values: [SEC - J - 201: SEC - J - 201] , [SEC - J - 601: SEC - J - 601] , [Other: Other]
• INSTALL_CONTRACTOR:
  Coded Values: [Energy Automation Technologies: Energy Automation Technologies] , [Envirocon: Envirocon] , [Other: Other]
• TYPE:
  Coded Values: [Security: Security] , [Other: Other]
• EXISTING:
  Inherited
Templates:
• Name: Building Automaion System JACE
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 3
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  INSTALL_CONTRACTOR: null
  TYPE: null
  INSTALL_DATE: null
  SECURITY_CONTROLS: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 2
Name: Building Automation System Device
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [American Auto: American Auto] , [Carel: Carel] , [Climate Master: Climate Master] , ...10 more...
• MODEL:
  Coded Values: [Jace 2: Jace 2] , [Jace 6: Jace 6] , [Other: Other]
• INSTALL_CONTRACTOR:
  Coded Values: [ABB: ABB] , [Energy Automation Technologies: Energy Automation Technologies] , [Envirocon: Envirocon] , ...1 more...
• TYPE:
  Coded Values: [Actuator: Actuator] , [Control Circuit Breaker: Control Circuit Breaker] , [Damper : Damper ] , ...11 more...
• EXISTING:
  Inherited
Templates:
• Name: Building Automation System Device
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 2
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  INSTALL_CONTRACTOR: null
  TYPE: null
  INSTALL_DATE: null
  SECURITY_CONTROLS: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 5
Name: DDC Meter - Water
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [BTU Onicon: BTU Onicon] , [Seametrics: Seametrics] , [Water Onicon: Water Onicon] , ...2 more...
• MODEL:
  Coded Values: [AO55: AO55] , [F-1120: F-1120] , [System-10: System-10] , ...2 more...
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• SECURITY_CONTROLS:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: DDC Meter - Water
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 5
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  INSTALL_CONTRACTOR: null
  TYPE: null
  INSTALL_DATE: null
  SECURITY_CONTROLS: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 4
Name: DDC Meter
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Emondmon: Emondmon] , [Ionmeter: Ionmeter] , [Schneider Powerlogic: Schneider Powerlogic] , ...3 more...
• MODEL:
  Coded Values: [480-3200-CEY: 480-3200-CEY] , [BCPMSC: BCPMSC] , [E50H5: E50H5] , ...3 more...
• INSTALL_CONTRACTOR:
  Coded Values: [ABB : ABB ] , [BROCK: BROCK] , [Energy Automation Technologies: Energy Automation Technologies] , ...3 more...
• INSTALL_DATE:
  Coded Values:
• SECURITY_CONTROLS:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: DDC Meter
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 4
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  INSTALL_CONTRACTOR: null
  TYPE: null
  INSTALL_DATE: null
  SECURITY_CONTROLS: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 7
Name: DDC Thermostat
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [Auto-Matrix : Auto-Matrix ] , [Honeywell: Honeywell] , [Vykonics: Vykonics] , ...1 more...
• MODEL:
  Coded Values: [SBC-STAT 1D: SBC-STAT 1D] , [SBC-STAT 3: SBC-STAT 3] , [T7350CsV2.1NM1: T7350CsV2.1NM1] , ...2 more...
• INSTALL_CONTRACTOR:
  Coded Values: [Energy Automation Technologies: Energy Automation Technologies] , [Envirocon: Envirocon] , [Other: Other]
• INSTALL_DATE:
  Coded Values:
• SECURITY_CONTROLS:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: DDC Thermostat
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 7
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  INSTALL_CONTRACTOR: null
  TYPE: null
  INSTALL_DATE: null
  SECURITY_CONTROLS: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 6
Name: DDC Sensor
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• MAKE:
  Coded Values: [ACI: ACI] , [Veris: Veris] , [Senva: Senva] , ...1 more...
• MODEL:
  Coded Values: [A/AN-D-8"-PB: A/AN-D-8"-PB] , [A/RH5-O: A/RH5-O] , [A/RH5-R: A/RH5-R] , ...11 more...
• INSTALL_CONTRACTOR:
  Coded Values: [Energy Automation Technologies: Energy Automation Technologies] , [Envirocon: Envirocon] , [Other: Other]
• TYPE:
  Coded Values:
• INSTALL_DATE:
  Coded Values:
• SECURITY_CONTROLS:
  Coded Values:
• EXISTING:
  Inherited
Templates:
• Name: DDC Sensor
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 6
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  INSTALL_CONTRACTOR: null
  TYPE: null
  INSTALL_DATE: null
  SECURITY_CONTROLS: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

ID: 8
Name: Other
Domains:
• ASSET_TYPE:
  Inherited
• FLOOR:
  Inherited
• ROOM_TYPE:
  Inherited
• EXISTING:
  Inherited
Templates:
• Name: Other
  Description:
  Prototype:
  FO_ASSET_ID: null
  NOTES: null
  ASSET_TYPE_SUBTYPE: 8
  ASSET_TYPE:
  ASSET_TAG:
  SITE:
  LOCATION:
  LEGACYID: null
  FLOOR: null
  ROOM_TYPE: null
  ROOM_ID: null
  MAKE: null
  MODEL: null
  INSTALL_CONTRACTOR: null
  TYPE: null
  INSTALL_DATE: null
  SECURITY_CONTROLS: null
  FACILITYID:
  EXISTING: Yes
  
  Drawing Tool: esriFeatureEditToolNone

---

Relationships:

• FACILITY_AND_OPERATIONS_ASSETS (4) -- Related To: FACILITY AND OPERATIONS ASSETS (1)

Capabilities: Query,Create,Update,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Related Records   Apply Edits   Add Features   Update Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata