| Data element |
Definition |
| Activity_Date Indexed - no
Format - Date
May be Null? Y | The last date any part of this record was updated in the source. Source field: SGRADVR_ACTIVITY_DATE |
| Advisor_Desc Indexed - no
Format - Varchar2(30)
May be Null? Y | Description of the code in Advisor_Type. Source field: STVADVR_DESC. |
| Advisor_First_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | First name of the student's advisor. Source field: SPRIDEN_FIRST_NAME |
| Advisor_Last_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Last name of the student's advisor. Source field: SPRIDEN_LAST_NAME |
| Advisor_Middle_Name Indexed - no
Format - Varchar2(60)
May be Null? Y | Middle name or initials of the student's advisor. Source field: SPRIDEN_MI |
| Advisor_Penn_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | The Penn ID of the student's advisor. Source field: SPRIDEN_ID |
| Advisor_Pidm Indexed - no
Format - Number
May be Null? Y | Banner internal identification number for the advisor. Source field: SGRADVR_ADVR_PIDM. |
| Advisor_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | The code for the type of advisor. Students can have multiple advisors; each advisor is assigned an advisor type, for example: major advisor, departmental advisor, etc. Source field: SGRADVR_ADVR_CODE. Source validation table: STVADVR. Warehouse validation table: ST_ADVISOR. |
| Effective_Term Indexed - no
Format - Varchar2(6)
May be Null? Y | The term the advisor assignment went into effect. Note that advisor data is stored in the warehouse term-by-term, but this field indicates the earliest term for the advisor assignment. See also the TERM field. Source: SGRADVR.EFFECTIVE_TERM |
| Penn_ID Indexed - no
Format - Varchar2(9)
May be Null? Y | Penn's identity management system identification number for the student. Source field: SPRIDEN_ID |
| Pidm Indexed - no
Format - Number
May be Null? Y | Banner internal identification number for the student. Source field: SGVADVR_PIDM |
| Refresh_Date Indexed - no
Format - Date
May be Null? Y | The last date the table was refreshed in the warehouse |
| St_Advisor_Pk Indexed - yes
Format - Varchar2(131)
May be Null? N | Internal warehouse primary key: based on pidm, term, advisor pidm, advisor type and surrogate id. |
| Term Indexed - no
Format - Varchar2(6)
May be Null? Y | A term in which the advisor is assigned to the student. Advisors can be assigned for multiple terms. Advisors can also change from term-to-term. The first term of this advisor's assignment to the student can be found in the EFFECTIVE_TERM column. Source field: SGRADVR_TERM |
