Project Management: Subcontracts

Find descriptions of the fields in the Project Management: Subcontracts data source organized by category.

Calendar Date

Year

Calendar year starting with January 1st and ending on December 31st. This may be different from the company's Fiscal Calendar.

Month

Includes all dates from the start of the month through the end of the month.

Week

This is the week number using a 12 month calendar year.

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

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

Billed

This is the current period's billing, before backing off the current period's retention amounts.

  • Vista table.field: JCCD.ActualCost
  • Spectrum table.field: VN_GL_DISTRIBUTION_DETAIL_MC.Debit_Amount
Billed to Date

This is the job-to-date billed, before backing off retention amounts.

Billed Quantity

This is the quantity billed for the current period.

  • Vista table.field: JCCD.ActualQuantity
  • Spectrum table.field: VN_GL_DISTRIBUTION_DETAIL_MC.Quantity
Billed Quantity to Date

This is the job-to-date quantity billed for the subcontract.

Executed Changes

By month, the total value of all executed Subcontract Change Orders and Change Requests.

  • Vista table.field: JCCD.TotalCommitedCost
  • Spectrum table.field: VN_CHNG_REQ_SUB_DET_MC.CR_Amount
Executed Quantity

By month, the total quantities used in all executed Subcontract Change Orders and Change Requests.

  • Vista table.field: JCCD.TotalCommitedUnits
  • Spectrum table.field: VN_CHNG_REQ_SUB_DET_MC.CR_Quantity
Revised Contract To Date

The sum of the original subcontract plus executed subcontract changes.

  • Vista: summation of the jccdtotalCommittedCosts from the start of the project up to the present.
  • Spectrum table.field: VN_SUBCONTRACT_PHASE_MC.Original_Contract_Amount + VN_CHNG_REQ_SUB_DET_MC.CR_Amount
Revised Quantity To Date

The sum of the original subcontract quantities plus executed subcontract changes to quantities.

  • Vista: summation of the jccd.totalCommittedUnits from the start of the project up to the present.
  • Spectrum table.field: VN_SUBCONTRACT_PHASE_MC.Original_Contract_Quantity + VN_CHNG_REQ_SUB_DET_MC.CR_Amount

Subcontract

Subcontract Type

For Spectrum only. The subcontract type is used to group subs by function, or by any other desired classification.

  • Spectrum table.field: VN_SUBCONTRACT_MC.Contract_Type
Vendor Code

This code represents a specific vendor.

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

This is the number used to refer to the subcontract.

  • Vista table.field: SLHD.SL
  • Spectrum table.field: VN_SUBCONTRACT_MC.Subcontract_Number

Subcontract Detail

Bill Item

This code represents a specific line item on the subcontract. Billing is done by these bill items.

  • Vista table.field: SLIT.SLItem
  • Spectrum table.field: VN_SUBCONTRACT_PHASE.Bid_Item_Number