DP_VIEW2USER_VW

(SQL View)
Index Back

PS_DP_USERVIEWS View #2

SELECT A.DP_CONFIGVIEW ,A.DP_CAPTION FROM PS_DP_CONFIGVIEWS A , PS_DP_VIEW1USER_VW B WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND DP_USERID = %OperatorId

SELECT C.OPRID , A.DP_CONFIGVIEW FROM PS_DP_CONFIGVIEWS A , PS_DP_USERVIEWS B , PSOPRDEFN C WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND B.DP_USERID = C.OPRID

# 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: %EDITTABLE