| Device Identifer |
| Base Entity | Device Physical Location |
| Attribute Name | Device Identifer |
| Logical Rolename | |
| ColumnName | DVC_ID |
| RoleName | |
| Domain | Device Id |
| Logical Only | NO |
| Definition | Device Identifier: The unique identifier for the device. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
| Note |
| Device Identifer Logical Attribute Properties |
| Logical Attribute Name | Device Identifer |
| Datatype | VARCHAR(50) |
| Nullable | NO |
| Device Identifer Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Device Identifer Security Types |
| Name | Current Value |
| Device Identifer Bound Attachments |
| Name | Current Value |
| Device Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Device Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Physical Location Device Identifer |
NO | ||
| EPICS (Oracle) DVC_PHYS_LOC DVC_ID |
NO |
| Device Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Device Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Device Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Device Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Bldg Id |
| Base Entity | Device Physical Location |
| Attribute Name | Bldg Id |
| Logical Rolename | |
| ColumnName | BLDG_ID |
| RoleName | |
| Domain | Building |
| Logical Only | NO |
| Definition | Building: The building number. |
| Note |
| Bldg Id Logical Attribute Properties |
| Logical Attribute Name | Bldg Id |
| Datatype | VARCHAR(10) |
| Nullable | NO |
| Bldg Id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Bldg Id Security Types |
| Name | Current Value |
| Bldg Id Bound Attachments |
| Name | Current Value |
| Bldg Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Bldg Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Physical Location Bldg Id |
NO | ||
| EPICS (Oracle) DVC_PHYS_LOC BLDG_ID |
NO |
| Bldg Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Bldg Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Bldg Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Bldg Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Area Id |
| Base Entity | Device Physical Location |
| Attribute Name | Area Id |
| Logical Rolename | |
| ColumnName | Area Id |
| RoleName | |
| Domain | Default Text |
| Logical Only | NO |
| Definition | Area Id: Generic area within a building. |
| Note |
| Area Id Logical Attribute Properties |
| Logical Attribute Name | Area Id |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| Area Id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Area Id Security Types |
| Name | Current Value |
| Area Id Bound Attachments |
| Name | Current Value |
| Area Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Area Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Physical Location Area Id |
NO | ||
| EPICS (Oracle) DVC_PHYS_LOC Area Id |
NO |
| Area Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Area Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Area Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Area Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rm |
| Base Entity | Device Physical Location |
| Attribute Name | Rm |
| Logical Rolename | |
| ColumnName | Rm |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Room: Room number within a building. |
| Note |
| Rm Logical Attribute Properties |
| Logical Attribute Name | Rm |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Rm Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Rm Security Types |
| Name | Current Value |
| Rm Bound Attachments |
| Name | Current Value |
| Rm Data Movement Rules |
| Name | Type | Rule Text/Value |
| Rm Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Physical Location Rm |
NO | ||
| EPICS (Oracle) DVC_PHYS_LOC RM |
NO |
| Rm Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rm Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rm Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Rm Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cab Row |
| Base Entity | Device Physical Location |
| Attribute Name | Cab Row |
| Logical Rolename | |
| ColumnName | Cab Row |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Cabinet Row: The row number is the device is a cabinet. |
| Note |
| Cab Row Logical Attribute Properties |
| Logical Attribute Name | Cab Row |
| Datatype | VARCHAR(5) |
| Nullable | YES |
| Cab Row Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Cab Row Security Types |
| Name | Current Value |
| Cab Row Bound Attachments |
| Name | Current Value |
| Cab Row Data Movement Rules |
| Name | Type | Rule Text/Value |
| Cab Row Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Physical Location Cab Row |
NO | ||
| EPICS (Oracle) DVC_PHYS_LOC Cab Row |
NO |
| Cab Row Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cab Row Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cab Row Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cab Row Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cab Pos |
| Base Entity | Device Physical Location |
| Attribute Name | Cab Pos |
| Logical Rolename | |
| ColumnName | Cab Pos |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Cabinet Position: If the device is a cabinet this will the the positon of the cabinet within the row. |
| Note |
| Cab Pos Logical Attribute Properties |
| Logical Attribute Name | Cab Pos |
| Datatype | VARCHAR(5) |
| Nullable | YES |
| Cab Pos Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Cab Pos Security Types |
| Name | Current Value |
| Cab Pos Bound Attachments |
| Name | Current Value |
| Cab Pos Data Movement Rules |
| Name | Type | Rule Text/Value |
| Cab Pos Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Physical Location Cab Pos |
NO | ||
| EPICS (Oracle) DVC_PHYS_LOC Cab Pos |
NO |
| Cab Pos Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cab Pos Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cab Pos Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Cab Pos Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |