INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
AID_YEARDefault Value: OPR_DEF_TBL_CS.AID_YEAR
Prompt Table: AID_YEAR_TBL
BGT_ITEM_CATEGORYF=Federal
I=Institutional
Default Value: F
BUDGET_CATG_VW(SQL View) |
Index Back |
|---|---|
Budget Category ViewBUDGET_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 institution ,aid_year ,bgt_item_category ,descr ,budget_item_type from PS_BUDGET_CATG_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 | BUDGET_ITEM_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Item Classification
F=Federal I=Institutional Default Value: F |