| DVC_ID |
| Base Object | DVC_PHYS_LOC |
| Attribute Name | DVC_ID |
| ColumnName | DVC_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| DVC_ID Column Properties |
| Datatype | VARCHAR2(40) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DVC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 20 |
| Percent Null | 0 |
| DVC_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| DVC_ID Security Types |
| Name | Current Value |
| DVC_ID Bound Attachments |
| Name | Current Value |
| DVC_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| DVC_ID 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 |
| DVC_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DVC_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| DVC_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DVC_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BLDG_ID |
| Base Object | DVC_PHYS_LOC |
| Attribute Name | BLDG_ID |
| ColumnName | BLDG_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Building: The building number. |
| Note |
| BLDG_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BLDG_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 5 |
| Percent Null | 0 |
| 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 Object | DVC_PHYS_LOC |
| Attribute Name | AREA_ID |
| ColumnName | AREA_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Area Id: Generic area within a building. |
| Note |
| AREA_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| AREA_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 9 |
| Percent Null | 24 |
| 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 Object | DVC_PHYS_LOC |
| Attribute Name | RM |
| ColumnName | RM |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Room: Room number within a building. |
| Note |
| RM Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RM Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 20 |
| 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 Object | DVC_PHYS_LOC |
| Attribute Name | CAB_ROW |
| ColumnName | CAB_ROW |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Cabinet Row: The row number is the device is a cabinet. |
| Note |
| CAB_ROW Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CAB_ROW Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 4 |
| Percent Null | 17 |
| 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 Object | DVC_PHYS_LOC |
| Attribute Name | CAB_POS |
| ColumnName | CAB_POS |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical 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 Column Properties |
| Datatype | VARCHAR2(5) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| CAB_POS Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 3 |
| Percent Null | 22 |
| 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 |