| Data element |
Definition |
| Allocation_Id
Indexed - yes
Format - Number
May be Null? N | File key, system-generated. |
| Accounting_Period
Indexed - yes
Format - Varchar2(6)
May be Null? N | The General Ledger Accounting Period that this stipend is expected to hit, in MMM-YY format. |
| Allocation_Type_Desc
Indexed - no
Format - Varchar2(60)
May be Null? Y | Allocation types are Service, Non-Service, Financial Aid or External.
See DWNGSS.GF_ALOOCATION_TYPE table. |
| Budgeted_Amount
Indexed - no
Format - Varchar2(6)
May be Null? Y | The amount, in US dollars, being budgeted for this stipend. |
| Fiscal_Year
Indexed - no
Format - Number (4)
May be Null? Y | The Fiscal Year that this stipend is to be used. Fiscal years run from July 1 through June 30, and the year is the calendar year of the second half. For example, July 1 2015 through June 30 2016 is Fiscan Year 2016. |
| Funding_Year
Indexed - no
Format - Number (4)
May be Null? Y | The academic year this stipend funding applies to. |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Package_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | The name of the package. See GF_FUNDING_PACKAGE. |
| Package_Line_ID
Indexed - no
Format - Number (22)
May be Null? Y | Internal Grad Funding system key to DWNGSS.GF_FUNDING_PACKAGE_LINE.
(note used by the Grad funding Business Objects universe) |
| Penn_Id Indexed - no
Format - Varchar2(8)
May be Null? Y | The student's Penn_ID. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
Stipend_Type_ID
Indexed - no
Format - Varchar2(60)
May be Null? Y |
Internal key to the DWNGSS_GF_STIPEND_TYPE table. |
