| # |
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 Rcd Nbr
|
| 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
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
X=Indeterminate/Intersex/Unspec
|
| 10 |
GPJP_DT_YYYYMMDD4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Holds the insured date as a ten bytes long character value
|
| 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
|
| 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 30 bytes long
|
| 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, srv yrs < 1
13=W/ renewal cond , 0.5 <=sy < 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, 0.5 <=sy <1
15=W/O renewal cond,srv yrs < 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
|