| Device Identifer |
| Base Entity | Device |
| 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 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 |
| 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 |
| System Identifier |
| Base Entity | Device |
| Attribute Name | System Identifier |
| Logical Rolename | |
| ColumnName | SYS_ID |
| RoleName | |
| Domain | System Id |
| Logical Only | NO |
| Definition | System Identifier: This System to which the device is assigned. This field is validated against the System table. If the value is not found then the Invalid Sys Ind field is set to "Y". |
| Note |
| System Identifier Logical Attribute Properties |
| Logical Attribute Name | System Identifier |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| System Identifier Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| System Identifier Security Types |
| Name | Current Value |
| System Identifier Bound Attachments |
| Name | Current Value |
| System Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| System Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device System Identifier |
NO | ||
| DIAG_MPS (Oracle) DVC SYS_ID |
NO | ||
| EPICS (Oracle) DVC SYS_ID |
NO | ||
| IRMISBase (Oracle) DVC SYS_ID |
NO | ||
| MPS (Oracle) DVC SYS_ID |
NO | ||
| XAL_OPTICS (Oracle) DVC SYS_ID |
NO |
| System Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| System Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| System Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| System Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subsystem Identifer |
| Base Entity | Device |
| Attribute Name | Subsystem Identifer |
| Logical Rolename | |
| ColumnName | SUBSYS_ID |
| RoleName | |
| Domain | Subsystem Identifier |
| Logical Only | NO |
| Definition | |
| Note |
| Subsystem Identifer Logical Attribute Properties |
| Logical Attribute Name | Subsystem Identifer |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Subsystem Identifer Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Subsystem Identifer Security Types |
| Name | Current Value |
| Subsystem Identifer Bound Attachments |
| Name | Current Value |
| Subsystem Identifer Data Movement Rules |
| Name | Type | Rule Text/Value |
| Subsystem Identifer Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Subsystem Identifer |
NO | ||
| DIAG_MPS (Oracle) DVC SUBSYS_ID |
NO | ||
| EPICS (Oracle) DVC SUBSYS_ID |
NO | ||
| IRMISBase (Oracle) DVC SUBSYS_ID |
NO | ||
| MPS (Oracle) DVC SUBSYS_ID |
NO | ||
| XAL_OPTICS (Oracle) DVC SUBSYS_ID |
NO |
| Subsystem Identifer Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subsystem Identifer Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subsystem Identifer Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Subsystem Identifer Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Type Id |
| Base Entity | Device |
| Attribute Name | Dvc Type Id |
| Logical Rolename | |
| ColumnName | Dvc Type Id |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Device Type Identifier: The unique identifier for a device type. |
| Note |
| Dvc Type Id Logical Attribute Properties |
| Logical Attribute Name | Dvc Type Id |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| Dvc Type Id Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| Dvc Type Id Security Types |
| Name | Current Value |
| Dvc Type Id Bound Attachments |
| Name | Current Value |
| Dvc Type Id Data Movement Rules |
| Name | Type | Rule Text/Value |
| Dvc Type Id Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Dvc Type Id |
NO | ||
| DIAG_MPS (Oracle) DVC Dvc Type Id |
NO | ||
| EPICS (Oracle) DVC Dvc Type Id |
NO | ||
| IRMISBase (Oracle) DVC Dvc Type Id |
NO | ||
| MPS (Oracle) DVC DVC_TYPE_ID |
NO | ||
| XAL_OPTICS (Oracle) DVC Dvc Type Id |
NO |
| Dvc Type Id Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Type Id Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Type Id Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Type Id Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Inst |
| Base Entity | Device |
| Attribute Name | Dvc Inst |
| Logical Rolename | |
| ColumnName | Dvc Inst |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Device Instance |
| Note |
| Dvc Inst Logical Attribute Properties |
| Logical Attribute Name | Dvc Inst |
| Datatype | VARCHAR(25) |
| Nullable | YES |
| 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 Entity | Device |
| Attribute Name | Device Identifer |
| Logical Rolename | Parent Dvc Id |
| ColumnName | PARENT_DVC_ID |
| RoleName | PARENT_DVC_ID |
| Domain | Device Id |
| Logical 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 Logical Attribute Properties |
| Logical Attribute Name | Device Identifer |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| 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 Entity | Device |
| Attribute Name | Dvc Desc |
| Logical Rolename | |
| ColumnName | Dvc Desc |
| RoleName | |
| Domain | Description |
| Logical Only | NO |
| Definition | Device Description: A free form text field used to describe a device. |
| Note |
| Dvc Desc Logical Attribute Properties |
| Logical Attribute Name | Dvc Desc |
| Datatype | VARCHAR(255) |
| Nullable | YES |
| 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 Entity | Device |
| Attribute Name | BL Dvc Ind |
| Logical Rolename | |
| ColumnName | BL Dvc Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Beam Line Device Indicator: Default is "N" |
| Note |
| BL Dvc Ind Logical Attribute Properties |
| Logical Attribute Name | BL Dvc Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| 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 Entity | Device |
| Attribute Name | Virtual Dvc Ind |
| Logical Rolename | |
| ColumnName | VIRTUAL_DVC_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Virtual Dvc Ind Logical Attribute Properties |
| Logical Attribute Name | Virtual Dvc Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| 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 Entity | Device |
| Attribute Name | Invalid Id Ind |
| Logical Rolename | |
| ColumnName | Invalid Id Ind |
| RoleName | |
| Domain | Indicator |
| Logical Only | NO |
| Definition | Invalid Identifier Indicator: Used to indicate if the device identifier conforms to standards. |
| Note |
| Invalid Id Ind Logical Attribute Properties |
| Logical Attribute Name | Invalid Id Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| 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 Entity | Device |
| Attribute Name | Dvc Id Alias |
| Logical Rolename | |
| ColumnName | Dvc Id Alias |
| RoleName | |
| Domain | |
| Logical 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 Logical Attribute Properties |
| Logical Attribute Name | Dvc Id Alias |
| Datatype | VARCHAR(75) |
| Nullable | YES |
| 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 Entity | Device |
| Attribute Name | Act Dvc Ind |
| Logical Rolename | |
| ColumnName | Act Dvc Ind |
| RoleName | |
| Domain | Indicator |
| Logical 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 Logical Attribute Properties |
| Logical Attribute Name | Act Dvc Ind |
| Datatype | CHAR(1) |
| Nullable | YES |
| 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 Entity | Device |
| Attribute Name | MPS Dvc Ind |
| Logical Rolename | |
| ColumnName | MPS Dvc Ind |
| RoleName | |
| Domain | Indicator |
| Logical 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 Logical Attribute Properties |
| Logical Attribute Name | MPS Dvc Ind |
| Datatype | CHAR(1) |
| Nullable | NO |
| 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 |
| Criticality Identifier |
| Base Entity | Device |
| Attribute Name | Criticality Identifier |
| Logical Rolename | |
| ColumnName | CRIT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | |
| Note |
| Criticality Identifier Logical Attribute Properties |
| Logical Attribute Name | Criticality Identifier |
| Datatype | VARCHAR(6) |
| Nullable | NO |
| Criticality Identifier Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | 'Medium' | ||
| Bound Default |
| Criticality Identifier Security Types |
| Name | Current Value |
| Criticality Identifier Bound Attachments |
| Name | Current Value |
| Criticality Identifier Data Movement Rules |
| Name | Type | Rule Text/Value |
| Criticality Identifier Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Device Criticality Identifier |
NO | ||
| DIAG_MPS (Oracle) DVC CRIT_ID |
NO | ||
| EPICS (Oracle) DVC CRIT_ID |
NO | ||
| IRMISBase (Oracle) DVC CRIT_ID |
NO | ||
| MPS (Oracle) DVC CRIT_ID |
NO | ||
| XAL_OPTICS (Oracle) DVC CRIT_ID |
NO |
| Criticality Identifier Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Criticality Identifier Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Criticality Identifier Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Criticality Identifier Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Owner Cat Id |
| Base Entity | Device |
| Attribute Name | Owner Cat Id |
| Logical Rolename | |
| ColumnName | OWNER_CAT_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Owner Category Identifier: The owner of the device as defined by the EQUIP_CAT categories. |
| Note |
| Owner Cat Id Logical Attribute Properties |
| Logical Attribute Name | Owner Cat Id |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| 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 Badge Number |
| Base Entity | Device |
| Attribute Name | Owner Badge Number |
| Logical Rolename | |
| ColumnName | OWNER_BN |
| RoleName | |
| Domain | Badge Number |
| Logical Only | NO |
| Definition | |
| Note |
| Owner Badge Number Logical Attribute Properties |
| Logical Attribute Name | Owner Badge Number |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| Owner Badge Number Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| Owner Badge Number Security Types |
| Name | Current Value |
| Owner Badge Number Bound Attachments |
| Name | Current Value |
| Owner Badge Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| Owner Badge Number 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 Badge Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Owner Badge Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| Owner Badge Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Owner Badge Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Property Number |
| Base Entity | Device |
| Attribute Name | ORNL Property Number |
| Logical Rolename | |
| ColumnName | ORNL_PROP_NBR |
| RoleName | |
| Domain | |
| Logical 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 Property Number Logical Attribute Properties |
| Logical Attribute Name | ORNL Property Number |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| ORNL Property Number Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| ORNL Property Number Security Types |
| Name | Current Value |
| ORNL Property Number Bound Attachments |
| Name | Current Value |
| ORNL Property Number Data Movement Rules |
| Name | Type | Rule Text/Value |
| ORNL Property Number 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 Property Number Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Property Number Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Property Number Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ORNL Property Number Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| Dvc Drw Nbr |
| Base Entity | Device |
| Attribute Name | Dvc Drw Nbr |
| Logical Rolename | |
| ColumnName | Dvc Drw Nbr |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Device Drawing Number: The number of the drawing for which the device is documented. |
| Note |
| Dvc Drw Nbr Logical Attribute Properties |
| Logical Attribute Name | Dvc Drw Nbr |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| 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 Entity | Device |
| Attribute Name | Drw Dvc Id |
| Logical Rolename | |
| ColumnName | Drw Dvc Id |
| RoleName | |
| Domain | Device Id |
| Logical 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 Logical Attribute Properties |
| Logical Attribute Name | Drw Dvc Id |
| Datatype | VARCHAR(50) |
| Nullable | YES |
| 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 Entity | Device |
| Attribute Name | Mod Dte |
| Logical Rolename | |
| ColumnName | Mod Dte |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Modify Date: The date the record was created or modified. |
| Note |
| Mod Dte Logical Attribute Properties |
| Logical Attribute Name | Mod Dte |
| Datatype | DATE |
| Nullable | YES |
| 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 Entity | Device |
| Attribute Name | Mod By Uid |
| Logical Rolename | |
| ColumnName | Mod By Uid |
| RoleName | |
| Domain | Mod By Uid |
| Logical 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 Logical Attribute Properties |
| Logical Attribute Name | Mod By Uid |
| Datatype | VARCHAR(64) |
| Nullable | YES |
| 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 |