STUDENT_ACCOUNT_BALANCE Table - Data Elements   Tables and Data Elements   Pennant Accounts Home   Data Warehouse Home

DETAIL_CODE Table

(dwngss.student_account_balance)

Explanation
The Student Account Balance table shows a summary of all billing transactions per student.

Common Usage examples

• Find total current balances for a population of students.
  
  

BANNER_PIDM
     

BANNER_PIDM

DWADMIN.PERSON
      

• The balance amounts in this table reflects the current state of the data - it does not show historical balances per term. For that, you will need to sum the amounts in the STUDENT_ACCOUNT_DETAIL table.
• Note that in the Business Objects Pennant Accounts universe, this table is joined to DEGREE_TERM_ALL_V on Penn_ID, and where the degree order = 1 (primary degree only). Since term is not a column in STUDENT_ACCOUNT_BALANCE, you will need to specify the term you want by using the term column in DEGREE_TERM_ALL_V.
• In the Business Objects universe, this table is also joined to an alias of PERSON_NODUP_V (a view of person which eliminates duplicates in Penn_ID). This is so you can get the student's Name without having to hop through the other joins to get to the PERSON table or view that is linked elsewhere in the universe. For a graphical representation of how these tables are joined together, see the Universe Diagram.
  

Source

• The Pennant Accounts (Banner) system

DETAIL CODE Table - Data Element Index  Tables and Data Elements   Pennant Accounts Home  Data Warehouse Home