SELECT DISTINCT(PS_DP_IPPUBSPC_HDR.DP_POLICYSET) ,PS_DP_SI_PS1USR_VW.OPRID FROM PS_DP_SI_PS1USR_VW , PS_DP_IPPUBSPC_HDR WHERE PS_DP_SI_PS1USR_VW.DP_POLICYSET = PS_DP_IPPUBSPC_HDR.DP_POLICYSET

DP_IPPUB_VW

(SQL View)
 Index Back

SELECT DISTINCT(PS_DP_IPPUBSPC_HDR.DP_POLICYSET) ,PS_DP_SI_PS1USR_VW.OPRID FROM PS_DP_SI_PS1USR_VW , PS_DP_IPPUBSPC_HDR WHERE PS_DP_SI_PS1USR_VW.DP_POLICYSET = PS_DP_IPPUBSPC_HDR.DP_POLICYSET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET

Prompt Table: DP_SI_PS1USR_VW

2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

Prompt Table: OPRID_VW