| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
GPJP_CHAR5 |
Character(5) |
VARCHAR2(5) NOT NULL |
Character Field of Length 5.
|
| 4 |
GPJP_CHAR1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Character Filed Length of 1
|
| 5 |
GPJP_CHAR4_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Character Field of Length 4.
|
| 6 |
GPJP_CHAR6_1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Character Field of Length 6.
|
| 7 |
GPJP_CHAR1_1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Character field Length of 1
|
| 8 |
GPJP_OBJYEAR_ERA |
Character(2) |
VARCHAR2(2) NOT NULL |
Object Year in Era
|
| 9 |
GPJP_CHRDT_YY1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Year in Era
|
| 10 |
GPJP_CHRDT_MM1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
|
| 11 |
GPJP_CHRDT_DD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Date
|
| 12 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Alternate Character Name
|
| 13 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 14 |
GPJP_FOREIGNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreigner
|
| 15 |
GPJP_CHAR40_1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Character used in enrollment file
|
| 16 |
GPJP_LI_ERA2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Object Year in Era
|
| 17 |
GPJP_CHRDT_YY4 |
Character(2) |
VARCHAR2(2) NOT NULL |
Year in Era
|
| 18 |
GPJP_CHRDT_MM4 |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
|
| 19 |
GPJP_CHRDT_DD4 |
Character(2) |
VARCHAR2(2) NOT NULL |
Date
|
| 20 |
GPJP_CHAR4_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Character Field Of Length 4
|
| 21 |
GPJP_CHAR6 |
Character(6) |
VARCHAR2(6) NOT NULL |
Character Field of Length 6.
|
| 22 |
GPJP_CHAR1_2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Character Filed Length of 1
|
| 23 |
GPJP_CHAR4_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Character Field of Length 4.
|
| 24 |
GPJP_CHAR6_2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Character Field of Length 6.
|
| 25 |
GPJP_CHRDT_ERA1 |
Character(1) |
VARCHAR2(1) NOT NULL |
Imperial Era
|
| 26 |
GPJP_LI_ERA3 |
Character(2) |
VARCHAR2(2) NOT NULL |
Object Year in Era
|
| 27 |
GPJP_CHRDT_YY5 |
Character(2) |
VARCHAR2(2) NOT NULL |
Year in Era
|
| 28 |
GPJP_CHRDT_MM5 |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
|
| 29 |
GPJP_CHRDT_DD5 |
Character(2) |
VARCHAR2(2) NOT NULL |
Date
|
| 30 |
GPJP_FLADDR1 |
Character(152) |
VARCHAR2(152) NOT NULL |
Concatenated Address
|
| 31 |
GPJP_NOTE |
Long Character |
CLOB |
Notes
|
| 32 |
GPJP_RECEIVER |
Character(12) |
VARCHAR2(12) NOT NULL |
Name of Public Employment Agency
|
| 33 |
GPJP_CHK_BOX1 |
Character(1) |
VARCHAR2(1) NOT NULL |
GPJP check box
|
| 34 |
GPJP_CHK_BOX2 |
Character(1) |
VARCHAR2(1) NOT NULL |
GPJP check box
|
| 35 |
GPJP_CHK_BOX3 |
Character(1) |
VARCHAR2(1) NOT NULL |
GPJP check box
|
| 36 |
GPJP_CHK_BOX4 |
Character(1) |
VARCHAR2(1) NOT NULL |
GPJP check box
|
| 37 |
GPJP_CHK_BOX5 |
Character(1) |
VARCHAR2(1) NOT NULL |
GPJP check box
|
| 38 |
GPJP_KANA_NM |
Character(25) |
VARCHAR2(25) NOT NULL |
Kana Name Before Change
|
| 39 |
GPJP_KANJI_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Kanji Name Before Change
|
| 40 |
GPJP_CHAR2_1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Character Field Length of 2
|
| 41 |
GPJP_CHRDT_YY2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Year in Era
|
| 42 |
GPJP_CHRDT_MM2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Month
|
| 43 |
GPJP_CHRDT_DD2 |
Character(2) |
VARCHAR2(2) NOT NULL |
Date
|
| 44 |
GPJP_LI_FREE_FORM |
Character(20) |
VARCHAR2(20) NOT NULL |
Free Form for Requesters
|