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 | 4 |
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 | 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 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 | 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 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 |
DVC_ID |
Base Object | BYPASS_REQ |
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 | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
DVC_ID Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 17 |
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 Bypass Request DVC_ID |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ DVC_ID |
NO | ||
EPICS (Oracle) BYPASS_REQ DVC_ID |
NO | ||
OPER (Oracle) BYPASS_REQ 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 |
REQ_DTE |
Base Object | BYPASS_REQ |
Attribute Name | REQ_DTE |
ColumnName | REQ_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Request Date: The date the bypass request is made. |
Note |
REQ_DTE Column Properties |
Datatype | DATE |
Nullable | NO |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
REQ_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
REQ_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
REQ_DTE Security Types |
Name | Current Value |
REQ_DTE Bound Attachments |
Name | Current Value |
REQ_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
REQ_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request REQ_DTE |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ REQ_DTE |
NO | ||
EPICS (Oracle) BYPASS_REQ REQ_DTE |
NO | ||
OPER (Oracle) BYPASS_REQ REQ_DTE |
NO |
REQ_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_BY |
Base Object | BYPASS_REQ |
Attribute Name | REQ_BY |
ColumnName | REQ_BY |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Requested Byr: The person who has requested the bypass. |
Note |
REQ_BY Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
REQ_BY Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 12 |
Percent Null | 0 |
REQ_BY Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
REQ_BY Security Types |
Name | Current Value |
REQ_BY Bound Attachments |
Name | Current Value |
REQ_BY Data Movement Rules |
Name | Type | Rule Text/Value |
REQ_BY Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request REQ_BY |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ REQ_BY |
NO | ||
EPICS (Oracle) BYPASS_REQ REQ_BY |
NO | ||
OPER (Oracle) BYPASS_REQ REQ_BY |
NO |
REQ_BY Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_BY Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_BY Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_BY 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 |
BYPASS_RSN |
Base Object | BYPASS_REQ |
Attribute Name | BYPASS_RSN |
ColumnName | BYPASS_RSN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Bypass Reason: Justification for the bypass. |
Note |
BYPASS_RSN Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BYPASS_RSN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 69 |
Percent Null | 0 |
BYPASS_RSN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BYPASS_RSN Security Types |
Name | Current Value |
BYPASS_RSN Bound Attachments |
Name | Current Value |
BYPASS_RSN Data Movement Rules |
Name | Type | Rule Text/Value |
BYPASS_RSN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request BYPASS_RSN |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ BYPASS_RSN |
NO | ||
EPICS (Oracle) BYPASS_REQ BYPASS_RSN |
NO | ||
OPER (Oracle) BYPASS_REQ BYPASS_RSN |
NO |
BYPASS_RSN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_RSN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_RSN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_RSN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_CONSEQ |
Base Object | BYPASS_REQ |
Attribute Name | BYPASS_CONSEQ |
ColumnName | BYPASS_CONSEQ |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Bypass Consequence: The consequences the bypass will have on other systems, |
Note |
BYPASS_CONSEQ Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BYPASS_CONSEQ Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 34 |
Percent Null | 31 |
BYPASS_CONSEQ Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BYPASS_CONSEQ Security Types |
Name | Current Value |
BYPASS_CONSEQ Bound Attachments |
Name | Current Value |
BYPASS_CONSEQ Data Movement Rules |
Name | Type | Rule Text/Value |
BYPASS_CONSEQ Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request BYPASS_CONSEQ |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ BYPASS_CONSEQ |
NO | ||
EPICS (Oracle) BYPASS_REQ BYPASS_CONSEQ |
NO | ||
OPER (Oracle) BYPASS_REQ BYPASS_CONSEQ |
NO |
BYPASS_CONSEQ Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_CONSEQ Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_CONSEQ Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BYPASS_CONSEQ Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_LMT |
Base Object | BYPASS_REQ |
Attribute Name | OPR_LMT |
ColumnName | OPR_LMT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Operational Limitations: How will the bypass limit operations. |
Note |
OPR_LMT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OPR_LMT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 78 |
OPR_LMT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OPR_LMT Security Types |
Name | Current Value |
OPR_LMT Bound Attachments |
Name | Current Value |
OPR_LMT Data Movement Rules |
Name | Type | Rule Text/Value |
OPR_LMT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request OPR_LMT |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ OPR_LMT |
NO | ||
EPICS (Oracle) BYPASS_REQ OPR_LMT |
NO | ||
OPER (Oracle) BYPASS_REQ OPR_LMT |
NO |
OPR_LMT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_LMT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_LMT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_LMT Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_BN |
Base Object | BYPASS_REQ |
Attribute Name | OPR_BN |
ColumnName | OPR_BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Operator Badge Number: The operator on duty when the bypass is requested. |
Note |
OPR_BN Column Properties |
Datatype | CHAR(6) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OPR_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 0 |
OPR_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OPR_BN Security Types |
Name | Current Value |
OPR_BN Bound Attachments |
Name | Current Value |
OPR_BN Data Movement Rules |
Name | Type | Rule Text/Value |
OPR_BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request OPR_BN |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ OPR_BN |
NO | ||
EPICS (Oracle) BYPASS_REQ OPR_BN |
NO | ||
OPER (Oracle) BYPASS_REQ OPR_BN |
NO |
OPR_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
PERF_BY |
Base Object | BYPASS_REQ |
Attribute Name | PERF_BY |
ColumnName | PERF_BY |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Performed By: The technican, engineer or other personnel who will make the jumper bypass. |
Note |
PERF_BY Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
PERF_BY Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 10 |
Percent Null | 30 |
PERF_BY Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
PERF_BY Security Types |
Name | Current Value |
PERF_BY Bound Attachments |
Name | Current Value |
PERF_BY Data Movement Rules |
Name | Type | Rule Text/Value |
PERF_BY Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request PERF_BY |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ PERF_BY |
NO | ||
EPICS (Oracle) BYPASS_REQ PERF_BY |
NO | ||
OPER (Oracle) BYPASS_REQ PERF_BY |
NO |
PERF_BY Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
PERF_BY Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
PERF_BY Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
PERF_BY Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
SYS_CHK_DTE |
Base Object | BYPASS_REQ |
Attribute Name | SYS_CHK_DTE |
ColumnName | SYS_CHK_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | System Check Date: The date/time the bypass was made and checked. |
Note |
SYS_CHK_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
SYS_CHK_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 0 |
SYS_CHK_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | sysdate |
Bound Default |
SYS_CHK_DTE Security Types |
Name | Current Value |
SYS_CHK_DTE Bound Attachments |
Name | Current Value |
SYS_CHK_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
SYS_CHK_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request SYS_CHK_DTE |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ SYS_CHK_DTE |
NO | ||
EPICS (Oracle) BYPASS_REQ SYS_CHK_DTE |
NO | ||
OPER (Oracle) BYPASS_REQ SYS_CHK_DTE |
NO |
SYS_CHK_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
SYS_CHK_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
SYS_CHK_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
SYS_CHK_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_CMNT |
Base Object | BYPASS_REQ |
Attribute Name | REQ_CMNT |
ColumnName | REQ_CMNT |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Comments: General comments on the bypass not covered in the previous comment attributes. |
Note |
REQ_CMNT Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
REQ_CMNT Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 16 |
Percent Null | 79 |
REQ_CMNT Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
REQ_CMNT Security Types |
Name | Current Value |
REQ_CMNT Bound Attachments |
Name | Current Value |
REQ_CMNT Data Movement Rules |
Name | Type | Rule Text/Value |
REQ_CMNT Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request REQ_CMNT |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ REQ_CMNT |
NO | ||
EPICS (Oracle) BYPASS_REQ REQ_CMNT |
NO | ||
OPER (Oracle) BYPASS_REQ REQ_CMNT |
NO |
REQ_CMNT Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_CMNT Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_CMNT Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
REQ_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. |
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 |
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 | 8 |
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 |
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 | 5 |
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 |
BLDG_AREA |
Base Object | BYPASS_REQ |
Attribute Name | BLDG_AREA |
ColumnName | BLDG_AREA |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
BLDG_AREA Column Properties |
Datatype | VARCHAR2(255) |
Nullable | NO |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
BLDG_AREA Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 8 |
Percent Null | 0 |
BLDG_AREA Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
BLDG_AREA Security Types |
Name | Current Value |
BLDG_AREA Bound Attachments |
Name | Current Value |
BLDG_AREA Data Movement Rules |
Name | Type | Rule Text/Value |
BLDG_AREA Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request BLDG_AREA |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ BLDG_AREA |
NO | ||
EPICS (Oracle) BYPASS_REQ BLDG_AREA |
NO | ||
OPER (Oracle) BYPASS_REQ BLDG_AREA |
NO |
BLDG_AREA Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_AREA Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_AREA Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
BLDG_AREA Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
EDM_SCR |
Base Object | BYPASS_REQ |
Attribute Name | EDM_SCR |
ColumnName | EDM_SCR |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | EDM Screens: The Electronic Display Manager screens that the bypass will affect. |
Note |
EDM_SCR Column Properties |
Datatype | VARCHAR2(2000) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
EDM_SCR Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 9 |
Percent Null | 68 |
EDM_SCR Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
EDM_SCR Security Types |
Name | Current Value |
EDM_SCR Bound Attachments |
Name | Current Value |
EDM_SCR Data Movement Rules |
Name | Type | Rule Text/Value |
EDM_SCR Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request EDM_SCR |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ EDM_SCR |
NO | ||
EPICS (Oracle) BYPASS_REQ EDM_SCR |
NO | ||
OPER (Oracle) BYPASS_REQ EDM_SCR |
NO |
EDM_SCR Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
EDM_SCR Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
EDM_SCR Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
EDM_SCR 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 | 7 |
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 |
POST_BYPASS_CHKLST |
Base Object | BYPASS_REQ |
Attribute Name | POST_BYPASS_CHKLST |
ColumnName | POST_BYPASS_CHKLST |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Post System Bypass Checklist: The checklist performed after bypass removal. |
Note |
POST_BYPASS_CHKLST Column Properties |
Datatype | VARCHAR2(50) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
POST_BYPASS_CHKLST Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 17 |
Percent Null | 47 |
POST_BYPASS_CHKLST Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
POST_BYPASS_CHKLST Security Types |
Name | Current Value |
POST_BYPASS_CHKLST Bound Attachments |
Name | Current Value |
POST_BYPASS_CHKLST Data Movement Rules |
Name | Type | Rule Text/Value |
POST_BYPASS_CHKLST Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request POST_BYPASS_CHKLST |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ POST_BYPASS_CHKLST |
NO | ||
EPICS (Oracle) BYPASS_REQ POST_BYPASS_CHKLST |
NO | ||
OPER (Oracle) BYPASS_REQ POST_BYPASS_CHKLST |
NO |
POST_BYPASS_CHKLST Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
POST_BYPASS_CHKLST Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
POST_BYPASS_CHKLST Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
POST_BYPASS_CHKLST 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 | 18 |
Percent Null | 64 |
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 |
OPR_APPR_BN |
Base Object | BYPASS_REQ |
Attribute Name | OPR_APPR_BN |
ColumnName | OPR_APPR_BN |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | Operations Approved Badge Number: The person who approved the bypass request. |
Note |
OPR_APPR_BN Column Properties |
Datatype | CHAR(6) |
Nullable | YES |
Not Null Constraint | |
Character Set | BYTE |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
OPR_APPR_BN Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 6 |
Percent Null | 2 |
OPR_APPR_BN Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
OPR_APPR_BN Security Types |
Name | Current Value |
OPR_APPR_BN Bound Attachments |
Name | Current Value |
OPR_APPR_BN Data Movement Rules |
Name | Type | Rule Text/Value |
OPR_APPR_BN Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request OPR_APPR_BN |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ OPR_APPR_BN |
NO | ||
EPICS (Oracle) BYPASS_REQ OPR_APPR_BN |
NO | ||
OPER (Oracle) BYPASS_REQ OPR_APPR_BN |
NO |
OPR_APPR_BN Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_APPR_BN Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_APPR_BN Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
OPR_APPR_BN Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
APPR_RMV_DTE |
Base Object | BYPASS_REQ |
Attribute Name | APPR_RMV_DTE |
ColumnName | APPR_RMV_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
APPR_RMV_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
APPR_RMV_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 35 |
APPR_RMV_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
APPR_RMV_DTE Security Types |
Name | Current Value |
APPR_RMV_DTE Bound Attachments |
Name | Current Value |
APPR_RMV_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
APPR_RMV_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request APPR_RMV_DTE |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ APPR_RMV_DTE |
NO | ||
EPICS (Oracle) BYPASS_REQ APPR_RMV_DTE |
NO | ||
OPER (Oracle) BYPASS_REQ APPR_RMV_DTE |
NO |
APPR_RMV_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
APPR_RMV_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
APPR_RMV_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
APPR_RMV_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |
APPR_DTE |
Base Object | BYPASS_REQ |
Attribute Name | APPR_DTE |
ColumnName | APPR_DTE |
Logical Rolename | |
RoleName | |
Domain | |
Physical Only | NO |
Definition | |
Note |
APPR_DTE Column Properties |
Datatype | DATE |
Nullable | YES |
Not Null Constraint | |
Encrypted | NO |
Encryption Algorithm | -- |
SALT | -- |
APPR_DTE Growth Metrics |
COLUMN METRIC | COLUMN METRIC VALUE |
Average Width | 7 |
Percent Null | 4 |
APPR_DTE Domain Restrictions |
CheckConstraint | |
Check Constraint Name | |
Bound Rule | |
Declared Default | |
Bound Default |
APPR_DTE Security Types |
Name | Current Value |
APPR_DTE Bound Attachments |
Name | Current Value |
APPR_DTE Data Movement Rules |
Name | Type | Rule Text/Value |
APPR_DTE Where Used |
Mapped Object | Is User Defined? | Description | Bound Attachments |
Logical Bypass Request APPR_DTE |
NO | ||
BYPASS_REQ (Oracle) BYPASS_REQ APPR_DTE |
NO | ||
EPICS (Oracle) BYPASS_REQ APPR_DTE |
NO | ||
OPER (Oracle) BYPASS_REQ APPR_DTE |
NO |
APPR_DTE Direct Source Mappings |
Columns | Transformation Logic | Transformation Description |
APPR_DTE Secondary Source Mappings |
Columns | Transformation Logic | Transformation Description |
APPR_DTE Direct Target Mappings |
Columns | Transformation Logic | Transformation Description |
APPR_DTE Secondary Target Mappings |
Columns | Transformation Logic | Transformation Description |