Skip to main content

System Status: 

Debt Service Dashboard

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."

  1. Navigate to bah.ucsd.edu. 
  2. Select Budget & Finance
  3. 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  
  4. If using the Card View, click the Central Offices tab and click Launch on the Debt Service Dashboard tile 
  5. 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.

 

debt prompts

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.

 debt 1

debt 2

debt 4.1

debt 5.1

debt 6