PA_HST_W2_AMTS

(SQL Table)
 Index Back

Historical Payroll Data

This is an employee table containing Historical Payroll Data. This is copied directly from the Payroll tables and retained within Pension. This record contains the amounts used on the W-2.

  • Parent record: W2_DATA

    • # 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
    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 W2_AMOUNT Signed Number(15,2) DECIMAL(13,2) NOT NULL W-2 Amount