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

STUDENT_ACCOUNT_PAID_APPLIED Table

(dwngss.student_account_paid_applied)

Explanation
Contains the sum of all payments against each transaction for each student.

Common Usage examples

• Find total applied amounts for a population of students.
• Using joins to STUDENT_ACCOUNT_DETAIL and from there to DETAIL_CODE, find applied amounts for specific detail code CATEGORIES.
  
  

BANNER_PIDM
TRANSACTION_NUMBER
     
      

BANNER_PIDM
TRANSACTION_NUMBER
      

DWNGSS.STUDENT_ACCOUNT_DETAIL

• Pennant Accounts contains transactional information as of Fall 2015. Earlier detail data is available for the conversion population only. See Refresh Schedule for explanation...

Source

• The Pennant Accounts (Banner) system.

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