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 balance transaction. These are summary level transactions that are posted to the general ledger. The view is at transaction level granularity.
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) | 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 |
Key Fields to View:
- Account
- Accounting Period
- Activity
- Award
- Award Fiscal Manager
- Award Fund Manger
- Award MSO DBO CAO
- Award Principal Investigator
- Award Project Manager
- Entity
- Financial Unit
- Function
- Fund
- Future
- General Ledger
- General Ledger Balances
- Location
- Managerial Reporting Account Hierarchy
- Managerial Reporting Fund Hierarchy
- Program
- Project
Key Fields Filter on:
- Accounting Period
- Ledger Encumbrance Type