Unifier - Cost Sheet History / Primavera - Cost Sheet History

Description: Use this subject area to analyze weekly historical cost sheet facts to better understand changes over time.

Note: Dimensional cost sheet history is not supported.

Folder	SubFolder	Field Name	Dimension/ Fact / Lookup	Description (From Table)	Values Derived From / Calculated By
Fact - Primavera - Cost Sheet History	Costs			Costs
Fact - Primavera - Cost Sheet History	Costs	Actuals Received	Fact	Actuals Received	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Actuals Received (Base)", "P6Core"."Fact - Cost Sheet History"."Actuals Received (Project)")
Fact - Primavera - Cost Sheet History	Costs	Approved Budget Revisions	Fact	Approved Budget Revisions	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Approved Budget Revisions (Base)", "P6Core"."Fact - Cost Sheet History"."Approved Budget Revisions (Project)")
Fact - Primavera - Cost Sheet History	Costs	Approved Change Orders	Fact	Approved Change Orders	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Approved Change Orders (Base)", "P6Core"."Fact - Cost Sheet History"."Approved Change Orders (Project)")
Fact - Primavera - Cost Sheet History	Costs	Approved Commitment Changes	Fact	Approved Commitment Changes	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Approved Commitment Changes (Base)", "P6Core"."Fact - Cost Sheet History"."Approved Commitment Changes (Project)")
Fact - Primavera - Cost Sheet History	Costs	Approved Invoices	Fact	Approved Invoices	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Approved Invoices (Base)", "P6Core"."Fact - Cost Sheet History"."Approved Invoices (Project)")
Fact - Primavera - Cost Sheet History	Costs	Approved PO Amendments	Fact	Approved PO Amendments	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Approved PO Amendments (Base)", "P6Core"."Fact - Cost Sheet History"."Approved PO Amendments (Project)")
Fact - Primavera - Cost Sheet History	Costs	Approved Payment Applications	Fact	Approved Payment Applications	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Approved Payment Applications (Base)", "P6Core"."Fact - Cost Sheet History"."Approved Payment Applications (Project)")
Fact - Primavera - Cost Sheet History	Costs	Approved Spends	Fact	Approved Spends	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Approved Spends (Base)", "P6Core"."Fact - Cost Sheet History"."Approved Spends (Project)")
Fact - Primavera - Cost Sheet History	Costs	Budget Percent	Fact	Budget Percent	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Budget Percent (Base)", "P6Core"."Fact - Cost Sheet History"."Budget Percent (Project)")
Fact - Primavera - Cost Sheet History	Costs	Budget Variance	Fact	Budget Variance	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Budget Variance (Base)", "P6Core"."Fact - Cost Sheet History"."Budget Variance (Project)")
Fact - Primavera - Cost Sheet History	Costs	Commitment Percent	Fact	Commitment Percent	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Commitment Percent (Base)", "P6Core"."Fact - Cost Sheet History"."Commitment Percent (Project)")
Fact - Primavera - Cost Sheet History	Costs	Contracts	Fact	Contracts	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Contracts (Base)", "P6Core"."Fact - Cost Sheet History"."Contracts (Project)")
Fact - Primavera - Cost Sheet History	Costs	Estimate	Fact	Estimate	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Estimate (Base)", "P6Core"."Fact - Cost Sheet History"."Estimate (Project)")
Fact - Primavera - Cost Sheet History	Costs	Forecast	Fact	Forecast	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Forecast (Base)", "P6Core"."Fact - Cost Sheet History"."Forecast (Project)")
Fact - Primavera - Cost Sheet History	Costs	Forecast Adjustments	Fact	Forecast Adjustments	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Forecast Adjustments (Base)", "P6Core"."Fact - Cost Sheet History"."Forecast Adjustments (Project)")
Fact - Primavera - Cost Sheet History	Costs	Journal Entries	Fact	Journal Entries	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Journal Entries (Base)", "P6Core"."Fact - Cost Sheet History"."Journal Entries (Project)")
Fact - Primavera - Cost Sheet History	Costs	Original Budget	Fact	Original Budget	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Original Budget (Base)", "P6Core"."Fact - Cost Sheet History"."Original Budget (Project)")
Fact - Primavera - Cost Sheet History	Costs	Original Commitments	Fact	Original Commitments	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Original Commitments (Base)", "P6Core"."Fact - Cost Sheet History"."Original Commitments (Project)")
Fact - Primavera - Cost Sheet History	Costs	Pending Budget Revisions	Fact	Pending Budget Revisions	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Pending Budget Revisions (Base)", "P6Core"."Fact - Cost Sheet History"."Pending Budget Revisions (Project)")
Fact - Primavera - Cost Sheet History	Costs	Pending Change Orders	Fact	Pending Change Orders	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Pending Change Orders (Base)", "P6Core"."Fact - Cost Sheet History"."Pending Change Orders (Project)")
Fact - Primavera - Cost Sheet History	Costs	Pending Commitment Changes	Fact	Pending Commitment Changes	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Pending Commitment Changes (Base)", "P6Core"."Fact - Cost Sheet History"."Pending Commitment Changes (Project)")
Fact - Primavera - Cost Sheet History	Costs	Pending Invoices	Fact	Pending Invoices	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Pending Invoices (Base)", "P6Core"."Fact - Cost Sheet History"."Pending Invoices (Project)")
Fact - Primavera - Cost Sheet History	Costs	Pending PO Amendments	Fact	Pending PO Amendments	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Approved PO Amendments (Base)", "P6Core"."Fact - Cost Sheet History"."Approved PO Amendments (Project)")
Fact - Primavera - Cost Sheet History	Costs	Pending Payment Applications	Fact	Pending Payment Applications	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Pending Payment Applications (Base)", "P6Core"."Fact - Cost Sheet History"."Pending Payment Applications (Project)")
Fact - Primavera - Cost Sheet History	Costs	Pending Spends	Fact	Pending Spends	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Pending Spends (Base)", "P6Core"."Fact - Cost Sheet History"."Pending Spends (Project)")
Fact - Primavera - Cost Sheet History	Costs	Purchase Orders	Fact	Purchase Orders	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Purchase Orders (Base)", "P6Core"."Fact - Cost Sheet History"."Purchase Orders (Project)")
Fact - Primavera - Cost Sheet History	Costs	Remaining Budget	Fact	Remaining Budget	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Remaining Budget (Base)", "P6Core"."Fact - Cost Sheet History"."Remaining Budget (Project)")
Fact - Primavera - Cost Sheet History	Costs	Revised Budget	Fact	Revised Budget	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Revised Budget (Base)", "P6Core"."Fact - Cost Sheet History"."Revised Budget (Project)")
Fact - Primavera - Cost Sheet History	Costs	Revised Commitments	Fact	Revised Commitments	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Revised Commitments (Base)", "P6Core"."Fact - Cost Sheet History"."Revised Commitments (Project)")
Fact - Primavera - Cost Sheet History	Costs	Risks and Issues	Fact	Risks and Issues	INDEXCOL( CASE VALUEOF(NQ_SESSION."CURRENCY_TYPE") WHEN 'Base' THEN 0 WHEN 'Project' THEN 1 END , "P6Core"."Fact - Cost Sheet History"."Risks and Issues (Base)", "P6Core"."Fact - Cost Sheet History"."Risks and Issues (Project)")

Related Topics