| 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. |
