DPA_EISPECU_LNS (SQL Table)	Index Back
DP Archive Record Online Table: DP_EISPECU_LNS

DPA_EISPECU_LNS

(SQL Table)

DP Archive Record

Online Table: DP_EISPECU_LNS

# 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_IMPORTSPEC Character(20) VARCHAR2(20) NOT NULL Specification used for running imports

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

4 DP_FIELDID Character(24) VARCHAR2(24) NOT NULL DP_FIELDID

5 DP_DATATYPE Character(1) VARCHAR2(1) NOT NULL DP_DATATYPE
0=Character
1=Long Character
2=Number
3=Signed Number
4=Date

6 DP_UPDATEMETHOD Character(4) VARCHAR2(4) NOT NULL DP_UPDATEMETHOD
ACC=Accumulate
AVG=Average Exclude Current
AVGA=Average Include Current
LAST=Replace with Last
WAVA=Weighted Average Include
WAVG=Weighted Average Exclude

#	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_IMPORTSPEC	Character(20)	VARCHAR2(20) NOT NULL	Specification used for running imports
3	DP_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW
4	DP_FIELDID	Character(24)	VARCHAR2(24) NOT NULL	DP_FIELDID
5	DP_DATATYPE	Character(1)	VARCHAR2(1) NOT NULL	DP_DATATYPE 0=Character 1=Long Character 2=Number 3=Signed Number 4=Date
6	DP_UPDATEMETHOD	Character(4)	VARCHAR2(4) NOT NULL	DP_UPDATEMETHOD ACC=Accumulate AVG=Average Exclude Current AVGA=Average Include Current LAST=Replace with Last WAVA=Weighted Average Include WAVG=Weighted Average Exclude