RC_TAX1042

(SQL Table)
 Index Back

Tax 1042 Processing Rpt Parms

Process Scheduler report parameter record utilized by a number of payroll and tax SQRs.

  • Parent Record Of RC_PROC_1042_EE RC_TAX1042_EMPL RC_TAX960TI_EE

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Default Value: PRCSRUNCNTL.OPRID

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

    Default Value: PRCSRUNCNTL.RUN_CNTL_ID

    3 RUN_ID Character(10) VARCHAR2(10) NOT NULL Pay Run ID

    Prompt Table: PAY_RUN_TBL

    4 TAX_YEAR Signed Number(5,0) DECIMAL(4) NOT NULL Tax Year
    5 FROMDATE Date(10) DATE From Date
    6 THRUDATE Date(10) DATE End Date
    7 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    8 TRANSMITTER Character(3) VARCHAR2(3) NOT NULL Transmitter

    Prompt Table: COMPANY_TBL

    9 TRANSMIT_CNTRL_COD Character(5) VARCHAR2(5) NOT NULL Transmitter Control Code
    10 MEDIA_1042 Character(1) VARCHAR2(1) NOT NULL Media for 1042
    B=Both Paper and Electronic File
    E=Electronic File
    P=Paper
    11 DISKETTE_TYPE Character(1) VARCHAR2(1) NOT NULL Diskette Type
    0=Not Applicable
    1=3.5 Inches High Density
    2=3.5 Inches Double Density

    Default Value: 0

    12 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSON_NAME

    13 MODE_FOR_1042S Character(1) VARCHAR2(1) NOT NULL Mode for 1042-S Creation
    C=Correction
    N=Normal
    V=Void

    Default Value: N

    14 ALIGN_ONLY Character(1) VARCHAR2(1) NOT NULL Alignment Only

    Y/N Table Edit

    15 ALIGN_COUNT Number(3,0) SMALLINT NOT NULL Alignment Count
    16 HP_1042S_FORM_ID Character(1) VARCHAR2(1) NOT NULL 1042-S Form ID indicator.
    L=LSR01
    P=LSR03UP
    P=LSR03UP
    V=LPS3V
    V=LPS3V
    X=BI Publisher

    Default Value: L

    17 HP_1042_FINAL_RUN Character(1) VARCHAR2(1) NOT NULL Final Run indicator for 1042S Magnetic Media Process.
    F=Final Run
    I=Reissue 1042-S
    R=Recreate File
    T=Preliminary Run

    Y/N Table Edit

    Default Value: N

    18 HP_1042_TEST_RUN Character(1) VARCHAR2(1) NOT NULL Test Run indicator for 1042S Magnetic Media Process.

    Y/N Table Edit

    Default Value: N

    19 REG_SELECT_PROC Character(1) VARCHAR2(1) NOT NULL Regular or Select Empl Proc
    A=Select Tax Reporting Agencies
    C=Selected W-2 Companies
    E=Selected EMPLIDs
    F=All Payees
    G=Selected Payees
    H=Within Selected Hire Dates
    J=All Tax Agencies
    L=Select Jurisdictions
    M=Within Selected Companies
    P=Within Selected Paygroups
    R=All Employees
    S=Selected Employees
    T=Sel Elig Locals by State