| Data element |
Definition |
| Allocation_Id Indexed - no
Format - Number
May be Null? Y | Foreign key to the tables with allocation data: GF_ALLOCATION_ORIG, GF_ALLOCATION_CHARGE, GF_ALLOCATION_STIPEND |
| Allocation_Type_Desc Indexed - no
Format - Varchar2(240)
May be Null? Y | Desctiptive text of the allocation type (e.g., Service/Non-Service), from the GF_ALLOCATION_TYPE table |
| Amount Indexed - no
Format - Number
May be Null? Y | For stipends, this comes from is the sum of the Budgeted_Amount in GF_ALLOCATION_STIPEND, summed per Allocation_ID, Allocation_Type, and term for the student.
For allocations covering charges, this is the Sum of the Derived_Amount from GF_ALLOCATION_CHARGE, summed per Allocation_ID, Allocation_Type, and term for the student. |
| Banner_Term Indexed - no
Format - Varchar2(24)
May be Null? Y | The academic term in Banner format (YYYYTT, where TT is: 10 = spring, 22 = summer1, 24 = summer2, 30 = fall). Part of the record key for this table. |
| Fiscal_Year Indexed - no
Format - Number
May be Null? Y | For stipends, this is the Fiscal_Year from GF_ALLOCATION_STIPEND.
For charges, this is derived from the Banner_Term in GF_ALLOCATION_CHARGE. |
| Funding_Type Indexed - no
Format - Char
May be Null? Y | This column will be either "STIPEND" or "CHARGES" indicating whether the view is getting the data from GF_ALLOCATION_STIPEND or GF_ALLOCATION_CHARGE. |
| Funding_Year Indexed - no
Format - Number
May be Null? Y | The academic year being funded.
This column comes from either the Funding_Year in GF_ALLOCATION_STIPEND, or the Year in GL_ALLOCATION_ORIG. |
| Package_Name Indexed - no
Format - Varchar2(240)
May be Null? Y | The name of the package, if applicable. See GF_FUNDING_PACKAGE. |
| Package_Year Indexed - no
Format - Number
May be Null? Y | Generic counter for the years, starts with 0 and will contain records up to the max years allowed for the package. This value, combined with the entry year of the student, will ensure that the correct plan for a given year is created correctly. |
| Penn_Id Indexed - no
Format - Varchar2(32)
May be Null? Y | The Penn_ID of the student being funded. |
| Stipend_Type Indexed - no
Format - Varchar2(240)
May be Null? Y | Derived from Stipend_Name in GF_STIPEND_TYPE. (decodes the Stipend_Type).
Examples: Ben Franklin Summer, Nursing TA Stipend, Physics & Astronomy Basic Package, etc. |
