GPJP_LI_ENR_DTL(SQL Table) |
Index Back |
|---|---|
Newly Enroll Report DetailNewly Enroll Report Detail |
| # | 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_PERS_NBR1 | Character(13) | VARCHAR2(13) NOT NULL | This field stores the My Number of each employee and dependent. |
| 6 | GPJP_CHAR4_1 | Character(4) | VARCHAR2(4) NOT NULL | Character Field of Length 4. |
| 7 | GPJP_CHAR6_1 | Character(6) | VARCHAR2(6) NOT NULL | Character Field of Length 6. |
| 8 | GPJP_CHAR1_1 | Character(1) | VARCHAR2(1) NOT NULL | Character field Length of 1 |
| 9 | GPJP_QUAL_REASON | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Type
1=New 2=Re-enrollment |
| 10 | NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Alternate Character Name |
| 11 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 12 | GPJP_KANJI_NM | Character(18) | VARCHAR2(18) NOT NULL | Kanji Name Before Change |
| 13 | GPJP_KANA_NM | Character(25) | VARCHAR2(25) NOT NULL | Kana Name Before Change |
| 14 | SEX | Character(1) | VARCHAR2(1) NOT NULL |
Gender
F=Female M=Male U=Unknown |
| 15 | GPJP_OBJYEAR_ERA | Character(2) | VARCHAR2(2) NOT NULL | Object Year in Era |
| 16 | GPJP_CHRDT_YY1 | Character(2) | VARCHAR2(2) NOT NULL | Year in Era |
| 17 | GPJP_CHRDT_MM1 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 18 | GPJP_CHRDT_DD1 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 19 | GPJP_CHAR4_2 | Character(4) | VARCHAR2(4) NOT NULL | Character Field Of Length 4 |
| 20 | GPJP_CHAR6 | Character(6) | VARCHAR2(6) NOT NULL | Character Field of Length 6. |
| 21 | GPJP_CHAR1_2 | Character(1) | VARCHAR2(1) NOT NULL | Character Filed Length of 1 |
| 22 | GPJP_CHAR2_1 | Character(2) | VARCHAR2(2) NOT NULL | Character Field Length of 2 |
| 23 | GPJP_CHRDT_YY2 | Character(2) | VARCHAR2(2) NOT NULL | Year in Era |
| 24 | GPJP_CHRDT_MM2 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 25 | GPJP_CHRDT_DD2 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 26 | GPJP_LA_ENROLL_RSN | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Reason
1=New Hire (New Graduates) 2=New Hire (Others) 3=Change from Daily Laborer 4=Others 8=Return to Home Company |
| 27 | GPJP_LA_WAGE_PMTH | Character(1) | VARCHAR2(1) NOT NULL |
Wage Payment Method
1=Monthly Pay 2=Weekly 3=Daily 4=Hourly 5=Others |
| 28 | GPJP_CHAR4_3 | Character(4) | VARCHAR2(4) NOT NULL | Character Field of Length 4. |
| 29 | GPJP_LA_EMPL_TYP | Character(1) | VARCHAR2(1) NOT NULL |
Type of Employment
1=Daily Laborer 2=Part Time Laborer 3=Seasonal Employment 4=Others 5=Dispatched Laborer 6=Predefined Term of Contract 7=Sailor |
| 30 | GPJP_CALC_METHOD | Character(2) | VARCHAR2(2) NOT NULL |
Calculation Method.
10=Computerized Method 20=Table Lookup |
| 31 | GPJP_HIRING_PATHWY | Character(1) | VARCHAR2(1) NOT NULL |
Hiring Pathway
1=Introduction by Location 2=Getting Employed by Self 3=Introduction by Private 4=Uncomprehended |
| 32 | GPJP_CHRDT_ERA1 | Character(1) | VARCHAR2(1) NOT NULL | Imperial Era |
| 33 | GPJP_CHRDT_ERA2 | Character(1) | VARCHAR2(1) NOT NULL | Imperial Era |
| 34 | GPJP_CHAR2_2 | Character(2) | VARCHAR2(2) NOT NULL | Character Field Of Length 2. |
| 35 | GPJP_LI_ERA1 | Character(2) | VARCHAR2(2) NOT NULL | Object Year in Era |
| 36 | GPJP_CHRDT_ERA3 | Character(1) | VARCHAR2(1) NOT NULL | Imperial Era |
| 37 | GPJP_LI_ERA2 | Character(2) | VARCHAR2(2) NOT NULL | Object Year in Era |
| 38 | GPJP_CHRDT_YY4 | Character(2) | VARCHAR2(2) NOT NULL | Year in Era |
| 39 | GPJP_CHRDT_MM4 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 40 | GPJP_CHRDT_DD4 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 41 | GPJP_LI_ERA3 | Character(2) | VARCHAR2(2) NOT NULL | Object Year in Era |
| 42 | GPJP_CHRDT_YY5 | Character(2) | VARCHAR2(2) NOT NULL | Year in Era |
| 43 | GPJP_CHRDT_MM5 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 44 | GPJP_CHRDT_DD5 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 45 | GPJP_CHRDT_ERA4 | Character(1) | VARCHAR2(1) NOT NULL | Imperial Era |
| 46 | GPJP_CHAR40 | Character(40) | VARCHAR2(40) NOT NULL | Character used in enrollment file |
| 47 | GPJP_FOREIGNER | Character(1) | VARCHAR2(1) NOT NULL | Foreigner |
| 48 | GPJP_CHAR40_1 | Character(40) | VARCHAR2(40) NOT NULL | Character used in enrollment file |
| 49 | GPJP_CHAR20_1 | Character(20) | VARCHAR2(20) NOT NULL | Character Field of Length 6. |
| 50 | GPJP_NATIONALITY | Character(3) | VARCHAR2(3) NOT NULL | Nationality/Territory Code |
| 51 | GPJP_CHAR30_1 | Character(30) | VARCHAR2(30) NOT NULL | Character Field of Length 30. |
| 52 | GPJP_RSDNTL_STS | Character(2) | VARCHAR2(2) NOT NULL | Residential Status |
| 53 | GPJP_CHARDATE | Character(4) | VARCHAR2(4) NOT NULL | This field stores dates in a character format, specifically in the format of MMDD. |
| 54 | GPJP_CHRDT_MM3 | Character(2) | VARCHAR2(2) NOT NULL | Month |
| 55 | GPJP_CHRDT_DD3 | Character(2) | VARCHAR2(2) NOT NULL | Date |
| 56 | GPJP_NQ_ACT_PRMSN | Character(3) | VARCHAR2(3) NOT NULL | Non-Qualified Act Permission. |
| 57 | GPJP_DSPTCH_CNTRCT | Character(3) | VARCHAR2(3) NOT NULL | Dispatch/Contract worker |
| 58 | GPJP_NOTE | Long Character | CLOB | Notes |
| 59 | GPJP_RECEIVER | Character(12) | VARCHAR2(12) NOT NULL | Name of Public Employment Agency |
| 60 | GPJP_CHK_BOX1 | Character(1) | VARCHAR2(1) NOT NULL | GPJP check box |
| 61 | GPJP_CHK_BOX2 | Character(1) | VARCHAR2(1) NOT NULL | GPJP check box |
| 62 | GPJP_CHK_BOX3 | Character(1) | VARCHAR2(1) NOT NULL | GPJP check box |
| 63 | GPJP_CHK_BOX4 | Character(1) | VARCHAR2(1) NOT NULL | GPJP check box |
| 64 | GPJP_CHK_BOX5 | Character(1) | VARCHAR2(1) NOT NULL | GPJP check box |
| 65 | GPJP_RES_CARD_NO | Character(12) | VARCHAR2(12) NOT NULL | Unemployment Cert. |
| 66 | GPJP_LI_FREE_FORM | Character(20) | VARCHAR2(20) NOT NULL | Free Form for Requesters |