Penn Computing

University of Pennsylvania
Penn Computing << go backback
STUDENT_ACCOUNT_DETAIL Table . Tables and Data Elements .  Pennant Accounts Home . Data Warehouse Home

STUDENT_ACCOUNT_DETAIL Table - Data Element Index

Select a data element to view its definition and its indexed, format, and null values.

Data element Definition
Banner_Pidm

Indexed - yes
Format - Number
May be Null? N

Internal Banner Identifier

Banner_Term

Indexed - no
Format - Varchar2(24)
May be Null? Y

Banner Term associated with the transaction. Banner term is formatted as YYYYTT, where YYYY is the calendar year, and TT is: 10 for Spring, 22 for Summer 1, 24 for Summer 2 and 30 for Fall. For student transactions Banner Term must be valid in the Banner SATURN.STVTERM table, or ARTERM for non-student transactions.

Bill_Date

Indexed - no
Format - Date
May be Null? Y

Date that the transaction is billed.

Charge_Payment_Ind

Indexed - no
Format - Varchar2(1)
May be Null? Y

This field indicates the whether the detail code is a charge or a payment. Valid values are: C - Charge, P - Payment.

Data_Origin

Indexed - no
Format - Varchar2(120)
May be Null? Y

Source system that last created or updated the data.

Detail_Code

Indexed - no
Format - Varchar2(16)
May be Null? Y

Detail code associated with the transaction. Valid values are in Banner TAISMGR.TBBDETC. See also the warehouse DWNGSS.DETAIL_CODE table.

Detail_Code_Description

Indexed - no
Format - Varchar2(120)
May be Null? Y

Text description of the DETAIL_CODE associated with the transaction. Default value comes from the Banner Detail Code description (TAISMGR.TBBDETC). See also the warehouse DWNGSS.DETAIL_CODE table.

Due_Date

Indexed - no
Format - Date
May be Null? Y

Date by which payment to the University is due. Due date set when the transaction is billed.

Effective_Date

Indexed - no
Format - Date
May be Null? Y

Effective date of the transaction used to calculate amount due, determine placement on the bill, and control feed to finance system based on Accounts Receivable System Control setting.

Entry_Date

Indexed - no
Format - Date
May be Null? Y

Initial create date of the transaction

Last_Activity_Date

Indexed - no
Format - Date
May be Null? Y

The last date this row was created or updated.

Ods_Etl_Update_Dt

Indexed - no
Format - Date
May be Null? Y

Date the staging table was updated for this record.

Penn_Id

Indexed - yes
Format - Char
May be Null? Y

The 8-digit identification number assigned to the student when their record was created in the PennCommunity database.

Source_Code

Indexed - no
Format - Varchar2(4)
May be Null? Y

Code that identifies the origin of the transaction. For example, K for feeder app, R for tuition calc, F for financial aid, T for transactions entered online, X for converted transactions The default value is user entered transaction (T). Valid values come from Banner TAISMGR.TTVSRCE.

Srs_Term

Indexed - yes
Format - Varchar2(5)
May be Null? Y

SRS term associated with the transaction. SRS term is formatted YYYYT where YYYY is the calendar year and T is: A for Spring, B for Summer (both sessions) and C for Fall.

Srs_Term_Session

Indexed - no
Format - Varchar2(1)
May be Null? Y

SRS session (for summer terms) associated with the transaction.

Stg_Merge_Dt

Indexed - no
Format - Date
May be Null? Y

Date the warehouse was last updated for this record.

Transaction_Amount

Indexed - no
Format - Number
May be Null? Y

Amount of the transaction

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.

User_Id

Indexed - no
Format - Varchar2(120)
May be Null? Y

Banner User ID, identifying who last updated the record in the source system (Pennant Accounts/Banner).

STUDENT_ACCOUNT_DETAIL Table . Tables and Data Elements . Pennant Accounts Home . Data Warehouse Home

Questions about this page? Email us at da-staff@isc.upenn.edu

Information Systems and Computing
University of Pennsylvania
Information Systems and Computing, University of Pennsylvania