| Data element |
Definition |
| Birth_Date Indexed - no
Format - Date
May be Null? Y | The student's date of birth, as recorded in the Grad Funding system.
Note that Grad Funding is not the system of record for this information. See DWADMIN.PERSON_ALL_V |
| Country_Of_Citizenship Indexed - no
Format - Varchar2(8)
May be Null? Y | Two character code for he student's country of citizenship as recorded in the Grad Funding system.
Note that Grad Funding is not the system of record for this information. See DWADMIN.PERSON_ALL_V |
| Email_Address Indexed - no
Format - Varchar2(400)
May be Null? Y | The student's email address, as recorded in the Grad Funding system.
Note that Grad Funding is not the system of record for this information. See DWADMIN.PERSON_ALL_V |
| Entered_By Indexed - no
Format - Varchar2(32)
May be Null? Y | The penn_ID of the person who created this row in Grad Funding. Note that records older than September 2015 may have only a single digit in this column. |
| Entered_On Indexed - no
Format - Date
May be Null? Y | The date this record was created in the Grad Funding system. |
| First_Name Indexed - no
Format - Varchar2(140)
May be Null? Y | The student's first name, as entered in the Grad Funding system.
Note that Grad Funding is not the system of record for this information. See DWADMIN.PERSON_ALL_V |
| Last_Edited_By Indexed - no
Format - Varchar2(32)
May be Null? Y | The penn_ID of the person who last editied this information in Grad Funding. Note that records older than September 2015 may have only a single digit in this column. |
| Last_Edited_On Indexed - no
Format - Date
May be Null? Y | The date this record was last editied in the Grad Funding system. |
| Last_Name Indexed - no
Format - Varchar2(140)
May be Null? Y | The student's last name, as entered in the Grad Funding system.
Note that Grad Funding is not the system of record for this information. See DWADMIN.PERSON_ALL_V |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Penn_Id Indexed - no
Format - Varchar2(32)
May be Null? Y | The student's Penn_ID, as entered in the Grad Funding system.
|
| Sex Indexed - no
Format - Varchar2(4)
May be Null? Y | The sex of the student, as entered in the Grad Funding system.
Values:
null
F
M
P
Note that Grad Funding is not the system of record for this information. See DWADMIN.PERSON_ALL_V |
| 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? N | Internal file key, system-generated. |
| Student_Status Indexed - no
Format - Varchar2(60)
May be Null? Y | Status contains the various reasons for including or excluding a student from appearing on the system. Pursuing degree is the default active setting. Note that Gard Funding is not the system of record for exit action information. See DWADMIN.DEGREE_PURSUAL_ALL_V.
Values:
Deferred
Dropped
Graduated
On Leave
Pursing Degree
Withdrawn
|
| Visa Indexed - no
Format - Varchar2(8)
May be Null? Y | The student's visa code, if applicable, as entered in the Grad Funding system.
Note that Grad Funding is not the system of record for this information. See DWADMIN.PERSON_ALL_V |
| Visa_Expires Indexed - no
Format - Date
May be Null? Y | The date the student's visa expires, if applicable, as entered in the Grad Funding system.
Note that Grad Funding is not the system of record for this information. See DWADMIN.PERSON_ALL_V |
