FINAH-UCSDGeneralLedger-View Quick Start Guide
This view contains the all of the transactions posted to the UCSD General Ledger including all encumbrances and actuals.
- This view only transactions that have posted. This does not include pre-posted, unposted, not approved transactions, not posted, and/or un-processed costs.
- This view does not contain sub-ledger information.
- Start here and then branch out as needed.
In order to see the General Ledger data within Oracle UI you'll need access to General Accounting Dashboard > Inquiry and Analysis Balances
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:
One row per general ledger transaction. These are summary level transactions that are posted to the general ledger. The view is at transaction level granularity.
Please note: Only objects with transactions are included in this view and only objects with transactions in the source Oracle table.
| Level | Key (uniqueness / group by) | Measures | |
|---|---|---|---|
| 1 | Transaction Amount | Tableau report developers: { FIXED [Transaction Line Code], [Transaction System Counter] : SUM([Transaction Amount]) } | |
| 2 | |||
| 3 | |||
| 4 | |||
| 6 | |||
| 7 | |||
| 8 |
Key Fields to View:
- Account
- Award
- Function
- Fund
- Location
- Program
- Project
Key Fields Filter on:
- Accounting Period
- Ledger Encumbrance Type