GPDE_AL06_SAL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
3	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	GPDE_AL_STAT_NBR	Character(9)	VARCHAR2(9) NOT NULL	DEUEV Activity Keys
6	EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Empl Record
7	GPDE_AL_NUM_OF_EMP	Number(6,0)	INTEGER NOT NULL	NUM OF EMPLOYEE
8	GPDE_AL_TOT_EMP	Number(10,0)	DECIMAL(10) NOT NULL	Total Number of employee
9	GRADE	Character(3)	VARCHAR2(3) NOT NULL	Salary Grade
10	SAL_ADMIN_PLAN	Character(4)	VARCHAR2(4) NOT NULL	Salary Administration Plan
11	PERFORM_GROUP_GER	Character(2)	VARCHAR2(2) NOT NULL	This field is used for German employees to track the Performance Group associated to the Job Labor agreement. A1=Blue Collar Performance Grp. 1 A2=Blue Collar Performance Grp. 2 A3=Blue Collar Performance Grp. 3 K1=Commercial White Collar Grp. 1 K2=Commercial White Collar Grp. 2 K3=Commercial White Collar Grp. 3 K4=Commercial White Collar Grp. 4 K5=Commerical White Collar Grp. 5 T1=Technical White Collar Grp. 1 T2=Technical White Collar Grp. 2 T3=Technical White Collar Grp. 3 T4=Technical White Collar Grp. 4 T5=Technical White Collar Grp. 5
12	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown
13	BIRTHDATE	Date(10)	DATE	Date of Birth
14	HIRE_DT	Date(10)	DATE	First Start Date
15	BA_CD	Character(5)	VARCHAR2(5) NOT NULL	BA Code
16	GPDE_SI_POS_IN_JOB	Character(1)	VARCHAR2(1) NOT NULL	Position 0=0 Apprentice 1=1 Blue Collar, non prof 2=2 Blue Collar Prof 3=3 BC Foreman 4=4 White Collar 5=5 Disabled 6=6 Rehabilitation 7=7 Homeworker;domestic business 8=8 Part Time < 18 Hrs. 9=9 Part Time >= 18 Hrs.
17	GPDE_SI_EDUCATION	Character(1)	VARCHAR2(1) NOT NULL	Education 0=0 unknown 1=1General Secondary w/o Prof 2=2 General Secondary with Prof 3=3 Gen Univ Entr no Prof Train 4=4 Gen Univ Entr w/Prof Train 5=5 Technical College Degree 6=6 University Degree 7=7 unknown degree
18	GPDE_DV_EMPL_CAT	Character(3)	VARCHAR2(3) NOT NULL	Employee Category 101=Regular SI Taxable 102=Apprentice 103=Old-Age Part Time 104=Consultant 105=Trainee 106=Student Trainee 107=Disabled 108=Early Retirement 109=Low Income Earner 110=Short-Term Employment 111=EE in Rehabilitation 112=Family member in agriculture 113=Part-time Farmer 114=PT Farmer, seasonal 116=FEI Compensation Receiver 118=Casual Worker 119=Old Age Pensioner 120=Pretended Freelancer 190=Insured only for Accident Ins 900=Public Servant 901=Managing Partner 903=Health Insured Pensioner 910=SI free Employee
19	GPDE_STD_HOURS_SUM	Number(19,6)	DECIMAL(18,6) NOT NULL	Sum of Std Hrs/Week
20	GPDE_RP_WRKDHRS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total of Worked Hours
21	GPDE_RP_OVRTMHRS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total of Overtime Hours
22	GPDE_RP_TOTGRSS	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total of Gross
23	GPDE_RP_TTGRSS_YTD	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Total of Gross
24	GPDE_RP_TXGRS_ANLZ	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
25	GPDE_SI_MNTH_GRS	Number(8,2)	DECIMAL(7,2) NOT NULL	Monthly Gross
26	GPDE_RP_RVDAYS_BON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
27	GPDE_RP_TXGRS_BON	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result
28	GPDE_RP_VACBAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Vacation Balance
29	GPDE_AL_OVERTPAY	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Over Time Pay Amount
30	GPDE_AL_SHIFT_PRE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Premiums for shift, weekend, holiday work or night shift
31	GPDE_AL_CPAY_ENDDT	Date(10)	DATE	Current Pay End Date
32	CALC_RSLT_VAL	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Calculation Numeric Result