GPES_CRT_LQ_TBL

(SQL Table)
 Index Back

CRT Liquidation Tbl

Liquidation Table for Creta Reporting

# 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/Surcharge Bases Increa
L91=Retro w/Surchage new Slices
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_STAT_LQ Character(1) VARCHAR2(1) NOT NULL Liquidation Status for Creta reporting
0=Not Started
1=In Progress
2=With Errors
3=Validated
4=Partially Confirmed
5=Confirmed
8 GPES_TRAINING_REDN Number(18,2) DECIMAL(17,2) NOT NULL Continuos Training Reduction
9 GPES_MONTHFROM Character(2) VARCHAR2(2) NOT NULL Month From
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
10 GPES_YEARFROM Character(4) VARCHAR2(4) NOT NULL Year From
11 GPES_MONTHTO Character(2) VARCHAR2(2) NOT NULL Month To
01=01 - January
02=02 - February
03=03 - March
04=04 - April
05=05 - May
06=06 - June
07=07 - July
08=08 - August
09=09 - September
10=10 - October
11=11 - November
12=12 - December
12 GPES_YEARTO Character(4) VARCHAR2(4) NOT NULL Year To
13 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL