LOGBOOK_V |
Name | LOGBOOK_V |
Owner | LOGBOOK |
Physical Only | NO |
Definition | |
Note | |
DDL Code | CREATE VIEW LOGBOOK.LOGBOOK_V (LOGBOOK_ID, LOGBOOK_NM, DIV_CD) AS SELECT x.instr_id,            x.facil_id || ' ' || x.instr_id || ' ' || x.instr_nm nm,            'X'       FROM xf_admin.INSTR x      WHERE x.facil_id <> 'CNMS'     UNION ALL     SELECT 'CHOP', 'NScD Choppers', 'X' FROM DUAL     UNION ALL     SELECT 'DATA', 'NScD Data Acquisition and Controls', 'X' FROM DUAL     UNION ALL     SELECT 'DETECT', 'NScD Detectors', 'X' FROM DUAL     UNION ALL     SELECT 'IHALLH', 'HFIR Instrument Hall Coordinators', 'X' FROM DUAL     UNION ALL     SELECT 'IHALLS', 'SNS Instrument Hall Coordinators', 'X' FROM DUAL     UNION ALL     SELECT 'ilog', 'NScD iLog Feedback', 'X' FROM DUAL     UNION ALL     SELECT 'SDA', 'NScD Scientific Data Analysis', 'X' FROM DUAL     UNION ALL     SELECT 'SDM', 'NScD Scientific Data Management', 'X' FROM DUAL     UNION ALL     SELECT 'ESH', 'NScD Environment, Safety, and Health', 'X' FROM DUAL     UNION ALL     SELECT 'LABH', 'HFIR Laboratories', 'X' FROM DUAL     UNION ALL     SELECT 'LABS', 'SNS Laboratories', 'X' FROM DUAL     UNION ALL     SELECT 'UO', 'NScD User Office', 'X' FROM DUAL     ORDER BY 2 |
LOGBOOK_V Columns |
Column Name / Expression | Alias Name | Parent Table Name |
INSTR_ID | LOGBOOK_ID | INSTR |
x.facil_id || ' ' || x.instr_id || ' ' || x.instr_nm | LOGBOOK_NM | |
'X' | DIV_CD |
LOGBOOK_V Where Used - Model Usage |
Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
Logical Does Not Exist |
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) LOGBOOK_V |
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_V |
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) 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 |
LOGBOOK_V Where Used - Submodel Usage |
Model | Submodel Usage |
EPICS (Oracle) | Main Model |
Instrument Logbook (Oracle) | Main Model |
LOGBOOK_V Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
LOGBOOK_V Security Types |
Name | Current Value |
LOGBOOK_V Bound Attachments |
Name | Current Value |