GPUS_YEC_DAT_PR

(SQL Table)
 Index Back

Year End Correction Data - PR

Year End Correction Data for Puerto Rico

  • Related Language Record: GPUS_YEC_PR_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_SPOUSE_SSN Character(9) VARCHAR2(9) NOT NULL Spouse Social Security Number
    10 GPUS_PSPOUSE_SSN Character(9) VARCHAR2(9) NOT NULL Previous Spouse Social Security Number
    11 GPUS_MARITAL_STAT Character(2) VARCHAR2(2) NOT NULL Marital Status
    10=Single
    20=Married
    12 GPUS_PMARITAL_STAT Character(2) VARCHAR2(2) NOT NULL Previous Marital Status
    10=Single
    20=Married
    13 GPUS_SWT_EIN Character(20) VARCHAR2(20) NOT NULL Employer Identification Number (SWT)
    14 GPUS_PEIN_SWT Character(20) VARCHAR2(20) NOT NULL Previous State Withholding EIN
    15 GPUS_YE_FNAME Character(15) VARCHAR2(15) NOT NULL First Name
    16 GPUS_YE_PFNAME Character(15) VARCHAR2(15) NOT NULL First Name
    17 GPUS_YE_LNAME Character(20) VARCHAR2(20) NOT NULL Last Name
    18 GPUS_YE_PLNAME Character(20) VARCHAR2(20) NOT NULL Last Name
    19 GPUS_YE_MNAME Character(15) VARCHAR2(15) NOT NULL Middle Name
    20 GPUS_YE_PMNAME Character(15) VARCHAR2(15) NOT NULL Middle Name
    21 GPUS_YE_SUFFIX Character(4) VARCHAR2(4) NOT NULL Suffix
    22 GPUS_YE_PSUFFIX Character(4) VARCHAR2(4) NOT NULL Suffix
    23 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Prompt Table: COUNTRY_TBL

    24 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    25 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    26 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    27 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
    28 CITY Character(30) VARCHAR2(30) NOT NULL City
    29 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    30 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    31 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
    AB=House Boat Reference
    WW=House Trailer Reference
    32 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
    33 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
    34 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
    35 COUNTY Character(30) VARCHAR2(30) NOT NULL County
    36 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    37 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    38 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
    39 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

    Y/N Table Edit

    40 GPUS_PADDRESS1 Character(55) VARCHAR2(55) NOT NULL Previous Address 1
    41 GPUS_PADDRESS2 Character(55) VARCHAR2(55) NOT NULL Previous Address 2
    42 GPUS_PADDRESS3 Character(55) VARCHAR2(55) NOT NULL Previous Address 3
    43 GPUS_PCITY Character(30) VARCHAR2(30) NOT NULL Previous City
    44 GPUS_PSTATE Character(6) VARCHAR2(6) NOT NULL Previous State
    45 GPUS_PCOUNTRY Character(3) VARCHAR2(3) NOT NULL Previous Country
    46 GPUS_PPOSTAL Character(12) VARCHAR2(12) NOT NULL Previous Postal Code
    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 GPUS_E_CONFIRM_NBR Character(11) VARCHAR2(11) NOT NULL Electronic Filing Confirmation Number for GPUS W-2 and W-2c Puerto Rico forms For 2018, the length changed to 11 characters
    50 GPUS_NEW_EX_SAL_CD Character(3) VARCHAR2(3) NOT NULL Correct Exempt Salaries Code for the EFW2c-PR Report
    51 MMREF_WRITTEN Character(1) VARCHAR2(1) NOT NULL MMREF record written

    Y/N Table Edit

    Default Value: N

    52 DESCRLONG Long Character CLOB Long Description