PY_IN_W2C_BX_TB

(SQL Table)
 Index Back

Insights W2 Correction Record

Insights W2 correction record for Pre-processing

  • Related Language Record: PY_IN_W2C_BX_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company
    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 W2C_BATCH_NBR Number(4,0) SMALLINT NOT NULL W-2c Batch Number
    6 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
    7 BOX Character(4) VARCHAR2(4) NOT NULL Box
    8 PRV_SSN Character(9) VARCHAR2(9) NOT NULL or SSN

    Default Value: W2C_DATA.PRV_SSN

    9 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: W2C_STATE_NM_VW

    10 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: W2C_LOCAL_TX_VW

    11 W2C_TAXFORM_ID Character(1) VARCHAR2(1) NOT NULL Tax Form Identification
    I=W-2VI
    M=W-2GU
    P=W-2PR
    S=W-2AS
    W=W-2
    12 PREVIOUS_VALUE Character(250) VARCHAR2(250) NOT NULL Previous Value
    13 UPDATED_VALUE Character(250) VARCHAR2(250) NOT NULL New Value
    14 PY_COR_REASON Character(254) VARCHAR2(254) NOT NULL Correction Reason
    15 TAXFORM_ID_DESCR Character(30) VARCHAR2(30) NOT NULL Taxform ID Description
    16 PY_W2_CMP_DESCR Character(254) VARCHAR2(254) NOT NULL W-2 company description
    17 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    18 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
    19 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    20 PY_DEPT_DESCR Character(100) VARCHAR2(100) NOT NULL Department description
    21 PY_PAYGROUP_DESCR Character(100) VARCHAR2(100) NOT NULL Paygroup Description
    22 PY_BUS_DESCR Character(100) VARCHAR2(100) NOT NULL Business Unit description
    23 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.