Versions Compared

Old Version 20

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

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

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
1Award

Award Number


All fields beginning with the word “Award” except those beginning with "Award Budget Period"
2Award Budget Period 

Award Number + Award Budget Period


Tableau report developers: {FIXED[Award Number], [Award Budget Period]:MIN([Award Budget Period....])}


All fields beginning with the word “Award Budget Period” 

One row per Award per Budget Period.


Key Fields:

  • Award Number
  • Award Budget Period

Key Fields to use as filters:

  • Award Number
  • Award Budget Period

Additional Notes:


Ui expand
titleAward Budget Period
  • Award Budget Period is the level of details up for those amount that can be aggregated up to the award amount without having to do any flexibility by the report developer.  Award Budget Period can be one or many periods.


Ui expand
titleAward Sponsor

Award Flow Through Sponsor

  • The Award Flow Through Sponsor is the prime sponsor in research on Kuali or RAH. 

Award REMS Sponsor

  • The REMS fields are fields from UC system wide registry for all sponsors and that system is called REMS.  These REMS fields were adding flow through from that system to RAH.  In OFC,  we have sponsor flow through sponsor code and sponsor name. These REMS fields are blending from RAH which are originated in system wide registry.