EODP_INTGRPVW1

(SQL View)
 Index Back

Integration Group References

Data Privacy Framewrok: Integration Group References View

SELECT A.IB_INTGROUPNAME ,' ' ,A.IB_SERVICENAME FROM PSIBSRVGROUP A ,PS_EODP_IBSVC_REF B WHERE A.IB_SERVICENAME=B.IB_SERVICENAME UNION SELECT A.IB_INTGROUPNAME ,IB_INTGROUPSUBNAME ,A.IB_SERVICENAME FROM PSIBSUBSRVGROUP A ,PS_EODP_IBSVC_REF B WHERE A.IB_SERVICENAME=B.IB_SERVICENAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 IB_INTGROUPNAME Character(30) VARCHAR2(30) NOT NULL Integration Group Name (see PSIBGROUPDEFN).
2 IB_INTGROUPSUBNAME Character(30) VARCHAR2(30) NOT NULL Integration Subgroup Name
3 IB_SERVICENAME Character(30) VARCHAR2(30) NOT NULL Service (see PSSERVICE).

Prompt Table: PSSERVICE