GPES_CRT_LQ_TBL

(SQL Table)
 Index Back

CRT Liquidation Tbl

Liquidation Table for Creta Reporting

  • Parent Record Of GPES_CRT_SS_LQ GPES_CRT_SS_TRM

    • # 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_SSTC_CNTRL_DT Date(10) DATE Social Security TCs control date
    8 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
    9 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

    Default Value: 0

    10 GPES_TRAINING_REDN Number(18,2) DECIMAL(17,2) NOT NULL Continuos Training Reduction
    11 GPES_YEARFROM Character(4) VARCHAR2(4) NOT NULL Year From
    12 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
    13 GPES_YEARTO Character(4) VARCHAR2(4) NOT NULL Year To
    14 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    15 GPES_CRT_STAT_VAL Character(1) VARCHAR2(1) NOT NULL CRET@ Social Security calculation verification status.
    0=Matched
    1=Mismatch
    3=Not Verified

    Default Value: 3

    16 GPES_SENDING_ID Character(10) VARCHAR2(10) NOT NULL Sending ID
    17 GPES_LQ_NUMBER Character(17) VARCHAR2(17) NOT NULL Error Code