DP_ROLIPITM2_VW

(SQL View)
 Index Back

View of ROLEIPITM -- Item Code

SELECT DISTINCT(B.OPRID ) , A.DP_POLICYSET , A.DP_ITEMCODE , 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_ITEMCODE 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_ITEMCODE Character(18) VARCHAR2(18) NOT NULL DP_ITEMCODE