Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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.


LevelKey (uniqueness / group by)Attributes
1UCSD Award Number - Base

2UCSD Award Sequence NumberUCSD Award Number - Full + UCSD Award Sequence Number
  • "Award Obligated Direct Cost",
  • "Award Obligated Indirect Cost",
  • "Award Obligated Total Cost",
  • "Award Anticipated Direct Cost",
  • "Award Anticipated Indirect Cost",
  • "Award Anticipated Total Cost",
  • "Award Pending Direct Amount",
  • "Award Pending Indirect Amount",
  • "Award Pending Total Amount",
  • "Award Investigator Count - COI",
  • "Award Investigator Count - PI",
  • "Award Investigator Count - Total"
3Lowest 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
  • No labels