BDGT_FORMLA_TBL

(SQL Table)
 Index Back

Budget Formula Sequence Table

Budget Formula Tbl - 01/11/97 - E.D. This table indicates the budget category, budget item code and the processing order for a formula. Part of Financial Aid - Budget Assignment.

  • Related Language Record: BDGT_FORMLA_LNG

  • Parent record: BDGT_FORMLA_TYP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    3 BGT_ITEM_CATEGORY Character(4) VARCHAR2(4) NOT NULL Budget Item Category

    Prompt Table: BUDGET_CATG_VW

    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %Date

    5 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    6 PROCESSING_NBR Number(3,0) SMALLINT NOT NULL Processing Order
    7 BUDGET_ITEM_CD Character(6) VARCHAR2(6) NOT NULL Budget Item Code

    Prompt Table: BUDGET_ITEM_TBL

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: BUDGET_ITEM_TBL.DESCR

    9 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: BUDGET_ITEM_TBL.DESCRSHORT