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.
Note |
---|
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
Additional Notes:
Ui expand | ||
---|---|---|
| ||
Date Fields Description
|
Ui expand | ||
---|---|---|
| ||
There are three types in the data for Ledger Encumbrance Type namely
To our knowledge, the nulls are what most people are looking for to use as the committed and obligated types are transactions that have not yet occurred. If you filter for Ledger Encumbrance Type is null then numbers in your report will should match Oracle (OFC). We have validated a bunch of fund/project/account/function combinations and found there to be a match between FinAH and OFC using this filter. |
Ui expand | ||
---|---|---|
| ||
We sometimes see a setup scenario in OFC where a sponsored project is assigned to more than one award. This seems to happen when they increment the award version from -00001 to -00002. If there are two records with the same base number then always select the -0002 record. |