Name: Actuators and Operators

Display Field: ROOMNAME

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:

Type ID Field: ASSET_TYPE_SUBTYPE

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ASSET_TYPE_SUBTYPE (type: esriFieldTypeInteger, alias: ASSET_TYPE_SUBTYPE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASSET_TYPE (type: esriFieldTypeString, alias: ASSET_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Door/Gate Operator: Door/Gate Operator], [Electric Actuator: Electric Actuator], [Hydraulic Actuator: Hydraulic Actuator], ... 1 more ...)
• CAMPUS (type: esriFieldTypeString, alias: CAMPUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [D.E. Benton WTP: D.E. Benton WTP], [E.M. Johnson WTP: EM Johnson WTP], [Neuse River WWTP: Neuse River WWTP], ... 2 more ...)
• BUILDING (type: esriFieldTypeString, alias: BUILDING, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [50-Trinity Academy PS: 50-Trinity Academy PS], [51-New Hope PS: 51-New Hope PS], [57-Bent Tree PS: 57-Bent Tree PS], ... 56 more ...)
• FLOOR (type: esriFieldTypeString, alias: FLOOR, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Basement: Basement], [1st Floor: 1st Floor], [2nd Floor: 2nd Floor], ... 12 more ...)
• FLOORID (type: esriFieldTypeString, alias: FLOORID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ROOMTYPE (type: esriFieldTypeString, alias: ROOMTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Administration: Administration], [Aeration Basin: Aeration Basin], [Aerobic Digester: Aerobic Digester], ... 59 more ...)
• ROOMNAME (type: esriFieldTypeString, alias: ROOMNAME, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ROOMID (type: esriFieldTypeString, alias: ROOMID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PLC (type: esriFieldTypeString, alias: PLC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PROCESS (type: esriFieldTypeString, alias: PROCESS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• SUBPROCESS (type: esriFieldTypeString, alias: SUBPROCESS, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ENTITYTYPE (type: esriFieldTypeString, alias: ENTITYTYPE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• RPUD_PUVA_ACTUATORS_OPERATORS_A (type: esriFieldTypeString, alias: RPUD.PUVA_ACTUATORS_OPERATORS.AREA, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FACILITYID (type: esriFieldTypeString, alias: FACILITYID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MAKE (type: esriFieldTypeString, alias: MAKE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ASSET_MODEL (type: esriFieldTypeString, alias: ASSET_MODEL, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• SERIAL_NUMBER (type: esriFieldTypeString, alias: SERIAL_NUMBER, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• TORQUE (type: esriFieldTypeInteger, alias: TORQUE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VOLTAGE (type: esriFieldTypeString, alias: VOLTAGE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• AMPS (type: esriFieldTypeInteger, alias: AMPS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUILDINGID (type: esriFieldTypeString, alias: BUILDINGID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TAGNAME (type: esriFieldTypeDouble, alias: TAGNAME, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NOTES (type: esriFieldTypeString, alias: NOTES, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• ASSET_TAG (type: esriFieldTypeString, alias: ASSET_TAG, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)

Types:

ID: 0
Name: Door/Gate Operator
Domains:

• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: FLOOR
  Inherited
  
• Field Name: ROOMTYPE
  Inherited
  
• Field Name: MAKE
  Coded Values:[Stanley: Stanley], [Liftmaster: Liftmaster], [Hy-Security: Hy-Security], More
  
• Field Name: VOLTAGE
  Coded Values:
  
• Field Name: AMPS
  Coded Values:
  
Templates:

Name: Door/Gate Operator
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• ASSET_TYPE_SUBTYPE: 0

---

ID: 1
Name: Electric Actuator
Domains:

• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: FLOOR
  Inherited
  
• Field Name: ROOMTYPE
  Inherited
  
• Field Name: MAKE
  Coded Values:[Auma: Auma], [Beck: Beck], [Rotorque: Rotorque], More
  
• Field Name: VOLTAGE
  Coded Values:[120: 120], [240: 240], [120/208/240: 120/208/240], More
  
Templates:

Name: Electric Actuator
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• ASSET_TYPE_SUBTYPE: 1

---

ID: 2
Name: Hydraulic Actuator
Domains:

• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: FLOOR
  Inherited
  
• Field Name: ROOMTYPE
  Inherited
  
• Field Name: MAKE
  Coded Values:[Ashbrook: Ashbrook], [Parker: Parker]
  
• Field Name: VOLTAGE
  Coded Values:
  
• Field Name: AMPS
  Coded Values:
  
Templates:

Name: Hydraulic Actuator
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• ASSET_TYPE_SUBTYPE: 2

---

ID: 3
Name: Pneumatic Actuator
Domains:

• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: FLOOR
  Inherited
  
• Field Name: ROOMTYPE
  Inherited
  
• Field Name: MAKE
  Coded Values:[Kinetrol: Kinetrol], [Dezurik: Dezurik], [Chicago Pneumatic: Chicago Pneumatic]
  
• Field Name: VOLTAGE
  Coded Values:
  
• Field Name: AMPS
  Coded Values:
  
Templates:

Name: Pneumatic Actuator
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• ASSET_TYPE_SUBTYPE: 3

---

ID: 4
Name: Other Actuator
Domains:

• Field Name: ASSET_TYPE
  Inherited
  
• Field Name: FLOOR
  Inherited
  
• Field Name: ROOMTYPE
  Inherited
  
• Field Name: VOLTAGE
  Coded Values:[120: 120], [240: 240], [120/208/240: 120/208/240], More
  
Templates:

Name: Other Actuator
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• ASSET_TYPE_SUBTYPE: 4

---

Relationships:

• ROOM (1) -- Related To: Buildings (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/19/2019 2:42:26 PM

Schema Last Edit Date: 9/19/2019 2:42:26 PM

Data Last Edit Date: 9/19/2019 2:42:26 PM

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