PY_IN_W2_AMC_LN

(SQL Table)
 Index Back

Insights W-2 Amounts Lan

Insights W-2 amounts related language record

  • Related Language Record for PY_IN_W2_AMT_CN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 PY_TAX_YEAR Number(4,0) SMALLINT NOT NULL Represents the year for personal income tax purposes.
    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 BOX Character(4) VARCHAR2(4) NOT NULL Box
    7 STATE Character(6) VARCHAR2(6) NOT NULL State
    8 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality
    9 WORK_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality
    10 RES_PSD_CD Character(6) VARCHAR2(6) NOT NULL Locality
    11 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    12 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company
    13 PY_W2_CMP_DESCR Character(254) VARCHAR2(254) NOT NULL W-2 company description
    14 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    15 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    16 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    17 PY_DEPT_DESCR Character(100) VARCHAR2(100) NOT NULL Department description
    18 PY_PAYGROUP_DESCR Character(100) VARCHAR2(100) NOT NULL Paygroup Description
    19 PY_COMPANY_DESCR Character(100) VARCHAR2(100) NOT NULL Company description
    20 PY_BUS_DESCR Character(100) VARCHAR2(100) NOT NULL Business Unit description
    21 TAXFORM_ID_DESCR Character(30) VARCHAR2(30) NOT NULL Taxform ID Description