BYPASS_NBR |
Base Object | BYPASS_REQ |
Attribute Name | BYPASS_NBR |
ColumnName | BYPASS_NBR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Bypass Number: System generated tracking number for the bypass request. |
Note |
BYPASS_NBR Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BYPASS_NBR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
BYPASS_NBR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BYPASS_NBR Security Types |
Name | Current Value |
BYPASS_NBR Bound Attachments |
Name | Current Value |
BYPASS_NBR Data Movement Rules |
Name | Type | Rule Text/Value |
BYPASS_NBR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Bypass Number |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ BYPASS_NBR |
NO | ||
EPICS (Oracle) BYPASS_REQ BYPASS_NBR |
NO | ||
OPER (Oracle) BYPASS_REQ BYPASS_NBR |
NO |
BYPASS_NBR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_NBR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_NBR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_NBR Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SYS_ID |
Base Object | BYPASS_REQ |
Attribute Name | SYS_ID |
ColumnName | SYS_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | System Code: The unique identifier for the Spalation Neutron Source Project System. |
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 | 10 |
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 Bypass Request System Identifier |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ SYS_ID |
NO | ||
EPICS (Oracle) BYPASS_REQ SYS_ID |
NO | ||
OPER (Oracle) BYPASS_REQ 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 | BYPASS_REQ |
Attribute Name | SUBSYS_ID |
ColumnName | SUBSYS_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Subsystem Identifier: The unique identifier for a SNS subsystem. |
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 | 10 |
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 Bypass Request Subsystem Identifer |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ SUBSYS_ID |
NO | ||
EPICS (Oracle) BYPASS_REQ SUBSYS_ID |
NO | ||
OPER (Oracle) BYPASS_REQ 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 |
BYPASS_MECH_NM |
Base Object | BYPASS_REQ |
Attribute Name | BYPASS_MECH_NM |
ColumnName | BYPASS_MECH_NM |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BYPASS_MECH_NM Column Properties |
Datatype | VARCHAR2(50) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BYPASS_MECH_NM Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 50 |
Percent Null | 0 |
BYPASS_MECH_NM Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BYPASS_MECH_NM Security Types |
Name | Current Value |
BYPASS_MECH_NM Bound Attachments |
Name | Current Value |
BYPASS_MECH_NM Data Movement Rules |
Name | Type | Rule Text/Value |
BYPASS_MECH_NM Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Bypass Mechanism Name |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ BYPASS_MECH_NM |
NO | ||
EPICS (Oracle) BYPASS_REQ BYPASS_MECH_NM |
NO | ||
OPER (Oracle) BYPASS_REQ BYPASS_MECH_NM |
NO |
BYPASS_MECH_NM Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_MECH_NM Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_MECH_NM Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_MECH_NM Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_CMNT |
Base Object | BYPASS_REQ |
Attribute Name | BYPASS_CMNT |
ColumnName | BYPASS_CMNT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Bypass Reason: Justification for the bypass. |
Note |
BYPASS_CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BYPASS_CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
BYPASS_CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BYPASS_CMNT Security Types |
Name | Current Value |
BYPASS_CMNT Bound Attachments |
Name | Current Value |
BYPASS_CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
BYPASS_CMNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Bypass Comment |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ BYPASS_CMNT |
NO | ||
EPICS (Oracle) BYPASS_REQ BYPASS_CMNT |
NO | ||
OPER (Oracle) BYPASS_REQ BYPASS_CMNT |
NO |
BYPASS_CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
STATUS_CD |
Base Object | BYPASS_REQ |
Attribute Name | STATUS_CD |
ColumnName | STATUS_CD |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Status Code: Indicates if the request has installation/verification data, is approved by operation or has been removed. A - Approved; I - Installed; Q - Request Removal; R - Removed; X - Approve Removal |
Note |
STATUS_CD Column Properties |
Datatype | CHAR(1) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
STATUS_CD Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
STATUS_CD Domain Restrictions |
CheckConstraint | status_cd in ('I','D','R') |
Check Constraint Name | CK_STATUS_CD |
Bound Rule | |
Declared Default | NULL |
Bound Default |
STATUS_CD Security Types |
Name | Current Value |
STATUS_CD Bound Attachments |
Name | Current Value |
STATUS_CD Data Movement Rules |
Name | Type | Rule Text/Value |
STATUS_CD Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Status Code |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ STATUS_CD |
NO | ||
EPICS (Oracle) BYPASS_REQ STATUS_CD |
NO | ||
OPER (Oracle) BYPASS_REQ STATUS_CD |
NO |
STATUS_CD Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
STATUS_CD Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
STATUS_CD Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
STATUS_CD Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXP_RMV_DTE |
Base Object | BYPASS_REQ |
Attribute Name | EXP_RMV_DTE |
ColumnName | EXP_RMV_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Expected Removal Date: The date in which the bypass is to be removed. |
Note |
EXP_RMV_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EXP_RMV_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
EXP_RMV_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
EXP_RMV_DTE Security Types |
Name | Current Value |
EXP_RMV_DTE Bound Attachments |
Name | Current Value |
EXP_RMV_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
EXP_RMV_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request EXP_RMV_DTE |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ EXP_RMV_DTE |
NO | ||
EPICS (Oracle) BYPASS_REQ EXP_RMV_DTE |
NO | ||
OPER (Oracle) BYPASS_REQ EXP_RMV_DTE |
NO |
EXP_RMV_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXP_RMV_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EXP_RMV_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EXP_RMV_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ID |
Base Object | BYPASS_REQ |
Attribute Name | BLDG_ID |
ColumnName | BLDG_ID |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Building: The building number. |
Note |
BLDG_ID Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BLDG_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
BLDG_ID Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BLDG_ID Security Types |
Name | Current Value |
BLDG_ID Bound Attachments |
Name | Current Value |
BLDG_ID Data Movement Rules |
Name | Type | Rule Text/Value |
BLDG_ID Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request BLDG_ID |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ BLDG_ID |
NO | ||
EPICS (Oracle) BYPASS_REQ BLDG_ID |
NO | ||
OPER (Oracle) BYPASS_REQ BLDG_ID |
NO |
BLDG_ID Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ID Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ID Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_ID Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_DTE |
Base Object | BYPASS_REQ |
Attribute Name | ADD_DTE |
ColumnName | ADD_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ADD_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ADD_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
ADD_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ADD_DTE Security Types |
Name | Current Value |
ADD_DTE Bound Attachments |
Name | Current Value |
ADD_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
ADD_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Add Date |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ ADD_DTE |
NO | ||
EPICS (Oracle) BYPASS_REQ ADD_DTE |
NO | ||
OPER (Oracle) BYPASS_REQ ADD_DTE |
NO |
ADD_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_BN |
Base Object | BYPASS_REQ |
Attribute Name | ADD_BN |
ColumnName | ADD_BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Operator Badge Number: The operator on duty when the bypass is requested. |
Note |
ADD_BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ADD_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
ADD_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
ADD_BN Security Types |
Name | Current Value |
ADD_BN Bound Attachments |
Name | Current Value |
ADD_BN Data Movement Rules |
Name | Type | Rule Text/Value |
ADD_BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Badge Number |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ ADD_BN |
NO | ||
EPICS (Oracle) BYPASS_REQ ADD_BN |
NO | ||
OPER (Oracle) BYPASS_REQ ADD_BN |
NO |
ADD_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_BN |
Base Object | BYPASS_REQ |
Attribute Name | UPDTE_BN |
ColumnName | UPDTE_BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
UPDTE_BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
UPDTE_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
UPDTE_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
UPDTE_BN Security Types |
Name | Current Value |
UPDTE_BN Bound Attachments |
Name | Current Value |
UPDTE_BN Data Movement Rules |
Name | Type | Rule Text/Value |
UPDTE_BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Badge Number |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ UPDTE_BN |
NO | ||
EPICS (Oracle) BYPASS_REQ UPDTE_BN |
NO | ||
OPER (Oracle) BYPASS_REQ UPDTE_BN |
NO |
UPDTE_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_DTE |
Base Object | BYPASS_REQ |
Attribute Name | UPDTE_DTE |
ColumnName | UPDTE_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
UPDTE_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
UPDTE_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
UPDTE_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
UPDTE_DTE Security Types |
Name | Current Value |
UPDTE_DTE Bound Attachments |
Name | Current Value |
UPDTE_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
UPDTE_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Update Date |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ UPDTE_DTE |
NO | ||
EPICS (Oracle) BYPASS_REQ UPDTE_DTE |
NO | ||
OPER (Oracle) BYPASS_REQ UPDTE_DTE |
NO |
UPDTE_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_CMNT |
Base Object | BYPASS_REQ |
Attribute Name | UPDTE_CMNT |
ColumnName | UPDTE_CMNT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
UPDTE_CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
UPDTE_CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
UPDTE_CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
UPDTE_CMNT Security Types |
Name | Current Value |
UPDTE_CMNT Bound Attachments |
Name | Current Value |
UPDTE_CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
UPDTE_CMNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Update Comment |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ UPDTE_CMNT |
NO | ||
EPICS (Oracle) BYPASS_REQ UPDTE_CMNT |
NO | ||
OPER (Oracle) BYPASS_REQ UPDTE_CMNT |
NO |
UPDTE_CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_DTE |
Base Object | BYPASS_REQ |
Attribute Name | RMV_DTE |
ColumnName | RMV_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Removal Date: The date when the bypass was actually removed. |
Note |
RMV_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RMV_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
RMV_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RMV_DTE Security Types |
Name | Current Value |
RMV_DTE Bound Attachments |
Name | Current Value |
RMV_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
RMV_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Remove Date |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ RMV_DTE |
NO | ||
EPICS (Oracle) BYPASS_REQ RMV_DTE |
NO | ||
OPER (Oracle) BYPASS_REQ RMV_DTE |
NO |
RMV_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_BN |
Base Object | BYPASS_REQ |
Attribute Name | RMV_BN |
ColumnName | RMV_BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
RMV_BN Column Properties |
Datatype | VARCHAR2(10) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RMV_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 0 |
RMV_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RMV_BN Security Types |
Name | Current Value |
RMV_BN Bound Attachments |
Name | Current Value |
RMV_BN Data Movement Rules |
Name | Type | Rule Text/Value |
RMV_BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Badge Number |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ RMV_BN |
NO | ||
EPICS (Oracle) BYPASS_REQ RMV_BN |
NO | ||
OPER (Oracle) BYPASS_REQ RMV_BN |
NO |
RMV_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_CMNT |
Base Object | BYPASS_REQ |
Attribute Name | RMV_CMNT |
ColumnName | RMV_CMNT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Removal Comments: Comments related to the bypass removal. |
Note |
RMV_CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RMV_CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 2000 |
Percent Null | 0 |
RMV_CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
RMV_CMNT Security Types |
Name | Current Value |
RMV_CMNT Bound Attachments |
Name | Current Value |
RMV_CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
RMV_CMNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Remove Comment |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ RMV_CMNT |
NO | ||
EPICS (Oracle) BYPASS_REQ RMV_CMNT |
NO | ||
OPER (Oracle) BYPASS_REQ RMV_CMNT |
NO |
RMV_CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_CMNT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_POST_IND |
Base Object | BYPASS_REQ |
Attribute Name | ADD_POST_IND |
ColumnName | ADD_POST_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
ADD_POST_IND Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
ADD_POST_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
ADD_POST_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
ADD_POST_IND Security Types |
Name | Current Value |
ADD_POST_IND Bound Attachments |
Name | Current Value |
ADD_POST_IND Data Movement Rules |
Name | Type | Rule Text/Value |
ADD_POST_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request ADD_POST_IND |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ ADD_POST_IND |
NO | ||
EPICS (Oracle) BYPASS_REQ ADD_POST_IND |
NO | ||
OPER (Oracle) BYPASS_REQ ADD_POST_IND |
NO |
ADD_POST_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_POST_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_POST_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
ADD_POST_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_POST_IND |
Base Object | BYPASS_REQ |
Attribute Name | RMV_POST_IND |
ColumnName | RMV_POST_IND |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
RMV_POST_IND Column Properties |
Datatype | VARCHAR2(1) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
RMV_POST_IND Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 1 |
Percent Null | 0 |
RMV_POST_IND Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | 'N' |
Bound Default |
RMV_POST_IND Security Types |
Name | Current Value |
RMV_POST_IND Bound Attachments |
Name | Current Value |
RMV_POST_IND Data Movement Rules |
Name | Type | Rule Text/Value |
RMV_POST_IND Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request RMV_POST_IND |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ RMV_POST_IND |
NO | ||
EPICS (Oracle) BYPASS_REQ RMV_POST_IND |
NO | ||
OPER (Oracle) BYPASS_REQ RMV_POST_IND |
NO |
RMV_POST_IND Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_POST_IND Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_POST_IND Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
RMV_POST_IND Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_EXP_RMV_DTE |
Base Object | BYPASS_REQ |
Attribute Name | UPDTE_EXP_RMV_DTE |
ColumnName | UPDTE_EXP_RMV_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
UPDTE_EXP_RMV_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
UPDTE_EXP_RMV_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
UPDTE_EXP_RMV_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
UPDTE_EXP_RMV_DTE Security Types |
Name | Current Value |
UPDTE_EXP_RMV_DTE Bound Attachments |
Name | Current Value |
UPDTE_EXP_RMV_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
UPDTE_EXP_RMV_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request Update Expected Remove Date |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ UPDTE_EXP_RMV_DTE |
NO | ||
EPICS (Oracle) BYPASS_REQ UPDTE_EXP_RMV_DTE |
NO | ||
OPER (Oracle) BYPASS_REQ UPDTE_EXP_RMV_DTE |
NO |
UPDTE_EXP_RMV_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_EXP_RMV_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_EXP_RMV_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
UPDTE_EXP_RMV_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |