| Data element |
Definition |
| Active Indexed - no
Format - Varchar2(4)
May be Null? Y | A one character flag (T/F) indicating whether the advisor record is currently valid for this student. |
| Advisor_Id Indexed - yes
Format - Number
May be Null? Y | Internal key to the GF_ADVISOR table. |
| Entered_By Indexed - no
Format - Varchar2(32)
May be Null? Y | The Penn_ID of the person who created the record in the Grad Funding system. |
| Entered_On Indexed - no
Format - Date
May be Null? Y | The date the record was created 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. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Student_Advisor_Id Indexed - yes
Format - Number
May be Null? N | Internal record key for this table, system-generated. |
| Student_Id Indexed - yes
Format - Number
May be Null? Y | Internal record key to the GF_STUDENT table. |
