| Data element |
Definition |
| 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. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Student_Id Indexed - yes
Format - Number
May be Null? Y | Foreign key to the GF_STUDENT table. |
| Student_Tag_Id Indexed - yes
Format - Number
May be Null? N | Primary key for the GF_STUDENT_TAG table. |
| Tag Indexed - yes
Format - Varchar2(160)
May be Null? Y | The text description of the tag. Note that this is the same as the TAG_DESCR in the GF_TAG table. |
| Tag_Id Indexed - no
Format - Number
May be Null? Y | Foreign key to the GF_TAG table. |
