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: Budget Period
One row per Award per Budget Period.
| Level | Key (uniqueness / group by) | Attributes | |
|---|---|---|---|
| 1 | Award | Award Number Tableau report developers: {FIXED[Award Number], [Award Budget Period]:AVG([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
Key Fields:
- Award Number
Key Fields to use as filters:
- Award Number