SELECT DISTINCT(PS_DP_SUMM_SPEC.DP_CONFIGVIEW) ,PS_DP_SI_VW1USR_VW.OPRID FROM PS_DP_SI_VW1USR_VW , PS_DP_SUMM_SPEC WHERE PS_DP_SI_VW1USR_VW.DP_CONFIGVIEW = PS_DP_SUMM_SPEC.DP_CONFIGVIEW

DP_SUMCFGVW_VW

(SQL View)
 Index Back

SELECT DISTINCT(PS_DP_SUMM_SPEC.DP_CONFIGVIEW) ,PS_DP_SI_VW1USR_VW.OPRID FROM PS_DP_SI_VW1USR_VW , PS_DP_SUMM_SPEC WHERE PS_DP_SI_VW1USR_VW.DP_CONFIGVIEW = PS_DP_SUMM_SPEC.DP_CONFIGVIEW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

Prompt Table: DP_CFGVWUSER_VW

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

Prompt Table: OPRID_VW