| Data element |
Definition |
| Active Indexed - no
Format - Varchar2(4)
May be Null? Y | A one-character code (T/F) indicated whether the comment is actively being used in the Grad Funding system. |
| Comment_Type Indexed - no
Format - Varchar2(160)
May be Null? Y | Indicates the level or scope of the comment
Values:
Allocation - comment relates to allocation of funds
Distribution - comment relates to the distribution of funded amounts
Student - comment relates overall to the student (not allocation or distribution specific)
|
| Entered_By Indexed - no
Format - Varchar2(32)
May be Null? Y | Penn_ID of the person who entered the comment online. |
| Entered_On Indexed - no
Format - Date
May be Null? Y | Date on which the comment was first entered. |
| Funding_Year Indexed - no
Format - Number
May be Null? Y | The Grad Funding year to which the comment applies. |
| Last_Edited_By Indexed - no
Format - Varchar2(32)
May be Null? Y | The Penn_ID of the person who last edited the comment. |
| Last_Edited_On Indexed - no
Format - Date
May be Null? Y | Date on which the comment 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_Comment Indexed - no
Format - Varchar2(4000)
May be Null? Y | Free-form text of the comment, as entered in Grad Funding. |
| Student_Comment_Id Indexed - yes
Format - Number
May be Null? N | Internal file key, system-generated. |
| Student_Id Indexed - yes
Format - Number
May be Null? Y | Internal foreign key to the GF_STUDENT table. |
