DP_PUBIPC30A_VW

(SQL View)
 Index Back

DP_PUBRLIPITMVW

DP_PUBRLIPITMVW

SELECT DISTINCT B.OPRID , E.DP_PUBLISHNAME , F.DP_POLICYSET , E.ITEM_FIELD_C30_A FROM PS_DP_ROLEIPITEM A , PSOPRDEFN B , PSROLEUSER C , PS_DP_POLS1USER_VW D , PS_DP_PUB_IPMAST E , PS_DP_PUB_INVPOL F WHERE A.ROLENAME = C.ROLENAME AND C.ROLEUSER = B.OPRID AND A.DP_POLICYSET = D.DP_POLICYSET AND A.DP_POLICYSET = F.DP_POLICYSET AND A.DP_ITEMCODE = E.DP_ITEMCODE AND A.DP_LOCATION = E.DP_LOCATION AND E.DP_PUBLISHNAME = F.DP_PUBLISHNAME AND E.DP_PUBLISH_DATE = F.DP_PUBLISH_DATE 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_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name
3 DP_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET

Prompt Table: DP_POLICYSETS

4 ITEM_FIELD_C30_A Character(30) VARCHAR2(30) NOT NULL User-defined item field - Character 30