B Field Mappings Between Unifier Essentials and Construction and Engineering Analytics
The following table provides field mappings between Unifier Essentials and Unifier - Cost Sheet subject area in Construction and Engineering 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")
|