DP_SI_DBV1USRVW

(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 FROM PS_DP_CONFIGVIEWS A , PS_DP_USERVIEWS B , PSOPRDEFN C WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND B.DP_USERID = C.OPRID AND A.DP_VIEWTYPE = '2'

# 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