PY_IN_YE_FMS_LN

(SQL Table)
 Index Back

Year End Forms Lang

Language table for Year End Forms table populated by Pre-processing application engine.Used in Insights visualization.

  • Related Language Record for PY_IN_YE_FMS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 PY_TAX_YEAR Number(4,0) SMALLINT NOT NULL Represents the year for personal income tax purposes.
    3 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company
    4 TAXFORM_ID Character(1) VARCHAR2(1) NOT NULL Tax Form Identification
    A=T4A Slip
    B=Business Payrolls Survey - CAN
    C=WCB Assessable Earnings
    E=Record of Employment
    F=940 - Annual Employer's FUTA
    I=W-2VI
    J=W-2cVI
    M=W-2GU
    N=W-2cGU
    P=W-2PR
    Q=W-2cPR
    R=RL-1 Slip
    S=W-2AS
    T=T4 Slip
    U=W-2cAS
    V=RL-2 Slip
    W=W-2
    X=W-2c
    Y=1099-R
    Z=1042-S
    5 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
    6 W2C_BATCH_NBR Number(4,0) SMALLINT NOT NULL W-2c Batch Number
    7 W2C_BATCH_YR Number(4,0) SMALLINT NOT NULL W-2c Batch Year
    8 PY_YE_FORM_SEQNUM Number(2,0) SMALLINT NOT NULL A sequential number to indicate the number of W2/W-2c that have been issued/generated for an employee. Initial copy will have a value of 1. Used in Self Service Year-End Forms.
    9 IRS_INCOME_CD_1042 Character(2) VARCHAR2(2) NOT NULL This field is to store the income code associated with the tax 1042 earnings. This income code is required on 1042S form.
    10 DISTRIB_CODE Character(2) VARCHAR2(2) NOT NULL Distribution Code
    11 COMPANY_1099R Character(3) VARCHAR2(3) NOT NULL 1099R Company
    12 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    13 PY_W2_CMP_DESCR Character(254) VARCHAR2(254) NOT NULL W-2 company description