Bypass Request 
EntityType  Independent 
Logical Entity Name  Bypass Request 
Default Table Name  BYPASS_REQ 
Logical Only  NO 
Owner  OPER 
Definition  
Bypass Request: Track the use of hardware and software jumpers to bypass system functions.
 
Note 
 

Bypass Request Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
Bypass Number(PK)    VARCHAR(10)  NO  
Bypass Number: System generated tracking number for the bypass request.
 
System Identifier(FK)  System Id  VARCHAR(10)  YES  
System Code: The unique identifier for the Spalation Neutron Source Project System.
 
Subsystem Identifer(FK)  Subsystem Identifier  VARCHAR(10)  YES 
 
Bypass Mechanism Name(FK)  Default Text  VARCHAR(50)  NO 
 
Bypass Comment  Comment  VARCHAR(2000)  NO  
Bypass Reason:  Justification for the bypass.
 
Status Code    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'.
 
Expected Removal Date  Date  DATE  NO  
Expected Removal Date:  The date in which the bypass is to be removed.
 
Add Date    DATE  YES 
 
Add Badge Number(FK)    VARCHAR(10)  YES 
 
Update Badge Number(FK)    VARCHAR(10)  YES 
 
Update Date  Date  DATE  NO  
Date: Date and time to seconds.
 
Update Comment  Comment  VARCHAR(2000)  YES  
Comment:  General comments.
 
Update Expected Remove Date  Date  DATE  NO  
Date: Date and time to seconds.
 
Remove Date  Date  DATE  YES  
Removal Date:  The date when the bypass was actually removed.
 
Remove Comment  Comment  VARCHAR(2000)  YES  
Removal Comments: Comments related to the bypass removal.
 
Remove Badge Number(FK)    VARCHAR(10)  YES 
 

Bypass Request Keys 
Key Name  Key Type  Keys 
BYPASS_REQ_PK  PrimaryKey  Bypass Number 

Bypass Request Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Bypass Mechanism  Non-Identifying  One To Zero or More        Bypass Mechanism Name  NO 
Subsystem  Non-Identifying  Zero or One to Zero or More        Subsystem Identifer  NO 
System  Non-Identifying  Zero or One to Zero or More        System Identifier  NO 
Employee  Non-Identifying  Zero or One to Zero or More        Add Badge Number  NO 
Employee  Non-Identifying  Zero or One to Zero or More        Remove Badge Number  NO 
Employee  Non-Identifying  Zero or One to Zero or More        Update Badge Number  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
Bypass Device  Identifying  One To Zero or More          NO 
Bypass Approve Association  Identifying  One To Zero or More          NO 
Bypass Image  Identifying  One To Zero or More          NO 

Bypass Request Check Constraints 
Check Constraint Name  CheckConstraint 

Bypass Request Object Permissions 

User/Role Name  Grantee Type  Permission Type  Action Type  Is Action Extended  Is System 
Bypass Request Security Types 
Name  Current Value 

Bypass Request Bound Attachments 
Name  Current Value 

Bypass Request 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 Request 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 Request Data Movement Rules 
Name  Type  Rule Text/Value