| 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. |
| Allocation_Id Indexed - no
Format - Number
May be Null? Y | The foreign key to the GF_ALLOCATION table. |
| Amount Indexed - no
Format - Number
May be Null? Y | The Amount for the Distribution. This will be the total amount, based on the allocation. The monthly amounts will be calculated on the fly, based on the start and stop dates. |
| 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_Start_Date Indexed - no
Format - Date
May be Null? Y | Start Date for Payroll data entry |
| Distrib_Stipend_Id Indexed - yes
Format - Number
May be Null? N | The primary key of the GF_DISTRIB_STIPEND table. Generated by Hibernate Sequence |
| Distrib_Stop_Date Indexed - no
Format - Date
May be Null? Y | Stop Date for Payroll data entry |
| Entered_By Indexed - no
Format - Varchar2(32)
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. |
| Job_Class Indexed - no
Format - Varchar2(24)
May be Null? Y | Six digit code for the Job Class from the GF_JOB_CLASS table.
In Grad Funding, the Job Class is used to identify the job title associated with stipends, for example, 'Research Assistant,' 'Educational Fellow,' 'Lecturer B,' etc.
See GF_JOB_CLASS table for list of values. |
| Job_Class_Id Indexed - no
Format - Number
May be Null? Y | Internal foreign key to the GF-JOB_CLASS table. |
| Last_Edited_By Indexed - no
Format - Varchar2(32)
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 Funding system. |
| 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(16)
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(32)
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 | Internal numeric foreign key to the GF_STUDENT table. For reporting purposes, it is better to use Penn_ID to identify individuals. |
