| Data element |
Definition |
| Active
Indexed - no
Format - Char (1)
May be Null? Y | A one-character (T/F) code indicating whether or not this Stipend Type is currently in use. |
Dept_Org
Indexed - no
Format - Varchar2(4)
May be Null? Y
|
The four digit Chart of Accounts Organization Code for the department, school or center that uses this Stipend Type to fund graduate students. |
| Entered_By
Indexed - no
Format - Varchar2(8)
May be Null? Y |
The Penn ID of the user who created the record. Note that older records (pre August 2015) will have a single digit rather than a penn ID. |
| Entered_On
Indexed - no
Format - Date
May be Null? Y |
The date the record was created |
| Last_Edited_By
Indexed - no
Format - Varchar2(8)
May be Null? Y |
The Penn ID of the last user who edited the record Note that older records (pre August 2015) will have a single digit rather than a penn ID. |
| 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. |
| Stipend_Name
Indexed - no
Format - Varchar2(60)
May be Null? Y |
Long name (decodes the Stipend_Type).
For example:
BFSUM: Stipend Name = Ben Franklin Summer
NURSTA: Stipend Name = Nursing TA Stipend
|
| Stipend_Type
Indexed - no
Format - Varchar2(6)
May be Null? Y |
Short code (up to 6 characters) for the Stipend Type. |
| Stipend_Type_ID
Indexed - yes
Format - Number
May be Null? N |
Internal file key, system-generated. |
