Penn Computing

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

GF_TAG 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 boolean indicator (T=True/F=False) for whether or not the tag is being used in the Grad Funding system.

Entered_By

Indexed - no
Format - Varchar2(32)
May be Null? Y

The Penn ID of the user who created the record

Entered_On

Indexed - no
Format - Date
May be Null? Y

The date the record was created

Last_Edited_By

Indexed - no
Format - Varchar2(32)
May be Null? Y

The Penn ID of the last user who edited the record

Last_Edited_On

Indexed - no
Format - Date
May be Null? Y

The date when the record was last edited.

Ods_Etl_Update_Dt

Indexed - no
Format - Date
May be Null? Y

Date the staging table was updated for this record.

School_Id

Indexed - no
Format - Number
May be Null? Y

Foreign key to the GF_SCHOOL table.

Note: this is not the code for School use in SRS or in Pennant Accounts.

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

Date the warehouse was last updated for this record.

Tag_Descr

Indexed - no
Format - Varchar2(160)
May be Null? Y

Text description of the tag, as entered by the school in the Grad Funding system.
Tag_Id

Indexed - yes
Format - Number
May be Null? N

Unique primary key for the GF_TAG table.

GF_TAG 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