BUDGET_ITEM_TBL(SQL Table) |
Index Back |
|---|---|
Budget Item TableBUDGET_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. |
| # | 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 | BUDGET_ITEM_CD |
Character(6) | VARCHAR2(6) NOT NULL | Budget Item Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL |
Short Description
Default Value: BUDGET_ITEM_TBL.DESCR |
| 7 | BUDGET_ITEM_AMOUNT | Number(8,2) | DECIMAL(7,2) NOT NULL | Budget Item Amount |
| 8 | PELL_ITEM_AMOUNT | Number(8,2) | DECIMAL(7,2) NOT NULL | Pell Amount |
| 9 | BUDG_MULTIPLIER | Character(1) | VARCHAR2(1) NOT NULL |
Budget Multiplier
Y/N Table Edit |
| 10 | BUDG_MULT_FIELD | Character(18) | VARCHAR2(18) NOT NULL |
Multiplier Field
Prompt Table: STDNT_BGT_NUMVW |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 12 | DESCRLONG | Long Character | CLOB | Long Description |
| 13 | THREE_QTR_TIME_ADJ | Number(6,2) | DECIMAL(5,2) NOT NULL | Three quarters Load Adjustment |
| 14 | HALF_TIME_ADJ | Number(6,2) | DECIMAL(5,2) NOT NULL | Half-time Adjustment |
| 15 | LESS_HALF_TIME_ADJ | Number(6,2) | DECIMAL(5,2) NOT NULL | Less Half-Time Adjustment |
| 16 | ZERO_TIME_ADJ | Number(6,2) | DECIMAL(5,2) NOT NULL | Zero-Time Adjustment |
| 17 | SFA_PELITMAMT_LHT | Number(8,2) | DECIMAL(7,2) NOT NULL | Filed used for the calculation of Less than half time Pell COA Budget Item amount. |
| 18 | USE_EQUATION_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use Equation
Y/N Table Edit Default Value: N |
| 19 | EQUATION_NAME | Character(12) | VARCHAR2(12) NOT NULL |
Equation Name
Prompt Table: FA_BDGT_EQ_C_VW |