Calendar Date

Year

Calendar year starting with January 1st and ending on December 31st. This may be different from the company's Fiscal Calendar. Note that this value is based on the actual date of each record.

Month

Includes all dates from the start of the month through the end of the month. Note that this value is based on the actual date of each record.

Week

This is the week number using a 12 month calendar year. Note that this value is based on the actual date of each record.

Cost Type

Cost Type

The lowest level of work managed on a project.

• Vista table.field: JCCT.CostType
• Spectrum table.field: JC_PHASE_MASTER_MC.Cost_Type

Cost Center

For Spectrum only. This represents the cost center, profit center or some other way to group the organization.

• Spectrum table.field: JC.PHASE_MASTER_MC.Cost_Center if it exists, otherwise JC_JOB_MASTER_MC.Cost_Center

Cost Groups

For Spectrum only. This represents the cost centers, profit centers or some other way to group the organization.

• Spectrum table.field: EM_COST_GROUP_LIST_MC.Cost_Group

Cost Type Summary

Cost Type Summary

For Spectrum only. A group of cost types added together for reporting purposes.

• Spectrum table.field: JC_COST_TYPE_SUMMARY_MC.Summary_Name

Employee Department

Department

The employee's home Payroll Department.

• Vista table.field: bPREH.PRDept
• Spectrum table.field:PR_EMPLOYEE_MASTER_1_MC.DepartmentCode

Employee Occupation

Occupation

The employee's occupation from payroll.

• Vista table.field: bPREH.OccupCat
• Spectrum table.field: PR_EMPLOYEE_MASTER_1_MC.Occupation

Employee Title

Employee Title

For Spectrum only. The employee's title.

• Spectrum table.field: PR_EMPLOYEE_MASTER_1_MC.Title

Employee Trade

Employee Trade

The employee's trade.

• Vista table.field: bPREH.Craft
• Spectrum table.field: PR_EMPLOYEE_MASTER_1_MC.Trade

Equipment

Equipment Type

Represents a type of equipment.

• Vista table.field: bEMEM.Type
• Spectrum table.field: EC_EQUIPMENT_MASTER_MC.Equipment_Type

Weight Class

For Spectrum only. Represents the equipment's weight class.

• Spectrum table.field: EC_EQUIPMENT_MASTER_MC.Equipment_Weight_Class

Make

Represents the make of the equipment.

• Vista table.field: bEMEM.Manufacturer
• Spectrum table.field: EC_EQUIPMENT_MASTER_MC.Equipment_Make

Model

Represents the model of the equipment.

• Vista table.field: bEMEM.Model
• Spectrum table.field: EC_EQUIPMENT_MASTER_MC.Equipment_Model

Equipment Code

This code represents specific equipment.

• Vista table.field: bEMEM.Equipment
• Spectrum table.field: EC_EQUIPMENT_MC.Equipment_Code

Item Code

Item Code

This code represents a material item. When it starts with '!', it indicates that the item is not stocked normally.

• Vista table.field: HQMT.Material and HQMT.MaterialGroup
• Spectrum table.field: IM_ITEM_MASTER_MC.Item_Code

Job

Company Code

This represents the specific company.

• Vista table.field: JCJM.JCCo
• Spectrum table.field: JC_JOB_MASTER_MC.Company_Code

Job Code

This code is used to identify the job.

• Vista table.field: JCJM.Job
• Spectrum table.field: JC_JOB_MASTER_MC.Job_Code

Phase Code

The Phase Code may be thought of as a way to break the job into smaller parts. Other names include Work Breakdown Structure (WBS) codes, Construction Specifications Institute (CSI) codes or cost codes.

• Vista table.field: JCCD.Phase
• Spectrum table.field: JC_PHASE_SUMMARY_MC.Phase_Code

Job Status

Job Status

The status of the job that includes Active, Inactive, and Complete.

• Vista table.field: JCJM.Status
• Spectrum table.field: JC_JOB_MASTER_MC.Status

Master Job

Master Job

For Spectrum Only. The master job serves as the primary setup, and be for reporting purposes to include all sub-job activity as if performed in a single large job, It may also control how T+M billings of the sub-jobs work.

• Spectrum table.field: JC_JOB_MASTER_MC.Master_Job

Measures

Cost

The current month's actual cost for the project.

• Vista table.field: JCCD.ActualCost
• Spectrum table.field: JC_TRANSACTION_HISTORY_MC.Tran_Amount

Cost to Date

This is the job-to-date actual cost amount for the project.

Estimated Cost

The net changes to estimated costs for the month

• Vista table.field: JCCD. - Job Cost Detail.CurrEstCosEstCost
• Spectrum 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 Cost to Date

The job-to-date estimated cost budget for this project.

Estimated Hours

The net changes to estimated hours for the month.

• Vista table.field: JCCD.EstHours
• Spectrum 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 Hours To Date

The job-to-date original estimated hours plus change orders.

Estimated Quantity

The net changes to estimated quantities for the month.

• Vista table.field: JCCD.EstUnits
• Spectrum table.field: JC_PHASE_MASTER_MC.Original_Est_Quantity + JC_PHASE_ESTIMATES_MC.Est_Quantity + CR_CHNG_REQ_CON_DET_MC.Change_Request_Quantity

Estimated Quantity To Date

The job-to-date estimated quantities budget for this project.

Hours

The labor hours and contract labor hours for the month.

• Vista table.field: JCCD.ActualHours
• Spectrum table.field: JC_TRANSACTION_HISTORY_MC.Total_Hours

Hours to Date

The job-to-date labor hours and contract labor hours for the job.

Original Estimated Cost

The original estimated costs for this project.

• Vista table.field: JCCD.EstCost
• Spectrum table.field: JC_PHASE_MASTER_MC.Original_Est_Cost

Projected Cost

The projected final cost of the contract. Note that if the projected final cost is zero, this value will display the estimated cost.

• Vista table.field: JCCD.ProjCost
• Spectrum table.field: JC_PROJ_COST_HISTORY_MC.Amount

Projected Cost to Date

The job-to-date projected cost budget for this project.

Projected Hours

The projected hours for the month.

• Vista table.field: JCCD.ProjHours
• Spectrum table.field: JC_PROJ_COST_HISTORY_MC.Projected_Hours

Projected Hours to Date

The job-to-date projected hours budget for this project.

Projected Quantity

The projected quantities for the month.

• Vista table.field: JCCD.ProjUnits
• Spectrum table.field: JC_PROJ_COST_HISTORY_MC.Quantity

Projected Quantity to Date

The job-to-date projected quantities for this project.

Quantity

The current month's quantity for this project.

• Vista table.field: JCCD.ActualUnits
• Spectrum table.field: JC_TRANSACTION_HISTORY_MC.Quantity

Quantity to Date

The job-to-date quantity for this project.

Transaction Type

Transaction Type Code (1)

Indicates the source of the transaction.

• AP - Accounts Payable
• AR - Accounts Receivable
• EQ - Equipment
• GL - General Ledger
• IC - Inventory
• JB - Job Billings
• JC - Job Cost
• OH - Overhead
• PR - Payroll

Vendor

Vendor

This code represents a specific vendor.

• Vista table.field: APVM.Vendor
• Spectrum table.field: VN_VENDOR_MASTER_MC.Vendor_Code