DP_CALCLP_AET

(SQL Table)
Index Back

DP_CALCLP_AET

DP_CALCLP_AET

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
3 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section
4 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
5 DP_LIFEPROFILE Character(10) VARCHAR2(10) NOT NULL DP_LIFEPROFILE
6 DP_CONFIGLEVEL Number(2,0) SMALLINT NOT NULL DP_CONFIGLEVEL
7 DP_FCSTARTYEAR Number(4,0) SMALLINT NOT NULL DP_FCSTARTYEAR
8 DP_FCSTARTPERIOD Number(3,0) SMALLINT NOT NULL DP_FCSTARTPERIOD
9 DP_PDSPERYEAR Number(2,0) SMALLINT NOT NULL DP_PDSPERYEAR

Default Value: 0

10 DP_CONFIGHISTPDS Number(3,0) SMALLINT NOT NULL DP_CONFIGHISTPDS

Default Value: 36

11 DP_CONFIGFUTUREPDS Number(3,0) SMALLINT NOT NULL DP_CONFIGFUTUREPDS

Default Value: 24

12 DP_ADJ_REASON Character(8) VARCHAR2(8) NOT NULL DP_ADJ_REASON

Prompt Table: DP_ADJ_REASONS

13 DP_ADJ_COMMENT Character(50) VARCHAR2(50) NOT NULL DP_ADJ_COMMENT