Overview

Supporting blended financial reporting and analysis, the Financial Activity Hub (FinAH) is a central repository for UC San Diego enterprise system data as it relates to all financial activity across relevant systems.

This hub contains data from current and future financial systems, including ledger, budget and student financial information. Activity pattern analysis, budget and forecast reporting, multi-fund analysis and tuition revenue modeling is available using the Cognos visualization tool. Blending the financial data from FinAH with other Activity Hubs is supported in Cognos.

Other Resources

Have a field name but not sure what view to look in? Search the Data Dictionary

Finance Office Hours Support

Data is loaded each night. To see when the data completed being loaded by UCSD into FINAH see this report: AH-Data Load Status Report

FINAH Basics

Data in Oracle is separated into various modules. FINAH focuses on General Ledger and PPM. PPM data in Oracle is further broken down to Revenue and Costs (aka Expenditures).

Recommended Knowledge

Read the Overview of Project Portfolio Management (PPM) with Attached PPM User Guide

Learn more about GL-PPM Reconciliation

Relationships

Types of Funds

Fund Type

Definition

Derived Fund

The fund that is associated with the project-task based on award setup for sponsored projects or project setup for non-sponsored projects.

For Sponsored Projects:

"Expenditure Funding Source Code" is internal / 5-digits, then use the "Expenditure Funding Source Code".
If "Expenditure Funding Source Code" is not internal / 5-digits then used the match on the Award Type to find the Fund Code.
If "Expenditure Funding Source Code" is not internal / 5-digits and "Award Type" = Special State Appropriations, then match on the "Award Sponsor REMS Code" to find the Fund Code.

Derived UC Path Fund

The Fund that should be used in UC Path chart strings based on the project/task/award accounting rules. Note, the Derived UC Path Fund and Derived Fund and Fund can differ.

See FIS OFC-017 FIS Automation of OFC Chart String for Sponsored and General Projects (D)

Fund

Fund listed on the General Ledger Accounting lines.

Find the View You Need

In general, use the summary view and move to the detail view if needed. Most popular views are highlighted in green.

View Type	View Name aka Cognos Package / Tableau Data Source View	Use this view when you are looking for...	Includes measures?
Core	FINAH-Account-View	All Accounts, even thoughts with no transactions, no measures. Helpful for speeding up Cognos prompts.	No measures
Core	FINAH-Activity-View	All Activities, even thoughts with no transactions, no measures. Helpful for speeding up Cognos prompts.	No measures
Core	FINAH-Award-View	All Awards with Award and Award Budget Period level measures.	Yes measures
Restricted	FINAH-BudgetAdjustments-View
Core	FINAH-ChartStringCombination-View	All Chart Strings that exist in Oracle, even thoughts with no transactions. This is only those with transactions and those created by the Oracle API.	Yes measures
Core	FINAH-Contract-View	All Contracts with Contract level measures.	Yes measures
Core	FINAH-ContractInvoiceDetail-View	Focused on Contract Invoice information.	Yes measures
Core	FINAH-ContractRevenue-View	All Contracts with revenue. Includes Project information.	Yes measures
Core	FINAH-ContractVersion-View	All historical statuses of all contract versions.	Yes measures
Core	FINAH-Entity-View	All Entities, even thoughts with no transactions, no measures. Helpful for speeding up Cognos prompts.	No measures
Restricted	FINAH-EPBCSSecurityAccess-View	Details of who has what access to EPBCS	Only flag measures
Core	FINAH-FinancialUnit-View	All Financial Units. Helpful for speeding up Cognos prompts.	Yes measures
Restricted	FINAH-FoundationAccount-View	All Foundation Accounts, no measures. Helpful for speeding up Cognos prompts.	No measures
Restricted	FINAH-FoundationInvestmentPool-View	All Foundation Investment Pools, no measures. Helpful for speeding up Cognos prompts.	No measures
Core	FINAH-Function-View	All Functions, no measures. Helpful for speeding up Cognos prompts.	No measures
Core	FINAH-Fund-View	All Funds, no measures. Helpful for speeding up Cognos prompts.	No measures
Core	FINAH-Interentity-View	All Interentities, no measures. Helpful for speeding up Cognos prompts.	No measures
Core	FINAH-Location-View	All Locations, no measures. Helpful for speeding up Cognos prompts.	No measures
Core	FINAH-PPMBalances-View	A combination of some elements from FINAH-PPM-TransactionDetail-View and aggregated measures (aka Balances). The FINAH-PPM-Balances-View will display the budget as point-in-time and specific costs at specific times. Balances will be displayed per Accounting Period (monthly). This will allow new reporting options around point-in-time budget reporting.	Yes measures
Core	FINAH-PPM-TransactionDetail-View	This view brings together Project Cost Detail, Revenue Detail and Commitment data. This is an extremely detailed view and can be slower that other views. Transaction Last Updated DateTime = Timestamp that indicates when the data was loaded	Yes measures
Core	FINAH-Project-View	All Projects. Helpful for speeding up Cognos prompts.	Yes measures
Core	FINAH-ProjectCostAdjustments-View	Focused on adjustments and includes details on where a cost is transferred from and to. This view will also include items that in in 'pending'.	Yes measures
Core	FINAH-ProjectCosts-View	All costs and expenditures from multiple levels of the Project. Includes Sponsored Contracts (aka Awards). Lowest level transaction. Cannot include tasks or non-sponsored contracts because Projects can have multiple Tasks or multiple non-sponsored Contracts. Can answer: Where are my ______ charges? What can you tell me about the Project? Which project classifications have contract revenue? What is the Task Source Reference? Expenditure Last Updated DateTime = Timestamp that indicates when the data was loaded	Yes measures
Core	FINAH-ProjectPersonnelRole-View	All personnel by role.	Yes measures
Core	FINAH-ProjectUnprocessedCost-View	focused on adjustments and includes details on where a cost is transferred from and to. This view will also include items that in in 'pending'. Unprocessed costs are created when subledgers or users create PPM transactions that cannot post as written because a data element is missing (i.e. POETAF requires a funding source and none was given) or a project is not in Active status, or the expenditure date is outside the project/task start and end dates, etc. The transactions post to an unprocessed costs table, which transaction creators must review, make corrections, and repost the costs. When the unprocessed costs are processed, they are removed completely from the unprocessed costs table.	Yes measures
Restricted	FINAH-ResourceCommitment-View	*Includes row level security from EPBCS	Yes measures
Core	FINAH-TE-ExpenseTransactionDetail-View	Details about Travel & Expense transactions	Yes measures
Core	FINAH-TE-ExpenseWorkflow-View	Focused on the workflow process related to travel expenses.	Only flag measures
Core	FINAH-TE-RequestDetail-View	Builds on the FINAH-TE-ExpenseTransactionDetail-View to include Request level information.	Yes measures
Core	FINAH-TE-User-View	Focused on Travel & Expense users.	Only flag measures
Core	FINAH-TE-UserDelegate-View	Builds on the FINAH-TE-User-View to include Delegate information.	Only flag measures
	FINAH-UCSDGeneralLedger-View	General Ledger summary data. Can answer: Did my _______ money come in? Do the aggregated totals match? Did expenditures get posted directly to the General Ledger? What have we spent this fiscal year? Did items post where they were expected to? Transaction System Date Time = Timestamp that indicates when the data was loaded	Yes measures
Core	FINAH-UCSDGeneralLedgerBalances-View	General Ledger summary data and Budget information. Transaction System Date Time = Timestamp that indicates when the data was loaded	Yes measures
Core	FINAH-UCSDGeneralLedgerInterface-View	All Transactions posted below UCSD General Ledger at the interface level. Due to the many transactions, reports using this view will take longer to run. When possible, use FINAH-UCSDGeneralLedger-View or FINAH-UCSDGeneralLedgerBalances-View for best performance. Transaction System Date Time and SLA Event Last Updated Date Time = Timestamp that indicates when the data was loaded	Yes measures
Core	FINAH-UCSDGeneralLedgerPeriod-View	Focused only on the UCSD Accounting Period.	Only flag measures

Related Views

Dats Sources

Description

To match get "Award Budget Period Funding Amount" to match what I see in Oracle.

New enhancement: "Award Budget Period Funding Amount" is now includes both the supplemental and base amount. Therefore "Award Budget Period Funding Amount" from FinAH and "Award Funding Amount" from ORACLE should now match.