TAXFORM_ACC_DTL

(SQL Table)
Index Back

Taxform Accessibility Details

Taxform Accessibility Details

  • Related Language Record: PY_TF_ACCD_LNG
  • # 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
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    4 BOX Character(4) VARCHAR2(4) NOT NULL Box
    5 BOX_INDICATOR Character(1) VARCHAR2(1) NOT NULL Box Indicator for Taxform Accessibility Set-up
    A=Amendment
    C=Employee Correction
    D=Form Details
    E=Employee Details
    F=Federal
    L=Local
    R=Employer Details
    S=State
    6 STANDARD_VIEW Character(1) VARCHAR2(1) NOT NULL Standard View Box for Taxform Accessibility Set-up

    Y/N Table Edit

    7 TAXFORM_XML_ID Character(50) VARCHAR2(50) NOT NULL Taxform XML Id
    8 TAXFORM_PRE_XML_ID Character(50) VARCHAR2(50) NOT NULL Taxform XML Id
    9 PROCESS_INDICATOR Character(1) VARCHAR2(1) NOT NULL Processing Indicator for Taxform Accessibility Set-up
    C=Correction
    N=Normal
    O=Overflow
    T=Other
    10 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254