| Data element |
Definition |
| Academic_Program_Id Indexed - yes
Format - Number
May be Null? Y | Internal record key for the GF_ACADEMIC_PROGRAM table. |
| Banner_Entry_Term Indexed - no
Format - Varchar2(24)
May be Null? Y | The student's proposed entry term into the specified academic program, in Banner format (YYYYTT, where TT is: 10 = spring, 22 = summer1, 24 = summer2, 30 = fall) |
| Banner_Last_Reg_Term Indexed - no
Format - Varchar2(24)
May be Null? Y | The student's last registered term, in Banner format (YYYYTT, where TT is: 10 = spring, 22 = summer1, 24 = summer2, 30 = fall)
Note: Grad Funding is not the system of record for this information. See DWADMIN.DEGREE_PURSUAL_ALL_V. |
| Degree_Order Indexed - yes
Format - Number
May be Null? Y | For students in more than one degree in the "current" Grad Funding term, Degree_Order = 1 will find their primary program, and Degree_Order = 2 will find their secondary program. To insure that you get back only one row per student, indicate Degree_Order =1, or specify the degree (using a join to the GF_ACADEMIC_PROGRAM table.) |
| Dissertation_Terms Indexed - no
Format - Number
May be Null? Y | The number of terms a student has been on Dissertation.
Note: Grad Funding is not the system of record for this information. See DWADMIN.STUDENT_TERM. |
| Earned_Credit Indexed - no
Format - Number
May be Null? Y | The total number of credits a student has earned, to-date, as captured in the Grad Funding system.
Note: Grad Funding is not the system of record for this information. See DWADMIN.DEGREE_PURSUAL_ALL_V. |
| Entered_By Indexed - no
Format - Varchar2(32)
May be Null? Y | tdb |
| Entered_On Indexed - no
Format - Date
May be Null? Y | The date the record was created in Grad Funding. |
| GPA
Indexed - no
Format - Number
May be Null? Y | The students Grade Point Average, as captured in the Grad Funding system.
Note: Grad Funding is not the system of record for this information. See DWADMIN.DEGREE_PURSUAL_ALL_V. |
| Incompletes Indexed - no
Format - Number
May be Null? Y | The number of Incomplete the student has received, as captured in the Grad Funding system.
Note: Grad Funding is not the system of record for this information. See DWADMIN.ENROLLMENT_ALL_V. |
| Major_Order Indexed - no
Format - Number
May be Null? Y | For studenets with more than one major in either their primary, or, if applicable, secondary program in the "current" Grad Funding term, Major_Order = 1 will be their primary major, Major_Order = 2 will be their second major and, if applicable, Major_Order = 3 will be their third major. To insure that you get back only one row per student, indicate Major_Order =1, or specify the major (using a join to the GF_ACADEMIC_PROGRAM table.)
See also Degree_Order. |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Phd_Term_Count Indexed - no
Format - Number
May be Null? Y | The number of terms a student has been pursuing a PhD at Penn, as captured in the Grad Funding system.
Note: Grad Funding is not the system of record for this information. See DWADMIN.STUDENT_TERM. |
| Phd_Term_Count_Term Indexed - no
Format - Varchar2(24)
May be Null? Y | The term for which the PhD_Term_Count in this record applies, as captured in the Grad Funding system.
Note: Grad Funding is not the system of record for this information. See DWADMIN.STUDENT_TERM. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Student_Id Indexed - yes
Format - Number
May be Null? Y | Internal key to the GF_STUDENT table. |
| Student_Program_Id Indexed - yes
Format - Number
May be Null? N | Internal file key for this table, system-generated. |
| Transfer_Credit Indexed - no
Format - Number
May be Null? Y | The number of transfer credits this student has been awarded, to count towards the specified degree at Penn, as captured in the Grad Funding system.
Note: Grad Funding is not the system of record for this information. See DWADMIN.DEGREE_PURSUAL_ALL_V. |
