This view contains all of the Award and associated information.
Data Loads:
Data is loaded nightly from Kuali.
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 | UCSD Award Sequence Number | UCSD Award Number - Full + UCSD Award Sequence Number | Measure:
All dimensions not listed below |
| 2 | Lowest Level | There are multiple groups of fields that live at a lower grain than the Award + Sequence Number. These groups are not part of a hierarchy and should be considered separately. If you add any field from these groups to your report you will see the Measures that live at a higher grain repeated for each value within these groups. This is expected behavior. | Folders containing these groups of fields include:
|
The lowest level is one row per associated field value.
Key Fields to View:
- UCSD Award Number - Base
- Award OP Reporting Date = the date of processing in Kuali
Key Fields Filter on:
- Award Version Status
- Legacy Tier Indicator
- Legacy Pending Transaction