GPJP_RC_LA_PYE

(SQL Table)
 Index Back

Newly Enrolled Employees Repor

Newly Enrolled Employees Report

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
3 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number

Prompt Table: GPJP_TAXESLA_VW

4 GPJP_INSURED_DATE Date(10) DATE NOT NULL Date Insured

Default Value: %date

5 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
6 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
7 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
8 GPJP_START_DATE Date(10) DATE Appraisal Prd Start Date (14-1)

Default Value: %date

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

Default Value: %date

10 GPJP_CREATED_DT Date(10) DATE NOT NULL Date Created

Default Value: %date

11 FILE_HANDLE Character(2) VARCHAR2(2) NOT NULL File Handle

Prompt Table: GPJP_FILE_HANDL