DP_SI_PS1USR_VW

(SQL View)
 Index Back

Policy Set by user

THE PURPOSE OF THIS VIEW IS TO PUT THE userid FIRST SO THAT THE MAGIC OF THE SEARCH DIALOG MEANS THAT THE EDITTABLE ON POLICY SET NAME WILL RESOLVE TO ONLY THOSE POLICY SETS AUTHORIZED FOR THE CURRENT USERID SELECT C.OPRID , A.DP_POLICYSET , B.DP_USERID , A.DP_CAPTION , B.DP_USERNAME , A.DP_USERDATACODE FROM PS_DP_POLICYSETS A , PS_DP_USERPOLICIES B , PSOPRDEFN C WHERE A.DP_POLICYSET = B.DP_POLICYSET AND B.DP_USERID = C.OPRID

SELECT C.OPRID , A.DP_POLICYSET , B.DP_USERID , A.DP_CAPTION , B.DP_USERNAME , A.DP_USERDATACODE FROM PS_DP_POLICYSETS A , PS_DP_USERPOLICIES B , PSOPRDEFN C WHERE A.DP_POLICYSET = B.DP_POLICYSET 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_POLICYSET Character(10) VARCHAR2(10) NOT NULL DP_POLICYSET
3 DP_USERID Character(30) VARCHAR2(30) NOT NULL DP_USERID

Prompt Table: DP_PSOPRDEFN_VW

4 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
5 DP_USERNAME Character(30) VARCHAR2(30) NOT NULL DP_USERNAME
6 DP_USERDATACODE Character(20) VARCHAR2(20) NOT NULL DP_USERDATACODE