IOC_HPRF_HARDWARE_V |
Name | IOC_HPRF_HARDWARE_V |
Owner | EPICS |
Physical Only | NO |
Definition | |
Note | |
DDL Code | CREATE VIEW EPICS.IOC_HPRF_HARDWARE_V (IOC, ETHERIP, UTILITY, MPS, TIMING, BECKHOFF, OMS, OTHER, TOTAL) AS SELECT    ioc_nm, MAX (DECODE (cat, 'EtherIP', pv, NULL)) etherip,              MAX (DECODE (cat, 'Util', pv, NULL)) utility,              MAX (DECODE (cat, 'MPS', pv, NULL)) mps,              MAX (DECODE (cat, 'Timing', pv, NULL)) timing,              MAX (DECODE (cat, 'Beckhoff', pv, NULL)) beckhoff,              MAX (DECODE (cat, 'OMS', pv, NULL)) oms,              MAX (DECODE (cat, 'Other', pv, NULL)) other,              MAX (DECODE (cat, NULL, pv, NULL)) total         FROM (SELECT    ioc_nm, cat, COUNT (cat) pv                   FROM (SELECT b.ioc_nm, rec_nm,                                CASE                                   WHEN fld_val = 'EtherIP'                                      THEN 'EtherIP'                                   WHEN REGEXP_LIKE (fld_val, 'util', 'i')                                      THEN 'Util'                                   WHEN REGEXP_LIKE (fld_val, 'mps', 'i')                                      THEN 'MPS'                                   WHEN REGEXP_LIKE (fld_val, 'timing',                                                     'i')                                      THEN 'Timing'                                   WHEN REGEXP_LIKE (fld_val, 'Bx9000',                                                     'i')                                      THEN 'Beckhoff'                                   WHEN REGEXP_LIKE (fld_val, 'OMS')                                      THEN 'OMS'                                   ELSE 'Other'                                END cat                           FROM irmisbase.ioc_boot a,                                irmisbase.ioc b,                                irmisbase.ioc_resource c,                                epics.ioc_dvc e,                                irmisbase.fld f,                                irmisbase.rec g,                                irmisbase.fld_type h                          WHERE a.current_load = 1                            AND a.ioc_id = b.ioc_id                            AND b.ioc_nm = e.ioc_net_nm                            AND a.ioc_boot_id = c.ioc_boot_id                            AND c.ioc_resource_type_id = 1                            AND c.ioc_resource_id = f.ioc_resource_id                            AND f.rec_id = g.rec_id                            AND f.fld_type_id = h.fld_type_id                            AND h.fld_type = 'DTYP'                            AND ioc_nm LIKE '%hprf%')               GROUP BY ROLLUP (ioc_nm, cat)               ORDER BY ioc_nm)     GROUP BY ioc_nm     ORDER BY ioc_nm |
IOC_HPRF_HARDWARE_V Columns |
Column Name / Expression | Alias Name | Parent Table Name |
IOC_HPRF_HARDWARE_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) IOC_HPRF_HARDWARE_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) 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) 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 |
IOC_HPRF_HARDWARE_V Where Used - Submodel Usage |
Model | Submodel Usage |
EPICS (Oracle) | Main Model |
IOC_HPRF_HARDWARE_V Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
IOC_HPRF_HARDWARE_V Security Types |
Name | Current Value |
IOC_HPRF_HARDWARE_V Bound Attachments |
Name | Current Value |