GF_STUDENT_PROGRAM Table
(dwngss.gf_student_program)
Explanation
Contains a subset of the current academic program information for the student in the Grad Funding system.
Common Usage examples
- Find the program related to the Grad Funding entry for a student.
| Primary Key |
Indexed Data Elements |
Related Tables |
STUDENT_PROGRAM_ID
|
Index 1:
STUDENT_PROGRAM_ID
STUDENT_ID
ACADEMIC_PROGRAM_ID
Index 2:
STUDENT_ID
DEGREE_ORDER
|
DWNGSS.GF_STUDENT
DWNGSS.GF_ACADEMIC_PROGRAM
|
Cautions
and notes
- The academic information in this table -- GPA, PhD Term count, Dissertation terms, etc. -- are recorded in the Grad Funding system. If these data elements are later updated in the Student Records System (SRS), they are not automaticaly updated in the GF_STUDENT_PROGRAM table. To get the most recent information on a student, use the DWADMIN.DEGREE_TERM_ALL_V and DWADMIN.STUDENT_TERM tables.
- The GF_STUDENT_PROGRAM.ACADEMIC_PROGRAM_ID links to the GF_ACADEMIC_PROGRAM table, which is the "current" program per the Grad Funding record, but is not term-specific. See also comments under the GF_ACADEMIC_PROGRAM table.
Source
- The Grad Funding online system
Questions about this page? Email us at da-staff@isc.upenn.edu
|
