| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 3 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
Default Value: 0
|
| 4 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 5 |
GPJP_LA_RPT_TYP |
Character(2) |
VARCHAR2(2) NOT NULL |
Report Type
10=Enrollment
20=Name Change
20=Name Change
30=Termination
60=Transfer
70=Status Change
70=Status Change
|
| 6 |
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
|
| 7 |
GPJP_HIRING_PLAN |
Character(1) |
VARCHAR2(1) NOT NULL |
Hiring Plan to Fill
Y/N Table Edit
|
| 8 |
GPJP_LOSSBY |
Character(1) |
VARCHAR2(1) NOT NULL |
Loss By
1=Other Reason than Termination
2=Termination not by employer
3=Termination by employer
|
| 9 |
GPJP_NAME_CHG |
Date(10) |
DATE |
Name Change Date
|
| 10 |
GPJP_UNEMP_CERT |
Character(1) |
VARCHAR2(1) NOT NULL |
Needs Umemployment Certificate
Y/N Table Edit
|
| 11 |
GPJP_LA_WAGE_PMTH |
Character(1) |
VARCHAR2(1) NOT NULL |
Wage Payment Method
1=Monthly Pay
2=Weekly
3=Daily
4=Hourly
5=Others
|
| 12 |
GPJP_LA_MTH_WAGE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Estimated Monthly Wage
|
| 13 |
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
|
| 14 |
GPJP_LA_JOB_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Job Type
1=Technical, Specialist Job
2=Executive Job
3=Office Job
4=Sales
5=Service
6=Security
7=Agriculture, forestry and fis
8=Transportation, communication
9=Production process, Labor
M=Construction/Mining Occupation
W=Carrying/Cleaning/WrappingOccp
|
| 15 |
GPJP_LA_TRM_CONTR |
Character(2) |
VARCHAR2(2) NOT NULL |
Predefined Term Of Contract
10=Contract term, and renewal con
10=Contract term, and renewal con
10=Contract term, and renewal con
11=Contract term, and no renewal
11=Contract term, and no renewal
11=Contract term, and no renewal
12=W/ renewal cond, srv yrs > = 1
12=W/ renewal cond, srv yrs > = 1
13=W/ renewal cond , 0.5 <=sy < 1
13=W/ renewal cond, srv yrs < 1
13=W/ renewal cond , 0.5 <=sy < 1
14=W/O renewal cond,srv yrs > = 1
14=W/O renewal cond,srv yrs > = 1
15=W/O renewal cond,srv yrs < 1
15=W/O renewal cond, 0.5 <=sy <1
15=W/O renewal cond, 0.5 <=sy <1
16=W/O renewal cond, srv yrs <0.5
16=W/O renewal cond, srv yrs <0.5
17=W/ renewal cond, srv yrs <0.5
17=W/ renewal cond, srv yrs <0.5
20=No cont term & = or >than 1yr
20=No cont term & = or >than 1yr
21=No cont term &=or
21=No cont term &=or
22=No contract term
|
| 16 |
GPJP_START_DATE |
Date(10) |
DATE |
Appraisal Prd Start Date (14-1)
|
| 17 |
GPJP_END_DATE |
Date(10) |
DATE |
Appraisal Prd End Date (14-2)
|
| 18 |
GPJP_LA_INS_TYP |
Character(1) |
VARCHAR2(1) NOT NULL |
Insurant Type
1=General
2=Short-term and Regular
3=Seasonal
4=Aged (Voluntary)
5=Return to Home Company
6=Short-time
7=Short-time (Aged)
|
| 19 |
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
|
| 20 |
GPJP_FOREIGNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreigner
Y/N Table Edit
|
| 21 |
GPJP_NAME_ROMAJI |
Character(40) |
VARCHAR2(40) NOT NULL |
Full Name in Romaji
|
| 22 |
GPJP_NATIONALITY |
Character(3) |
VARCHAR2(3) NOT NULL |
Nationality/Territory Code
Prompt Table:
GPJP_NATION_TBL
|
| 23 |
GPJP_RSDNTL_STS |
Character(2) |
VARCHAR2(2) NOT NULL |
Residential Status
|
| 24 |
GPJP_RSDNTL_PERIOD |
Date(10) |
DATE |
Residential Period
|
| 25 |
GPJP_NQ_ACT_PRMSN |
Character(3) |
VARCHAR2(3) NOT NULL |
Non-Qualified Act Permission.
Y/N Table Edit
|
| 26 |
GPJP_DSPTCH_CNTRCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Dispatch/Contract worker
Y/N Table Edit
|
| 27 |
GPJP_NOTE |
Long Character |
CLOB |
Notes
|
| 28 |
GPJP_DIFF_NAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Name is different from the name on Employment Insurance card
Y/N Table Edit
|
| 29 |
GPJP_KANA_NM |
Character(25) |
VARCHAR2(25) NOT NULL |
Kana Name Before Change
|
| 30 |
GPJP_KANJI_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Kanji Name Before Change
|
| 31 |
GPJP_QUAL_REASON |
Character(1) |
VARCHAR2(1) NOT NULL |
Enrollment Type
1=New
2=Re-enrollment
|
| 32 |
GPJP_RES_CARD_NO |
Character(12) |
VARCHAR2(12) NOT NULL |
Unemployment Cert.
|
| 33 |
GPJP_LI_FREE_FORM |
Character(20) |
VARCHAR2(20) NOT NULL |
Free Form for Requesters
|