TAXFORM_NOTES

(SQL Table)
 Index Back

Tax Form Footnotes Table

Footnotes associated with a Tax Form Box. BOX_NOTE_TEXT is the data that will print on the form. BOX_NOTE_COMMENT documents the footnote.

  • Related Language Record: TAXFORM_NT_LANG

  • Parent record: TAXFORM_TBL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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

    Prompt Table: TAXFORM_TBL

    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 BOX Character(4) VARCHAR2(4) NOT NULL Box

    Prompt Table: TAXFORM_BOX

    4 BOX_NOTE_SEQ Number(3,0) SMALLINT NOT NULL Footnote Priority
    5 BOX_NOTE_CD Character(3) VARCHAR2(3) NOT NULL Footnote Code (Display)
    6 BOX_NOTE_TEXT Character(40) VARCHAR2(40) NOT NULL Footnote Text
    7 BOX_NOTE_COMMENT Long Character CLOB Footnote Comments