| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EOEW_ETL_SEQNUM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Sequence
|
| 3 |
EOEW_ERR_MSG01 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 4 |
EOEW_ERR_MSG02 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 5 |
EOEW_ERR_MSG03 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 6 |
EOEW_ERR_MSG04 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 7 |
EOEW_ERR_MSG05 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 8 |
EOEW_ERR_MSG06 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 9 |
EOEW_ERR_MSG07 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 10 |
EOEW_ERR_MSG08 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 11 |
EOEW_ERR_MSG09 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 12 |
EOEW_ERR_MSG10 |
Character(11) |
VARCHAR2(11) NOT NULL |
For Error Table purposes. This field has the following format : Message_Set_Nbr , Message_Nbr. For instance if the message set number is 18024 and the message number is 1201, the content of this field will be "18024,1201".
|
| 13 |
EOEW_FP_CHAR3_0 |
Character(3) |
VARCHAR2(3) NOT NULL |
EOEW_FP_CHAR3_0
|
| 14 |
EOEW_FP_CHAR3_1 |
Character(3) |
VARCHAR2(3) NOT NULL |
EOEW_FP_CHAR3_1
|
| 15 |
EOEW_FP_CHAR18_0 |
Character(18) |
VARCHAR2(18) NOT NULL |
EOEW_FP_CHAR18_0
|
| 16 |
EOEW_FP_CHAR27_0 |
Character(27) |
VARCHAR2(27) NOT NULL |
EOEW_FP_CHAR27_0
|
| 17 |
EOEW_FP_CHAR30_0 |
Character(30) |
VARCHAR2(30) NOT NULL |
EOEW_FP_CHAR30_0
|
| 18 |
EOEW_FP_CHAR30_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
EOEW_FP_CHAR30_1
|
| 19 |
EOEW_FP_CHAR32_0 |
Character(32) |
VARCHAR2(32) NOT NULL |
EOEW_FP_CHAR32_0
|
| 20 |
EOEW_FP_CHAR32_1 |
Character(32) |
VARCHAR2(32) NOT NULL |
EOEW_FP_CHAR32_1
|
| 21 |
EOEW_FP_CHAR32_2 |
Character(32) |
VARCHAR2(32) NOT NULL |
EOEW_FP_CHAR32_2
|
| 22 |
EOEW_FP_CHAR32_3 |
Character(32) |
VARCHAR2(32) NOT NULL |
EOEW_FP_CHAR32_3
|
| 23 |
EOEW_FP_CHAR32_4 |
Character(32) |
VARCHAR2(32) NOT NULL |
EOEW_FP_CHAR32_4
|
| 24 |
EOEW_FP_CHAR32_5 |
Character(32) |
VARCHAR2(32) NOT NULL |
EOEW_FP_CHAR32_5
|
| 25 |
EOEW_FP_CHAR32_6 |
Character(32) |
VARCHAR2(32) NOT NULL |
EOEW_FP_CHAR32_6
|
| 26 |
EOEW_FP_CHAR50_0 |
Character(50) |
VARCHAR2(50) NOT NULL |
EOEW_FP_CHAR50_0
|
| 27 |
EOEW_FP_CHAR50_1 |
Character(50) |
VARCHAR2(50) NOT NULL |
EOEW_FP_CHAR50_1
|
| 28 |
EOEW_FP_CHAR50_2 |
Character(50) |
VARCHAR2(50) NOT NULL |
EOEW_FP_CHAR50_2
|
| 29 |
EOEW_FP_CHAR50_3 |
Character(50) |
VARCHAR2(50) NOT NULL |
EOEW_FP_CHAR50_3
|
| 30 |
EOEW_FP_CHAR50_4 |
Character(50) |
VARCHAR2(50) NOT NULL |
EOEW_FP_CHAR50_4
|
| 31 |
EOEW_FP_CHAR50_5 |
Character(50) |
VARCHAR2(50) NOT NULL |
EOEW_FP_CHAR50_5
|
| 32 |
EOEW_FP_CHAR64_0 |
Character(64) |
VARCHAR2(64) NOT NULL |
EOEW_FP_CHAR64_0
|
| 33 |
EOEW_FP_CHAR64_1 |
Character(64) |
VARCHAR2(64) NOT NULL |
EOEW_FP_CHAR64_1
|
| 34 |
EOEW_FP_CHAR64_2 |
Character(64) |
VARCHAR2(64) NOT NULL |
EOEW_FP_CHAR64_2
|
| 35 |
EOEW_FP_CHAR64_3 |
Character(64) |
VARCHAR2(64) NOT NULL |
EOEW_FP_CHAR64_3
|
| 36 |
EOEW_FP_CHAR64_4 |
Character(64) |
VARCHAR2(64) NOT NULL |
EOEW_FP_CHAR64_4
|
| 37 |
EOEW_FP_CHAR80_0 |
Character(80) |
VARCHAR2(80) NOT NULL |
EOEW_FP_CHAR80_0
|
| 38 |
EOEW_FP_CHAR254_0 |
Character(254) |
VARCHAR2(254) NOT NULL |
EOEW_FP_CHAR254_0
|
| 39 |
EOEW_FP_CHAR254_1 |
Character(254) |
VARCHAR2(254) NOT NULL |
EOEW_FP_CHAR254_1
|
| 40 |
EOEW_FP_N3_0 |
Number(3,0) |
SMALLINT NOT NULL |
EOEW_FP_N3_0
|
| 41 |
EOEW_FP_N11_0 |
Number(11,0) |
DECIMAL(11) NOT NULL |
EOEW_FP_N11_0
|
| 42 |
EOEW_FP_N12D4_0 |
Number(12,4) |
DECIMAL(11,4) NOT NULL |
EOEW_FP_N12D4_0
|
| 43 |
EOEW_FP_N15_0 |
Number(15,0) |
DECIMAL(15) NOT NULL |
EOEW_FP_N15_0
|
| 44 |
EOEW_FP_N16D5_0 |
Number(16,5) |
DECIMAL(15,5) NOT NULL |
EOEW_FP_N16D5_0
|
| 45 |
EOEW_FP_S17D8_0 |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
EOEW_FP_S17D8_0
|
| 46 |
EOEW_FP_DATE_0 |
Date(10) |
DATE |
EOEW_FP_DATE_0
|
| 47 |
EOEW_FP_DATE_1 |
Date(10) |
DATE |
EOEW_FP_DATE_1
|