| 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 | |
| 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 |
| 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_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 |
| 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 |
| 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 |