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

STUDENT_ACCOUNT_DETAIL Table

(dwngss.student_account_detail)

Explanation
Contains transactional details for all student billing charges and payments.

Common Usage examples

• Find the detail charges and payments for a population of students in a specific term.
  
  

BANNER_PIDM
TRANSACTION_NUMBER
    

BANNER_PIDM
TRANSACTION_NUMBER
PENN_ID
SRS_TERM

      

DWADMIN.DEGREE_TERM
DWNGSS.STUDENT_ACCOUNT_PAID_APPLIED
DWNGSS.STUDENT_ACCT_GL_DETAIL
DWNGSS.DETAIL_CODE
      

• For people using a query tool other than Webi, when joining to DEGREE_TERM, be sure to specifiy DEGREE_ORDER = 1 (or specify the specific type of division and degree you want to query). Otherwise, you will pick up two rows for students in dual degree programs, which will inflate the summary amounts from Pennant. Note: the Business Objects Pennant Accounts universe already enforces the DEGREE_ORDER = 1 restriction.
• Some records in Pennant Accounts do not have a corresponding term record in SRS. This is because billing can occur and then the student can defer or drop out, resulting in their term data being removed. Similarly, but occurring less frequently: some records in the SRS Term data do not have corresponding STUDENT_ACCOUNT_DETAIL data. Outer joins between DEGREE_TERM and STUDENT_ACCOUNT_DETAIL are recommended. Note: the Business Objects Pennant Accounts universe already provides the outer join between these two tables.
• 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_DETAIL Table - Data Element Index  Tables and Data Elements   Pennant Accounts Home  Data Warehouse Home