| Data element |
Definition |
| Account_Group_Id Indexed - no
Format - Number
May be Null? Y | The Account group from which funding will come. This is a foreign key to the LOV_ACCOUNT_GROUP table |
| Account_Group_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | The Account group name is a way to categorize Accounts. A set of Account groups are owned by a single org, which allows editing and retirement of this account group. |
| Allocation_Funding_Id Indexed - yes
Format - Number
May be Null? N | The primary key of the GF_ALLOCATION_FUNDING_SOURCE table. |
| Allocation_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_ALLOCATION_ORIG table |
| Appointment_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | The Organization code from which the distribution funding will come |
| Covers_Fall Indexed - no
Format - Varchar2(1)
May be Null? Y | This boolean indicates whether or not the funding is for the Fall semester of the allocation year. Note that funding sources can cover more than one term.
Values:
T - funding covers Fall term
F - funding does not cover Fall term |
| Covers_Spring Indexed - no
Format - Varchar2(1)
May be Null? Y | This boolean indicates whether or not the funding is for the Spring semester of the allocation year. Note that funding sources can cover more than one term.
Values:
T - funding covers Spring term
F - funding does not cover Spring term |
| Covers_Summer1 Indexed - no
Format - Varchar2(1)
May be Null? Y | This boolean indicates whether or not the funding is for the Summer 1 semester of the allocation year. Note that funding sources can cover more than one term.
Values:
T - funding covers Summer 1 term
F - funding does not cover Summer 2 term |
| Covers_Summer2 Indexed - no
Format - Varchar2(1)
May be Null? Y | This boolean indicates whether or not the funding is for the Summer 2 semester of the allocation year. Note that funding sources can cover more than one term.
Values:
T - funding covers Summer 2 term
F - funding does not cover Summer 2 term |
| Entered_By Indexed - no
Format - Varchar2(8)
May be Null? Y | The Penn ID of the user who created the Allocation funding record |
| Entered_On Indexed - no
Format - Date
May be Null? Y | The date the record was created |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | |
