Spectrum Standard Power BI Report: Job Cost Detail

Find definitions of the fields and measures included in the Spectrum Standard Power BI Report: Job Cost Detail dashboard organized by column header.

Company

Filters the report data by company code or name. All are selected by default.

Job

Filters the report data by job number or name. All are selected by default.

Job Cost Center

Filters the report data by job cost center code or name. All are selected by default.

Job Status

Filters the report data to include jobs that are coded as either Pending, Open, Soft Closed, or Hard Closed. All are selected by default.

Project Manager

Filters the report data by project manager name. All are selected by default.

Master Job

Filters the report data by master job code or name. All are selected by default.

Comp

Displays the filtered company code.

  • SpectrumActual Costs table.field: JC_TRANSACTION_HISTORY_MC.Company_Code
  • SpectrumEstimated Costs table.field:

    JC_PHASE_MASTER_MC.Company_Code

    CR_CHNG_REQ_CON_DET_MC.Company_Code

  • SpectrumProjected Costs table.field: JC_PROJ_COST_HISTORY_MC.Job_Number+ JC_JOB_MASTER_MC.Job_Description
Job

Displays the filtered job number and description.

  • SpectrumActual Costs table.field: JC_TRANSACTION_HISTORY_MC.Job_Number+ JC_JOB_MASTER_MC.Job_Description
  • SpectrumEstimated Costs table.field:

    JC_PHASE_MASTER_MC.Job_Number+ JC_JOB_MASTER_MC.Job_Description

    CR_CHNG_REQ_CON_DET_MC.Job_Number+ JC_JOB_MASTER_MC.Job_Description

  • SpectrumProjected Costs table.field: JC_PROJ_COST_HISTORY_MC.Job_Number+ JC_JOB_MASTER_MC.Job_Description
Phase

Displays the job phase.

  • SpectrumActual Costs table.field: JC_TRANSACTION_HISTORY_MC.Phase_Code
  • SpectrumEstimated Costs table.field:

    JC_PHASE_MASTER_MC.Phase_Code

    CR_CHNG_REQ_CON_DET_MC.Phase_Code

  • SpectrumProjected Costs table.field: JC_PROJ_COST_HISTORY_MC.Phase_Code
Cost Type

Displays the job cost type code.

  • SpectrumActual Costs table.field: JC_TRANSACTION_HISTORY_MC.Cost_Type
  • SpectrumEstimated Costs table.field:

    JC_PHASE_MASTER_MC.Cost_Type

    CR_CHNG_REQ_CON_DET_MC.Cost_Type

  • SpectrumProjected Costs table.field: JC_PROJ_COST_HISTORY_MC.Cost_Type
Cost

Displays the job cost.

  • SpectrumActual Costs table.field: JC_TRANSACTION_HISTORY_MC.Tran_Amount
Hours

Displays the job hours.

  • SpectrumActual Costs table.field: JC_TRANSACTION_HISTORY_MC.Total_Hours
Quantity

Displays the asset quantity.

  • SpectrumActual Costs table.field: JC_TRANSACTION_HISTORY_MC.Quantity
Projected Cost

Displays the projected job cost.

  • SpectrumProjected Costs table.field: JC_PROJ_COST_HISTORY_MC.Amount
Projected Hours

Displays the projected job hours.

  • SpectrumProjected Costs table.field: JC_PROJ_COST_HISTORY_MC.Projected_Hours
Projected Quantity

Displays the projected asset quantity.

  • SpectrumProjected Costs table.field: JC_PROJ_COST_HISTORY_MC.Projected_Quantity
Estimated Cost

Displays the estimated job cost.

  • SpectrumEstimated Costs table.field:

    JC_PHASE_MASTER_MC.Original_Est_Cost + JC_PHASE_ESTIMATES_MC.Est_Cost

    CR_CHNG_REQ_CON_DET_MC.Change_Request_Amount

Estimated Hours

Displays the estimated job hours.

  • SpectrumEstimated Costs table.field:

    JC_PHASE_MASTER_MC.Original_Est_Hours + JC_PHASE_ESTIMATES_MC.Est_Hours

    CR_CHNG_REQ_CON_DET_MC.Change_Request_Hours

Estimated Quantity

Displays the estimated asset quantity.

  • SpectrumEstimated Costs table.field:

    JC_PHASE_MASTER_MC.Original_Est_Quantity + JC_PHASE_ESTIMATES_MC.Est_Quantity

    CR_CHNG_REQ_CON_DET_MC.Change_Request_Quantity

Division

Displays the job division.

  • SpectrumActual Costs table.field: JC_JOB_MASTER_MC.Division
Phase Cost Center

Displays the job phase cost center.

  • SpectrumActual Costs table.field: JC_PHASE_MASTER_MC.Phase_Cost_Center or JC_JOB_MASTER_MC.Cost_Center
  • SpectrumEstimated Costs table.field: JC_PHASE_MASTER_MC.Phase_Cost_Center or JC_JOB_MASTER_MC.Cost_Center
  • SpectrumProjected Costs table.field: JC_PHASE_MASTER_MC.Phase_Cost_Center or JC_JOB_MASTER_MC.Cost_Center
Project Manager

Displays the job project manager.

  • SpectrumActual Costs table.field: JC_JOB_MASTER_MC.Project_Manager
  • SpectrumEstimated Costs table.field: JC_JOB_MASTER_MC.Project_Manager
  • SpectrumProjected Costs table.field: JC_JOB_MASTER_MC.Project_Manager
Master Job

Displays the job's master job.

  • SpectrumActual Costs table.field: JC_JOB_MASTER_MC.Master_Job
  • SpectrumEstimated Costs table.field: JC_JOB_MASTER_MC.Master_Job
  • SpectrumProjected Costs table.field: JC_JOB_MASTER_MC.Master_Job