BYPASS_REQ |
Logical Entity Name | Bypass Request |
Default Table Name | BYPASS_REQ |
Oracle Temporary Table | NO |
Physical Only | NO |
Do Not Generate | False |
Owner | OPER |
Definition | Bypass Request: Track the use of hardware and software jumpers to bypass system functions. |
Note | |
PreSQL | |
DDL Code | CREATE TABLE OPER.BYPASS_REQ(      "Bypass Nbr"       VARCHAR2(10)       NOT NULL,      SYS_ID             VARCHAR2(10),      SUBSYS_ID          VARCHAR2(10),      "Bypass Mech Nm"   VARCHAR2(50)       NOT NULL,      BYPASS_CMNT        VARCHAR2(2000)     NOT NULL,      STATUS_CD          CHAR(1),      EXPT_RMV_DTE       DATE               DEFAULT sysdate NOT NULL,      BLDG_ID            VARCHAR2(10)       NOT NULL,      ADD_DTE            DATE,      ADD_BN             VARCHAR2(10),      ADD_APPR_BN        VARCHAR2(10),      UPDTE_BN           VARCHAR2(10),      UPDTE_APPR_BN      VARCHAR2(10),      UPDTE_DTE          DATE               DEFAULT sysdate NOT NULL,      UPDTE_CMNT         VARCHAR2(2000),      RMV_DTE            DATE               DEFAULT sysdate,      RMV_CMNT           VARCHAR2(2000),      RMV_BN             VARCHAR2(10),      RMV_APPR_BN        VARCHAR2(10),      CONSTRAINT BYPASS_REQ_PK PRIMARY KEY ("Bypass Nbr")      USING INDEX          LOGGING,      CONSTRAINT fk_br_add_appr_bn_to_employee FOREIGN KEY (ADD_APPR_BN)      REFERENCES OPER.EMPLOYEE(BN),      CONSTRAINT fk_br_add_bn_to_employee FOREIGN KEY (ADD_BN)      REFERENCES OPER.EMPLOYEE(BN),      CONSTRAINT fk_br_updte_bn_to_employee FOREIGN KEY (UPDTE_BN)      REFERENCES OPER.EMPLOYEE(BN),      CONSTRAINT fk_br_updte_appr_bn_to_employee FOREIGN KEY (UPDTE_APPR_BN)      REFERENCES OPER.EMPLOYEE(BN),      CONSTRAINT fk_br_rmv_bn_to_employee FOREIGN KEY (RMV_BN)      REFERENCES OPER.EMPLOYEE(BN),      CONSTRAINT fk_br_rmv_appr_bn_to_employee FOREIGN KEY (RMV_APPR_BN)      REFERENCES OPER.EMPLOYEE(BN),      CONSTRAINT BYPASS_REQ_BYPASS_MECH_FK FOREIGN KEY ("Bypass Mech Nm")      REFERENCES OPER.Bypass_Mech("Bypass Mech Nm") ) LOGGING NOPARALLEL NOCACHE NOCOMPRESS ; |
PostSQL |
BYPASS_REQ Columns |
ColumnName | Domain | Datatype | NULL | Definition |
Bypass Nbr | VARCHAR2(10) | NO | Bypass Number: System generated tracking number for the bypass request. |
|
SYS_ID | System Id | VARCHAR2(10) | YES | System Code: The unique identifier for the Spalation Neutron Source Project System. |
SUBSYS_ID | Subsystem Identifier | VARCHAR2(10) | YES | |
Bypass Mech Nm | Default Text | VARCHAR2(50) | NO | |
BYPASS_CMNT | Comment | VARCHAR2(2000) | NO | Bypass Reason: Justification for the bypass. |
STATUS_CD | CHAR(1) | YES | 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'. |
|
EXPT_RMV_DTE | Date | DATE | NO | Expected Removal Date: The date in which the bypass is to be removed. |
BLDG_ID | Building | VARCHAR2(10) | NO | Building: The building number. |
ADD_DTE | DATE | YES | ||
ADD_BN | VARCHAR2(10) | YES | ||
ADD_APPR_BN | VARCHAR2(10) | YES | ||
UPDTE_BN | VARCHAR2(10) | YES | ||
UPDTE_APPR_BN | VARCHAR2(10) | YES | ||
UPDTE_DTE | Date | DATE | NO | Date: Date and time to seconds. |
UPDTE_CMNT | Comment | VARCHAR2(2000) | YES | Comment: General comments. |
RMV_DTE | Date | DATE | YES | Removal Date: The date when the bypass was actually removed. |
RMV_CMNT | Comment | VARCHAR2(2000) | YES | Removal Comments: Comments related to the bypass removal. |
RMV_BN | VARCHAR2(10) | YES | ||
RMV_APPR_BN | VARCHAR2(10) | YES |
BYPASS_REQ Primary and Unique Keys |
Key Name | Key Type | Keys |
BYPASS_REQ_PK | PrimaryKey | Bypass Nbr |
BYPASS_REQ Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Bypass_Mech | Non-Identifying | One To Zero or More | BYPASS_REQ_BYPASS_MECH_FK | Bypass Mech Nm | NO | NO | NO | ||
EMPLOYEE | Non-Identifying | Zero or One to Zero or More | fk_br_add_appr_bn_to_employee | ADD_APPR_BN | NO | NO | NO | ||
EMPLOYEE | Non-Identifying | Zero or One to Zero or More | fk_br_add_bn_to_employee | ADD_BN | NO | NO | NO | ||
EMPLOYEE | Non-Identifying | Zero or One to Zero or More | fk_br_rmv_appr_bn_to_employee | RMV_APPR_BN | NO | NO | NO | ||
EMPLOYEE | Non-Identifying | Zero or One to Zero or More | fk_br_rmv_bn_to_employee | RMV_BN | NO | NO | NO | ||
EMPLOYEE | Non-Identifying | Zero or One to Zero or More | fk_br_updte_appr_bn_to_employee | UPDTE_APPR_BN | NO | NO | NO | ||
EMPLOYEE | Non-Identifying | Zero or One to Zero or More | fk_br_updte_bn_to_employee | UPDTE_BN | NO | NO | NO |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |
BYPASS_DVC | Identifying | One To Zero or More | NO | NO | YES | ||||
BYPASS_IMG | Identifying | One To Zero or More | fk_bypass_img_to_bypass_req | NO | NO | NO |
BYPASS_REQ Check Constraints |
Check Constraint Name | CheckConstraint |
BYPASS_REQ Storage |
STORAGE OPTION | STORAGE VALUE |
TABLESPACE | |
PctFree | |
PCTUSED | |
MinExtents | |
MaxExtents | |
Initial | |
Next | |
PctIncrease | |
InitTrans | |
MaxTrans | |
Organization | Heap |
Cache | NO |
Logging | |
Parallel | NO |
Parallel Degrees | |
Parallel Instances | |
FREELISTS | |
FREELIST GROUPS | |
Buffer Pool | |
Table Compression | NO |
Compress Expression | |
Row Movement | Disabled |
BYPASS_REQ Partitions |
PARTITION PROPERTY | PARTITION PROPERTY VALUE |
BYPASS_REQ Growth Metrics |
TABLE METRIC | TABLE METRIC VALUE |
Current Row Count | 0 |
Growth | Static |
Growth Type | N/A |
Growth Period | N/A |
Maximum Rows | 0 |
Average Row Size | 0 |
BYPASS_REQ Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
BYPASS_REQ Security Types |
Name | Current Value |
BYPASS_REQ Bound Attachments |
Name | Current Value |
BYPASS_REQ Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical OPER.Bypass Request |
NO | |||
ALARM_MYSQL (MySQL) Does Not Exist |
NO | |||
ALARM_ORACLE (Oracle) Does Not Exist |
NO | |||
BICS (Oracle) Does Not Exist |
NO | |||
BLM (Oracle) Does Not Exist |
NO | |||
BYPASS_REQ (Oracle) OPER.BYPASS_REQ |
NO | |||
CHAN_ARCH (Oracle) Does Not Exist |
NO | |||
CNMS_PRPSL (Oracle) Does Not Exist |
NO | |||
DIAG (Oracle) Does Not Exist |
NO | |||
DIAG_MPS (Oracle) Does Not Exist |
NO | |||
ENGA (Oracle) Does Not Exist |
NO | |||
EPICS (Oracle) EPICS.BYPASS_REQ |
NO | |||
EQUIP (Oracle) Does Not Exist |
NO | |||
EXPRESS (Oracle) Does Not Exist |
NO | |||
ICS_SFTW_APPL (Oracle) Does Not Exist |
NO | |||
INSTR (Oracle) Does Not Exist |
NO | |||
Instrument Logbook (Oracle) Does Not Exist |
NO | |||
INVT (Oracle) Does Not Exist |
NO | |||
IONSRC (Oracle) Does Not Exist |
NO | |||
IONSRC1 (Oracle) Does Not Exist |
NO | |||
IPTSv5 (Oracle) Does Not Exist |
NO | |||
IRMISBase (Oracle) Does Not Exist |
NO | |||
Logbook (Oracle) Does Not Exist |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) OPER.BYPASS_REQ |
NO | |||
PART (Oracle) Does Not Exist |
NO | |||
PRINT (Oracle) Does Not Exist |
NO | |||
PROC (Oracle) Does Not Exist |
NO | |||
PRPSL (Oracle) Does Not Exist |
NO | |||
PUBL (Oracle) Does Not Exist |
NO | |||
PUBL_V1 (Oracle) Does Not Exist |
NO | |||
PV_LOGGER (Oracle) Does Not Exist |
NO | |||
SCORE (Oracle) Does Not Exist |
NO | |||
SICAT (Oracle) Does Not Exist |
NO | |||
SMPL (Oracle) Does Not Exist |
NO | |||
SMPLACT (Oracle) Does Not Exist |
NO | |||
SURVEY (Oracle) Does Not Exist |
NO | |||
Watchman (Oracle) Does Not Exist |
NO | |||
XAL_OPTICS (Oracle) Does Not Exist |
NO | |||
XF_ADMIN (Oracle) Does Not Exist |
NO |
BYPASS_REQ Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Bypass Request |
Logical | EPICS |
BYPASS_REQ (Oracle) | Main Model |
EPICS (Oracle) | Main Model |
OPER (Oracle) | Main Model |
BYPASS_REQ Data Movement Rules |
Name | Type | Rule Text/Value |