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.
Are you looking for every detail of Costs? Use FINAH-ProjectCosts-View.
Are you looking for every detail and attribute of Revenue? Use FINAH-ContractRevenue-View.
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 |
---|---|---|---|---|---|---|---|
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 |
---|---|
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 |
---|---|---|
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:
|
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:
And the following fields:
|
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