PROCESS_INSTANCE0=Character
1=Long Character
2=Number
3=Signed Number
4=Date
ACC=Accumulate
AVG=Average Exclude Current
AVGA=Average Include Current
LAST=Replace with Last
WAVA=Weighted Average Include
WAVG=Weighted Average Exclude
DP_EISPCLNS_AET(SQL Table) |
Index Back |
|---|---|
External Import Specflds stateExternal Import Specflds state |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | DP_FIELDID | Character(24) | VARCHAR2(24) NOT NULL | DP_FIELDID |
| 3 | DP_RECORD_FIELDID | Character(50) | VARCHAR2(50) NOT NULL | DP_RECORD_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 |