| Data element |
Definition |
| Banner_Pidm Indexed - yes
Format - Number
May be Null? N | Internal Banner Identifier |
| Current_Balance Indexed - no
Format - Number
May be Null? Y | Amount the student owes as of today; this is a cumulative balance that reflects all transactions posted to the student's account and may include some transactions that have not been billed. |
| Memo_Amount Indexed - no
Format - Number
May be Null? Y | Amount of unapplied Memos There are the total temporary credits pending financial aid or other payment(s) as of today. Note: memos expire when the actual credit is applied or by the final deadline prior to the end of the term |
| Net_Current_Balance Indexed - no
Format - Number
May be Null? Y | Total account balance (see CURRENT_BALANCE) less total active memos (see MEMO_AMOUNT). |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Penn_Id Indexed - no
Format - Char
May be Null? Y | The 8-digit identification number assigned to the student when their record was created in the PennCommunity database. |
| Stg_Merge_Dt Indexed - no
Format - Date
May be Null? Y | Date the warehouse was last updated for this record. |
| Sum_Charges Indexed - no
Format - Number
May be Null? Y | Sum of all the charges applied to a student's account |
| Sum_Exemptions Indexed - no
Format - Number
May be Null? Y | Sum of all the student's exemptions |
| Sum_Payments Indexed - no
Format - Number
May be Null? Y | Sum of all the payments applied to a student's account |
