W2_DATA_PR

(SQL Table)
 Index Back

W-2PR Data

This record contains detail data about an employee's W-2PR.

  • Parent record: W2_EE_PR

    • # 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 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
    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
    5 SEQUENCE_NUMBER Number(2,0) SMALLINT NOT NULL Sequence Number
    6 SSN Character(9) VARCHAR2(9) NOT NULL Social Security #
    7 W2_NAME Character(30) VARCHAR2(30) NOT NULL W-2 Name
    8 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
    9 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
    10 CITY Character(30) VARCHAR2(30) NOT NULL City
    11 STATE Character(6) VARCHAR2(6) NOT NULL State
    12 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    13 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    14 STATUTORY_EE Character(1) VARCHAR2(1) NOT NULL Statutory Employee

    Y/N Table Edit

    Default Value: N

    15 DECEASED Character(1) VARCHAR2(1) NOT NULL Deceased

    Y/N Table Edit

    Default Value: N

    16 W2_STATE Character(2) VARCHAR2(2) NOT NULL W-2 State
    17 EMPLOYER_ID_SWT Character(20) VARCHAR2(20) NOT NULL Employer ID (SWT).
    18 CONTROL_NUMBER Character(12) VARCHAR2(12) NOT NULL Control Number
    19 MAR_STATUS Character(1) VARCHAR2(1) NOT NULL Marital Status
    C=Common-Law
    D=Divorced
    E=Separated
    H=Head of Household
    L=DissDeclLost Civil Partner
    M=Married
    P=Civil Partnership
    S=Single
    T=Surviving Civil Partner
    U=Unknown
    V=Dissolved Civil Partnership
    W=Widowed
    20 SPOUSE_SSN Character(9) VARCHAR2(9) NOT NULL Spouse SSN
    21 MEDICARE_ONLY Character(1) VARCHAR2(1) NOT NULL Medicare Only

    Y/N Table Edit

    Default Value: N