GPES_CRT_DAT_VW

(SQL View)
 Index Back

CRT EE Data per Slice VW

Employee Data per Slice View for Creta Reporting

SELECT A.SSN_EMPLOYER , A.GPES_SSTC_PAYMNT , A.GPES_YEAR , A.GPES_MONTH , A.GPES_CRT_BRK_LQ , A.GPES_MONTH_RECALC , A.GPES_YEAR_RECALC , A.EMPLID , A.EMPL_RCD , A.SLICE_BGN_DT , A.GPES_CRT_CODE , A.GPES_CRT_DATA_TYPE , CASE WHEN A.GPES_CRT_DATA_TYPE = 'I' THEN A.GPES_CRT_CHAR_RSLT WHEN A.GPES_CRT_DATA_TYPE = 'H' THEN %NumToChar(A.GPES_CRT_NUM_RSLT) ELSE %NumToChar(A.GPES_CRT_NUM_RSLT*100) END , A.GPES_CRT_STATUS_EE , A.SLICE_END_DT FROM PS_GPES_CRT_VER_VW A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
2 GPES_SSTC_PAYMNT Character(3) VARCHAR2(3) NOT NULL Payment Type. This field is used to populate the GP Write Array, which is used to generate the FAN File.
L00=Regular
L02=Litigation Salary
L03=Retroactivity wo/Surcharge
L04=Reductions Payback
L09=Retroactivity w/Surcharge
L13=Vacations
L90=Retro w/Surcharge Bases Increa
L91=Retro w/Surchage new Slices
3 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
4 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
5 GPES_CRT_BRK_LQ Number(6,0) INTEGER NOT NULL Breaking Point
6 GPES_MONTH_RECALC Number(2,0) SMALLINT NOT NULL Retro month
7 GPES_YEAR_RECALC Number(4,0) SMALLINT NOT NULL Retro year
8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
10 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
11 GPES_CRT_CODE Character(3) VARCHAR2(3) NOT NULL Code for Creta reporting
01=Part Time Contract Hours
02=Complementary Hours
03=Presential Training Hours
04=Distance Training Hours
05=Part Time Coefficient in ERE
500=General Contingencies Base
501=Structural Overtime
502=Non-structural Overtime
509=CC Base for Maternity/Risk
51=Salary Modality
52=Option 126 Epigraph
535=CC Base for Maternity/Risk
536=CC Base for Maternity/Risk
537=Complementary Hours
563=IT Illness & Accident
601=Professional Contingences Base
603=CP Base for Maternity/Risk
611=Professional Contingences Base
613=Professional Contingences Base
634=CP Base for Maternity/Risk
635=CP Base for Maternity/Risk
636=CP Base for Maternity/Risk
637=CP Base for Maternity/Risk
663=IT by IA and PI
763=Bonif. INEM Cont. Form.
12 GPES_CRT_DATA_TYPE Character(1) VARCHAR2(1) NOT NULL Type of Data for Creta reporting: C-concept, H-hours, I-Identifier
C=Amount
H=Hour
I=Indicator
13 GPES_CRT_DATA Character(11) VARCHAR2(11) NOT NULL Data for Creta reporting
14 GPES_CRT_STATUS_EE Character(1) VARCHAR2(1) NOT NULL Employee Status for Creta reporting
0=No Reported
1=Reported
E=With Errors
M=Manually Selected
V=Validated
X=Excluded
15 SLICE_END_DT Date(10) DATE Element Slice End Date