| # |
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
Prompt Table:
DP_VIEW1USER_VW
|
| 3 |
DP_CALCCODE |
Character(20) |
VARCHAR2(20) NOT NULL |
DP_CALCCODE
Prompt Table:
DP_CALCCODES_VW
|
| 4 |
DP_SEQNUMBER |
Number(10,0) |
DECIMAL(10) NOT NULL |
MT - increased size to 10 digits to be consistent with DP_SEQNUMBER_PREV field.
|
| 5 |
DP_CALCOPERATOR |
Character(2) |
VARCHAR2(2) NOT NULL |
DP_CALCOPERATOR
00=Absolute
01=Add Constant
02=Add Rows
03=Compare
04=Constant Fill
05=Days-Calendar
06=Divide by Constant
07=Divide Rows
08=Exponent
09=Include Calculation
10=If Then Else
11=Linear Trend
12=Log Values
13=Maximum Against Constant
14=Maximum Between Rows
15=Minimum Against Constant
16=Minimum Between Rows
17=Multiply and Add Rows
18=Multiply by Constant
19=Multiply Rows
20=Offset
21=Percent
22=Round
23=Round Down
24=Round Up
25=Subtract Constant
26=Subtract Rows
27=Truncate
28=Unit of Measure
|
| 6 |
DP_FIELDID |
Character(24) |
VARCHAR2(24) NOT NULL |
DP_FIELDID
Prompt Table:
DP_USARRCDS1_VW
|
| 7 |
DP_SOURCE1 |
Character(26) |
VARCHAR2(26) NOT NULL |
DP_SOURCE1
Prompt Table:
DP_VWFLDSEL2_VW
|
| 8 |
DP_SOURCE2 |
Character(26) |
VARCHAR2(26) NOT NULL |
DP_SOURCE2
Prompt Table:
DP_VWFLDSEL2_VW
|
| 9 |
DP_SOURCE3 |
Character(26) |
VARCHAR2(26) NOT NULL |
DP_SOURCE3
Prompt Table:
DP_VWFLDSEL2_VW
|
| 10 |
DP_OFFSET_FROMPD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_OFFSET_FROMPD
|
| 11 |
DP_OFFSET_TOPD |
Character(4) |
VARCHAR2(4) NOT NULL |
DP_OFFSET_TOPD
|
| 12 |
DP_FROMPERIOD |
Number(2,0) |
SMALLINT NOT NULL |
DP_FROMPERIOD
|
| 13 |
DP_FROMYEAR |
Number(4,0) |
SMALLINT NOT NULL |
DP_FROMYEAR
|
| 14 |
DP_TOPERIOD |
Number(2,0) |
SMALLINT NOT NULL |
DP_TOPERIOD
|
| 15 |
DP_TOYEAR |
Number(4,0) |
SMALLINT NOT NULL |
DP_TOYEAR
|