Debt Service Dashboard

Last Updated: July 3, 2024 5:20:39 PM PDT

The Debt Service Dashboard provides campus customers with information on timing and amounts due for debt service (principal and interest) on both Internally Funded Loans and Externally Financed Bonds.

The Debt Service Dashboard is available from the Business Analytics Hub (bah.ucsd.edu) under the Central Offices tab.

The dashboard includes:

Debt Service Summary by Sub-VC
Debt Service Summary by Debt Grouping
Debt Service Raw Data
Data Glossary

Access

Access has been provisioned to anyone with the Oracle BI Consumer JR role. Staff who do not have access should request the Cognos role. Access failure appears as error "Unable to load requested view. Displaying home view instead."

Navigate to bah.ucsd.edu.
Select Budget & Finance.
If using the List View, look for Debt Service Dashboard in the list or use the search bar at the top right and click the dashboard name
If using the Card View, click the Central Offices tab and click Launch on the Debt Service Dashboard tile
Use your Active Directory credentials to sign in, if prompted.

Navigation

Here you can find various tips and tricks on navigating Cognos report functionality

Use these parameters to filter for the data you want to view
These filters can be used in combination or individually to produce desired results

Prompt	What to Know
Fiscal Year	This prompt is required. The default selection is set to 2024-2033 (current year +10). Users may deselect default years or select additional years by editing selections within the prompt (CTRL+Click).
Vice Chancellor & Sub Vice Chancellor	These prompts are bopth optional. They are custom fields specific to debt service data and are not aligned directly with the COA Financial Unit Hierarchy. If users only select for Vice Chancellor, the Debt Service Summary tabs will display all associated Sub Vice Chancellor areas. Conversely, if users only select for Sub-Vice Chancelor, the Debt Service Summary tabs will auto populate with the associated Vice Chancellor.
Debt Grouping (Pledge Source)	This prompt is optional. It is based on UCOP debt group classification and is also used for the Internal Loan group.

Report Views

To export the report in PDF, Excel, or CSV, click on the ‘HTML’ button in the toolbar and select your desired output.
Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules.