DEPT_BUDGET_DT

(SQL Table)
 Index Back

Dept Budget Period Dates

This record is the header record for the Department Budgeting Process. It contains one record for each budget period and defines the characteristics of the budget period such as start and end dates, fiscal year, and currency type.

  • Parent Record Of DEPT_BDGT_VW DEPT_BUDGET DEPT_FTE_EFFDT

    • # 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 BUDGET_BEGIN_DT Date(10) DATE NOT NULL Budget Begin Date
    5 BUDGET_END_DT Date(10) DATE NOT NULL Budget End Date
    6 BUDGET_CAP_INDC Character(1) VARCHAR2(1) NOT NULL Budget Cap
    D=Detail
    O=Overall

    Default Value: O

    7 DEPT_OFFSET_GRP Character(5) VARCHAR2(5) NOT NULL Department Offset Group

    Prompt Table: DEPT_OFFSET_GRP

    8 DEFAULT_FUND_OPTN Character(1) VARCHAR2(1) NOT NULL Default Funding Source Option
    A=Distrib over Actual Earnings
    E=Earnings Funding Source
    N=No Defaults
    S=Specified Defaults

    Default Value: A

    9 ACCT_CD_DED Character(25) VARCHAR2(25) NOT NULL Combination Code (Deductions)

    Prompt Table: ACCT_CD_CA_VW

    10 HP_DFLT_FND_DT_FLG Character(1) VARCHAR2(1) NOT NULL Funding End Date Defaults From Funding Source

    Y/N Table Edit

    Default Value: N

    11 FUND_END_DT_DED Date(10) DATE Funding End Date (Ded)
    12 ACCT_CD_TAX Character(25) VARCHAR2(25) NOT NULL Combination Code (Tax)

    Prompt Table: ACCT_CD_CA_VW

    13 FUND_END_DT_TAX Date(10) DATE Funding End Date (Tax)
    14 HP_FRINGE_GROUP Character(5) VARCHAR2(5) NOT NULL Fringe Group

    Prompt Table: HP_FRINGE_GROUP

    15 HP_ERN_ACCT Character(1) VARCHAR2(1) NOT NULL Use Acct Defined for Earnings

    Y/N Table Edit

    Default Value: Y

    16 HP_DED_ACCT Character(1) VARCHAR2(1) NOT NULL Use Account Defined for Dedns

    Y/N Table Edit

    Default Value: Y

    17 HP_TAX_ACCT Character(1) VARCHAR2(1) NOT NULL Use Account Defined for US Tax

    Y/N Table Edit

    Default Value: Y

    18 HP_CTX_ACCT Character(1) VARCHAR2(1) NOT NULL Use Account Defined for CanTax

    Y/N Table Edit

    Default Value: Y