| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 JOBINSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Job Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 5 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 6 |
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
|
| 7 |
NAME_AC |
Character(50) |
VARCHAR2(50) NOT NULL |
Alternate Character Name
|
| 8 |
GPJP_CHAR3 |
Character(3) |
VARCHAR2(3) NOT NULL |
Character Field of Length 3.
Default Value: SEX
|
| 9 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
|
| 10 |
GPJP_DT_YYYYMMDD4 |
Character(10) |
VARCHAR2(10) NOT NULL |
10 Bytes Long Character Date
|
| 11 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 12 |
GPJP_LA_ESTAB_NO |
Character(13) |
VARCHAR2(13) NOT NULL |
Unemployment Cert.
|
| 13 |
GPJP_DT_YYYYMMDD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Holds The Birth Date in Japanese Era Format
|
| 14 |
GPJP_INSURED_DATE |
Date(10) |
DATE |
Date Insured
|
| 15 |
GPJP_CHAR4_1 |
Character(4) |
VARCHAR2(4) NOT NULL |
Character Field of Length 4.
|
| 16 |
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
|
| 17 |
GPJP_CHAR9 |
Character(9) |
VARCHAR2(9) NOT NULL |
Character Field of Length 9.
|
| 18 |
GPJP_LA_MTH_WAGE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Estimated Monthly Wage
|
| 19 |
GPJP_CHAR4_2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Character Field Of Length 4
|
| 20 |
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
|
| 21 |
GPJP_CHAR4_3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Character Field of Length 4.
|
| 22 |
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
|
| 23 |
GPJP_CHAR7 |
Character(7) |
VARCHAR2(7) NOT NULL |
Character Field of Length 7.
|
| 24 |
STD_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Standard Hours
|
| 25 |
GPJP_CHAR30 |
Character(30) |
VARCHAR2(30) NOT NULL |
Character Field of Length 30.
|
| 26 |
GPJP_CHAR15 |
Character(15) |
VARCHAR2(15) NOT NULL |
Character Field of length 15
|
| 27 |
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
|
| 28 |
GPJP_START_DATE |
Date(10) |
DATE |
Appraisal Prd Start Date (14-1)
|
| 29 |
GPJP_END_DATE |
Date(10) |
DATE |
Appraisal Prd End Date (14-2)
|
| 30 |
NAME |
Character(50) |
VARCHAR2(50) NOT NULL |
Name
|
| 31 |
GPJP_CHAR20_1 |
Character(20) |
VARCHAR2(20) NOT NULL |
Character Field of Length 6.
|
| 32 |
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
|
| 33 |
GPJP_CHAR30_1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Character Field of Length 30.
|
| 34 |
GPJP_NAME_ROMAJI |
Character(40) |
VARCHAR2(40) NOT NULL |
Full Name in Romaji
|
| 35 |
GPJP_CHAR50 |
Character(50) |
VARCHAR2(50) NOT NULL |
Character used in enrollment file
|
| 36 |
GPJP_NATIONALITY |
Character(3) |
VARCHAR2(3) NOT NULL |
Nationality/Territory Code
|
| 37 |
GPJP_CHAR40_2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Character used in enrollment file
|
| 38 |
GPJP_CHAR40 |
Character(40) |
VARCHAR2(40) NOT NULL |
Character used in enrollment file
|
| 39 |
GPJP_CHAR6_1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Character Field of Length 6.
|
| 40 |
GPJP_RSDNTL_STS |
Character(2) |
VARCHAR2(2) NOT NULL |
Residential Status
|
| 41 |
GPJP_CHAR40_3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Character used in enrollment file
|
| 42 |
GPJP_CHAR40_1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Character used in enrollment file
|
| 43 |
GPJP_CHAR6_2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Character Field of Length 6.
|
| 44 |
GPJP_RSDNTL_PERIOD |
Date(10) |
DATE |
Residential Period
|
| 45 |
GPJP_CHAR15_2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Character Field of Length 6.
|
| 46 |
GPJP_NQ_ACT_PRMSN |
Character(3) |
VARCHAR2(3) NOT NULL |
Non-Qualified Act Permission.
|
| 47 |
GPJP_CHAR6_3 |
Character(6) |
VARCHAR2(6) NOT NULL |
Character Field of Length 6.
|
| 48 |
GPJP_DSPTCH_CNTRCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Dispatch/Contract worker
|
| 49 |
GPJP_CHAR6_4 |
Character(6) |
VARCHAR2(6) NOT NULL |
Character Field of Length 6.
|
| 50 |
GPJP_FOREIGNER |
Character(1) |
VARCHAR2(1) NOT NULL |
Foreigner
|