Appendix B: Field Mappings Between Unifier Essentials and CIC Analytics
The following table provides field mappings between Unifier Essentials and Unifier - Cost Sheet subject area in CIC Analytics:
Unifier Essentials Field | Unifier - Cost Sheet Subject Area Fields |
|---|---|
Project Cost 09 | "Primavera - Cost Sheet"."Costs"."Revised Commitments"
|
Project Cost 4 | "Primavera - Cost Sheet"."Costs"."Revised Budget"
|
Project Cost 21 | "Primavera - Cost Sheet"."Costs"."User Defined Column 7"
|
Project Cost 22 | "Primavera - Cost Sheet"."Costs"."User Defined Column 8"
|
Project Cost 24 | "Primavera - Cost Sheet"."Costs"."User Defined Column 14"
|
Project Cost 16 | "Primavera - Cost Sheet"."Costs"."User Defined Column 13"
|
Projected Costs | "Primavera - Cost Sheet"."Costs"."User Defined Column 14" +"Primavera - Cost Sheet"."Costs"."Revised Commitments" +"Primavera - Cost Sheet"."Costs"."User Defined Column 7"
|
%Projected/Forecast | (("Primavera - Cost Sheet"."Costs"."User Defined Column 14"+"Primavera - Cost Sheet"."Costs"."Revised Commitments"+"Primavera - Cost Sheet"."Costs"."User Defined Column 6") / ("Primavera - Cost Sheet"."Costs"."User Defined Column 7" + "Primavera - Cost Sheet"."Costs"."User Defined Column 13"))
|
Estimated cost at Completion | "Primavera - Cost Sheet"."Costs"."User Defined Column 8" +"Primavera - Cost Sheet"."Costs"."User Defined Column 13"
|
% Forecast | 1 - (% Projected / Forecast)
|
Projected Over Under | "Primavera - Cost Sheet"."Costs"."Revised Budget" - ("Primavera - Cost Sheet"."Costs"."User Defined Column 8" + "Primavera - Cost Sheet"."Costs"."User Defined Column 13")
|
% Forecast / Budget | ("Primavera - Cost Sheet"."Costs"."User Defined Column 8" + "Primavera - Cost Sheet"."Costs"."User Defined Column 13") / "Primavera - Cost Sheet"."Costs"."Revised Budget"
|
Project Count | COUNT(DISTINCT "Primavera - Cost Sheet"."General - (Project)"."Project Object Id")
|
Last Published Friday, December 8, 2023