Data element |
Definition |
Advisor_Active Indexed - no Format - Varchar2(4) May be Null? Y | A one character (T/F) flag indicating whether or not the advisor listed is actively participating in grad funding advising. |
Advisor_Cref Indexed - no Format - Varchar2(16) May be Null? Y | The number 4-byteGeneral Ledger Center Ref code of the advisor, if available.
See DWADMIN.CENTER_REF_CODES for values. |
Advisor_Email_Address Indexed - no Format - Varchar2(240) May be Null? Y | The email address of the advisor. Note that if the Advisor_Active flag is "F" this email may no longer be valid. |
Advisor_Id Indexed - yes Format - Number May be Null? N | Internal file key, system-assigned. |
Advisor_Org Indexed - no Format - Varchar2(16) May be Null? Y | The numeric 3-byte General Ledger Oranganization Code of the advisor.
See DWADMIN.ORG_CODES for values. |
Advisor_Penn_Id Indexed - no Format - Varchar2(32) May be Null? Y | The Penn_ID of the advisor. |
First_Name Indexed - no Format - Varchar2(120) May be Null? Y | The advisor's first name, as entered into the Grad Funding system. |
Last_Name Indexed - no Format - Varchar2(140) May be Null? Y | The advisor's last name, as entered into 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. |