| # |
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
|
| 3 |
DP_FIELDID |
Character(24) |
VARCHAR2(24) NOT NULL |
DP_FIELDID
|
| 4 |
DP_CAPTION |
Character(30) |
VARCHAR2(30) NOT NULL |
DP_CAPTION
|
| 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_KEYFIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_KEYFIELD
|
| 7 |
DP_AVAILON_CALCODE |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_CALCODE
Y/N Table Edit
|
| 8 |
DP_AVAILON_MAMAINT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_MAMAINT
Y/N Table Edit
|
| 9 |
DP_AVAILON_POLSETS |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_POLSETS
Y/N Table Edit
|
| 10 |
DP_AVAILON_FCITCAP |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_FCITCAP
Y/N Table Edit
|
| 11 |
DP_AVAILON_FCINQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_FCINQ
Y/N Table Edit
|
| 12 |
DP_AVAILON_FCREF |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_FCREF
|
| 13 |
DP_AVAILON_ERRSEL |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_ERRSEL
Y/N Table Edit
|
| 14 |
DP_AVAILON_ARTOUSE |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_ARTOUSE
Y/N Table Edit
|
| 15 |
DP_AVAILON_ADJHIST |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_ADJHIST
Y/N Table Edit
|
| 16 |
DP_AVAILON_SUMM |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_SUMM
Y/N Table Edit
Default Value: N
|
| 17 |
DP_AVAILON_EVINQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_EVINQ
Y/N Table Edit
|
| 18 |
DP_AVAILON_FCINQCH |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_FCINQCH
Y/N Table Edit
|
| 19 |
DP_AVAILON_ADJCHRT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_ADJCHRT
Y/N Table Edit
|
| 20 |
DP_AVAILON_EIFCI |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_EIFCI
|
| 21 |
DP_AVAILON_FUNCAUD |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_FUNCAUD
|
| 22 |
DP_AVAILON_ROLESEC |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_ROLESEC
Y/N Table Edit
|
| 23 |
DP_AVAILON_EIUPD |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_EIUPD
|
| 24 |
DP_AVAILON_PUBFCST |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFCST
Y/N Table Edit
Default Value: N
|
| 25 |
DP_AVAILON_PUBFLTR |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFLTR
Y/N Table Edit
Default Value: N
|
| 26 |
DP_AVAILON_PUBARAY |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFLTR
Y/N Table Edit
Default Value: N
|
| 27 |
DP_AVAILON_WQPURGE |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_WQPURGE
Y/N Table Edit
Default Value: N
|
| 28 |
DP_AVAILON_BAMSPEC |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_BAMSPEC
Y/N Table Edit
Default Value: N
|
| 29 |
DP_AVAILON_INTDMD |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_INTDMD
Y/N Table Edit
Default Value: N
|
| 30 |
DP_AVAILON_INTADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_INTADJ
Y/N Table Edit
Default Value: N
|
| 31 |
DP_AVAILON_INTFCI |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_INTFCI
Y/N Table Edit
Default Value: N
|
| 32 |
DP_AVAILON_INTUP |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_INTUP
Y/N Table Edit
Default Value: N
|
| 33 |
DP_AVAILON_AHISSEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Adjustment History
Y/N Table Edit
Default Value: N
|
| 34 |
DP_AVAILON_BPPUB |
Character(1) |
VARCHAR2(1) NOT NULL |
Publish for Business Planning
Y/N Table Edit
Default Value: N
|
| 35 |
DP_AVAILON_PUBINQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_WQPURGE
Y/N Table Edit
Default Value: N
|
| 36 |
DP_AVAILON_DPIFACE |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_ARTOUSE
Default Value: N
|
| 37 |
DP_AVAILON_MMSELCT |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Y/N Table Edit
Default Value: N
|
| 38 |
DP_AVAILON_DYNREL |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_PUBFLTR
Y/N Table Edit
Default Value: N
|
| 39 |
DP_AVAILON_PRORATE |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_SUMM
Default Value: N
|
| 40 |
DP_AVAILON_IIMP |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N
|
| 41 |
DP_AVAILON_DHISINQ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N
|
| 42 |
DP_AVAILON_EIMPADJ |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N
|
| 43 |
DP_AVAILON_EIMPDMD |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N
|
| 44 |
DP_AVAILON_EIMPFCI |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N
|
| 45 |
DP_AVAILON_EIMPUPD |
Character(1) |
VARCHAR2(1) NOT NULL |
DP_AVAILON_CSUMG
Default Value: N
|