DP_LIFEPROF_VW

(SQL View)
Index Back

DP_LIFEPROF_VW

DP_LIFEPROF_VW

SELECT DP_CONFIGVIEW ,DP_LIFEPROFILE , DP_CONFIGLEVEL , DP_CAPTION , DP_LIFEDURATION FROM PS_DP_LIFEPROFILES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
2 DP_LIFEPROFILE Character(10) VARCHAR2(10) NOT NULL DP_LIFEPROFILE

Prompt Table: DP_LIFEPROFILES

3 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
4 DP_CAPTION Character(30) VARCHAR2(30) NOT NULL DP_CAPTION
5 DP_LIFEDURATION Number(3,0) SMALLINT NOT NULL DP_LIFEDURATION