BDGT_CATG_COPY

(SQL View)
 Index Back

Budget Category Table

BUDGET_ITEM_TBL is where individual components or items of a student budget are defined. The items are later associated with a budget group, which is then assigned to a student.

Select A.INSTITUTION ,A.AID_YEAR ,A.BGT_ITEM_CATEGORY ,A.DESCR ,A.DESCRSHORT ,A.BUDGET_ITEM_TYPE ,A.PELL_CATEGORY From PS_BUDGET_CATG_TBL A

  • Related Language Record: BUDGET_CATG_LNG

  • Parent record: AID_YEAR_TBL

    • # 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
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: BUDGET_CATG_TBL.DESCR

    6 BUDGET_ITEM_TYPE Character(1) VARCHAR2(1) NOT NULL Item Classification
    F=Federal
    I=Institutional

    Default Value: F

    7 PELL_CATEGORY Character(1) VARCHAR2(1) NOT NULL Pell Category
    B=Books and Supplies
    C=Dependent Child Care
    D=Disability Expenses
    F=Student Activities Fees
    H=Housing
    L=Loan Fees
    P=Personal/Miscellaneous
    S=Transportation
    T=Tuition