This view contains all of the basic Award financial information. Awards are sponsored contracts. Every award is a contract, not every contract is an award. Only a contract that becomes sponsored that becomes an award.
Granularity:
1st Level: Award
2nd Level: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” except those beginning with "Award Budget Period" | |
| 2 | Award Budget Period | Award Number + Award Budget Period Tableau report developers: {FIXED[Award Number], [Award Budget Period]: | AVGMIN([Award Budget Period....])}
| All fields beginning with the word “Award Budget Period” |
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| Period” |
One row per Award per Budget Period.
Key Fields:
- Award Number
Key Fields to use as filters:
- Award Number
| Ui expand | ||
|---|---|---|
| ||
Data Field Definition
|