DEPT_BUDGET_DED

(SQL Table)
 Index Back

Department Budget Ded Dist

DEPT_BUDGET_DED is the record which contains the Deductions 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 deductions 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 DEPT_BDGT_DED_KEY Character(36) VARCHAR2(36) NOT NULL Additional Field on Dept Bdgt Ded to contain concatenated key for record. If each key field were separate on the key the maximum number of keys (16) would be exceeded
    13 BUDGET_SEQ Number(2,0) SMALLINT NOT NULL Budget Sequence
    14 ACCT_CD Character(25) VARCHAR2(25) NOT NULL Combination Code

    Prompt Table: ACCT_CD_CA_VW

    15 PLAN_TYPE Character(2) VARCHAR2(2) NOT NULL Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
    16 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

    Prompt Table: BENEF_PLAN_TBL

    17 DEDCD Character(6) VARCHAR2(6) NOT NULL Deduction Code

    Prompt Table: DEDUCTION_TBL

    18 DED_CLASS Character(1) VARCHAR2(1) NOT NULL Deduction Classification
    A=After-Tax
    B=Before-Tax
    L=QC Taxable Benefit
    N=Nontaxable Benefit
    P=Nontaxable Btax Benefit
    T=Taxable Benefit

    Prompt Table: DED_CLASS_VW

    19 GL_PAY_TYPE Character(6) VARCHAR2(6) NOT NULL General Ledger Pay Type
    20 BUDGET_AMT Number(19,3) DECIMAL(18,3) NOT NULL Budget Amount
    21 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

    22 DIST_PCT Number(7,3) DECIMAL(6,3) NOT NULL Percent of Distribution
    23 FUNDING_END_DT Date(10) DATE Funding End Date
    24 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

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

    Y/N Table Edit

    Default Value: N