| DVC_ID |
| Base Object | DVC |
| Attribute Name | Device Identifer |
| ColumnName | DVC_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Device Id |
| Physical 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 |
| DVC_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| DVC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 40 |
| 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 Device Identifer |
NO | ||
| DIAG_MPS (Oracle) DVC DVC_ID |
NO | ||
| EPICS (Oracle) DVC DVC_ID |
NO | ||
| IRMISBase (Oracle) DVC DVC_ID |
NO | ||
| MPS (Oracle) DVC DVC_ID |
NO | ||
| XAL_OPTICS (Oracle) DVC 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 |
| Dvc Inst |
| Base Object | DVC |
| Attribute Name | Dvc Inst |
| ColumnName | Dvc Inst |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Device Instance |
| Note |
| Dvc Inst Column Properties |
| Datatype | VARCHAR2(25) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Dvc Inst Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 25 |
| Percent Null | 0 |
| Dvc Inst Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Dvc Inst Security Types |
| Name | Current Value |
| Dvc Inst Bound Attachments |
| Name | Current Value |
| Dvc Inst Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dvc Inst Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Dvc Inst |
NO | ||
| DIAG_MPS (Oracle) DVC DVC_INST |
NO | ||
| EPICS (Oracle) DVC Dvc Inst |
NO | ||
| IRMISBase (Oracle) DVC Dvc Inst |
NO | ||
| MPS (Oracle) DVC DVC_INST |
NO | ||
| XAL_OPTICS (Oracle) DVC Dvc Inst |
NO |
| Dvc Inst Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Inst Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Inst Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Inst Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PARENT_DVC_ID |
| Base Object | DVC |
| Attribute Name | Device Identifer |
| ColumnName | PARENT_DVC_ID |
| Logical Rolename | Parent Dvc Id |
| RoleName | PARENT_DVC_ID |
| Domain | Device Id |
| Physical Only | NO |
| Definition | Parent Device Identifier: If the device is part of another device this field will contain the device identifier for the parent device. |
| Note |
| PARENT_DVC_ID Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| PARENT_DVC_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 40 |
| Percent Null | 0 |
| PARENT_DVC_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| PARENT_DVC_ID Security Types |
| Name | Current Value |
| PARENT_DVC_ID Bound Attachments |
| Name | Current Value |
| PARENT_DVC_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| PARENT_DVC_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Device Identifer |
NO | ||
| DIAG_MPS (Oracle) DVC PARENT_DVC_ID |
NO | ||
| EPICS (Oracle) DVC PARENT_DVC_ID |
NO | ||
| IRMISBase (Oracle) DVC PARENT_DVC_ID |
NO | ||
| MPS (Oracle) DVC PARENT_DVC_ID |
NO | ||
| XAL_OPTICS (Oracle) DVC PARENT_DVC_ID |
NO |
| PARENT_DVC_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PARENT_DVC_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| PARENT_DVC_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| PARENT_DVC_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Desc |
| Base Object | DVC |
| Attribute Name | Dvc Desc |
| ColumnName | Dvc Desc |
| Logical Rolename | |
| RoleName | |
| Domain | Description |
| Physical Only | NO |
| Definition | Device Description: A free form text field used to describe a device. |
| Note |
| Dvc Desc Column Properties |
| Datatype | VARCHAR2(255) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Dvc Desc Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 255 |
| Percent Null | 0 |
| Dvc Desc Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Dvc Desc Security Types |
| Name | Current Value |
| Dvc Desc Bound Attachments |
| Name | Current Value |
| Dvc Desc Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dvc Desc Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Dvc Desc |
NO | ||
| DIAG_MPS (Oracle) DVC DVC_DESC |
NO | ||
| EPICS (Oracle) DVC Dvc Desc |
NO | ||
| IRMISBase (Oracle) DVC Dvc Desc |
NO | ||
| MPS (Oracle) DVC DVC_DESC |
NO | ||
| XAL_OPTICS (Oracle) DVC Dvc Desc |
NO |
| Dvc Desc Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Desc Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Desc Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Desc Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BL Dvc Ind |
| Base Object | DVC |
| Attribute Name | BL Dvc Ind |
| ColumnName | BL Dvc Ind |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Beam Line Device Indicator: Default is "N" |
| Note |
| BL Dvc Ind Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| BL Dvc Ind Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| BL Dvc Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| BL Dvc Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| BL Dvc Ind Security Types |
| Name | Current Value |
| BL Dvc Ind Bound Attachments |
| Name | Current Value |
| BL Dvc Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| BL Dvc Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device BL Dvc Ind |
NO | ||
| DIAG_MPS (Oracle) DVC BL_DVC_IND |
NO | ||
| EPICS (Oracle) DVC BL Dvc Ind |
NO | ||
| IRMISBase (Oracle) DVC BL Dvc Ind |
NO | ||
| MPS (Oracle) DVC BL_DVC_IND |
NO | ||
| XAL_OPTICS (Oracle) DVC BL Dvc Ind |
NO |
| BL Dvc Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BL Dvc Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| BL Dvc Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BL Dvc Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VIRTUAL_DVC_IND |
| Base Object | DVC |
| Attribute Name | Virtual Dvc Ind |
| ColumnName | VIRTUAL_DVC_IND |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| VIRTUAL_DVC_IND Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| VIRTUAL_DVC_IND Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| VIRTUAL_DVC_IND Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| VIRTUAL_DVC_IND Security Types |
| Name | Current Value |
| VIRTUAL_DVC_IND Bound Attachments |
| Name | Current Value |
| VIRTUAL_DVC_IND Data Movement Rules |
| Name | Type | Rule Text/Value |
| VIRTUAL_DVC_IND Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Virtual Dvc Ind |
NO | ||
| DIAG_MPS (Oracle) DVC VIRTUAL_DVC_IND |
NO | ||
| EPICS (Oracle) DVC VIRTUAL_DVC_IND |
NO | ||
| IRMISBase (Oracle) DVC VIRTUAL_DVC_IND |
NO | ||
| MPS (Oracle) DVC VIRTUAL_DVC_IND |
NO | ||
| XAL_OPTICS (Oracle) DVC VIRTUAL_DVC_IND |
NO |
| VIRTUAL_DVC_IND Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VIRTUAL_DVC_IND Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| VIRTUAL_DVC_IND Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| VIRTUAL_DVC_IND Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Invalid Id Ind |
| Base Object | DVC |
| Attribute Name | Invalid Id Ind |
| ColumnName | Invalid Id Ind |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Invalid Identifier Indicator: Used to indicate if the device identifier conforms to standards. |
| Note |
| Invalid Id Ind Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Invalid Id Ind Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| Invalid Id Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| Invalid Id Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Invalid Id Ind Security Types |
| Name | Current Value |
| Invalid Id Ind Bound Attachments |
| Name | Current Value |
| Invalid Id Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Invalid Id Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Invalid Id Ind |
NO | ||
| DIAG_MPS (Oracle) DVC INVALID_ID_IND |
NO | ||
| EPICS (Oracle) DVC Invalid Id Ind |
NO | ||
| IRMISBase (Oracle) DVC Invalid Id Ind |
NO | ||
| MPS (Oracle) DVC INVALID_ID_IND |
NO | ||
| XAL_OPTICS (Oracle) DVC Invalid Id Ind |
NO |
| Invalid Id Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Invalid Id Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Invalid Id Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Invalid Id Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Id Alias |
| Base Object | DVC |
| Attribute Name | Dvc Id Alias |
| ColumnName | Dvc Id Alias |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Device Identifier Alias: This field is used to the "to-be" device identifier. Currently non-standard device identifiers are stored in the device identifier field. The alias field is used to store the device identifier that will later become the actual identifier for the device. |
| Note |
| Dvc Id Alias Column Properties |
| Datatype | VARCHAR2(75) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Dvc Id Alias Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 75 |
| Percent Null | 0 |
| Dvc Id Alias Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Dvc Id Alias Security Types |
| Name | Current Value |
| Dvc Id Alias Bound Attachments |
| Name | Current Value |
| Dvc Id Alias Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dvc Id Alias Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Dvc Id Alias |
NO | ||
| DIAG_MPS (Oracle) DVC DVC_ID_ALIAS |
NO | ||
| EPICS (Oracle) DVC Dvc Id Alias |
NO | ||
| IRMISBase (Oracle) DVC Dvc Id Alias |
NO | ||
| MPS (Oracle) DVC DVC_ID_ALIAS |
NO | ||
| XAL_OPTICS (Oracle) DVC Dvc Id Alias |
NO |
| Dvc Id Alias Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Id Alias Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Id Alias Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Id Alias Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Dvc Ind |
| Base Object | DVC |
| Attribute Name | Act Dvc Ind |
| ColumnName | Act Dvc Ind |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Active Device Indicator: Indicates that the device is in active use. (i.e. If device is still in design and not yet functional the indicator will be set to N) |
| Note |
| Act Dvc Ind Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Act Dvc Ind Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| Act Dvc Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'Y' |
| Bound Default |
| Act Dvc Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| Act Dvc Ind Security Types |
| Name | Current Value |
| Act Dvc Ind Bound Attachments |
| Name | Current Value |
| Act Dvc Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| Act Dvc Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Act Dvc Ind |
NO | ||
| DIAG_MPS (Oracle) DVC ACT_DVC_IND |
NO | ||
| EPICS (Oracle) DVC Act Dvc Ind |
NO | ||
| IRMISBase (Oracle) DVC Act Dvc Ind |
NO | ||
| MPS (Oracle) DVC ACT_DVC_IND |
NO | ||
| XAL_OPTICS (Oracle) DVC Act Dvc Ind |
NO |
| Act Dvc Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Dvc Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Dvc Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Act Dvc Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MPS Dvc Ind |
| Base Object | DVC |
| Attribute Name | MPS Dvc Ind |
| ColumnName | MPS Dvc Ind |
| Logical Rolename | |
| RoleName | |
| Domain | Indicator |
| Physical Only | NO |
| Definition | Machine Protection System Device Inidcator: Indicates the device is part of the MPS or is protected by the MPS. |
| Note |
| MPS Dvc Ind Column Properties |
| Datatype | CHAR(1) |
| Nullable | NO |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| MPS Dvc Ind Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 1 |
| Percent Null | 0 |
| MPS Dvc Ind Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | 'N' |
| Bound Default |
| MPS Dvc Ind Reference Value (Bound to Domain) |
| Name | Standard Indicator |
| Description | These are the standard values for the Indicator domain. |
| Type | By List |
| Value | Value Description |
| Y | Yes |
| N | No |
| MPS Dvc Ind Security Types |
| Name | Current Value |
| MPS Dvc Ind Bound Attachments |
| Name | Current Value |
| MPS Dvc Ind Data Movement Rules |
| Name | Type | Rule Text/Value |
| MPS Dvc Ind Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device MPS Dvc Ind |
NO | ||
| DIAG_MPS (Oracle) DVC MPS_DVC_IND |
NO | ||
| EPICS (Oracle) DVC MPS Dvc Ind |
NO | ||
| IRMISBase (Oracle) DVC MPS Dvc Ind |
NO | ||
| MPS (Oracle) DVC MPS_DVC_IND |
NO | ||
| XAL_OPTICS (Oracle) DVC MPS Dvc Ind |
NO |
| MPS Dvc Ind Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MPS Dvc Ind Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| MPS Dvc Ind Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| MPS Dvc Ind Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OWNER_CAT_ID |
| Base Object | DVC |
| Attribute Name | Owner Cat Id |
| ColumnName | OWNER_CAT_ID |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Owner Category Identifier: The owner of the device as defined by the EQUIP_CAT categories. |
| Note |
| OWNER_CAT_ID Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OWNER_CAT_ID Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| OWNER_CAT_ID Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OWNER_CAT_ID Security Types |
| Name | Current Value |
| OWNER_CAT_ID Bound Attachments |
| Name | Current Value |
| OWNER_CAT_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| OWNER_CAT_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Owner Cat Id |
NO | ||
| DIAG_MPS (Oracle) DVC OWNER_CAT_ID |
NO | ||
| EPICS (Oracle) DVC OWNER_CAT_ID |
NO | ||
| IRMISBase (Oracle) DVC OWNER_CAT_ID |
NO | ||
| MPS (Oracle) DVC OWNER_CAT_ID |
NO | ||
| XAL_OPTICS (Oracle) DVC OWNER_CAT_ID |
NO |
| OWNER_CAT_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OWNER_CAT_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OWNER_CAT_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OWNER_CAT_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OWNER_BN |
| Base Object | DVC |
| Attribute Name | Owner Badge Number |
| ColumnName | OWNER_BN |
| Logical Rolename | |
| RoleName | |
| Domain | Badge Number |
| Physical Only | NO |
| Definition | |
| Note |
| OWNER_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| OWNER_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| OWNER_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| OWNER_BN Security Types |
| Name | Current Value |
| OWNER_BN Bound Attachments |
| Name | Current Value |
| OWNER_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| OWNER_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Owner Badge Number |
NO | ||
| DIAG_MPS (Oracle) DVC OWNER_BN |
NO | ||
| EPICS (Oracle) DVC OWNER_BN |
NO | ||
| IRMISBase (Oracle) DVC OWNER_BN |
NO | ||
| MPS (Oracle) DVC OWNER_BN |
NO | ||
| XAL_OPTICS (Oracle) DVC OWNER_BN |
NO |
| OWNER_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OWNER_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| OWNER_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| OWNER_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR |
| Base Object | DVC |
| Attribute Name | ORNL Property Number |
| ColumnName | ORNL_PROP_NBR |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | ORNL Property Number: The property number assigned to ORNL porperty which falls into certain categories and which are above a certain value . This attribute rightly belongs to the equipment entity but has been added to the Device as a concession. |
| Note |
| ORNL_PROP_NBR Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ORNL_PROP_NBR Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| ORNL_PROP_NBR Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ORNL_PROP_NBR Security Types |
| Name | Current Value |
| ORNL_PROP_NBR Bound Attachments |
| Name | Current Value |
| ORNL_PROP_NBR Data Movement Rules |
| Name | Type | Rule Text/Value |
| ORNL_PROP_NBR Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device ORNL Property Number |
NO | ||
| DIAG_MPS (Oracle) DVC ORNL_PROP_NBR |
NO | ||
| EPICS (Oracle) DVC ORNL_PROP_NBR |
NO | ||
| IRMISBase (Oracle) DVC ORNL_PROP_NBR |
NO | ||
| MPS (Oracle) DVC ORNL_PROP_NBR |
NO | ||
| XAL_OPTICS (Oracle) DVC ORNL_PROP_NBR |
NO |
| ORNL_PROP_NBR Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL_PROP_NBR Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Drw Nbr |
| Base Object | DVC |
| Attribute Name | Dvc Drw Nbr |
| ColumnName | Dvc Drw Nbr |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Device Drawing Number: The number of the drawing for which the device is documented. |
| Note |
| Dvc Drw Nbr Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Dvc Drw Nbr Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 50 |
| Percent Null | 0 |
| Dvc Drw Nbr Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Dvc Drw Nbr Security Types |
| Name | Current Value |
| Dvc Drw Nbr Bound Attachments |
| Name | Current Value |
| Dvc Drw Nbr Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dvc Drw Nbr Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Dvc Drw Nbr |
NO | ||
| DIAG_MPS (Oracle) DVC DVC_DRW_NBR |
NO | ||
| EPICS (Oracle) DVC Dvc Drw Nbr |
NO | ||
| IRMISBase (Oracle) DVC Dvc Drw Nbr |
NO | ||
| MPS (Oracle) DVC DVC_DRW_NBR |
NO | ||
| XAL_OPTICS (Oracle) DVC Dvc Drw Nbr |
NO |
| Dvc Drw Nbr Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Drw Nbr Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Drw Nbr Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Drw Nbr Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drw Dvc Id |
| Base Object | DVC |
| Attribute Name | Drw Dvc Id |
| ColumnName | Drw Dvc Id |
| Logical Rolename | |
| RoleName | |
| Domain | Device Id |
| Physical Only | NO |
| Definition | Drawing Device Id: The device id as it was specified on the drawing. The device very well may have been renamed since it was defined on a drawing. |
| Note |
| Drw Dvc Id Column Properties |
| Datatype | VARCHAR2(50) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Drw Dvc Id Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 40 |
| Percent Null | 0 |
| Drw Dvc Id Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Drw Dvc Id Security Types |
| Name | Current Value |
| Drw Dvc Id Bound Attachments |
| Name | Current Value |
| Drw Dvc Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Drw Dvc Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Drw Dvc Id |
NO | ||
| DIAG_MPS (Oracle) DVC DRW_DVC_ID |
NO | ||
| EPICS (Oracle) DVC Drw Dvc Id |
NO | ||
| IRMISBase (Oracle) DVC Drw Dvc Id |
NO | ||
| MPS (Oracle) DVC DRW_DVC_ID |
NO | ||
| XAL_OPTICS (Oracle) DVC Drw Dvc Id |
NO |
| Drw Dvc Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drw Dvc Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drw Dvc Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Drw Dvc Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod Dte |
| Base Object | DVC |
| Attribute Name | Mod Dte |
| ColumnName | Mod Dte |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Modify Date: The date the record was created or modified. |
| Note |
| Mod Dte Column Properties |
| Datatype | DATE |
| Nullable | YES |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Mod Dte Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| Mod Dte Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Mod Dte Security Types |
| Name | Current Value |
| Mod Dte Bound Attachments |
| Name | Current Value |
| Mod Dte Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mod Dte Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Mod Dte |
NO | ||
| DIAG_MPS (Oracle) DVC MOD_DTE |
NO | ||
| EPICS (Oracle) DVC Mod Dte |
NO | ||
| IRMISBase (Oracle) DVC Mod Dte |
NO | ||
| MPS (Oracle) DVC Mod Dte |
NO | ||
| XAL_OPTICS (Oracle) DVC Mod Dte |
NO |
| Mod Dte Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod Dte Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod Dte Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod Dte Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid |
| Base Object | DVC |
| Attribute Name | Mod By Uid |
| ColumnName | Mod By Uid |
| Logical Rolename | |
| RoleName | |
| Domain | Mod By Uid |
| Physical Only | NO |
| Definition | Modified by Userid: The database userid of the person who inserted or update a record in the table. |
| Note |
| Mod By Uid Column Properties |
| Datatype | VARCHAR2(64) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| Mod By Uid Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 64 |
| Percent Null | 0 |
| Mod By Uid Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Mod By Uid Security Types |
| Name | Current Value |
| Mod By Uid Bound Attachments |
| Name | Current Value |
| Mod By Uid Data Movement Rules |
| Name | Type | Rule Text/Value |
| Mod By Uid Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Mod By Uid |
NO | ||
| DIAG_MPS (Oracle) DVC MOD_BY_UID |
NO | ||
| EPICS (Oracle) DVC Mod By Uid |
NO | ||
| IRMISBase (Oracle) DVC Mod By Uid |
NO | ||
| MPS (Oracle) DVC MOD_BY_UID |
NO | ||
| XAL_OPTICS (Oracle) DVC Mod By Uid |
NO |
| Mod By Uid Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Mod By Uid Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |