Summary:

This view includes Project that are sponsored and non-sponsored (such as general) - see the field Project Type
This view includes Award data associated with Sponsored Projects

Data Loads:

Data is loaded each night. To see when the data completed being loaded by UCSD into FINAH see this report: Tableau > Public > AH Data Load Status Report

Granularity:

Granularity is the scale or level of detail present in a set of data. It identifies where levels of uniqueness exists in the data. The data lives in the view at the lowest level, but each BI tool totals the levels differently.

	Level	Key (uniqueness / group by)	Attributes
1	Award	Award Number	All fields beginning with the word “Award”
2	Award Budget Period	Award Number + Award Budget Period ID Tableau report developers: {FIXED[Award Number], [Award Budget Period ID]:MIN([Award Budget Period....])}	All fields beginning with the word “Award Budget Period”
3	Project	Award Number + Project ID Tableau report developers: {FIXED[Award Number],[Project ID]:MIN([Project......])}	All fields beginning with the word “Project” and "Financial Unit" except those beginning "Project Budget Period' and "Project Funding Issue"
4	Project Budget Period	Award Number + Project ID + Project Budget Period ID Tableau report developers: {FIXED[Award Number],[Project ID],[Project Budget Period ID]:MIN([Project Budget Period......])}	All fields beginning with the word “Project Budget Period"
5	Project Funding Issue	Award Number +Award Budget Period + Project ID + Project Budget Period ID +Project Funding Issue Number Tableau report developers: {FIXED[Award Number],[Award Budget Period],[Project ID],[Project Budget Period ID],[Project Funding Issue Number]:MIN([Project Funding Issue......])}	All fields beginning with the word “Project Funding Issue”

Key Fields:

Award Number
Project ID

Key Fields to use as filters:

Award Number
Project ID

Additional Notes:

Project is tied to sponsored and tied to the Award and the Award data will be populated.