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)") |