GPES_CRT_LQT_VW (SQL View)	Index Back
Cret@ liquidation summary Cret@ liquidation totals by creta code

GPES_CRT_LQT_VW

(SQL View)

Cret@ liquidation summary

Cret@ liquidation totals by creta code

SELECT SSN_EMPLOYER , GPES_YEAR , GPES_MONTH , GPES_SSTC_PAYMNT , GPES_YEAR_RECALC , GPES_MONTH_RECALC , GPES_CRT_DATA_TYPE , GPES_CRT_CODE , SUM(GPES_SSTC_CT_EE) , SUM(GPES_SSTC_CT_ER) FROM PS_GPES_CRT_LQ_EE D WHERE %Sql(GPES_CRT_MAX_VER_REV_NUM, PS_GP_PYE_PRC_STAT, D) GROUP BY SSN_EMPLOYER, GPES_YEAR, GPES_MONTH, GPES_SSTC_PAYMNT, GPES_YEAR_RECALC, GPES_MONTH_RECALC, GPES_CRT_DATA_TYPE, GPES_CRT_CODE

# 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_YEAR Number(4,0) SMALLINT NOT NULL Year

3 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month

4 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

5 GPES_YEAR_RECALC Number(4,0) SMALLINT NOT NULL Retro year

6 GPES_MONTH_RECALC Number(2,0) SMALLINT NOT NULL Retro month

7 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

8 GPES_CRT_CODE Character(3) VARCHAR2(3) NOT NULL Code for Creta reporting

9 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.

10 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.

#	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_YEAR	Number(4,0)	SMALLINT NOT NULL	Year
3	GPES_MONTH	Number(2,0)	SMALLINT NOT NULL	Month
4	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
5	GPES_YEAR_RECALC	Number(4,0)	SMALLINT NOT NULL	Retro year
6	GPES_MONTH_RECALC	Number(2,0)	SMALLINT NOT NULL	Retro month
7	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
8	GPES_CRT_CODE	Character(3)	VARCHAR2(3) NOT NULL	Code for Creta reporting
9	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.
10	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.