RC_X_TAX

(SQL Table)
 Index Back

RC for Tax Dedn Extract

Run Control table used to store the run control parameters for the Tax Deduction Extract process.

  • Parent Record Of RC_PYAP_TXINI_L RC_PYAP_TXINI_S RC_X_TAX_LOCALS RC_X_TAX_STATES RC_X_TAX_TYPE_F

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 INCLUDE_FEDERAL_TX Character(1) VARCHAR2(1) NOT NULL Include Federal Taxes

    Y/N Table Edit

    Default Value: N

    4 INCLUDE_STATE_TX Character(1) VARCHAR2(1) NOT NULL Include State Taxes

    Y/N Table Edit

    Default Value: N

    5 INCLUDE_LOCAL_TX Character(1) VARCHAR2(1) NOT NULL Include Local Taxes

    Y/N Table Edit

    Default Value: N

    6 STATE_ALL Character(1) VARCHAR2(1) NOT NULL All States
    A=All States
    S=Specific States

    Default Value: A

    7 LOCALITY_ALL Character(1) VARCHAR2(1) NOT NULL All Localities
    A=All Localities
    S=Specific Localities

    Default Value: A

    8 PERIOD_END_DT Date(10) DATE NOT NULL Tax Period End Date
    9 PAYMENT_DT Date(10) DATE NOT NULL Payment Due Date
    10 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL