GPJP_LA_PYE_RPT (SQL Table)	Index Back
LA Payee Report LA Payee Report

GPJP_LA_PYE_RPT

(SQL Table)

LA Payee Report

# 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 Rcd Nbr

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
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_LA_WAGE_PMTH Character(1) VARCHAR2(1) NOT NULL Wage Payment Method
1=Monthly Pay
2=Weekly
3=Daily
4=Hourly
5=Others

8 GPJP_LA_MTH_WAGE Number(19,6) DECIMAL(18,6) NOT NULL Estimated Monthly Wage

9 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

10 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

11 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

12 GPJP_START_DATE Date(10) DATE Appraisal Prd Start Date (14-1)

13 GPJP_END_DATE Date(10) DATE Appraisal Prd End Date (14-2)

14 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)

15 GPJP_NOTE Long Character CLOB Notes

#	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 Rcd Nbr
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 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_LA_WAGE_PMTH	Character(1)	VARCHAR2(1) NOT NULL	Wage Payment Method 1=Monthly Pay 2=Weekly 3=Daily 4=Hourly 5=Others
8	GPJP_LA_MTH_WAGE	Number(19,6)	DECIMAL(18,6) NOT NULL	Estimated Monthly Wage
9	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
10	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
11	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
12	GPJP_START_DATE	Date(10)	DATE	Appraisal Prd Start Date (14-1)
13	GPJP_END_DATE	Date(10)	DATE	Appraisal Prd End Date (14-2)
14	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)
15	GPJP_NOTE	Long Character	CLOB	Notes