DP_USRLPINST_VW

(SQL View)
Index Back

DP_USRLPINST_VW

DP_USRLPINST_VW

SELECT DISTINCT(A.OPRID) , B.DP_CONFIGVIEW , B.DP_CONFIGLEVEL , B.DP_LIFEPROFILE , B.DP_FORECASTITEM , A.DP_FCITEMCAPTION , A.DP_LIFEPROFILEITEM FROM PS_DP_ROLEFCITM_VW A , PS_DP_LPINSTANCES B WHERE A.DP_CONFIGVIEW = B.DP_CONFIGVIEW AND A.DP_CONFIGLEVEL = B.DP_CONFIGLEVEL AND A.DP_TEMPLATEITEM <> 'Y' AND A.DP_LIFEPROFILEITEM = '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_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW

Prompt Table: %EDITTABLE

3 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
4 DP_LIFEPROFILE Character(10) VARCHAR2(10) NOT NULL DP_LIFEPROFILE
5 DP_FORECASTITEM Character(120) VARCHAR2(120) NOT NULL DP_FORECASTITEM

Prompt Table: DP_FCITMLP_VW

6 DP_FCITEMCAPTION Character(40) VARCHAR2(40) NOT NULL DP_FCITEMCAPTION
7 DP_LIFEPROFILEITEM Character(1) VARCHAR2(1) NOT NULL DP_LIFEPROFILEITEM

Y/N Table Edit