DP_EISPECU_LNS (SQL Table)	Index Back
External Import Specs Details External Import Specs Details

DP_EISPECU_LNS

(SQL Table)

External Import Specs Details

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 DP_IMPORTSPEC Character(20) VARCHAR2(20) NOT NULL Specification used for running imports

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

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

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

5 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	DP_IMPORTSPEC	Character(20)	VARCHAR2(20) NOT NULL	Specification used for running imports
2	DP_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW
3	DP_FIELDID	Character(24)	VARCHAR2(24) NOT NULL	DP_FIELDID
4	DP_DATATYPE	Character(1)	VARCHAR2(1) NOT NULL	DP_DATATYPE 0=Character 1=Long Character 2=Number 3=Signed Number 4=Date
5	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