GPES_CRT_VER_VW

(SQL View)
 Index Back

CRT Max Version SS Data

CRT Max Version SS Data for Creta reporting

SELECT EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , GPES_MONTH , GPES_YEAR , SSN_EMPLOYER , GPES_SSTC_PAYMNT , SLICE_BGN_DT , GPES_CRT_BRK_LQ , GPES_CRT_DATA_TYPE , GPES_CRT_CODE , GPES_CRT_CHAR_RSLT , GPES_CRT_NUM_RSLT , SLICE_END_DT , GPES_MONTH_RECALC , GPES_YEAR_RECALC , RSLT_VER_NUM , RSLT_REV_NUM , GPES_CRT_STATUS_EE , GPES_SSTC_CNTRL_DT , GPES_REUSE_PRV_BS , GPES_CRT_PRINT_OK FROM PS_GPES_CRT_LQ_EE D WHERE %Sql(GPES_CRT_MAX_VER_REV_NUM, PS_GP_PYE_PRC_STAT, D) AND GPES_CRT_PRINT_OK <> 'N'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
9 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
10 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
11 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
12 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
13 GPES_CRT_BRK_LQ Number(6,0) INTEGER NOT NULL Breaking Point
14 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
15 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.
16 GPES_CRT_CHAR_RSLT Character(2) VARCHAR2(2) NOT NULL Chart Result
17 GPES_CRT_NUM_RSLT Signed Number(10,2) DECIMAL(8,2) NOT NULL Numeric result
18 SLICE_END_DT Date(10) DATE Element Slice End Date
19 GPES_MONTH_RECALC Number(2,0) SMALLINT NOT NULL Retro month
20 GPES_YEAR_RECALC Number(4,0) SMALLINT NOT NULL Retro year
21 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
22 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
23 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
24 GPES_SSTC_CNTRL_DT Date(10) DATE Social Security TC�s control date
25 GPES_REUSE_PRV_BS Character(1) VARCHAR2(1) NOT NULL Reuse Previous Month Bases for Creta reporting
26 GPES_CRT_PRINT_OK Character(1) VARCHAR2(1) NOT NULL Check Box to select No Reported employees for Creta reporting

Y/N Table Edit