| Data element |
Definition |
| Banner_Pidm Indexed - yes
Format - Number
May be Null? N | Internal Banner Identifier |
| Ods_Etl_Update_Dt Indexed - no
Format - Date
May be Null? Y | Date the staging table was updated for this record. |
| Paid_Applied_Amount Indexed - no
Format - Number
May be Null? Y | Sum of all payments against the transaction |
| Paid_Applied_Date Indexed - no
Format - Date
May be Null? Y | Date of the most recent payment against the transaction |
| 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. |
| Transaction_Number Indexed - yes
Format - Number
May be Null? N | The transaction number of this transaction. Each transaction for a student has a sequential transaction number assigned by Banner at the time the transaction is created. For each subsequent transaction, the transaction number is incremented by 1. Transaction numbers are unique within a student's account. For any detail transaction, the key is always student id and transaction number. |
