SFA_SS_SETUPCOA(SQL Table) |
Index Back |
|---|---|
Shopping Sheet SetupShopping Sheet Setup for Cost of Attendance grouping |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: AID_YEAR_TBL |
| 3 | SFA_SS_GROUP |
Character(10) | VARCHAR2(10) NOT NULL | Group |
| 4 | SFA_SS_COA_GROUP |
Character(2) | VARCHAR2(2) NOT NULL |
Shopping Sheet Cost Group
1=Tuition and fees 2=Housing and meals 3=Books and supplies 4=Transportation 5=Other education costs |
| 5 | BGT_ITEM_CATEGORY |
Character(4) | VARCHAR2(4) NOT NULL |
Budget Item Category
Prompt Table: BUDGET_CATG_VW |