Department Specific
Find out about business scenarios, data selection, report view options, and data definitions for Department Panoramas available under Budget & Finance in the Business Analytics Hub (bah.ucsd.edu).
Athletics Expenses
The report summarizes Intercollegiate Athletics Expenses on a sport-by-sport basis into NCAA-required reporting categories, and data will be reported to the NCAA and Department of Education
Summary
Business Scenarios
-
The report summarizes Intercollegiate Athletics expenses on a sport-by-sport basis into NCAA-required reporting categories, and data will be reported to the NCAA and Department of Education as a condition of our NCAA membership and to document Title IX compliance in accordance with the Equity in Athletics Disclosures Act
-
An external auditor engaged by UCOP will audit the report, and the transaction details will be provided for the purposes of sample selection. The report may be provided to campus stakeholders on an ad-hoc basis
Data Selection and View Options
- 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
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Guarantees
Amounts paid to visiting participating institutions, including per diems and/or travel and meal expenses. This includes payments made due to game cancellations. On the other side, it is also the revenue received from participation in away games.
Business Scenarios
-
Populates line item transaction details for Guarantees category, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
- The screenshot depicts Head Coaching however it is applicable to Guarantees
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Head Coaching Salaries
Compensation, bonuses and benefits paid to all coaches reportable on the university or related entities W-2 and 1099 forms, as well as non-taxable benefits, inclusive of:
- Gross wages and bonuses.
- Benefits including allowances, speaking fees, retirement, stipends, memberships, media income, tuition reimbursement/exemptions and earned deferred compensation, including those funded by the state
Business Scenarios
-
Populates line item transaction details for Head Coaching Salaries category, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Assistant Coaching Salaries
Business Scenarios
-
Populates line item transaction details for Assistant Coaching Salaries category, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
- Even though Head Coach is referenced on screenshot, parameters are applicable to this report
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- Even though Head Coach is referenced on screenshot, report views are applicable to this report
- Assistant Coaching compensation, bonuses and benefits are paid to all coaches reportable on the university or related entities W-2 and 1099 forms, as well as non-taxable benefits, inclusive of:
- Gross wages and bonuses
- Benefits including allowances, speaking fees, retirement, stipends, memberships, media income, tuition reimbursement/exemptions and earned deferred compensation, including thosefunded by the state
Support Staff
Business Scenarios
-
Populates line item transaction details for Support Staff category, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
- Even though Head Coach is referenced on screenshot, parameters are applicable to this report
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- Even though Head Coach is referenced on screenshot, report views are applicable to this report
Recruiting
Business Scenarios
-
Populates line item transaction details for Recruiting category, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
- Even though Head Coach is referenced on screenshot, parameters are applicable to this report
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- Even though Head Coach is referenced on screenshot, report views are applicable to this report
- Recruiting: Transportation, lodging and meals for prospective student athletes and institutional personnel on official and unofficial visits, telephone call charges, postage and such. Include value of use of institution's own vehicles or airplanes as well as in-kind value of loaned or contributed transportation
Team Travel
Business Scenarios
-
Populates line item transaction details for Team Travel category, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
- Even though Head Coach is referenced on screenshot, parameters are applicable to this report
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- Even though Head Coach is referenced on screenshot, report views are applicable to this report
- Team Travel: Air and ground travel, lodging, meals and incidentals (including housing costs incurred during school break period) for competition related to preseason, regular season and non-bowl postseason. Amounts incurred for food and lodging for housing the team before a home game also should be included. Use of the institution's own vehicles or airplanes as well as in-kind value of donor-provided transportation
Equipment
Business Scenarios
-
Populates line item transaction details for Equipment category, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
- Even though Head Coach is referenced on screenshot, parameters are applicable to this report
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- Even though Head Coach is referenced on screenshot, report views are applicable to this report
- Equipment, Uniforms and Supplies: Items that are provided to the teams only. Equipment amounts are those expended from current or operating funds
Game Expenses
Game-day expenses other than travel which are necessary for intercollegiate athletics competition, including officials, security, event staff, ambulance, etc. Input any payments back to the NCAA for hosting a tournament
Business Scenarios
-
Populates line item transaction details for Game Expenses category, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
- Even though Head Coach is referenced on screenshot, parameters are applicable to this report
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- Even though Head Coach is referenced on screenshot, report views are applicable to this report
Fund Raising
Business Scenarios
-
Populates line item transaction details for Fund Raising category, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
- Even though Head Coach is referenced on screenshot, parameters are applicable to this report
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- Even though Head Coach is referenced on screenshot, report views are applicable to this report
- Fundraising, Marketing & Promotions: Costs associated with fundraising, marketing and promotion for media guides, brochures, recruiting publications and such
Other Expense Categories
Business Scenarios
- Reports all transactions not categorized into the previous reporting categories (Guarantees, Head Coach Salaries, Asst Coach Salaries, etc)
Data Selection and View Options
- 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
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- Sports Camp Expenses: All expenses paid by the athletics department, including non athletics personnel salaries and benefits, from hosting sports camps and clinics
- Studente Athlete Meals (non travel): Meal allowance and food/snacks provided to student athletes
Athletics Revenue
The report summarizes Intercollegiate Athletics revenues on a sport-by-sport basis into NCAA-required reporting categories, and data will be reported to the NCAA and Department of Education
Athletics Revenue
Business Scenarios
-
The report summarizes Intercollegiate Athletics revenues on a sport-by-sport basis into NCAA-required reporting categories, and data will be reported to the NCAA and Department of Education as a condition of our NCAA membership and to document Title IX compliance in accordance with the Equity in Athletics Disclosures Act
-
An external auditor engaged by UCOP will audit the report, and the transaction details will be provided for the purposes of sample selection
-
The report may be provided to campus stakeholders on an ad-hoc basis
Data Selection and View Options
- 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
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
- NCAA distributions including tournament rev: Revenues received from all NCAA distributions including NCAA championships reimbursements and payments received from the NCAA for hosting a championship
- 'Other' field refers to any operating revenues received by athletics in the report year which cannot be classified into one of the stated categories.
Athletic Revenues for Student Fees, Direct Institutional Support, Guarantees, Contributions, Media Rights, NCAA, etc
Business Scenarios
-
Populates line item transaction details for All Athletic Revenue categories, to be provided to the auditors to make selections for audit
Data Selection and View Options
- 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
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules.
- Contributions: provided and used by athletics in the reporting year including:
- Amounts received from individuals, corporations, associations, foundations, clubs or other organizations designated for the operations of the athletics program
- Funds contributed by outside contributors for the payment of debt service, lease payments or rental fee expenses for athletic facilities in the reporting year
- Amounts received above face value for tickets
- Ticket Sales: Revenue received for sales of admissions to athletic events. This may include:
- Public and faculty sales
- Student sales
- Shipping and Handling fees
- Direct Institutional Support: Direct Funds provided by the institution to athletics for the operations of intercollegiate athletics
- Direct Overhead and Administrative Expenses: Overhead and administrative expenses paid by or charged directly to athletics including:
- Administrative/Overhead fees charged by the institution to athletics.
- Facilities maintenance.
- Security
- Risk Management
- Utilities
- Equipment Repair
- Telephone
- Other Administrative Expenses
- Media Rights: All revenue received for radio, television, internet, digital and e-commerce rights, including the portion of conference distributions related to media rights - if applicable
- Conference Distributions: All revenues received by conference distribution, excluding portions of distribution relating to media rights
- Student Fees: Student fees assessed and restricted for support of intercollegiate athletics
- Sports Camp Revenues: Revenues received by the athletics department for sports camps and clinics
Preuss School Financial Reports
Balance Sheet
Business Scenarios
Data Selection and View Options
- 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
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
Income Statement
Business Scenarios
Data Selection and View Options
- 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
Report Views
- Results display in a default table with the ability to export the result set into a file
- Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
