Aperture Requirements
- Allena Kendrick (Unlicensed)
Aperture Data Model
Aperture Classes:
DV_DEVICE_T Schema
20190830 Export: Sort by Category all items in Green
Sort by Platform for all items in Green
DV_DEVICE_T | UNIQUE_ID | varchar | 18 | The unique identifier for this device |
DV_DEVICE_T | DEVICE_NAME | varchar | 42 | The name of this device. This is blank for cards. |
DV_DEVICE_T | SERIAL_NUMBER | varchar | 30 | The Serial number associated with this device |
DV_DEVICE_T | BARCODE_NUMBER | varchar | 20 | The Barcode number associated with this device |
DV_DEVICE_T | MANUFACTURER | varchar | 20 | The Manufacturer name of this device such as HP, Dell, etc. This is part of a three part key (Manufacturer, Model, Model_Info) to uniquely identify a device model. |
DV_DEVICE_T | MODEL | varchar | 20 | The Model of the device such as PowerEdge 2400, etc. This is part of a three part key (Manufacturer, Model, Model_Info) to uniquely identify a device model. |
DV_DEVICE_T | ASSET_NUMBER | varchar | 15 | The Asset Number associated with this device |
DV_DEVICE_T | RACK_NAME | varchar | 42 | The name of the Rack where this device is located |
DV_DEVICE_T | DEVICE_TYPE | varchar | 30 | The type of device. Typically this will be the same value as Asset Class. |
DV_DEVICE_T | INSTALL_STATUS | varchar | 25 | Indicates the Install Status of this device. Values can be Operational, Pending |
DV_DEVICE_T | RESERVED_STATUS | varchar | 50 | Indicates the Reservation Status of this device. Values can be RESERVED-INSTALL / RESERVED-MOVE / RESERVED-DISPOSE / RESERVED / AVAILABLE |
DV_DEVICE_T | OBJECTID | varchar | 18 | The Aperture OBJECTID associated with this device. Used for zooming to a front visual of the device. |
DV_DEVICE_T | MODEL_INFO | varchar | 24 | The Model Info of the device such as PowerEdge 2400, etc. This is part of a three part key (Manufacturer, Model, Model_Info) to uniquely identify a device model. |
DV_DEVICE_T | DESCRIPTION | varchar | 45 | The description of the Device Model as indicated in the DV_MANUFUCATURER_DEVICE_SPECS_T table. |
DV_DEVICE_T | USE_STATUS | varchar | 25 | Indicates the Use Status of this device. Values can be PENDING / SPARE / DEFECTIVE / INSTALLED |
DV_DEVICE_T | GRID_LOCATION | varchar | 12 | The User assigned Grid Location of the Device |
DV_DEVICE_T | HEIGHT | float | 8 | The Height of the device as indicated in the DV_MANUFUCATURER_DEVICE_SPECS_T table. |
DV_DEVICE_T | WIDTH | float | 8 | The Width of the device as indicated in the DV_MANUFUCATURER_DEVICE_SPECS_T table. |
DV_DEVICE_T | OBJECT_TYPE | varchar | 25 | Obsolete field. |
DV_DEVICE_T | BUILDING | varchar | 30 | The Building where this device is located |
DV_DEVICE_T | FLOOR | varchar | 25 | The Floor where this device is located |
DV_DEVICE_T | SPACE_ID | varchar | 25 | The name of the Space (Rasied Floor Space) where this device is located. |
DV_DEVICE_T | HEIGHT_UNITS | float | 8 | The height of this device in Rack Units (Height/1.75 inches) |
DV_DEVICE_T | TOP_RACK_UNIT | float | 8 | The Top Rack Unit of the device in the Rack. |
DV_DEVICE_T | BOTTOM_RACK_UNIT | float | 8 | The Bottom Rack Unit of the device in the Rack. |
DV_DEVICE_T | CLIENT | varchar | 25 | Obsolete field. |
DV_DEVICE_T | RACK_SPACE_NO | varchar | 25 | Obsolete field. |
DV_DEVICE_T | CAGE_SIZE | varchar | 10 | Obsolete field. |
DV_DEVICE_T | OBJECT_LOCATION | varchar | 20 | Obsolete field. |
DV_DEVICE_T | CATEGORY | varchar | 256 | The category to which the device belongs |
DV_DEVICE_T | PARENT_UNIQUE_ID | varchar | 18 | If this device instance describes a card, then this field points to the Parent Unique ID of the containing device. |
DV_DEVICE_T | RACK_UNIQUE_ID | varchar | 18 | The unique identifier of the Rack this device is installed in. |
DV_DEVICE_T | SPACE_UNIQUE_ID | varchar | 18 | The unique identifier of the Space (Raised Floor Space) where this device is located. |
DV_DEVICE_T | PLATFORM | varchar | 50 | The Platform such as Unix, Wintel, Linux, etc for this device |
DV_DEVICE_T | RECEPTACLE_TYPE | varchar | 25 | Receptacle type assoicated with the device. |
DV_DEVICE_T | DUAL_POWER | varchar | 4 | Inidicates if this device requires redundant power sources |
DV_DEVICE_T | NUM_CORDS | varchar | 4 | The number of power cords available on this device. |
DV_DEVICE_T | POWER_NEEDS | text | 16 | Describes any special power requirements for this device. |
DV_DEVICE_T | OBJECTID_TD | varchar | 18 | The Aperture OBJECTID of the top down visual for this device. |
DV_DEVICE_T | ROTATION | float | 8 | The Rotation angle for this device (0,90,180,270) for an FMD. (0,90) if device is an RMD. |
DV_DEVICE_T | DEPTH | float | 8 | The Depth of the device as indicated in the DV_MANUFUCATURER_DEVICE_SPECS_T table. |
DV_DEVICE_T | OBJECTID_REAR | varchar | 18 | The Aperture OBJECTID of the rear visual for this device. |
DV_DEVICE_T | RACK_MOUNT_SIDE | varchar | 10 | Indicates which side of the Rack the device is mounted. Values can be Front or Rear. |
DV_DEVICE_T | MOUNT_TYPE | varchar | 50 | Indicates the Mount Type for this device. Values are RACK MOUNT, FLOOR MOUNT, DEVICE MOUNT. This determines how the device can be placed. |
DV_DEVICE_T | ASSET_CLASS | varchar | 50 | The Asset Class categorization of this Device Model. This value comes from the symbol library. Values can be Server, Rack/Cabinet, Card, etc. This field is filtered throughout the product. |
DV_DEVICE_T | RACK_UNITS | float | 8 | If this device instance describes a Rack, then this field indicates the total Rack Units available in the rack. |
DV_DEVICE_T | RACK_INSIDE_HEIGHT | float | 8 | If this device instance describes a Rack, then this field indicates the inside height of the rack. |
DV_DEVICE_T | RACK_INSIDE_DEPTH | float | 8 | If this device instance describes a Rack, then this field indicates the inside depth of the rack. |
DV_DEVICE_T | RACK_INSIDE_WIDTH | float | 8 | If this device instance describes a Rack, then this field indicates the inside width of the rack. |
DV_DEVICE_T | DMZ | varchar | 8 | Indicates if this device is IN or OUTSIDE the DMZ. |
DV_DEVICE_T | TERM_SERVER_CONNECT | varchar | 12 | Inidicates if this device requires a terminal server connection. |
DV_DEVICE_T | MACHINE_CATEGORY | varchar | 50 | The Machine Category of the device such as Production, Development, QA, etc. |
DV_DEVICE_T | MACHINE_TYPE | varchar | 50 | The Machine Type indicates the function of this device. Values can be Domain Server, Application Server, Database Server, etc. |
DV_DEVICE_T | DATABASE_TYPE | varchar | 50 | If the Machine Type is Database Server, then this field indicates the name of the database. Values can be Oracle, SQL Server, etc. |
DV_DEVICE_T | OS_LEVEL | varchar | 50 | The OS Level of the PLATFORM associated with this device. |
DV_DEVICE_T | ALIGNMENT | varchar | 50 | The aligment of the device relative to a Floor Tile or relative to the Rack. |
DV_DEVICE_T | OFFSET_X | float | 8 | The Offset X of the device relative to the floor tile or relative to the rack. |
DV_DEVICE_T | OFFSET_Y | float | 8 | The Offset Y position of the device relative to the floor. |
DV_DEVICE_T | PLACEMENT_GRID | varchar | 12 | The internal Grid Location of the device. This is not user defineable. |
DV_DEVICE_T | RACK_START_UNIT | float | 8 | If this device instance describes a Rack, then this field indicates the start rack unit number. Values can be 0 or 1. |
DV_DEVICE_T | RU_SCALE_POS | varchar | 10 | If this device instance describes a Rack, then this field indicates if the Rack units are number Top to Bottom or Bottom to Top. |
DV_DEVICE_T | RACK_ROW_NAME | varchar | 50 | The Row Name associated with this device or rack |
DV_DEVICE_T | VC_VISUAL_PENDING | varchar | 1 | System field to indicate if a visual needs to be generated. |
DV_DEVICE_T | VC_VISUAL_PENDING_COUNTER | float | 8 | System field for managing generation of drawings |
DV_DEVICE_T | VC_VISUAL_STATUS | int | 4 | System field for managing generation of drawings |
DV_DEVICE_T | ASSET_SUB_CLASS | varchar | 50 | The Asset Sub Class associated with the Asset Class of the device. This is a more granualr categorization of the device (i.e. Asset Class = CARD, Asset Sub Class = BLADE SERVER) |
DV_DEVICE_T | OP_VOLTS | float | 8 | The operating voltage of this device |
DV_DEVICE_T | PSUPPLY_N | int | 4 | The minimum number of active power supplies in the device |
DV_DEVICE_T | PSUPPLY_MAX | int | 4 | The Maximum number of power supplies in the device - Obsolete. |
DV_DEVICE_T | POWER_FACTOR | float | 8 | The Power Factor assigned to the device |
DV_DEVICE_T | WATTS | float | 8 | The Watts of the device as indicated in the DV_MANUFACTURER_DEVICE_SPECS_T table. |
DV_DEVICE_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of this device instance |
DV_DEVICE_T | MLOAD_WATTS | float | 8 | The Measured Load (in Watts) of this device. |
DV_DEVICE_T | PARENT_VOB_ID | uniqueidentifier | 16 | If this device instance describes a card, then this field points to the Parent VOB_ID of the containing device. |
DV_DEVICE_T | RACK_VOB_ID | uniqueidentifier | 16 | The VOB_ID of the rack where this device is located. |
DV_DEVICE_T | SPACE_VOB_ID | uniqueidentifier | 16 | The VOB_ID of the Space (Raised Floor Space) where this device is located. |
DV_DEVICE_T | CONTAINER | varchar | 20 | The Container location for this device. Values can be RAISED FLOOR, RACK FRONT, RACK REAR, SLOT |
DV_DEVICE_T | LOCATION | varchar | 20 | Location of the device within the container. Values can be RAISED FLOOR - CEILING, WALL, FLOOR SURFACE, OTHER. RACK FRONT/REAR - INSIDE, TOP, BOTTOM, LEFT, RIGHT, LEFT RAIL, RIGHT RAIL, OTHER. SLOT - INSIDE |
DV_DEVICE_T | VISUAL | char | 1 | Y/N. Internal use. If Y, a visual is created for the device. |
DV_DEVICE_T | PLACE_COMMENT | varchar | 100 | A placement comment to describe any unique characteristics of the device placement. |
DV_DEVICE_T | VC_REBUILD_TOPDOWN | varchar | 1 | Indicates if the Topdown visual should be rebuilt |
DV_DEVICE_T | VC_REBUILD_FRONT_ELEVATION | varchar | 1 | Indicates if the Front Elevation visual should be rebuilt |
DV_DEVICE_T | VC_REBUILD_REAR_ELEVATION | varchar | 1 | Indicates if the Rear Elevation visual should be rebuilt |
DV_DEVICE_T | FMD_PARENT_VOB_ID | uniqueidentifier | 16 | The FMD relative to which this device has been placed, if applicable. |
DV_DEVICE_T | GHOST_VOB_ID | uniqueidentifier | 16 | Internal use, used during a device move. |
DV_DEVICE_T | ORIGINAL_VOB_ID | uniqueidentifier | 16 | Internal use, used during a device move. |
DV_DEVICE_T | SLOT_VOB_ID | uniqueidentifier | 16 | If this device instance describes a card, then this field indicates the SLOT VOB_ID this card is associated with. |
DV_DEVICE_T | SLOT_UNIQUE_ID | varchar | 18 | If this device instance describes a card, then this field indicates the slot unqiueid this card is associated with. |
DV_DEVICE_T | VC_VISUAL_PENDING_TIMESTAMP | datetime | 8 | An internal use field for Visual Generator. |
DV_DEVICE_T | MLOAD_WATTS_OVERRIDE_DEFAULT | varchar | 1 | Indicates if the default was overridden for this field |
DV_DEVICE_T | OP_VOLTS_OVERRIDE_DEFAULT | varchar | 1 | Indicates if the default was overridden for this field |
DV_DEVICE_T | PSUPPLY_N_OVERRIDE_DEFAULT | varchar | 1 | Indicates if the default was overridden for this field |
JOIN Table Name |
| DV_APPLICATION_CATALOG_T |
| DV_APPLICATION_T |
| DV_DEVICE_T |
| DV_FLOOR_GRID_COLUMN_T |
| DV_FLOOR_GRID_ROW_T |
| DV_FLOOR_GRID_T |
| DV_FLOOR_T |
| DV_MANUFACTURER_DEVICE_SPECS_T |
| DV_RACK_ATTRIBUTES_T |
| DV_RACK_FREESPACE_T |
| DV_RACK_SUMMARY_T |
| DV_SLOT_T |
| DV_SPACE_T |
| DV_SPACE_T |
| PWR_BREAKER_T |
| PWR_GENERATOR_T |
| PWR_PANEL_T |
| PWR_PDU_T |
| PWR_POWER_STRIP_T |
| PWR_RPP_T |
| PWR_STRIP_TYPES |
| PWR_UPS_T |
| DATA_CENTER_T |
| DATA_CENTER_SPACE_REL_T |
Selected Data Attributes
| Table Name | Field Name | Data Type | Length | Description |
| DV_APPLICATION_CATALOG_T | APPLICATION_ID | bigint | 8 | The unique identifier for this Application |
| DV_APPLICATION_CATALOG_T | APPLICATION_NAME | varchar | 50 | The name of the Application in this catalog |
| DV_APPLICATION_CATALOG_T | VERSION | varchar | 50 | The Version of the Application |
| DV_APPLICATION_CATALOG_T | VENDOR | varchar | 50 | The Vendor of the Application |
| DV_APPLICATION_CATALOG_T | PRIMARY_CONTACT | varchar | 50 | The primary support contact for this application |
| DV_APPLICATION_CATALOG_T | SECONDARY_CONTACT | varchar | 50 | The secondary support contact for this application |
| DV_APPLICATION_CATALOG_T | SUPPORT_GROUP | varchar | 50 | The Support Group associated with this application |
| DV_APPLICATION_CATALOG_T | BUSINESS_AREA | varchar | 50 | The Business Area associated with this application |
| DV_APPLICATION_CATALOG_T | CRITICAL_STATUS | varchar | 1 | The Critical status of the application to the organization |
| DV_APPLICATION_T | UNIQUE_ID | varchar | 18 | The UniqueID of the device this application is associated with |
| DV_APPLICATION_T | APPLICATION_ID | varchar | 50 | The ApplicationID associated with the device |
| DV_APPLICATION_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of this application instance. |
| DV_DEVICE_T | UNIQUE_ID | varchar | 18 | The unique identifier for this device |
| DV_DEVICE_T | DEVICE_NAME | varchar | 42 | The name of this device. This is blank for cards. |
| DV_DEVICE_T | SERIAL_NUMBER | varchar | 30 | The Serial number associated with this device |
| DV_DEVICE_T | BARCODE_NUMBER | varchar | 20 | The Barcode number associated with this device |
| DV_DEVICE_T | MANUFACTURER | varchar | 20 | The Manufacturer name of this device such as HP, Dell, etc. This is part of a three part key (Manufacturer, Model, Model_Info) to uniquely identify a device model. |
| DV_DEVICE_T | MODEL | varchar | 20 | The Model of the device such as PowerEdge 2400, etc. This is part of a three part key (Manufacturer, Model, Model_Info) to uniquely identify a device model. |
| DV_DEVICE_T | ASSET_NUMBER | varchar | 15 | The Asset Number associated with this device |
| DV_DEVICE_T | RACK_NAME | varchar | 42 | The name of the Rack where this device is located |
| DV_DEVICE_T | DEVICE_TYPE | varchar | 30 | The type of device. Typically this will be the same value as Asset Class. |
| DV_DEVICE_T | INSTALL_STATUS | varchar | 25 | Indicates the Install Status of this device. Values can be Operational, Pending |
| DV_DEVICE_T | MODEL_INFO | varchar | 24 | The Model Info of the device such as PowerEdge 2400, etc. This is part of a three part key (Manufacturer, Model, Model_Info) to uniquely identify a device model. |
| DV_DEVICE_T | DESCRIPTION | varchar | 45 | The description of the Device Model as indicated in the DV_MANUFUCATURER_DEVICE_SPECS_T table. |
| DV_DEVICE_T | GRID_LOCATION | varchar | 12 | The User assigned Grid Location of the Device |
| DV_DEVICE_T | HEIGHT | float | 8 | The Height of the device as indicated in the DV_MANUFUCATURER_DEVICE_SPECS_T table. |
| DV_DEVICE_T | WIDTH | float | 8 | The Width of the device as indicated in the DV_MANUFUCATURER_DEVICE_SPECS_T table. |
| DV_DEVICE_T | BUILDING | varchar | 30 | The Building where this device is located |
| DV_DEVICE_T | FLOOR | varchar | 25 | The Floor where this device is located |
| DV_DEVICE_T | SPACE_ID | varchar | 25 | The name of the Space (Rasied Floor Space) where this device is located. |
| DV_DEVICE_T | HEIGHT_UNITS | float | 8 | The height of this device in Rack Units (Height/1.75 inches) |
| DV_DEVICE_T | TOP_RACK_UNIT | float | 8 | The Top Rack Unit of the device in the Rack. |
| DV_DEVICE_T | BOTTOM_RACK_UNIT | float | 8 | The Bottom Rack Unit of the device in the Rack. |
| DV_DEVICE_T | RACK_SPACE_NO | varchar | 25 | Obsolete field. |
| DV_DEVICE_T | RACK_UNIQUE_ID | varchar | 18 | The unique identifier of the Rack this device is installed in. |
| DV_DEVICE_T | SPACE_UNIQUE_ID | varchar | 18 | The unique identifier of the Space (Raised Floor Space) where this device is located. |
| DV_DEVICE_T | RECEPTACLE_TYPE | varchar | 25 | Receptacle type assoicated with the device. |
| DV_DEVICE_T | DUAL_POWER | varchar | 4 | Inidicates if this device requires redundant power sources |
| DV_DEVICE_T | POWER_NEEDS | text | 16 | Describes any special power requirements for this device. |
| DV_DEVICE_T | DEPTH | float | 8 | The Depth of the device as indicated in the DV_MANUFUCATURER_DEVICE_SPECS_T table. |
| DV_DEVICE_T | RACK_MOUNT_SIDE | varchar | 10 | Indicates which side of the Rack the device is mounted. Values can be Front or Rear. |
| DV_DEVICE_T | MOUNT_TYPE | varchar | 50 | Indicates the Mount Type for this device. Values are RACK MOUNT, FLOOR MOUNT, DEVICE MOUNT. This determines how the device can be placed. |
| DV_DEVICE_T | ASSET_CLASS | varchar | 50 | The Asset Class categorization of this Device Model. This value comes from the symbol library. Values can be Server, Rack/Cabinet, Card, etc. This field is filtered throughout the product. |
| DV_DEVICE_T | RACK_UNITS | float | 8 | If this device instance describes a Rack, then this field indicates the total Rack Units available in the rack. |
| DV_DEVICE_T | RACK_INSIDE_HEIGHT | float | 8 | If this device instance describes a Rack, then this field indicates the inside height of the rack. |
| DV_DEVICE_T | RACK_INSIDE_DEPTH | float | 8 | If this device instance describes a Rack, then this field indicates the inside depth of the rack. |
| DV_DEVICE_T | RACK_INSIDE_WIDTH | float | 8 | If this device instance describes a Rack, then this field indicates the inside width of the rack. |
| DV_DEVICE_T | MACHINE_CATEGORY | varchar | 50 | The Machine Category of the device such as Production, Development, QA, etc. |
| DV_DEVICE_T | MACHINE_TYPE | varchar | 50 | The Machine Type indicates the function of this device. Values can be Domain Server, Application Server, Database Server, etc. |
| DV_DEVICE_T | OS_LEVEL | varchar | 50 | The OS Level of the PLATFORM associated with this device. |
| DV_DEVICE_T | RACK_START_UNIT | float | 8 | If this device instance describes a Rack, then this field indicates the start rack unit number. Values can be 0 or 1. |
| DV_DEVICE_T | RACK_ROW_NAME | varchar | 50 | The Row Name associated with this device or rack |
| DV_DEVICE_T | OP_VOLTS | float | 8 | The operating voltage of this device |
| DV_DEVICE_T | PSUPPLY_N | int | 4 | The minimum number of active power supplies in the device |
| DV_DEVICE_T | WATTS | float | 8 | The Watts of the device as indicated in the DV_MANUFACTURER_DEVICE_SPECS_T table. |
| DV_DEVICE_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of this device instance |
| DV_DEVICE_T | LOCATION | varchar | 20 | Location of the device within the container. Values can be RAISED FLOOR - CEILING, WALL, FLOOR SURFACE, OTHER. RACK FRONT/REAR - INSIDE, TOP, BOTTOM, LEFT, RIGHT, LEFT RAIL, RIGHT RAIL, OTHER. SLOT - INSIDE |
| DV_DEVICE_T | SLOT_VOB_ID | uniqueidentifier | 16 | If this device instance describes a card, then this field indicates the SLOT VOB_ID this card is associated with. |
| DV_DEVICE_T | SLOT_UNIQUE_ID | varchar | 18 | If this device instance describes a card, then this field indicates the slot unqiueid this card is associated with. |
| DV_FLOOR_GRID_COLUMN_T | UNIQUE_ID | varchar | 18 | The unique id of the space this column is associated with |
| DV_FLOOR_GRID_COLUMN_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of this column name |
| DV_FLOOR_GRID_ROW_T | UNIQUE_ID | varchar | 18 | The unique id of the space this row is associated with |
| DV_FLOOR_GRID_ROW_T | ROW_NUMBER | int | 4 | The row number of this row name |
| DV_FLOOR_GRID_ROW_T | ROW_NAME | varchar | 5 | The name of the row for this space |
| DV_FLOOR_GRID_T | UNIQUE_ID | varchar | 18 | The unique id of the space this Grid definition is associated with. |
| DV_FLOOR_GRID_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of the space |
| DV_FLOOR_T | BUILDING | varchar | 30 | The name of the building this floor is associated with |
| DV_FLOOR_T | FLOOR | varchar | 15 | The Floor name of this floor |
| DV_FLOOR_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of the floor |
| DV_MANUFACTURER_DEVICE_SPECS_T | MANUFACTURER | varchar | 20 | The manufacturer of the device. Such as Hewlett Packard or IBM. This field is loaded from the symbol used to define this device. |
| DV_MANUFACTURER_DEVICE_SPECS_T | MODEL | varchar | 20 | The model of the device as specifiec by the manufacturer. Obtained from symbol |
| DV_MANUFACTURER_DEVICE_SPECS_T | MODEL_INFO | varchar | 24 | This field is used to clarify the Model. For example, if a given model has 2 voltages, this field will difrientiate 1 form the other. This field is loaded form the symbol |
| DV_MANUFACTURER_DEVICE_SPECS_T | VOLTS_50HZ | float | 8 | The "Typical" voltage used in europe. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | POWER_KVA_50HZ | float | 8 | The power load at 50Hz in kVA. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | PHASES_50HZ | float | 8 | The number of phases in a 50Hz environment. Not used in V500' |
| DV_MANUFACTURER_DEVICE_SPECS_T | NUMBER_WIRES_50HZ | float | 8 | The number of wires in a power connection in the 50HZ case. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | PLUG_50HZ | varchar | 12 | The plug designztion (NEMA/IEC/R&S…) in the 50HZ environment. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | CONNECTOR_50HZ | varchar | 12 | The connector designation in the 50HZ environment. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | RECEPTACLE_50HZ | varchar | 12 | The receptacle designztion (NEMA/IEC/R&S…) in the 50HZ environment. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | VOLTS | float | 8 | The voltage this device runs at. A typical value is used when multiple values are possible. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | POWER_KVA | float | 8 | The power load at 60Hz in kVA. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | PHASES | float | 8 | The number of phases. Not used in V500' |
| DV_MANUFACTURER_DEVICE_SPECS_T | NUMBER_WIRES | float | 8 | The number of wires in a power connection. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | PLUG | varchar | 12 | The plug designztion (NEMA/IEC/R&S…). Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | CONNECTOR | varchar | 12 | The connector designation. Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | RECEPTACLE | varchar | 12 | The receptacle designztion (NEMA/IEC/R&S…). Not used in V500 |
| DV_MANUFACTURER_DEVICE_SPECS_T | MIN_TEMP_F | float | 8 | Environmental Requirement |
| DV_MANUFACTURER_DEVICE_SPECS_T | MAX_TEMP_F | float | 8 | Environmental Requirement |
| DV_MANUFACTURER_DEVICE_SPECS_T | WET_BULF_F | float | 8 | Environmental Requirement |
| DV_MANUFACTURER_DEVICE_SPECS_T | MIN_HUMID_PERCENT | float | 8 | Environmental Requirement |
| DV_MANUFACTURER_DEVICE_SPECS_T | MAX_HUMID_PERCENT | float | 8 | Environmental Requirement |
| DV_MANUFACTURER_DEVICE_SPECS_T | MIN_TEMP_C | float | 8 | Environmental Requirement |
| DV_MANUFACTURER_DEVICE_SPECS_T | MAX_TEMP_C | float | 8 | Environmental Requirement |
| DV_MANUFACTURER_DEVICE_SPECS_T | WET_BULB_C | float | 8 | Environmental Requirement |
| DV_MANUFACTURER_DEVICE_SPECS_T | TO_AIR_BTU | float | 8 | The heat dissapation to air of the device |
| DV_MANUFACTURER_DEVICE_SPECS_T | TO_AIR_WATT | float | 8 | The heat dissapation in Watts of the device |
| DV_MANUFACTURER_DEVICE_SPECS_T | TO_WATER_WATT | float | 8 | The head dissapation to watter in watts for water cooled devices (Older mainframes) |
| DV_MANUFACTURER_DEVICE_SPECS_T | AIRFLOW_M3_MIN | float | 8 | Air flow through the device in cubic meters/Min |
| DV_MANUFACTURER_DEVICE_SPECS_T | AIRFLOW_CFM | float | 8 | Air flow through the device in cubic feet/Min |
| DV_MANUFACTURER_DEVICE_SPECS_T | TO_WATER_BTU | float | 8 | The head dissapation to watter in BTU for water cooled devices (Older mainframes) |
| DV_MANUFACTURER_DEVICE_SPECS_T | HEIGHT_IN | float | 8 | Height Dimension in Inches of the device in normal orientation |
| DV_MANUFACTURER_DEVICE_SPECS_T | WIDTH_IN | float | 8 | Width Dimension in Inches of the device in normal orientation |
| DV_MANUFACTURER_DEVICE_SPECS_T | DEPTH_IN | float | 8 | Depth Dimension in Inches of the device in normal orientation |
| DV_MANUFACTURER_DEVICE_SPECS_T | WEIGHT_LBS | float | 8 | The weight in Lbs of the device |
| DV_MANUFACTURER_DEVICE_SPECS_T | HEIGHT_MM | float | 8 | Height Dimension in MM of the device in normal orientation |
| DV_MANUFACTURER_DEVICE_SPECS_T | WIDTH_MM | float | 8 | Width Dimension in MM of the device in normal orientation |
| DV_MANUFACTURER_DEVICE_SPECS_T | DEPTH_MM | float | 8 | Depth Dimension in MM of the device in normal orientation |
| DV_MANUFACTURER_DEVICE_SPECS_T | DESCRIPTION | varchar | 50 | A general description of the device |
| DV_MANUFACTURER_DEVICE_SPECS_T | AMPS | float | 8 | The power load in Amps at 60Hz. Not used in V500 |
| DV_RACK_ATTRIBUTES_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of the rack |
| DV_RACK_ATTRIBUTES_T | DEVICE_UNIQUE_ID | varchar | 18 | The unique id of the rack |
| DV_RACK_ATTRIBUTES_T | POWER_CAPACITY_WATTS | float | 8 | The design power capacity for the rack |
| DV_RACK_ATTRIBUTES_T | POWER_LIMIT | float | 8 | The operating threshold capacity for the rack |
| DV_RACK_ATTRIBUTES_T | THERMAL_CAPACITY_WATTS | float | 8 | The design thermal capacity for the rack |
| DV_RACK_ATTRIBUTES_T | THERMAL_LIMIT | float | 8 | The operating threshold capacity for the rack |
| DV_RACK_ATTRIBUTES_T | WEIGHT_THRESHOLD | float | 8 | The weight thresold for the rack |
| DV_RACK_ATTRIBUTES_T | RACK_USE | varchar | 50 | The Rack use or purpose of the rack. The values for this field are user definable |
| DV_RACK_FREESPACE_T | UNIQUE_ID | varchar | 18 | The UNIQUE_ID of the rack this entry is for |
| DV_RACK_SUMMARY_T | UNIQUE_ID | varchar | 18 | The UNIQUE_ID of the rack this entry is for |
| DV_RACK_SUMMARY_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of the rack |
| DV_RACK_SUMMARY_T | TOTAL_WEIGHT | float | 8 | The total weight (in Lbs) of all the devices in the rack (Including the rack) |
| DV_RACK_SUMMARY_T | DEVICE_WATTS | float | 8 | The sum af all the device Watt loads in this rack |
| DV_RACK_SUMMARY_T | WATTS_LOAD | float | 8 | The total watts consumed in the rack. This is the sum of the watts for each device in the rack. |
| DV_SLOT_T | UNIQUE_ID | varchar | 18 | The Uique ID of the slot |
| DV_SLOT_T | SLOT_NUMBER | varchar | 3 | Slot number as assigned in the symbol |
| DV_SLOT_T | PARENT_OBJECTID | varchar | 18 | The Object ID of the object containing the slot |
| DV_SLOT_T | PARENT_UNIQUE_ID | varchar | 18 | The nuiqueID of the object containing the slot |
| DV_SLOT_T | OBJECTID | varchar | 18 | The OBJECTID of the slot |
| DV_SLOT_T | STATUS | varchar | 10 | A flag indicating the status of the slot (OPEN/USED…) |
| DV_SLOT_T | SIDE | varchar | 10 | THE side of the device the slot is on (FRONT/REAR) |
| DV_SLOT_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of the slot |
| DV_SLOT_T | PARENT_VOB_ID | uniqueidentifier | 16 | The VOB_ID of the object containing the slot |
| DV_SLOT_T | HEIGHT | float | 8 | The Height in inches of the slot |
| DV_SLOT_T | WIDTH | float | 8 | The width in inches of the slot |
| DV_SPACE_T | UNIQUE_ID | varchar | 18 | The UNIQUE_ID of the space |
| DV_SPACE_T | SPACE_USE | varchar | 25 | The Unique ID of the drawing polygon defining the space |
| DV_SPACE_T | SPACE_TYPE | varchar | 25 | A description if the "Type" of space. Always "ASSIGNABLE" for data centers |
| DV_SPACE_T | SPACE_NAME | varchar | 15 | The space name as assigned when the space is defined |
| DV_SPACE_T | FLOOR | varchar | 15 | The Floor the space is on |
| DV_SPACE_T | BUILDING | varchar | 30 | The name of the building the space is in |
| DV_SPACE_T | SPACE_ID | varchar | 30 | A string automatically calculated showing the Building code and the space name |
| DV_SPACE_T | BUILDING_CODE | varchar | 8 | The building code for the building the space is in |
| DV_SPACE_T | SPACE_CODE | varchar | 5 | A user assigned Space Code |
| DV_SPACE_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of the space |
| PWR_BREAKER_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of the Breaker |
| PWR_BREAKER_T | HOLD_DEVICE_VOB_ID | uniqueidentifier | 16 | The VOB_ID of the containing object (usually a panel) |
| PWR_BREAKER_T | BREAKER_NAME | varchar | 20 | The user assigned name of the breaker |
| PWR_BREAKER_T | TRIP_CURRENT_AMPS | int | 4 | The trip cuttent in amps of the breaker |
| PWR_BREAKER_T | NUM_POLES | int | 4 | The number of poles of the breaker (1,2, or 3) |
| PWR_BREAKER_T | MEASURED_TEMP_F | float | 8 | The measured temperature in degrees F of the breaker |
| PWR_BREAKER_T | PANEL_POSITION | int | 4 | The panel position the top pole of the breaker is installed in |
| PWR_BREAKER_T | LOAD_SAFTY_FACTOR_PCT | int | 4 | The load safety factor required for this Breaker (% of Maximum) |
| PWR_BREAKER_T | OP_THRESHOLD_PCT | int | 4 | The operational threshold factor required for this Breaker(% of Maximum) |
| PWR_GENERATOR_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of this generator |
| PWR_GENERATOR_T | DEVICE_UNIQUE_ID | varchar | 18 | The DEVICE UNIQUEID od this generator |
| PWR_GENERATOR_T | OUTPUT_VOLTS | int | 4 | The nominal voltage output by this generator |
| PWR_GENERATOR_T | MAX_OUTPUT_WATTS | int | 4 | The Maximum watts this generator can output |
| PWR_GENERATOR_T | MAX_OUTPUT_AMPS | float | 8 | The Maximum Amps this generator can output |
| PWR_GENERATOR_T | NUM_PHASES | int | 4 | The number of phases output by this generator |
| PWR_GENERATOR_T | LOAD_SAFTY_FACTOR_PCT | int | 4 | The load safety factor required for this Generator (% of Maximum) |
| PWR_GENERATOR_T | OP_THRESHOLD_PCT | int | 4 | The operational threshold factor for this Generator(% of Maximum) |
| PWR_PANEL_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of this panel |
| PWR_PANEL_T | HOLD_DEVICE_VOB_ID | uniqueidentifier | 16 | The VOB_ID of the object continong this panel |
| PWR_PANEL_T | MAIN_BREAKER_TRIP_AMPS | int | 4 | The trip amp value fo the main breaker on this panel |
| PWR_PANEL_T | PANEL_NAME | varchar | 20 | The Panel name |
| PWR_PANEL_T | MAX_AMPS | int | 4 | The Maximum amps this panel can handle(Manufacturers specification) |
| PWR_PANEL_T | MAX_POSITIONS | int | 4 | The number of mreaker positions in this panel |
| PWR_PANEL_T | NUM_PHASES | int | 4 | The number of phases this panel distributes |
| PWR_PANEL_T | LOAD_SAFTY_FACTOR_PCT | int | 4 | The load safety factor required for this PAnel (% of Maximum) |
| PWR_PANEL_T | PANEL_STYLE | int | 4 | The panel style(1=US Style 2 column;2=UK Style 2 column;3=1 column) |
| PWR_PANEL_T | OP_THRESHOLD_PCT | int | 4 | The operational threshold factor required for this Panel(% of Maximum) |
| PWR_PANEL_T | CATEGORY | varchar | 256 | The category to which the device belongs |
| PWR_PDU_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of this PDU |
| PWR_PDU_T | DEVICE_UNIQUE_ID | varchar | 18 | The UNIQUE_ID of the PDU device |
| PWR_PDU_T | INPUT_VOLTS | int | 4 | The input voltage of this PDU |
| PWR_PDU_T | OUTPUT_VOLTS | int | 4 | The output voltage of this PDU |
| PWR_PDU_T | MAX_OUTPUT_WATTS | int | 4 | The maximum output in watts of this PDU |
| PWR_PDU_T | MAX_OUTPUT_AMPS | float | 8 | The maximum output in Amps of this PDU |
| PWR_PDU_T | NUM_FEEDS | int | 4 | The number of feeds this PDU can take(1 or 2) |
| PWR_PDU_T | NUM_PHASES | int | 4 | The number of phases this PDU distributes |
| PWR_PDU_T | LOAD_SAFTY_FACTOR_PCT | int | 4 | The load safety factor required for this PDU (% of Maximum) |
| PWR_PDU_T | OP_THRESHOLD_PCT | int | 4 | The operational threshold factor required for this PDU(% of Maximum) |
| PWR_POWER_STRIP_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of this strip |
| PWR_POWER_STRIP_T | DEVICE_UNIQUE_ID | varchar | 18 | The Device UNIQUE_ID of this Strip |
| PWR_POWER_STRIP_T | MAX_AMPS | int | 4 | The Maximum amps this strip can handle(Manufacturers specification) |
| PWR_POWER_STRIP_T | NUM_LEGS | int | 4 | Tne numer of legs(phases) this strip distributes |
| PWR_POWER_STRIP_T | STRIP_TYPE | int | 4 | An attribute distingushing strip types(1 = Power Strip, 2 = Under-floor receptacle) |
| PWR_RPP_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID fo this RPP |
| PWR_RPP_T | DEVICE_UNIQUE_ID | varchar | 18 | The UNIQUE ID of this RPP device |
| PWR_RPP_T | MAX_WATTS | int | 4 | The Makimum Watts this RPP can support |
| PWR_RPP_T | INPUT_BREAKER_TRIP_AMPS | int | 4 | The trip amp rating of the main circuit breaker (If any) |
| PWR_RPP_T | NUM_PHASES | int | 4 | The number of phases this RPP distributes |
| PWR_RPP_T | RPP_TYPE | int | 4 | A code indicating the RPP type(1 = RPP, 2 = Tap Box, 3 = Sub-Panel) |
| PWR_RPP_T | PANEL_CONNECTION | int | 4 | A code indicating the panel connection scheme for this RPP (1 = Direct, 2 = RPP Connected) |
| PWR_RPP_T | LOAD_SAFTY_FACTOR_PCT | int | 4 | The load safety factor required for this RPP (% of Maximum) |
| PWR_RPP_T | OP_THRESHOLD_PCT | int | 4 | The operational threshold factor required for this RPP(% of Maximum) |
| PWR_STRIP_TYPES | CODE | int | 4 | Power Strip type code |
| PWR_STRIP_TYPES | NAME | varchar | 50 | User Readable name for this strip type code |
| PWR_UPS_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of this UPS |
| PWR_UPS_T | DEVICE_UNIQUE_ID | varchar | 18 | The Device UNIQUEID of this UPS |
| PWR_UPS_T | INPUT_VOLTAGE | int | 4 | The input voltage of this UPS |
| PWR_UPS_T | OUTPUT_VOLTAGE | int | 4 | The output voltage of this UPS |
| PWR_UPS_T | MAX_WATTS | int | 4 | The Maximum Watts this UPS outputs |
| PWR_UPS_T | MAX_AMPS | float | 8 | The Maximum Amps this UPS outputs |
| PWR_UPS_T | NUM_PHASES | int | 4 | The number of output phases for this UPS |
| PWR_UPS_T | LOAD_SAFTY_FACTOR_PCT | int | 4 | The load safety factor required for this UPS (% of Maximum) |
| PWR_UPS_T | OP_THRESHOLD_PCT | int | 4 | The operational threshold factor required for this UPS(% of Maximum) |
| DATA_CENTER_T | NAME | varchar | 128 | Name of the data center |
| DATA_CENTER_T | CODE | varchar | 5 | Code of the data center |
| DATA_CENTER_T | DESCRIPTION | varchar | 256 | Description of the data center |
| DATA_CENTER_T | ENTERPRISE_VOB_ID | uniqueidentifier | 16 | The ENTERPRISE_VOB_ID of the data center |
| DATA_CENTER_T | REGION | varchar | 50 | Region of the data center |
| DATA_CENTER_T | VOB_ID | uniqueidentifier | 16 | The VOB_ID of the data center |
| DATA_CENTER_SPACE_REL_T | DATA_CENTER_VOB_ID | uniqueidentifier | 16 | The DATA_CENTER_VOB_ID of the data center |
| DATA_CENTER_SPACE_REL_T | SPACE_VOB_ID | uniqueidentifier | 16 | The SPACE_VOB_ID of the data center |
Relationships
Open Questions
| Question | Answer | Date Answered |
|---|---|---|