GPJP_LA03_AET

(SQL Table)
 Index Back

State Record for AE

State Record for AE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 JOBINSTANCE Number(10,0) DECIMAL(10) NOT NULL Job Instance
5 GPJP_TAX_ESTAB Character(15) VARCHAR2(15) NOT NULL Salary Payer Reference Number
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 GPJP_LA_ESTAB_NO Character(13) VARCHAR2(13) NOT NULL Unemployment Cert.
8 GPJP_INSURED_DATE Date(10) DATE Date Insured
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 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
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 , 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
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_CREATED_DT Date(10) DATE Date Created
15 GPJP_REC_CNT Number(8,0) INTEGER NOT NULL Record Count
16 GPJP_ERR_CNT Number(8,0) INTEGER NOT NULL Error Count
17 ERROR_TYPE Character(3) VARCHAR2(3) NOT NULL Error Type
ERR=Stop
NON=None
WAR=Warning
18 FILE_NAME Character(80) VARCHAR2(80) NOT NULL File Name
19 GPJP_FILE_NAME Character(30) VARCHAR2(30) NOT NULL File Name
20 CHARSET Character(40) VARCHAR2(40) NOT NULL Character Set
21 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
22 YEAR_DESCR_JPN Character(10) VARCHAR2(10) NOT NULL Stores descriptions used on the AE program GPJP_YEALOAD.
23 MONTH_DESCR_JPN Character(10) VARCHAR2(10) NOT NULL Stores descriptions used on the AE program GPJP_YEALOAD.
24 DAY_DESCR_JPN Character(10) VARCHAR2(10) NOT NULL Stores descriptions used on the AE program GPJP_YEALOAD.
25 STRING_TEXT Character(100) VARCHAR2(100) NOT NULL String Text