Skip to main content

System Status: 

  1. Home
  2. Finance
  3. BI & Financial Reporting
  4. Information Lookup
  5. Project Information Lookup Panorama

Project Information Lookup Panorama

Last Updated: October 17, 2024 12:16:08 PM PDT
Give feedback

The Project Information Lookup brings back all the Projects for a Business unit, Project Organization or Project Manager and where available it provides full COA and POETAF Chart string values for these Projects.

The Project Information Lookup Panorama is available from the Business Analytics Hub (bah.ucsd.edu) under the Information Lookups tab.

  • The dashboard includes the following reports:
  • Project COA Lookup
  • Award Project Task Personnel
  • Expenditure Type List
  • Non-Sponsored Project Task DFFs
  • Award Personnel

Access

Access has been provisioned to anyone with standard inquiry and reporting access. Staff who do not have access should complete the Oracle and Concur Role Requests Form. Access failure typically appears as an inability to load prompt values.

  1. Navigate to bah.ucsd.edu.
  2. Select Budget & Finance. 
  3. If using the List View, look for Project Information Lookup Panorama 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 Information Lookups tab and click Launch on the Project Information Lookup Panorama tile 
  5. Use your Active Directory credentials to sign in, if prompted.

Project COA Lookup

Business Scenarios

  • Determine the full chart of accounts string for a project

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

prompt update


Report Views

  • Results display in a table of 22 columns
  • Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules
  • Project/Tasks that have not had any activity recorded will not have any Chart of Account (CoA) segments available 
  • Oracle does not populate the full CoA until activity has been recorded to the system

 report

Award Project Task Personnel

Business Scenarios

  • Determine what personnel have been assigned to specific roles on a project

Data Selection and View Options

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

 prompt

 

Report Views

  • Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

report 

Expenditure Type List

Business Scenarios

  • View expenditure types along with description, account number, and expenditure category

Data Selection and View Options

  • Use these parameters to filter for the data you want to see
  • These filters can be used in combination or individually to produce desired results
  • The report is designed to bring back all Expenditures

Expenditure-Type-List_p.png

Report Views

  • Results display in a table of 5 columns
  • Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

 Expenditure-Type-List_rv.png

Non-Sponsored Project Task DFFs

Business Scenarios

  • View of all data flex fields on each task for a specific project

Data Selection and View Options

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

Screen-Shot-2022-08-19-at-10.48.07-AM.png

 

Report Views

  •  
  • Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

 Screen-Shot-2022-08-19-at-10.48.22-AM.png

Award Personnel

Business Scenarios

  • Determine what personnel have been assigned to specific roles on an award

Data Selection and View Options

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

awardpersonnel_data.png

 

Report Views

  •  
  • Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules

 awardpersonnel_report.png

Release Notes & Communications

Date Release Notes & Communications
10/15/2024 Budget & Finance Weekly Digest Project COA Lookup: Project Nickname has been added.
8/13/2024 Budget & Finance Weekly Digest Project COA Lookup: Added columns for Project Fund Manager and Task Fund Manager to enable users to identify the fund manager responsible for the chartstring.
4/25/2023 Budget & Finance Weekly Digest

Project COA Lookup: A new parameter has been added to the Project COA Lookup for “Fund starts with (First Character only)” to help narrow down searching for gift funds on the report.
5/9/2023 Budget & Finance Weekly Digest

Project COA Lookup: A new filter for “Fund Starts With (First Character Only)” has been added to the Project COA Lookup report.  Use this filter to search for all chartstrings for a particular category of gift funds.
12/12/2023 Budget & Finance Weekly Digest

Project COA Lookup: a Project Class Code prompt has been added to allow users to identify chartstrings and other project information for groups of similarly classified projects, such as Faculty Start-Up or GSGEI.