SAH-AR-Transaction-View Quick Start Guide
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 , SAH Core Views Quick Start Guides and SAH-AR Views
Overview
The following article is a start guide for those using SAH-AR-Transaction-View.
If you are looking to report on AR Transaction but do not need the financial accounting behind the transaction then start with this view. If you are looking for the financial accounting behind the transaction then use the SAH-AR-TransactionDetail-View.
Critical Concepts
Unique to this View
One row per transaction, includes Student PID and Detail Code details on that transaction.
Pre-joined with SAH-Demographics-View and SAH-StudentStatsPerTerm-View
Pre-Joined Data
SAH-Demographics-View per Student ID
SAH-StudentStatsPerTerm-View per Student ID
Masked Data
The contents of the following fields will only be available to those who have requested access.
SIS Detail Code Description
SIS Detail Code Description Short
SIS Category Code
SIS Category
SIS Category Description
Steps to Take
Key Fields to Display
SIS Account ID
SIS Transaction Date
SIS Category
SIS Detail Type
Key Fields to Filter on
SIS Account ID
Granularity
Granularity is the scale or level of detail present in a set of data. It identifies where levels of uniqueness exists in the data. The data lives in the view at the lowest level, but each BI tool totals the levels differently.
Please note: The Level of Detail (LOD) calculations listed here for Tableau developers are a baseline and do not necessary include all of the LOD equations needed for your report.
| Level | Key ( uniqueness / group by) | Measures |
|---|---|---|---|
1 |
|
|
|
2 |
|
|
|
3 |
|
|
|
4 |
|
|
|
5 |
|
|
|
If you still have questions or need additional assistance, please submit a ticket or email busintel@ucsd.edu