BDGT_TREE_TBL

(SQL Table)
 Index Back

Budget Criteria Type Table

Budget Tree Table - 07/29/96 - E.D. This table indicates the budget category and budget item code for a budget criteria defined to use the budget tree. Part of Financial Aid - Budget Assignement.

  • Related Language Record: BDGT_TREE_LANG

  • Parent record: BDGT_TREE_CATG

    • # 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_TBL

    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

    10 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Default Value: POSTAL

    11 BDGT_TREE_OPER Character(3) VARCHAR2(3) NOT NULL Budget Tree Operator
    NWN=Not Within the Range of
    WIN=Within the Range of
    12 TREE_NAME Character(18) VARCHAR2(18) NOT NULL Tree Name

    Prompt Table: TREE_FIELD_VW

    13 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

    Prompt Table: FA_ZIP_REGN_VW