| 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 Nbr |
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 | System Identifier |
| ColumnName | SYS_ID |
| Logical Rolename | |
| RoleName | |
| Domain | System Id |
| 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 | Subsystem Identifer |
| ColumnName | SUBSYS_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Subsystem Identifier |
| Physical Only | NO |
| Definition | |
| 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 | Default Text |
| 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 Mech Nm |
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 Comment |
| ColumnName | BYPASS_CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| 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 Code |
| ColumnName | STATUS_CD |
| Logical Rolename | |
| RoleName | |
| Domain | |
| Physical Only | NO |
| Definition | Status Code: Indicates if the request has installation/verification data, iis approved by operations or has been retired. The valid values are 'I','A','R'. |
| Note |
| STATUS_CD Column Properties |
| Datatype | CHAR(1) |
| Nullable | YES |
| 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 | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| 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 |
| EXPT_RMV_DTE |
| Base Object | BYPASS_REQ |
| Attribute Name | Expected Removal Date |
| ColumnName | EXPT_RMV_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Expected Removal Date: The date in which the bypass is to be removed. |
| Note |
| EXPT_RMV_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| Not Null Constraint | |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| EXPT_RMV_DTE Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 7 |
| Percent Null | 0 |
| EXPT_RMV_DTE Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | sysdate |
| Bound Default |
| EXPT_RMV_DTE Security Types |
| Name | Current Value |
| EXPT_RMV_DTE Bound Attachments |
| Name | Current Value |
| EXPT_RMV_DTE Data Movement Rules |
| Name | Type | Rule Text/Value |
| EXPT_RMV_DTE Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Bypass Request Expected Removal Date |
NO | ||
| BYPASS_REQ (Oracle) BYPASS_REQ EXPT_RMV_DTE |
NO | ||
| EPICS (Oracle) BYPASS_REQ EXPT_RMV_DTE |
NO | ||
| OPER (Oracle) BYPASS_REQ EXPT_RMV_DTE |
NO |
| EXPT_RMV_DTE Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RMV_DTE Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RMV_DTE Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| EXPT_RMV_DTE Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| BLDG_ID |
| Base Object | BYPASS_REQ |
| Attribute Name | Building Identifier |
| ColumnName | BLDG_ID |
| Logical Rolename | |
| RoleName | |
| Domain | Building |
| 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 Building Identifier |
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 Date |
| 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 | Badge Number |
| ColumnName | ADD_BN |
| Logical Rolename | Add Badge Number |
| RoleName | ADD_BN |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ADD_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| 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 |
| ADD_APPR_BN |
| Base Object | BYPASS_REQ |
| Attribute Name | Badge Number |
| ColumnName | ADD_APPR_BN |
| Logical Rolename | Add Approve Badge Number |
| RoleName | ADD_APPR_BN |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| ADD_APPR_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| ADD_APPR_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| ADD_APPR_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| ADD_APPR_BN Security Types |
| Name | Current Value |
| ADD_APPR_BN Bound Attachments |
| Name | Current Value |
| ADD_APPR_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| ADD_APPR_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Bypass Request Badge Number |
NO | ||
| BYPASS_REQ (Oracle) BYPASS_REQ ADD_APPR_BN |
NO | ||
| EPICS (Oracle) BYPASS_REQ ADD_APPR_BN |
NO | ||
| OPER (Oracle) BYPASS_REQ ADD_APPR_BN |
NO |
| ADD_APPR_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADD_APPR_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADD_APPR_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| ADD_APPR_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPDTE_BN |
| Base Object | BYPASS_REQ |
| Attribute Name | Badge Number |
| ColumnName | UPDTE_BN |
| Logical Rolename | Update Badge Number |
| RoleName | UPDTE_BN |
| 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_APPR_BN |
| Base Object | BYPASS_REQ |
| Attribute Name | Badge Number |
| ColumnName | UPDTE_APPR_BN |
| Logical Rolename | Update Approve Badge Number |
| RoleName | UPDTE_APPR_BN |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| UPDTE_APPR_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| UPDTE_APPR_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| UPDTE_APPR_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| UPDTE_APPR_BN Security Types |
| Name | Current Value |
| UPDTE_APPR_BN Bound Attachments |
| Name | Current Value |
| UPDTE_APPR_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| UPDTE_APPR_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Bypass Request Badge Number |
NO | ||
| BYPASS_REQ (Oracle) BYPASS_REQ UPDTE_APPR_BN |
NO | ||
| EPICS (Oracle) BYPASS_REQ UPDTE_APPR_BN |
NO | ||
| OPER (Oracle) BYPASS_REQ UPDTE_APPR_BN |
NO |
| UPDTE_APPR_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPDTE_APPR_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPDTE_APPR_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPDTE_APPR_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| UPDTE_DTE |
| Base Object | BYPASS_REQ |
| Attribute Name | Update Date |
| ColumnName | UPDTE_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| Physical Only | NO |
| Definition | Date: Date and time to seconds. |
| Note |
| UPDTE_DTE Column Properties |
| Datatype | DATE |
| Nullable | NO |
| 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 | sysdate |
| 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 | Update Comment |
| ColumnName | UPDTE_CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| Physical Only | NO |
| Definition | Comment: General comments. |
| 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 | Remove Date |
| ColumnName | RMV_DTE |
| Logical Rolename | |
| RoleName | |
| Domain | Date |
| 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 | sysdate |
| 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_CMNT |
| Base Object | BYPASS_REQ |
| Attribute Name | Remove Comment |
| ColumnName | RMV_CMNT |
| Logical Rolename | |
| RoleName | |
| Domain | Comment |
| 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 |
| RMV_BN |
| Base Object | BYPASS_REQ |
| Attribute Name | Badge Number |
| ColumnName | RMV_BN |
| Logical Rolename | Remove Badge Number |
| RoleName | RMV_BN |
| 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_APPR_BN |
| Base Object | BYPASS_REQ |
| Attribute Name | Badge Number |
| ColumnName | RMV_APPR_BN |
| Logical Rolename | Remove Approve Badge Number |
| RoleName | RMV_APPR_BN |
| Domain | |
| Physical Only | NO |
| Definition | |
| Note |
| RMV_APPR_BN Column Properties |
| Datatype | VARCHAR2(10) |
| Nullable | YES |
| Not Null Constraint | |
| Character Set | BYTE |
| Encrypted | NO |
| Encryption Algorithm | -- |
| SALT | -- |
| RMV_APPR_BN Growth Metrics |
| COLUMN METRIC | COLUMN METRIC VALUE |
| Average Width | 10 |
| Percent Null | 0 |
| RMV_APPR_BN Domain Restrictions |
| CheckConstraint | |
| Check Constraint Name | |
| Bound Rule | |
| Declared Default | |
| Bound Default |
| RMV_APPR_BN Security Types |
| Name | Current Value |
| RMV_APPR_BN Bound Attachments |
| Name | Current Value |
| RMV_APPR_BN Data Movement Rules |
| Name | Type | Rule Text/Value |
| RMV_APPR_BN Where Used |
| Mapped Object | Is User Defined? | Description | Bound Attachments |
| Logical Bypass Request Badge Number |
NO | ||
| BYPASS_REQ (Oracle) BYPASS_REQ RMV_APPR_BN |
NO | ||
| EPICS (Oracle) BYPASS_REQ RMV_APPR_BN |
NO | ||
| OPER (Oracle) BYPASS_REQ RMV_APPR_BN |
NO |
| RMV_APPR_BN Direct Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RMV_APPR_BN Secondary Source Mappings |
| Columns | Transformation Logic | Transformation Description |
| RMV_APPR_BN Direct Target Mappings |
| Columns | Transformation Logic | Transformation Description |
| RMV_APPR_BN Secondary Target Mappings |
| Columns | Transformation Logic | Transformation Description |