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