DP_IPWQP_VW

(SQL View)
Index Back

IP Work Queue Purge Spec View

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

SELECT DISTINCT(PS_DP_IPWKQUE_SPEC.DP_POLICYSET) ,PS_DP_SI_PS1USR_VW.OPRID FROM PS_DP_SI_PS1USR_VW , PS_DP_IPWKQUE_SPEC WHERE PS_DP_SI_PS1USR_VW.DP_POLICYSET = PS_DP_IPWKQUE_SPEC.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