ICS_COMM_DVC_V |
Name | ICS_COMM_DVC_V |
Owner | EPICS |
Physical Only | NO |
Definition | ICS Communications: |
Note | |
DDL Code | CREATE VIEW EPICS.ICS_COMM_DVC_V (DVC_ID, SYS_ID, SUBSYS_ID, DVC_TYPE_ID, DVC_INST, PARENT_DVC_ID, DVC_DESC, IP_ADDR, ETHER_ADDR, NET_MASK, NET_DOMAIN, VLAN_NBR, ICS_NET_NM, SW_DVC_ID, SW_PORT_NBR, TSRV_DVC_ID, TSRV_PORT_NBR, RPC_DVC_ID, RPC_ADDR, DVC_DRW_NBR, DVC_ID_ALIAS, ORNL_PROP_NBR, OWNER_BN, NOTES, VIRTUAL_DVC_IND, BL_DVC_IND, INVALID_ID_IND, DSGN_CAB_SLOT_POS_IND, DSGN_CAB_SLOT_BGN, DSGN_CAB_SLOT_END, POS_WITHIN_SLOTS) AS SELECT dvc.dvc_id, dvc.sys_id, dvc.subsys_id, dvc.dvc_type_id,            dvc.dvc_inst, dvc.parent_dvc_id, dvc.dvc_desc, ics_comm_dvc.ip_addr,            ics_comm_dvc.ether_addr, ics_comm_dvc.net_mask,            ics_comm_dvc.net_domain, ics_comm_dvc.vlan_nbr,            ics_comm_dvc.ics_net_nm, ics_comm_dvc.sw_dvc_id,            ics_comm_dvc.sw_port_nbr, ics_comm_dvc.tsrv_dvc_id,            ics_comm_dvc.tsrv_port_nbr, ics_comm_dvc.rpc_dvc_id,            ics_comm_dvc.rpc_addr, dvc.dvc_drw_nbr, dvc.dvc_id_alias,            dvc.ornl_prop_nbr, dvc.owner_bn,            ics_comm_dvc.notes, dvc.virtual_dvc_ind, dvc.bl_dvc_ind,            dvc.invalid_id_ind, ics_comm_dvc.dsgn_cab_slot_pos_ind,            ics_comm_dvc.dsgn_cab_slot_bgn, ics_comm_dvc.dsgn_cab_slot_end,            ics_comm_dvc.pos_within_slots       FROM dvc dvc, ics_comm_dvc      WHERE ((dvc.dvc_id = ics_comm_dvc.dvc_id)) |
ICS_COMM_DVC_V Columns |
Column Name / Expression | Alias Name | Parent Table Name |
DVC_ID | DVC_ID | DVC |
SYS_ID | SYS_ID | DVC |
SUBSYS_ID | SUBSYS_ID | DVC |
DVC_TYPE_ID | DVC_TYPE_ID | DVC |
DVC_INST | DVC_INST | DVC |
PARENT_DVC_ID | PARENT_DVC_ID | DVC |
DVC_DESC | DVC_DESC | DVC |
IP_ADDR | IP_ADDR | ICS_COMM_DVC |
ETHER_ADDR | ETHER_ADDR | ICS_COMM_DVC |
NET_MASK | NET_MASK | ICS_COMM_DVC |
NET_DOMAIN | NET_DOMAIN | ICS_COMM_DVC |
VLAN_NBR | VLAN_NBR | ICS_COMM_DVC |
ICS_NET_NM | ICS_NET_NM | ICS_COMM_DVC |
SW_DVC_ID | SW_DVC_ID | ICS_COMM_DVC |
SW_PORT_NBR | SW_PORT_NBR | ICS_COMM_DVC |
TSRV_DVC_ID | TSRV_DVC_ID | ICS_COMM_DVC |
TSRV_PORT_NBR | TSRV_PORT_NBR | ICS_COMM_DVC |
RPC_DVC_ID | RPC_DVC_ID | ICS_COMM_DVC |
RPC_ADDR | RPC_ADDR | ICS_COMM_DVC |
DVC_DRW_NBR | DVC_DRW_NBR | DVC |
DVC_ID_ALIAS | DVC_ID_ALIAS | DVC |
ORNL_PROP_NBR | ORNL_PROP_NBR | DVC |
OWNER_BN | OWNER_BN | DVC |
NOTES | NOTES | ICS_COMM_DVC |
VIRTUAL_DVC_IND | VIRTUAL_DVC_IND | DVC |
BL_DVC_IND | BL_DVC_IND | DVC |
INVALID_ID_IND | INVALID_ID_IND | DVC |
DSGN_CAB_SLOT_POS_IND | DSGN_CAB_SLOT_POS_IND | ICS_COMM_DVC |
DSGN_CAB_SLOT_BGN | DSGN_CAB_SLOT_BGN | ICS_COMM_DVC |
DSGN_CAB_SLOT_END | DSGN_CAB_SLOT_END | ICS_COMM_DVC |
POS_WITHIN_SLOTS | POS_WITHIN_SLOTS | ICS_COMM_DVC |
ICS_COMM_DVC_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) ICS_COMM_DVC_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 |
ICS_COMM_DVC_V Where Used - Submodel Usage |
Model | Submodel Usage |
EPICS (Oracle) | Main Model |
ICS_COMM_DVC_V Object Permissions |
User/Role Name | Grantee Type | Permission Type | Action Type | Is Action Extended | Is System |
ICS_COMM_DVC_V Security Types |
Name | Current Value |
ICS_COMM_DVC_V Bound Attachments |
Name | Current Value |