SAH-AR Views

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

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

SAH-AR-DetailCodeAccountingNarrow-View

FINAH PPM segments

FINAH CCOA as columns

One row per Detail Code per Detail Code Distribution

Core

SAH-AR-DetailCodeAccountingWide-View

FINAH CCOA

One row per Detail Code

Core w/ Masking

SAH-AR-Transaction-View

SAH-Demographics-View

SAH-StudentStatsPer-Term-View

One row per Transaction

Core w/ Masking

SAH-AR-TransactionDetail-View

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

SAH-AR-Transaction-Restricted-View

Same as SAH-AR-Transaction-View

Same as SAH-AR-Transaction-View

Restricted

no masking

SAH-AR-TransactionDetail-Restricted-View

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