SAH-AR Views
Add yourself as a Watcher to this page to be automatically emailed with any changes to this page.
This page assumes you have read SAH Quick Start Guides and SAH Core Views Quick Start Guides
Overview
The following article is a start guide for those using SAH-AR Views.
SAH displays the data available from ISIS and TSS with no pre-filters. We are aware that some data has been archived and is no longer available from ISIS.
Critical Concepts
ISIS Data in TSS
July 30, 2026 was the cut-over date for moving ISIS Student AR data into TSS.
Only active records were moved into TSS, this includes unpaid transactions and open deposits.
PIDs
SAH-AR includes more than Student PIDs as more than Students can make payment. Use these fields to find the PIDs for other types of payers.
SIS Transaction Internal Ref ID
SIS Transaction Description
SIS AR Data Source and SIS Data Source
Are these the same?
No. SIS AR Data Source is based on the AR transaction rows. SIS Data Source is based on the Student rows.
But they match?
Most of the time, yet. Only when the payment is made from a non-Student account with the SIS Data Source be null.
SIS Transaction Term Code and Term Code
Are these the same?
No. SIS Transaction Term Code is based on the AR transaction rows and only populated in ISIS. Term Code is based on the Student rows from ISIS on ISIS rows and from TSS on the TSS rows.
SAH-AR and FINAH
Several SAH-AR views include Oracle data in order to help analysts compare what is in AR and what has posted to Oracle. The fields seen in SAH-AR are based on the AR data. To see the Oracle data you will need to use FINAH. When comparing SAH-AR to FINAH you will see additional rows in FINAH, these are offset transactions that only exist in Oracle and get created during the data integration process.
Suggested SAH-AR fields to use include:
SIS Original Transaction Number
Suggested FINAH fields to use include:
Transaction Description
Chart Combination Chartstring
Journal Source
SAH-AR Views
View Type | View Name | Pre-Joined With | Grain |
|---|---|---|---|
Core w/ Masking | SAH-AR-Clearing-View |
|
|
Core w/ Masking | SAH-AR-ClearingDetail-View |
|
|
Core | SAH-AR-DepositDetail-View |
|
|
Core | FINAH PPM segments FINAH CCOA as columns | One row per Detail Code per Detail Code Distribution | |
Core | FINAH CCOA | One row per Detail Code | |
Core w/ Masking | SAH-Demographics-View SAH-StudentStatsPer-Term-View | One row per Transaction | |
Core w/ Masking | SAH-Demographics-View per Student ID SAH-StudentStatsPerTerm-View per Student ID FINAH CCOA FINAH Managerial Reporting Account Hierarchy and Managerial Reporting Fund Hierarchy | One row per CCOA chartstring per transaction. Which means multiple rows per transaction. | |
Restricted no masking | SAH-AR-Clearing-Restricted-View |
|
|
Restricted no masking | SAH-AR-ClearingDetail-Restricted-View |
|
|
Restricted no masking | Same as SAH-AR-Transaction-View | Same as SAH-AR-Transaction-View | |
Restricted no masking | Same as SAH-AR-TransactionDetail-View | Same as SAH-AR-TransactionDetail-View |
If you still have questions or need additional assistance, please submit a ticket or email busintel@ucsd.edu