Versions Compared

Old Version 4

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.

All ve $All Contract tied to general projects and sponsored projects with revenue.  Includes Project information.

Data Loads:

Data is loaded nightly from oracle.  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
1Contract Code

 Contract Code

Tableau report developers: {FIXED[Contract Code] : MIN([Contract....])}

All fields in Contract Measures beginning with the word “Contract” except "Contract Line".


2Contract Line Number

Contract Code + Contract Line Number

Tableau report developers: {FIXED[Contract Code],[Contract Line Number] : MIN([Contract Line....])}

All fields in Contract Measures beginning with the word "Contract Line".
3Revenue Dist Number

Contract Code + Contract Line Number + Revenue Dist Number

Tableau report developers: {FIXED[Contract Code],[Contract Line Number],[Revenue Dist Number] : MIN([Revenue Dist....])}


All fields in Contract Revenue Measures beginning with the word "Revenue Dist".
4Project Code

Contract Code

Tableau report developers: {FIXED[Project Code] : MIN([Project....])}

All fields in Project Measures 






















Key Fields:

  • Award Number
  • Contract ID


Key Fields to use as filters:

  • Award Number
  • Contract ID


Additional Notes:


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.


Ui expand
titleContract
  • 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.


Ui expand
title Most Recent Project Manager Name Full
  • Last Project Manager after end dateIf the project manager assigned to a project in OFC is end dated and there is no current assignment, then project manager will show “null” in the project cost view. The Most Recent Project Manger Name Full will show the latest project manager name full.

Image Added


Ui expand
title Most Recent Project Fund Manager Name Full
  • Last Project Fund Manager after end date

    If the project fund manager assigned to a project in OFC is end dated and there is no current assignment, then project fund manager will show “null” in the project cost view. The Most Recent Project Fund Manger Name Full will show the latest project fund manager name full.