/
FINAH-PPM-TransactionDetail-View Quick Start Guide

FINAH-PPM-TransactionDetail-View Quick Start Guide

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.

 

Critical Concepts


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.

Transaction Type to Folder / Field Groups

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.  

Transaction Type

Commitment

Commitment IDC Adjustment

Expenditure

Funding Issue

Payroll Projection

Budget (PPM)

Revenue

Transaction Type

Commitment

Commitment IDC Adjustment

Expenditure

Funding Issue

Payroll Projection

Budget (PPM)

Revenue

All task attributes

x

x

x

 

x

x

x

All project attributes

x

x

x

x

x

x

x

All award attributes

x

x

x

x

x

x

x

All contract attributes (based on transaction)

x

x

x

 

 

 

x

All budget period attributes

x

x

x

x

x

x

x

Expenditure Category

x

x

x

 

x

x

x

Revenue Category

x

x

x

 

x

x

x

Revenue Category Direct Indirect

x

x

x

 

x

x

x

Transaction ID

x

 

x

x

 

 

x

Transaction Number

x

 

x

x

 

 

x

Transaction Dist ID

x

 

x

 

 

 

x

Transaction Date

x

x

x

x

 

 

x

Transaction Description

x

 

x

x

 

 

x

Transaction Expenditure Type 

x

x

x

 

 

 

 

Transaction Supplier ID

x

 

x

 

 

 

 

Transaction Supplier Code

x

 

x

 

 

 

 

Transaction Supplier

x

 

x

 

 

 

 

Transaction Supplier Code And Name

x

 

x

 

 

 

 

Transaction Invoice Number

X* from Accounts Payable (AP)

 

X* from Accounts Payable (AP)

 

 

 

X* from Accounts Receivable (AR)

Transaction Invoice ID

X* from AP

 

X* from AP

 

 

 

X* from AR

Transaction Invoice Date

X* from AP

 

X* from AP

 

 

 

X* from AR

Transaction Invoice Line Requester Name Full

 

 

X*

 

 

 

 

Transaction PO Number

x

 

x

 

 

 

 

Transaction PO ID

x

 

x

 

 

 

 

Transaction PO Line

x

 

x

 

 

 

 

Transaction Bill Event Type

 

 

 

 

 

 

x

Original Transaction Reference

 

 

x

 

 

 

 

Transaction Document

 

 

x

 

 

 

 

Transaction Line Type

x

x

x

x

 

 

 

Transaction Accounting Date

x

x

x

 

 

 

x

Transaction Accounting Period

x

x

x

 

 

 

x

Transaction Fiscal Period Full

x

x

x

 

 

 

x

Transaction Fiscal Period Number

x

x

x

 

 

 

x

Transaction Fiscal Period Short

x

x

x

 

 

 

x

Transaction Fiscal Day (DDD)

x

x

x

 

 

 

x

Transaction Fiscal Month (MM)

x

x

x

 

 

 

x

Transaction Fiscal Quarter (Q)

x

x

x

 

 

 

x

Transaction Fiscal Week (WW)

x

x

x

 

 

 

x

Transaction Fiscal Year

x

x

x

 

 

 

x

Transaction Fiscal Year (YYYY)

x

x

x

 

 

 

x

Transaction Fiscal Period Start Date

x

x

x

 

 

 

x

Transaction Fiscal Period End Date

x

x

x

 

 

 

x

Commitment Raw Cost

x

 

 

 

 

 

 

Commitment Burdened Cost

x

 

 

 

 

 

 

Commitment Indirect Cost

x

 

 

 

 

 

 

Commitment Burdened Cost Adjusted for IDC

x

x

 

 

 

 

 

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

 

 

Crosswalk to Other FINAH Views

When Transaction Type = Funding Issue

  • Transaction ID will display Funding Issue Internal System ID

FINAH-PPM-TransactionDetail-View Field Name

FINAH-Project-View Field Name

FINAH-PPM-TransactionDetail-View Field Name

FINAH-Project-View Field Name

Transaction ID

 

Transaction Date

Project Funding Issue DateTime

Transaction Number

Project Funding Issue Number

Transaction Description

Project Funding Issue

Transaction Line Type

Project Funding Issue Type

 

Steps to Take


Key Fields to Display

  • Transaction Type

Key Fields to Filter On

  • Transaction Type

 

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.

 

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.

 

Level

Key (uniqueness / group by)

Measures

Level

Key (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

 

 

 

 

 

 

Related content