FINAH-ContractRevenue-View Quick Start Guide
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.
| Level | Key (uniqueness / group by) | Attributes | |
|---|---|---|---|
| 1 | Contract Code | Contract Code Tableau report developers: {FIXED[Contract Code] : MIN([Contract....])} | All fields in Contract Measures beginning with the word “Contract” except "Contract Line". |
| 2 | Contract 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". |
| 3 | Revenue 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". |
| 4 | Project 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