Versions Compared

Old Version 13

changes.mady.by.user Saparnell

Saved on

compared with

New Version Current

changes.mady.by.user Mohamed Al-Omar

Saved on

Key

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

Note:

  • Some of the names are slightly different between FINAH-Projectcosts-View, FINAH-ContractRevenue and FINAH-PPM-Transaction-View b/c in order to blend the data the field names were made more generic. Ie. Transaction instead of Expenditure where an expenditure is a type of transaction.


Table of Contents

Summary

This view brings together Project Cost Detail, Revenue Detail and Commitment data.  There are six different transaction types in this view: PPM Budget, Commitment (aka Expenditures In Progress), Expenditures (aka Costs), Revenue and Payroll Projections.  

Ui expand
titleFields to Transaction Types


Transaction TypeCommitmentCommitment IDC AdjustmentExpenditureFunding IssuePayroll ProjectionBudget (PPM)Revenue
All task attributesxxx
xxx
All project attributesxxxxxxx
All award attributesxxxxxxx
All contract attributes (based on transaction)xxx


x
All budget period attributesxxxxxxx
Expenditure Categoryxxx
xxx
Revenue Categoryxxx
xxx
Revenue Category Direct Indirectxxx
xxx
Transaction IDx
xx

x
Transaction Numberx
xx

x
Transaction Dist IDx
x


x
Transaction Datexxxx

x
Transaction Descriptionx
xx

x
Transaction Expenditure Type xxx



Transaction Supplier IDx
x



Transaction Supplier Codex
x



Transaction Supplierx
x



Transaction Supplier Code And Namex
x



Transaction Invoice NumberX* from Accounts Payable (AP)
X* from Accounts Payable (AP)


X* from Accounts Receivable (AR)
Transaction Invoice IDX* from AP
X* from AP


X* from AR
Transaction Invoice DateX* from AP
X* from AP


X* from AR
Transaction Invoice Line Requester Name Full

X*



Transaction PO Numberx
x



Transaction PO IDx
x



Transaction PO Linex
x



Transaction Bill Event Type





x
Original Transaction Reference

x



Transaction Document

x



Transaction Line Typexxxx


Transaction Accounting Datexxx


x
Transaction Accounting Periodxxx


x
Transaction Fiscal Period Fullxxx


x
Transaction Fiscal Period Numberxxx


x
Transaction Fiscal Period Shortxxx


x
Transaction Fiscal Day (DDD)xxx


x
Transaction Fiscal Month (MM)xxx


x
Transaction Fiscal Quarter (Q)xxx


x
Transaction Fiscal Week (WW)xxx


x
Transaction Fiscal Yearxxx


x
Transaction Fiscal Year (YYYY)xxx


x
Transaction Fiscal Period Start Datexxx


x
Transaction Fiscal Period End Datexxx


x
Commitment Raw Costx





Commitment Burdened Costx





Commitment Indirect Costx





Commitment Burdened Cost Adjusted for IDCxx




Expenditure Raw Cost

x



Expenditure Burdened Cost

x



Project Funding Issue Amount


x


Revenue Amount





x
Task Budget Period Budget Amount




x

Task Budget Period Payroll Projection Amount

(Aggregation of EAH data)





x



When to use this view

This view includes a more diverse set of transaction without the number of details on each transaction type.

  1. Are you looking for every detail of Costs?  Use FINAH-ProjectCosts-View.
  2. Are you looking for every detail and attribute of Revenue?  Use FINAH-ContractRevenue-View.
  3. Do you need Commitment details?  Use this view.

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.


Note

Please note:  The Level of Detail (LOD) calculations listed here for Tableau developers are a baseline and do not necessary include all of the LOD equations needed for your report.


LevelKey (uniqueness / group by)Measures
Award

Award Number

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

All measures beginning with the word “Award”
Project

Project ID

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


All measures beginning with the word “Project”

Task


Task ID

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


All measures beginning with the word “Task” except:

  • "Task Budget Period Payroll Projection Amount"
  • "Task Budget Period Budget Amount"



Contract

Contract ID

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

All measures beginning with “Contract"

Transaction PO Line

Transaction PO ID + Transaction PO Line Number

Tableau report developers: {FIXED ([Transaction PO ID], [Transaction PO Line Number]): MIN([Transaction PO Line...])}

All measures beginning with "Transaction PO Line"
Transaction Invoice ID

Transaction Invoice ID

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

All measures beginning with "Transaction Invoice"
Transaction Distribution

Transaction Type + Transaction ID + Transaction Dist ID

No LOD in Tableau needed

All measures in the following folders:

  • Commitment Measures
  • Expenditure Measures
  • Revenue Measures

And the following fields:

  • Task Budget Period Payroll Projection Amount

  • Task Budget Period Budget Amount


Key Fields to View


  • Transaction ID
  • Transaction Type
  • Transaction Line Type
  • Expenditure Category
  • Revenue Category
  • Award fields
  • Project fields


Key Fields Filter on

  • Transaction Accounting Period
  • Expenditure Category
  • Revenue Category
  • Transaction Type
  • Transaction Line Type


Additional Notes

The source of "Transaction Date" in this view depends on the "Transaction Type".

Commitments = expenditure item date/the date on which the commitment cost was incurred.

Commitment IDC Adjustments = expenditure item date/the date on which the commitment cost was incurred.

Expenditure = expenditure item date

Funding Issue = funding issue date

Payroll Projection = null (not used)

Budget (PPM) = null (not used)

Revenue = transaction date/the date the transaction occurred



Ui expand
titleGeneric Field Names
Expenditure and Revenue fields from other Views have slightly different names in FINAH-PPM-Transaction-View due to the fact that this view combines both transaction types.



Ui expand
titleMeasures

Measures are only populated for their corresponding Transaction Type

Transaction TypePPM BudgetCommitmentCommitment IDC AdjustmentExpenditureRevenuePayroll Projection
Commitment Raw Cost
x



Commitment Burdened Cost
x



Commitment Indirect Cost
x



Commitment Burdened Cost Adjusted for IDC
xx


Expenditure Raw Cost


x

Expenditure Burdened Cost


x

Revenue Amount



x
Task Budget Period Budget Amountx




Task Budget Period Payroll Projection Amount




x