DP_SI_VW1USR_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_CONFIGVIEW , B.DP_USERID , B.DP_USERNAME , A.DP_USERDATACODE , A.DP_VIEWTYPE FROM PS_DP_CONFIGVIEWS A , PS_DP_USERVIEWS B , PSOPRDEFN C WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW 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_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

Prompt Table: %EDITTABLE

3 DP_USERID Character(30) VARCHAR2(30) NOT NULL DP_USERID

Prompt Table: DP_PSOPRDEFN_VW

4 DP_USERNAME Character(30) VARCHAR2(30) NOT NULL DP_USERNAME
5 DP_USERDATACODE Character(20) VARCHAR2(20) NOT NULL DP_USERDATACODE
6 DP_VIEWTYPE Character(1) VARCHAR2(1) NOT NULL DP_VIEWTYPE
0=Working View
1=Dynamic View
2=Disbursement View