Summary

This view contains the all of the transactions posted below UCSD General Ledger at the interface level.

This view contains only transactions that have posted. This does not include pre-posted, unposted, not approved transactions, not posted, and/or un-processed costs.

In order to see the General Ledger data within Oracle UI you'll need access to General Accounting Dashboard > Inquiry and Analysis Balances

Due to the number of transactions in this view, reports built against this view will run longer that other FINAH views.

When possible, use FINAH-UCSDGeneralLedger-View or FINAH-UCSDGeneralLedgerBalances-View for best performance.

Data Loads

Data is loaded nightly from oracle. To see when the data completed being loaded by UCSD into FINAH see this report: Tableau > Public > AH Data Load Status Report

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)

Measure

1

CCOA Levels

There are multiple groups of fields that live at a higher grain than the Transaction Line. These groups are not part of a hierarchy and should be considered separately.

If you use the measures from this group you will see them repeat with combined with lower grain data.

Example:

Tableau report developers: {FIXED[Entity Code]: MIN([Entity Is Current Count])}

Be sure to use the matching fields.

{FIXED[% Code]: MIN([% Is Current Count])}

All measures in the Flag Measures folder

2

Transaction Line

Transaction Header Code + Transaction Line Code

Tableau report developers: {FIXED[Transaction Header Code], [Transaction Line Code]: MIN([Transaction...])}

All measures starting with Transaction%

3

SLA Line

SLA Event ID + SLA Event Header ID + SLA Event Line Number

Lowest level, no LOD needed.

All measures starting with SLA%

Key Fields to View:

Account
Accounting Period
Activity
Award
Award Fiscal Manger
Award Fund Manager
Award MSO DBO CAO
Award Principal Investigator
Award Project Manager
Entity
Expenditure
Financial Unit
Function
Fund
Future
General Ledger
Journal
Location
Managerial Reporting Account Hierarchy
Managerial Reporting Fund Hierarchy
Program
Project
SLA Event

Key Fields Filter on:

Accounting Period
Ledger Encumbrance Type
SLA Event ID
SLA Event Header ID
SLA Event Line Number
Transaction Header Code
Transaction Line Code

Additional Notes:

Browser not supported