GPDE_AL06_SM_VW

(SQL View)
Index Back

Temp Table with AL06 data

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

SELECT PROCESS_INSTANCE , SETID ,LOCATION ,SEX ,%Sql(FUNCLIB_HR_MATH_TO_NUMBER,%Substring(PERFORM_GROUP_GER,2,1)) , SUM(GPDE_AL_NUM_OF_EMP ) , SUM(GPDE_RP_A2_9290 ) , SUM(GPDE_STD_HOURS_SUM ) , SUM(GPDE_RP_WRKDHRS ) , SUM(GPDE_RP_OVRTMHRS ) , GPDE_RC_EE_TYPE_ST , HIRE_DT , USER_DATE1 , SUM(GPDE_RP_TXGRS_BON) , FTE , GPDE_DV_EMPL_CAT FROM PS_GPDE_AL06_SUM GROUP BY PROCESS_INSTANCE , SETID , LOCATION , SEX ,%Substring(PERFORM_GROUP_GER,2,1) , GPDE_RC_EE_TYPE_ST , GPDE_DV_EMPL_CAT , HIRE_DT , USER_DATE1 , GPDE_RP_TXGRS_BON , FTE

# 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 SEX Character(1) VARCHAR2(1) NOT NULL Gender
F=Female
M=Male
U=Unknown
5 GPDE_PERF_GRP_TYPE Number(1,0) SMALLINT NOT NULL Performance group type
6 GPDE_AL_NUM_OF_EMP Number(6,0) INTEGER NOT NULL NUM OF EMPLOYEE
7 GPDE_RP_A2_9290 Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Gross
8 GPDE_STD_HOURS_SUM Number(19,6) DECIMAL(18,6) NOT NULL Sum of Std Hrs/Week
9 GPDE_RP_WRKDHRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Worked Hours
10 GPDE_RP_OVRTMHRS Signed Number(20,6) DECIMAL(18,6) NOT NULL Total of Overtime Hours
11 GPDE_RC_EE_TYPE_ST Character(1) VARCHAR2(1) NOT NULL Employee Type
1=Both
2=Salaried
3=Wage Earners
12 HIRE_DT Date(10) DATE First Start Date
13 USER_DATE1 Date(10) DATE User Date Field 1
14 GPDE_RP_TXGRS_BON Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
15 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
16 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