Platform Owner	SureshPandian Pandian (Unlicensed)
Document status	WORK IN PROGRESS
Tech lead	Allena Kendrick (Unlicensed)
Technical writers	Vandana Bansal
PM	David Swanson (Unlicensed)
CI Owner	Valdemar Queiroga (Unlicensed)
CMDB Manager	Christopher Abbott (Unlicensed)
ServiceNow Developer	Vimalpriya Kothandapani (Unlicensed)

Aperture Data Model

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

Out of Scope

Browser not supported