GPES_CRT_RS_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 , SSN_EMPLOYER , GPES_YEAR , GPES_MONTH , GPES_SSTC_PAYMNT , GPES_CRT_DATA_TYPE , GPES_CRT_CODE , SLICE_BGN_DT , SLICE_END_DT , GPES_YEAR_RECALC , GPES_MONTH_RECALC , GPES_CRT_BRK_LQ , GPES_CRT_CHAR_RSLT , GPES_CRT_NUM_RSLT , GPES_SSTC_CT_EE , GPES_SSTC_CT_ER , RSLT_VER_NUM , RSLT_REV_NUM , GPES_CRT_STATUS_EE , GPES_CRT_STAT_RSN , GPES_SSTC_CNTRL_DT , GPES_REUSE_PRV_BS , GPES_CRT_DELETE , GPES_CRT_PRINT_OK , GPES_CRT_PRINT_FLG FROM PS_GPES_CRT_LQ_EE D WHERE %Sql(GPES_CRT_MAX_VER_REV_NUM, PS_GP_PYE_PRC_STAT, D)

# 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 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
9 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
10 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
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 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_CODE Character(3) VARCHAR2(3) NOT NULL Code for Creta reporting
14 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
15 SLICE_END_DT Date(10) DATE Element Slice End Date
16 GPES_YEAR_RECALC Number(4,0) SMALLINT NOT NULL Retro year
17 GPES_MONTH_RECALC Number(2,0) SMALLINT NOT NULL Retro month
18 GPES_CRT_BRK_LQ Number(9,0) DECIMAL(9) NOT NULL Breaking Point
19 GPES_CRT_CHAR_RSLT Character(2) VARCHAR2(2) NOT NULL Chart Result
20 GPES_CRT_NUM_RSLT Signed Number(10,2) DECIMAL(8,2) NOT NULL Numeric result
21 GPES_SSTC_CT_EE Signed Number(17,2) DECIMAL(15,2) NOT NULL Employee Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.
22 GPES_SSTC_CT_ER Signed Number(15,2) DECIMAL(13,2) NOT NULL Employer Social Security Contributions. This field is used to populate the GP Write Array, which is used to generate the FAN File.
23 RSLT_VER_NUM Number(4,0) SMALLINT NOT NULL Result Version Number
24 RSLT_REV_NUM Number(4,0) SMALLINT NOT NULL Result Revision Number
25 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
26 GPES_CRT_STAT_RSN Character(1) VARCHAR2(1) NOT NULL Check Box to select No Reported employees for Creta reporting
A=Data not Needed
N=Negative Bases
P=Reuse Previous Bases
27 GPES_SSTC_CNTRL_DT Date(10) DATE Social Security TCs control date
28 GPES_REUSE_PRV_BS Character(1) VARCHAR2(1) NOT NULL Reuse Previous Month Bases for Creta reporting
29 GPES_CRT_DELETE Character(1) VARCHAR2(1) NOT NULL Data for Creta reporting

Y/N Table Edit

Default Value: N

30 GPES_CRT_PRINT_OK Character(1) VARCHAR2(1) NOT NULL Check Box to select No Reported employees for Creta reporting

Y/N Table Edit

31 GPES_CRT_PRINT_FLG Character(1) VARCHAR2(1) NOT NULL Flag to check the employees to be Always Reported or Never Reported.
C=Conditional
N=Never Report
Y=Always Report

Default Value: C