Penn Computing

University of Pennsylvania
Penn Computing << go backback
GF_STUDENT_ADVISOR Table . Tables and Data Elements . Grad Funding Home . Data Warehouse Home

GF_STUDENT_ADVISOR Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

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.

GF_STUDENT_ADVISOR Table . Tables and Data Elements . Grad Funding Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania