DP_USER1VIEW_VW (SQL View)	Index Back
Forecast Views by user Used for Security by the external programs when selecting view. It is designed to resemble the DP_VIEW1USER_VW record with some modifications.

DP_USER1VIEW_VW

(SQL View)

Forecast Views by user

Used for Security by the external programs when selecting view. It is designed to resemble the DP_VIEW1USER_VW record with some modifications.

SELECT A.DP_CONFIGVIEW , B.DP_USERID , B.DP_USERNAME FROM PS_DP_CONFIGVIEWS A , PS_DP_USERVIEWS B WHERE A.DP_VIEWTYPE = '0' AND A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND B.DP_USERID = %OperatorId

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	DP_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW
2	DP_USERID	Character(30)	VARCHAR2(30) NOT NULL	DP_USERID
3	DP_USERNAME	Character(30)	VARCHAR2(30) NOT NULL	DP_USERNAME