DP_ROLIPITM3_VW

(SQL View)
 Index Back

View of ROLEIPITM Location

SELECT DISTINCT(B.OPRID ) , A.DP_POLICYSET , A.DP_LOCATION , A.DP_DESCR FROM PS_DP_ROLEIPITEM A , PSOPRDEFN B , PSROLEUSER C , PS_DP_POLS1USER_VW D WHERE A.ROLENAME = C.ROLENAME AND C.ROLEUSER = B.OPRID AND A.DP_POLICYSET = D.DP_POLICYSET AND B.OPRID = D.OPRID

SELECT DISTINCT(B.OPRID) , A.DP_POLICYSET , A.DP_LOCATION FROM PS_DP_ROLEIPITEM A , PSOPRDEFN B , PSROLEUSER C , PS_DP_POLS1USER_VW D WHERE A.ROLENAME = C.ROLENAME AND C.ROLEUSER = B.OPRID AND A.DP_POLICYSET = D.DP_POLICYSET AND B.OPRID = D.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_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET

Prompt Table: %EDITTABLE

3 DP_LOCATION Character(5) VARCHAR2(5) NOT NULL DP_LOCATION