DEPT_BUDGET_TAX

(SQL Table)
 Index Back

Department Budget Tax Dist

DEPT_BUDGET_TAX is the record which contains the Taxes Distributions to Accounts for each of the specified Department Budget Levels. Each Expense can be budgeted differently and sequence numbers can be used to specify priority in the accounts to be charged. For each budget level record there will always be at least one default Taxes distribution row.

  • Parent record: DEPT_BUDGET

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
    4 POSITION_POOL_ID Character(3) VARCHAR2(3) NOT NULL Position Pool ID
    5 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    6 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    7 POSITION_NBR Character(8) VARCHAR2(8) NOT NULL Position Number
    8 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    9 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    10 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    11 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence

    Default Value: 0

    12 STATE Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TAX_TBL

    13 LOCALITY Character(10) VARCHAR2(10) NOT NULL Locality

    Prompt Table: LOCAL_TAX_TBL

    14 TAX_CLASS Character(3) VARCHAR2(3) NOT NULL Tax Balance Class

    Prompt Table: PY_TAX_CLASS

    15 BUDGET_SEQ Number(2,0) SMALLINT NOT NULL Budget Sequence
    16 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: ACCT_CD_CA_VW

    17 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    18 BUDGET_AMT Number(19,3) DECIMAL(18,3) NOT NULL Budget Amount
    19 HP_EXCESS Character(1) VARCHAR2(1) NOT NULL Commitment Accounting allowed to exceed budget amount
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    20 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution
    21 FUNDING_END_DT Date(10) DATE Funding End Date
    22 HP_USED_DISTRIBUTN Character(1) VARCHAR2(1) NOT NULL Field to represent if a set of budget earnings, deductions, or taxes have been distributed by the CA distribution process
    N=Used only by Payroll
    Y=Used By Distribution

    Y/N Table Edit

    Default Value: N

    23 OVERRIDE_IND Character(1) VARCHAR2(1) NOT NULL Override Indicator

    Y/N Table Edit

    Default Value: N