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 Number - Base | ||
| 2 | UCSD Award Sequence Number | UCSD Award Number - Full + UCSD Award Sequence Number |
|
| 3 | Lowest Level |
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
| Ui expand | ||
|---|---|---|
| ||
IP or Award with Keyword like %Covid%. |
| Ui expand | ||
|---|---|---|
| ||
Many fields are manually entered into Kuali. If there is a change in spelling then the reporting tool will see the various data at a new row of data. The following fields are often affected:
Include the following fields in your report to clarify differences: Award Number Base |
| Ui expand | ||
|---|---|---|
| ||
Filters:Award Version Status in Active (for most recent), Archive (for Coeus) Legacy Tier Indicator in '-', Tier 3 (so you only get transactions). Kuali records will be '-' and Coeus Legacy Pending Transaction <> 'Y' Award OP Reporting Date = the date of processing in Kuali Measures:Award Obligated Direct Cost Award Obligated Indirect Cost Award Obligated Total Cost |