GPDE_AL06_SAL

(SQL Table)
Index Back

Temp Table with AL06 data

Temporary table for Application Engine GPDEAL06 containing summarized salary information for employees at a certain company/location.

# 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