| Data element |
Definition |
| Active Indexed - no
Format - Varchar2(4)
May be Null? Y | A one character (T/F) code indicating whether the Charge Type is currently being used. |
| Associated_Charge_Type_Id Indexed - no
Format - Number
May be Null? Y | References another Charge Type ID, when different types are associated with each other.
For example, the Charge Type for Courses is associated with the Charge Type for General Fee by Course, so the Charge Type ID for General Fee by Course is in the Associated Charge Type ID for the Charge Type for Courses. |
| Charge_Category Indexed - no
Format - Varchar2(8)
May be Null? Y | A one character code for the category of the Charge Type
Values:
F - Fees
T - Tuition
H - Health
|
| Charge_Subcategory Indexed - no
Format - Varchar2(4)
May be Null? Y | |
| Charge_Type_Code Indexed - no
Format - Varchar2(8)
May be Null? Y | The Grad Funding two-character code for the Charge Type (used in Grad Funding only - not a code used in Pennant Accounts):
Values:
$ - Cash
C1 - Health Insurance, Single
C4 - Health Insurance, Spring Only
C5 - Health Insurance Summer Only
CF - Clinical Fee
CU - Courses
DD - Dissertation Deposit Fee
DF - Disability Fee
FT - Full Tuition
GC - General Fee by Course
GF - General Fee
GR - Reduced General Fee
MR - Masters Reg
OS - Ver Out-of-State Tuition
PF - Program Fee
RF - Tech Fee-Reduced
RT - Reduced Tuition
TF - Tech Fee
|
| Charge_Type_Id Indexed - yes
Format - Number
May be Null? N | Internal numeric file key, system-generated |
| Description Indexed - no
Format - Varchar2(160)
May be Null? Y | The text description of the Charge Type, in Grad Funding. |
| Entered_By Indexed - no
Format - Varchar2(32)
May be Null? Y | |
| Entered_On Indexed - no
Format - Date
May be Null? Y | The date the record was created in the Grad Funding system. |
| Last_Edited_By Indexed - no
Format - Varchar2(32)
May be Null? Y | |
| Last_Edited_On Indexed - no
Format - Date
May be Null? Y | The date the record was last changed in the Grad Funding system. |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Pls_Budget_Comp_Code Indexed - no
Format - Varchar2(12)
May be Null? Y | A foreign key to the Penn Loans System table: PLS_BUDGET_COMP_TUIT. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Tuit_Type Indexed - no
Format - Varchar2(4)
May be Null? Y | A one-character code for the method in which tuition is calculated for records using this Charge Type.
Values:
F - full tuition school
C - tuition based on courses taken
|
| Yis Indexed - no
Format - Varchar2(8)
May be Null? Y | Used by the Penn Loans System (PLS). For most Charge Types, this will be '99'. |
