GPUS_YEC_PR_LNG

(SQL Table)
Index Back

Year End Correction Data - PR

Year End Correction Data for Puerto Rico

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

    Prompt Table: PERSON

    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
    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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCRLONG Long Character CLOB Long Description