Daily Order Required Reading |
EntityType | Dependent |
Logical Entity Name | Daily Order Required Reading |
Default Table Name | DAILY_ORDER_REQD_READ |
Logical Only | NO |
Owner | LOGBOOK |
Definition | Daily Order Required Reading: The daily orders generated by Operations management for the operators. When a daily order is created in the log_entry table it's id is also kept in this table with an in effect flag. The order will be displayed as a log entry to the operators each day until the in effect flag is turned off. Required Reading can be published to the any Logbook user but work essentially the same as Daily Orders. |
Note |
Daily Order Required Reading Attributes |
Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
Log Entry Id | INTEGER | NO | Log Entry Identifier: The unique identifier for a log entry. This number is automatically generated in sequential order. |
|
In Effect Ind | Indicator | CHAR(1) | NO | In Effect Indicator: Indicates the Daily Order is in effect and must be acknowledged by the Operator. |
Reqd Read Freq Id | INTEGER | YES | Required Reading Frequency Identifier: Unique numeric identifier for the required reading frequencies. |
|
Daily Order Creation Date | Date | DATE | YES | Date: Date and time to seconds. |
Daily Order Expiration Date | Date | DATE | YES | Date: Date and time to seconds. |
Mod Dte | Date | DATE | NO | Date: Date and time to seconds. |
Daily Order Required Reading Keys |
Key Name | Key Type | Keys |
daily_order_req_read_pk | PrimaryKey | Log Entry Id |
Daily Order Required Reading Relationships |
Parent Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
Log Entry | Identifying | One To Zero or More | Log Entry Id | NO | |||
Required Reading Frequency | Non-Identifying | Zero or One to Zero or More | Reqd Read Freq Id | NO |
Child Relationships: |
Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
Daily Order Required Reading Check Constraints |
Check Constraint Name | CheckConstraint |
Daily Order Required Reading Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
Daily Order Required Reading Security Types |
Name | Current Value |
Daily Order Required Reading Bound Attachments |
Name | Current Value |
Daily Order Required Reading Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical LOGBOOK.Daily Order Required Reading |
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) Does Not Exist |
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) Does Not Exist |
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) LOGBOOK.DAILY_ORDER_REQD_READ |
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) LOGBOOK.DAILY_ORDER_REQD_READ |
NO | |||
Magnet (Oracle) Does Not Exist |
NO | |||
MPS (Oracle) Does Not Exist |
NO | |||
NS_OPER (Oracle) Does Not Exist |
NO | |||
OPER (Oracle) Does Not Exist |
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 |
Daily Order Required Reading Where Used - Submodel Usage |
Model | Submodel Usage |
Logical | Main Model |
Logical | Logbook |
Instrument Logbook (Oracle) | Main Model |
Logbook (Oracle) | Main Model |
Daily Order Required Reading Data Movement Rules |
Name | Type | Rule Text/Value |