DVC_ID |
Base Object | DVC |
Attribute Name | DVC_ID |
ColumnName | DVC_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical 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 Column Properties |
Datatype | VARCHAR2(40) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 20 |
Percent Null | 0 |
DVC_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
DVC_ID Security Types |
Name | Current Value |
DVC_ID Bound Attachments |
Name | Current Value |
DVC_ID Data Movement Rules |
Name | Type | Rule Text/Value |
DVC_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Device 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 |
SYS_ID |
Base Object | DVC |
Attribute Name | SYS_ID |
ColumnName | SYS_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical 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 Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SYS_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
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 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 |
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 Object | DVC |
Attribute Name | SUBSYS_ID |
ColumnName | SUBSYS_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical 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 Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SUBSYS_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
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 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 |
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 Object | DVC |
Attribute Name | DVC_TYPE_ID |
ColumnName | DVC_TYPE_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical 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 Column Properties |
Datatype | VARCHAR2(25) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DVC_TYPE_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 5 |
Percent Null | 0 |
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 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 | 8 |
Percent Null | 20 |
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 |
DVC_DESC |
Base Object | DVC |
Attribute Name | DVC_DESC |
ColumnName | DVC_DESC |
Logical Rolename | |
RoleName | |
Domain | |
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 | 10 |
Percent Null | 59 |
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 |
PARENT_DVC_ID |
Base Object | DVC |
Attribute Name | DVC_ID |
ColumnName | PARENT_DVC_ID |
Logical Rolename | PARENT_DVC_ID |
RoleName | PARENT_DVC_ID |
Domain | |
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(40) |
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 | 20 |
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 |
BL_DVC_IND |
Base Object | DVC |
Attribute Name | BL_DVC_IND |
ColumnName | BL_DVC_IND |
Logical Rolename | |
RoleName | |
Domain | |
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 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 | |
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 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 i |
Note |
DVC_ID_ALIAS Column Properties |
Datatype | VARCHAR2(40) |
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 | 2 |
Percent Null | 96 |
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 | |
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 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 | |
Physical Only | NO |
Definition | Machine Protection System Device Indicator: Indicates that the device is part of or 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 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 | 2 |
Percent Null | 99 |
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 | |
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(40) |
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 | 2 |
Percent Null | 97 |
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 | |
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 | 5 |
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 |
CRIT_ID |
Base Object | DVC |
Attribute Name | CRIT_ID |
ColumnName | CRIT_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
CRIT_ID Column Properties |
Datatype | VARCHAR2(6) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
CRIT_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 0 |
CRIT_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'NotSet' |
Bound Default |
CRIT_ID Security Types |
Name | Current Value |
CRIT_ID Bound Attachments |
Name | Current Value |
CRIT_ID Data Movement Rules |
Name | Type | Rule Text/Value |
CRIT_ID 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 |
CRIT_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
CRIT_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
CRIT_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
CRIT_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ORNL_PROP_NBR |
Base Object | DVC |
Attribute Name | ORNL_PROP_NBR |
ColumnName | ORNL_PROP_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
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 | 2 |
Percent Null | 99 |
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 |
OWNER_BN |
Base Object | DVC |
Attribute Name | OWNER_BN |
ColumnName | OWNER_BN |
Logical Rolename | |
RoleName | |
Domain | |
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 | 2 |
Percent Null | 99 |
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 |