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

STUDENT_ACCOUNT_GL Table

(dwngss.student_account_gl)

Explanation
Student Account General Ledger table, showing the paired debit and credit transactions actually sent to the GL.

Common Usage examples

• Find the journal batch name and journal reference number for the debit and credit transactions sent to the GL.
  
  

ID
CR_DR_IND
     
      

ID
CR_DR_IND

DWNGSS.STUDENT_ACCT_GL_DETAIL

• ID is not unique on this table - each ID will be repeated twice - once each for the debit and credit sides of the transaction. To get back only one row, restrict your query to either CR_DR_IND = 'C' or CR_DR_IND = 'D'
• Transactions are rolled up when they are sent to the GL. There can be more than one row in STUDENT_ACCT_GL_DETAIL related to the paired rows in STUDENT_ACCOUNT_GL. Avoid a many-to-many relationship by joining on GFC_KEY and CR_DR_IND.

Source

• The Pennant Accounts (Banner) system

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