RAH-SubawardInvoice-View Quick Start Guide

This view contains all of the Subaward Invoice 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.

Cognos developers: Cognos will aggregate the totals at the correct grain.  You can shut off the aggregation as needed.

Tableau developers:  Tableau will aggregate the total for all levels of the view, this will inflate your numbers.  Level of Detail calculations have been built into the Tableau data source based on the measure's the granularity.


LevelKey (uniqueness / group by)Attributes
1Award

UCSD Award Number - Full


Tableau report developers: {FIXED[UCSD Award Number - Full] :MIN([Award...])}

Measures:
  • Award Obligated Direct Cost
  • Award Obligated Indirect Cost
  • Award Obligated Total Cost


2Subaward

Subaward ID


Tableau report developers: {FIXED[Subaward ID]:MIN([Subaward...])}

Measures:
  • Subaward FFATA Required Count
  • Subaward Obligated Direct Cost
  • Subaward Obligated Indirect Cost
  • Subaward Obligated Total Cost
3Subaward Invoice

Subaward Invoice ID


Tableau report developers: {FIXED[Subaward Invoice ID]:MIN([Subaward Invoice...])}

All fields beginning with the word “Subaward Invoice"


The lowest level is one row per associated field value. 

Key Fields to View:

  • Subaward Number
  • Subaward Status
  • Subaward Version Status
  • Subaward Invoice Number

Key Fields Filter on:

  • Subaward Status = ACTIVE
  • Subaward Version Status= ACTIVE


Measures:

Subaward Invoice View

  • Subaward Invoice Total: Reflects Total Invoiced Amount for subaward
  • Subaward Invoice Amount: Use in conjunction with Subaward Invoice Number, otherwise will equal Subaward Invoice Total
  • Subaward Obligated Total Amount: reflect total amount obligated to Subaward.
  • Award Obligate Total Cost: Reflects total amount obligated to Award that is funding the Subaward