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_DATA_TYPE IN ('I','C')) OR (%Sql(GPES_CRT_LAST_CALC, PS_GP_PYE_PRC_STAT, D ) AND GPES_CRT_DATA_TYPE = 'H')) 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 Record
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/Surch. Base Incr.
L91=Retro w/Surch. New Slices
V03=Retro wo/ Surcharge Vacations
V90=Retro w/ Surcharge Vacations
12 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
13 GPES_CRT_BRK_LQ Number(9,0) DECIMAL(9) 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
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 CRET@ Employee reporting status
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 TCs 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