Versions Compared

Version Old Version 9 New Version 10
Changes made by

Russia Madden

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.

Granularity:

1st Level: Award

2nd Level:Budget Period

One row per Award per Budget Period.


LevelKey (uniqueness / group by)Attributes
1Award

Award Number


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

All fields beginning with the word “Award Budget Period”


Data Loads:

Data is loaded each night.  To see when the data completed being loaded by UCSD into EAH FINAH see this report: Tableau > Public > AH Data Load Status Report

Key Fields:

  • Award Number

Key Fields to use as filters:

  • Award Number


Ui expand
titleData Field Definition

Data Field Definition

  • 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.