DP_WRKVIEWS_VW2

(SQL View)
 Index Back

SELECT B.DP_USERID , A.DP_CONFIGVIEW FROM PS_DP_CONFIGVIEWS A , PS_DP_USERVIEWS B WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND A.DP_VIEWTYPE = '0'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

Prompt Table: DP_WORKVIEWS_VW