DPA_LPINSTANCES

(SQL Table)
Index Back

DP Archive Record

Online: DP_LPINSTANCES

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
2 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
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_LIFESTARTYR Number(4,0) SMALLINT NOT NULL DP_LIFESTARTYR
7 DP_LIFESTARTPD Number(2,0) SMALLINT NOT NULL DP_LIFESTARTPD
8 DP_CONTTOWEIGHTS Character(1) VARCHAR2(1) NOT NULL DP_CONTTOWEIGHTS

Y/N Table Edit

Default Value: N

9 DP_EXPLIFEVOLUME Number(13,2) DECIMAL(12,2) NOT NULL DP_EXPLIFEVOLUME
10 DP_ORIGEXPLIFEVOL Number(13,2) DECIMAL(12,2) NOT NULL DP_ORIGEXPLIFEVOL
11 DP_LIFESTARTED Character(1) VARCHAR2(1) NOT NULL DP_LIFESTARTED

Y/N Table Edit

12 DP_LIFEBUILT Character(1) VARCHAR2(1) NOT NULL DP_LIFEBUILT

Y/N Table Edit

Default Value: N

13 DP_LIFEVOLREVPDS Number(2,0) SMALLINT NOT NULL DP_LIFEVOLREVPDS