DP_SI_PS1UIN_VW

(SQL View)
 Index Back

Forecast Views 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 FORECAST VIEW NAME WILL RESOLVE TO ONLY THOSE VIEWS AUTHORIZED FOR THE CURRENT USERID SELECT A.DP_CONFIGVIEW , B.DP_USERID , A.DP_CAPTION , B.DP_USERNAME FROM PS_DP_CONFIGVIEWS A , PS_DP_USERVIEWS B WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND B.DP_USERID = %OperatorId

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 AND A.DP_USESINVENTORY = 'Y'

# 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