| Data element |
Definition |
| Account_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_ACCOUNT Table, used in case the COA changes. Note that distributions can consist of multiple accounts per allocation. |
| Active Indexed - no
Format - Varchar2(1)
May be Null? Y | A flag indicating whether the distribution is active.
Values:
T - Active
F - Not active
|
| Allocation_Component_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_ALLOCATION_CHARGE table. |
| Amount Indexed - no
Format - Number
May be Null? Y | The amount that is being paid. |
| Banner_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The Banner Term associated with the Allocation Charge of this charge payment. See GF_ALLOCATION_CHARGE. |
| Distrib_Percentage Indexed - no
Format - Number
May be Null? Y | The Percentage of the distribution, stored from the entry screen, in case the user wishes to see the distribution percentages after entry. If nothing is entered for a percentage, this column will be zero. |
| Distrib_Tuition_Comp_Id Indexed - yes
Format - Number
May be Null? N | The primary key of the DISTRIB_CHARGE_PAYMENT table. Generated by hibernate sequence. |
| Entered_By Indexed - no
Format - Varchar2(8)
May be Null? Y | The Penn ID of the user who entered the record |
| Entered_On Indexed - no
Format - Date
May be Null? Y | The date the record was created in the Grad Funding system. |
| Last_Edited_By Indexed - no
Format - Varchar2(8)
May be Null? Y | The Penn ID of the last editor of the record |
| Last_Edited_On Indexed - no
Format - Date
May be Null? Y | The date the record was last edited in the Grad Funging System. |
| Match Indexed - no
Format - Varchar2(1)
May be Null? Y | |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Paying_Org Indexed - no
Format - Varchar2(4)
May be Null? Y | The equivalent of Job Department, the paying org represents the organization code from which funding is paid. |
| Penn_Id Indexed - no
Format - Varchar2(8)
May be Null? Y | The Penn ID of the student |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the Data Warehouse was last updated for this record. |
| Student_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_STUDENT table. This is the student receiving the funding |
