| DVC_ID |
| Base Entity | Invalid Device |
| Attribute Name | DVC_ID |
| Logical Rolename | |
| ColumnName | DVC_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Device Identifier: The unique identifier for the device. It is represented in the form of a bar code. The identifier consists of the concatenation of the following fields: System ID, Subsystem ID, Device Qualifier, Device Type and Device Instance. |
| Note |
| DVC_ID Logical Attribute Properties |
| Logical Attribute Name | DVC_ID |
| Datatype | VARCHAR(40) |
| Nullable | NO |
| 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 Invalid Device DVC_ID |
NO | ||
| EPICS (Oracle) INVALID_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 |
| SYS_ID |
| Base Entity | Invalid Device |
| Attribute Name | SYS_ID |
| Logical Rolename | |
| ColumnName | SYS_ID |
| RoleName | |
| Domain | |
| 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 |
| SYS_ID Logical Attribute Properties |
| Logical Attribute Name | SYS_ID |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| SYS_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| SYS_ID Security Types |
| Name | Current Value |
| SYS_ID Bound Attachments |
| Name | Current Value |
| SYS_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SYS_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Invalid Device SYS_ID |
NO | ||
| EPICS (Oracle) INVALID_DVC SYS_ID |
NO |
| SYS_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SYS_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SYS_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SYS_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBSYS_ID |
| Base Entity | Invalid Device |
| Attribute Name | SUBSYS_ID |
| Logical Rolename | |
| ColumnName | SUBSYS_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Subsystem Identifier: This Subsystem to which the device is assigned. This field is validated against the Subsystem table. If the value is not found then the Invalid Sub Sys Ind field is set to "Y". |
| Note |
| SUBSYS_ID Logical Attribute Properties |
| Logical Attribute Name | SUBSYS_ID |
| Datatype | VARCHAR(10) |
| Nullable | YES |
| SUBSYS_ID Domain Restrictions |
| CheckConstraint | |||
| Check Constraint Name | |||
| Bound Rule | |||
| Declared Default | |||
| Bound Default |
| SUBSYS_ID Security Types |
| Name | Current Value |
| SUBSYS_ID Bound Attachments |
| Name | Current Value |
| SUBSYS_ID Data Movement Rules |
| Name | Type | Rule Text/Value |
| SUBSYS_ID Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Invalid Device SUBSYS_ID |
NO | ||
| EPICS (Oracle) INVALID_DVC SUBSYS_ID |
NO |
| SUBSYS_ID Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBSYS_ID Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBSYS_ID Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| SUBSYS_ID Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| DVC_TYPE_ID |
| Base Entity | Invalid Device |
| Attribute Name | DVC_TYPE_ID |
| Logical Rolename | |
| ColumnName | DVC_TYPE_ID |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Device Type Identifier: This Device Type to which the device is assigned. This field is validated against the Dvc Type table. If the value is not found then the Invalid Dvc Type Ind field is set to "Y". |
| 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 Invalid Device DVC_TYPE_ID |
NO | ||
| EPICS (Oracle) INVALID_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 | Invalid 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 Invalid Device DVC_INST |
NO | ||
| EPICS (Oracle) INVALID_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 |
| DVC_DESC |
| Base Entity | Invalid Device |
| Attribute Name | DVC_DESC |
| Logical Rolename | |
| ColumnName | DVC_DESC |
| RoleName | |
| Domain | |
| 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 Invalid Device DVC_DESC |
NO | ||
| EPICS (Oracle) INVALID_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 |
| PARENT_DVC_ID |
| Base Entity | Invalid 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 | 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 |
| 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 Invalid Device Device Identifer |
NO | ||
| EPICS (Oracle) INVALID_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 |
| BL_DVC_IND |
| Base Entity | Invalid Device |
| Attribute Name | BL_DVC_IND |
| Logical Rolename | |
| ColumnName | BL_DVC_IND |
| RoleName | |
| Domain | |
| 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 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 Invalid Device BL_DVC_IND |
NO | ||
| EPICS (Oracle) INVALID_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 | Invalid 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 Invalid Device VIRTUAL_DVC_IND |
NO | ||
| EPICS (Oracle) INVALID_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 | Invalid Device |
| Attribute Name | INVALID_ID_IND |
| Logical Rolename | |
| ColumnName | INVALID_ID_IND |
| RoleName | |
| Domain | |
| 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 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 Invalid Device INVALID_ID_IND |
NO | ||
| EPICS (Oracle) INVALID_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 | Invalid 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 i |
| Note |
| DVC_ID_ALIAS Logical Attribute Properties |
| Logical Attribute Name | DVC_ID_ALIAS |
| Datatype | VARCHAR(40) |
| 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 Invalid Device DVC_ID_ALIAS |
NO | ||
| EPICS (Oracle) INVALID_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 | Invalid Device |
| Attribute Name | ACT_DVC_IND |
| Logical Rolename | |
| ColumnName | ACT_DVC_IND |
| RoleName | |
| Domain | |
| 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 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 Invalid Device ACT_DVC_IND |
NO | ||
| EPICS (Oracle) INVALID_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 | Invalid Device |
| Attribute Name | MPS_DVC_IND |
| Logical Rolename | |
| ColumnName | MPS_DVC_IND |
| RoleName | |
| Domain | |
| Logical Only | NO |
| Definition | Machine Protection System Device Indicator: Indicates that the device is part of or 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 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 Invalid Device MPS_DVC_IND |
NO | ||
| EPICS (Oracle) INVALID_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 Entity | Invalid 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 Invalid Device DVC_DRW_NBR |
NO | ||
| EPICS (Oracle) INVALID_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 | Invalid Device |
| Attribute Name | DRW_DVC_ID |
| Logical Rolename | |
| ColumnName | DRW_DVC_ID |
| RoleName | |
| Domain | |
| 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(40) |
| 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 Invalid Device DRW_DVC_ID |
NO | ||
| EPICS (Oracle) INVALID_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 Entity | Invalid Device |
| Attribute Name | MOD_BY_UID |
| Logical Rolename | |
| ColumnName | MOD_BY_UID |
| RoleName | |
| Domain | |
| 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 Invalid Device MOD_BY_UID |
NO | ||
| EPICS (Oracle) INVALID_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 Entity | Invalid 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 Invalid Device MOD_DTE |
NO | ||
| EPICS (Oracle) INVALID_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 Entity | Invalid 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 Invalid Device OWNER_CAT_ID |
NO | ||
| EPICS (Oracle) INVALID_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 |