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