W2_COMPANY_LANG

(SQL Table)
 Index Back

Related Lang for W2_COMPANY

This record contains the company information used to create a W-2.

  • Related Language Record for W2_COMPANY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
    3 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

    Default Value: COMPANY_TBL.TAX_REPORT_TYPE

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: COMPANY_TBL.DESCR