GPUS_YEC_DAT

(SQL Table)
 Index Back

Year End Correction Data

Year End Correction Data

  • Related Language Record: GPUS_YEC_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    2 GPUS_CAL_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
    3 GPUS_TAX_EIN Character(9) VARCHAR2(9) NOT NULL Federal Employer Identification Number

    Prompt Table: GPUS_DEF_EIN_VW

    4 GPUS_TAXFORM_ID Character(3) VARCHAR2(3) NOT NULL Tax Form ID
    10=W-2
    110=W-2c
    120=W-2cAS
    130=W-2cGU
    140=W-2cPR
    150=W-2cVI
    20=W-2AS
    30=W-2GU
    40=W-2PR
    50=W-2VI
    5 GPUS_YEC_BATCH_NBR Number(4,0) SMALLINT NOT NULL Batch Number
    6 GPUS_YEC_STATUS Character(2) VARCHAR2(2) NOT NULL Year-End Correction statement Statuses
    10=Open
    20=Closed
    30=Void

    Default Value: 10

    7 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    8 GPUS_PSSN Character(9) VARCHAR2(9) NOT NULL Previous SSN
    9 GPUS_YE_FNAME Character(15) VARCHAR2(15) NOT NULL First Name
    10 GPUS_YE_PFNAME Character(15) VARCHAR2(15) NOT NULL First Name
    11 GPUS_YE_LNAME Character(20) VARCHAR2(20) NOT NULL Last Name
    12 GPUS_YE_PLNAME Character(20) VARCHAR2(20) NOT NULL Last Name
    13 GPUS_YE_MNAME Character(15) VARCHAR2(15) NOT NULL Middle Name
    14 GPUS_YE_PMNAME Character(15) VARCHAR2(15) NOT NULL Middle Name
    15 GPUS_YE_SUFFIX Character(4) VARCHAR2(4) NOT NULL Suffix
    16 GPUS_YE_PSUFFIX Character(4) VARCHAR2(4) NOT NULL Suffix
    17 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: SCC_CNT_ADFMTVW

    18 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    19 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    20 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    21 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    22 CITY Character(30) VARCHAR2(30) NOT NULL City
    23 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    24 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    25 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    26 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    27 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    28 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    29 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    30 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    31 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    32 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    33 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    34 GPUS_PADDRESS1 Character(55) VARCHAR2(55) NOT NULL Previous Address 1
    35 GPUS_PADDRESS2 Character(55) VARCHAR2(55) NOT NULL Previous Address 2
    36 GPUS_PADDRESS3 Character(55) VARCHAR2(55) NOT NULL Previous Address 3
    37 GPUS_PCITY Character(30) VARCHAR2(30) NOT NULL Previous City
    38 GPUS_PSTATE Character(6) VARCHAR2(6) NOT NULL Previous State
    39 GPUS_PCOUNTRY Character(3) VARCHAR2(3) NOT NULL Previous Country
    40 GPUS_PPOSTAL Character(12) VARCHAR2(12) NOT NULL Previous Postal Code
    41 GPUS_STATUTORYFLAG Character(1) VARCHAR2(1) NOT NULL Statutory Employee

    Y/N Table Edit

    42 GPUS_PRV_STATUT_EE Character(1) VARCHAR2(1) NOT NULL Statutory Employee

    Y/N Table Edit

    43 GPUS_PENSION_FLAG Character(1) VARCHAR2(1) NOT NULL Pension Flag

    Y/N Table Edit

    44 GPUS_PREV_PENSION Character(1) VARCHAR2(1) NOT NULL Pension Flag

    Y/N Table Edit

    45 GPUS_3SICKPAY_FLAG Character(1) VARCHAR2(1) NOT NULL Third Party Sick Pay Flag

    Y/N Table Edit

    46 GPUS_PREV_SICKPAY Character(1) VARCHAR2(1) NOT NULL Third Party Sick Pay Flag

    Y/N Table Edit

    47 GPUS_CONTROL_NBR Character(12) VARCHAR2(12) NOT NULL Control Number
    48 GPUS_PCONTROL_NBR Character(12) VARCHAR2(12) NOT NULL Previous Control Number
    49 MMREF_WRITTEN Character(1) VARCHAR2(1) NOT NULL MMREF record written

    Y/N Table Edit

    Default Value: N

    50 DESCRLONG Long Character CLOB Long Description