Vista Standard Power BI Report: Contract Status
Find definitions of the fields and measures included in the Vista Standard Power BI Report: Contract Status dashboard organized by column header.
- JC Company - Name
-
Filters the report data by job cost company name. All are selected by default.
- Department - Desc
-
Filters the report data by department description. All are selected by default.
- Contract - Desc
-
Filters the report data by contract description. All are selected by default.
- Job - Desc
-
Filters the report data by job description. All are selected by default.
- Project Manager
-
Filters the report data by project manager name. All are selected by default.
- Original Contract Amount
-
Displays the original contract item amount as specified in the OrigContractAmt in bJCCI.
- Current Contract Amount
-
Displays the current contract item amount as specified in the ContractAmt column in bJCIP.
- Pending Changes Amount
-
Displays the sum of all pending changes as specified in the ContractItemFact column in bJCCI.
- Approved Changes Amount
-
Displays the sum of all approved changes (not interfaced) as specified in the ContractItemFact column in bJCCI.
- Current Gross Profit
- Displays the current gross profit as specified in the ContractItemFact column in bJCCI.
- Projected Gross Profit
-
Displays the projected contract item amount as specified in the ContractItemFact column in bJCCI.
- Month
-
Includes all dates from the start of the month through the end of the month.
- Department
-
This field is used to group jobs together.
- Department Description
-
Describes the parameters of the Department.
- Cost Type
-
The lowest level of work managed on a project.
- Cost Type Description
-
Describes the parameters of the Cost Type.
- Estimated Cost
-
Displays the estimated cost as specified in bJCCD.EstCost.
- Projected Cost
-
Displays the projected cost as specified in bJCCD.ProjCost.
- YTD Cost
-
The total costs for the year-to-date.
- + / - From Previous Period
-
Indicates the difference from the previous fiscal period.
- Phase
-
The job phase to which the contract item was assigned.
- Phase Description
-
Describes the parameters of the Phase.
- Posted Date
-
The date on which a contract item's batch was posted.
- Actual Date
-
The calendar date on which a contract item payment occurred.
- Source
-
The source of a contract item.
- Description
-
Describes the parameters of a contract item.
- Actual Cost
-
Displays the actual cost (including both direct and indirect costs) as specified in bJCCD.ActualCost.
- Actual Hours
-
Displays the actual hours (including both billable and non-billable) as specified in bJCCD.ActualHours.
- Actual Units
-
Displays the actual units as specified in bJCCD.ActualUnits.
- Actual Unit Cost
-
The real cost incurred per unit, including both direct and indirect costs.
- Estimated Hours
-
Displays the estimated hours as specified in bJCCD.EstHours.
- Estimated Units
-
Displays the estimated units as specified in bJCCD.EstUnits.
- Projected Hours
-
Displays the projected hours as specified in bJCCD.ProjHours.
- Projected Units
-
Displays the projected units as specified in bJCCD.ProjUnits.
