Graduate Student Funding Report

Access has been provisioned to anyone with the Oracle BI Consumer JR role.  Staff who do not have access should request the Oracle 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 Graduate Student Funding Report in the list or use the search bar at the top right and click the dashboard name
   • If using the Card View, click the Financial Accountability tab and click Launch on the 
   • Graduate Student Funding Report tile
4. Use your Active Directory credentials to sign in, if prompted.

• 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

1. Under Choose a Date Search Option, select either Accounting Period or Expenditure Item Date (required). 
   1. Accounting Period: Use this option to identify charges that were accounted during a given time period.  Choose From and To Accounting Periods.
   2. Expenditure Item Date: Use this option to identify charges that were incurred during a given time period.  Choose From and To Expenditure Item Dates.
2. Display Reports prompt is multi-select with a default selection of “transactions”.
3. Student PID, Student Name, Graduate Primary Major Department, Financial Unit, Hiring Department, Project, and Expenditure Type are all select and search, multi-select prompts.
   1. Graduate Primary Major Department: Use this option to view funding for students earning degrees in your department, regardless of how they are funded.
   2. Financial Unit: Use this option to view funding for students paid by your department, regardless of their degree department.
   3. Hiring Department: Use this option to view funding for students hired by your department. Use of this prompt will only return payroll data.
4. Personnel Prompts:
   1. PI/PM/TM is a multi-select prompt that will display results for all students paid on a award / project / or task for the Principal Investigator, Project Manager, or Task Manager selected.
   2. MSO/DBO/CAO, Fiscal Manager, and Fund Manager are single-select prompts that will display results for all students paid on a project for the personnel selected.

This report combines data from three different activity hubs:

1. Student Activity Hub
   1. Source: SIS
   2. Fields: Student PID, Student Name, Degree Type, Admit Term Year, Primary Major Department
2. Financial Activity Hub
   1. Source: PPM Subledger
   2. Transactions: Stipends, Tuition and Fees
   3. Fields: Chartstring information
3. Employee Activity Hub
   1. Source: Labor Ledger
   2. Transactions: Payroll
   3. Fields: Employee ID, Student PID, Chartstring information 

Transactions Tab: Use this report to view transaction-level data associated with each student.

Summary Tab: Use this report to view a summary of total expenses by month associated with each student.

Note: This view is best displayed when selected the accounting period date search option.

Payroll Projections Tab: Use this report to view payroll projection by month associated with each student.

Short answer: because they haven’t posted.

Why haven’t they posted?