Project Financial Analytics - APIs - V1 - Labor and Equipment Hours

API Name: CoreconAPI_Hours


Note: Job Cost Code, Internal Grouping and Owner Code fields will be blank if multi-projects are selected.


  • ProjectId
  • ProjectNumber
  • ProjectTitle
  • ProjectBidContactName
  • ProjectSalesContactName
  • ProjectPMContactName
  • ProjectEstStartDateUtc
  • ProjectEstStartDateOrgLocal
  • ProjectEstFinishDateUtc
  • ProjectEstFinishDateOrgLocal

  • PrimeContractId
  • PrimeContractNumber
  • PrimeContractSubject
  • PrimeContractIssueDateUtc
  • PrimeContractIssueDateOrgLocal
  • PrimeContractStatus
  • PrimeContractApprovalDateUtc
  • PrimeContractApprovalDateOrgLocal
  • PrimeContractBillingType
  • PrimeContractBillingTypeValue
  • OwnerCompanyName
  • OwnerContactName
  • ContractorCompanyName
  • ContractorContactName
  • PrimeContractEstStartDateUtc
  • PrimeContractEstFinishDateUtc
  • PrimeContractEstStartDateOrgLocal
  • PrimeContractEstFinishDateOrgLocal

  • JobCostCodeId
  • JobCostCodeOrderNumber
  • JobCostCode
  • JobCostCodeDescription
  • JobCostCodeQuantity
  • JobCostCodeUnit

  • JobCostCodeInternalDivision
  • JobCostCodeInternalDivisionDesc
  • JobCostCodeInternalMajor
  • JobCostCodeInternalMajorDesc
  • JobCostCodeInternalMinor
  • JobCostCodeInternalMinorDesc
  • JobCostCodeInternalSubMinor
  • JobCostCodeInternalSubMinorDesc

  • OwnerCostCode
  • OwnerCostCodeDescription

  • HourBudget_Prime_L
  • HourBudget_ApprovedCOs_L
  • HourBudget_Revised_L

  • HourBudget_PendingCOs_L
  • HourBudget_ApprovedCPRs_L
  • HourBudget_PendingCPRs_L

  • LbrTimecard_Approved_Hours_NoCORef
  • LbrTimecard_Approved_Hours_WithCORef
  • LbrTimecard_Approved_Hours

  • LbrTimecard_Pending_Hours_NoCORef
  • LbrTimecard_Pending_Hours_WIthCORef
  • LbrTimecard_Pending_Hours

  • LbrTimecard_ApprovedAndPending_Hours = [LbrTimecard_Approved_Hours] + [LbrTimecard_Pending_Hours]

  • Projected_Hours_L = [LbrTimecard_Approved_Hours] / [EstimatedFieldPercentComplete]

  • RevisedLbrHourBudget_Less_ApprLbrHours = [HourBudget_Revised_L] - [LbrTimecard_Approved_Hours]
  • RevisedLbrHourBudget_Less_ApprAndPendLbrHours = [HourBudget_Revised_L] - ([LbrTimecard_Approved_Hours] + [LbrTimecard_Pending_Hours])
  • RevisedLbrHourBudget_Less_ProjectedLbrHours = [HourBudget_Revised_L] - [Projected_Hours_L]
  • ProjectedLbrHours_Less_RevisedLbrHourBudget = [Projected_Hours_L] - [HourBudget_Revised_L]

  • CostBudget_Prime_L
  • CostBudget_ApprovedCOs_L
  • CostBudget_Revised_L

  • CostBudget_PendingCOs_L
  • CostBudget_ApprovedCPRs_L
  • CostBudget_PendingCPRs_L

  • LbrTimecard_Approved_CostTotal
  • LbrTimecard_Approved_Billable
  • LbrTimecard_Approved_Unbillable
  • LbrTimecard_Approved_OnHold

  • LbrTimecard_Pending_CostTotal
  • LbrTimecard_Pending_Billable
  • LbrTimecard_Pending_Unbillable
  • LbrTimecard_Pending_OnHold

  • LbrTimecard_Projected_Total = ([LbrTimecard_Approved_CostTotal] / [LbrTimecard_Approved_Hours]) * [Projected_Hours_L]

  • RevisedLbrCostBudget_Less_ApprLbrCost = [CostBudget_Revised_L] - [LbrTimecard_Approved_CostTotal]
  • RevisedLbrCostBudget_Less_ApprAndPendLbrCost = [CostBudget_Revised_L] - ([LbrTimecard_Approved_CostTotal] +[LbrTimecard_Pending_CostTotal])
  • RevisedLbrCostBudget_Less_ProjectedLbrCost = [CostBudget_Revised_L] - [LbrTimecard_Projected_Total]

  • Cost Budget_Per_JCCQty_Rate = IF(IsNull([JobCostCodeQuantity]) OR ([JobCostCodeQuantity] = 0), 0, ([CostBudget_Revised_L] / [JobCostCodeQuantity]))
  • ActualCost_Per_DailyLogQty_Rate = IF(IsNull([DailyLog_Activity_JobCostCodeQuantity]) OR ([DailyLog_Activity_JobCostCodeQuantity] = 0), 0, ([LbrTimecard_Approved_CostTotal] / [DailyLog_Activity_JobCostCodeQuantity]))
  • ProjectedCost_Per_JCCQty_Rate = IF(IsNull([JobCostCodeQuantity]) OR ([JobCostCodeQuantity] = 0), 0, ([LbrTimecard_Projected_Total] / [JobCostCodeQuantity]))

  • HourBudget_Prime_E
  • HourBudget_ApprovedCOs_E
  • HourBudget_Revised_E

  • HourBudget_PendingCOs_E
  • HourBudget_ApprovedCPRs_E
  • HourBudget_PendingCPRs_E

  • EqpTimecard_Hours_NoCORef
  • EqpTimecard_Hours_WithCORef
  • EqpTimecard_Hours

  • Projected_Hours_E = [EqpTimecard_Hours] / [EstimatedFieldPercentComplete]

  • RevisedEqpHourBudget_Less_EqpHours = [HourBudget_Revised_E] - [EqpTimecard_Hours]
  • RevisedEqpHourBudget_Less_ProjectedEqpHours = [HourBudget_Revised_E] - [Projected_Hours_E]
  • ProjectedEqpHours_Less_RevisedEqpHourBudget = [Projected_Hours_E] - [HourBudget_Revised_E]

  • CostBudget_Prime_E
  • CostBudget_ApprovedCOs_E
  • CostBudget_Revised_E

  • CostBudget_PendingCOs_E
  • CostBudget_ApprovedCPRs_E
  • CostBudget_PendingCPRs_E

  • EqpTimecard_CostTotal
  • EqpTimecard_Billable
  • EqpTimecard_Unbillable
  • EqpTimecard_OnHold

  • EqpTimecard_Projected_Total = ([EqpTimecard_CostTotal] / [EqpTimecard_Hours]) * [Projected_Hours_E]

  • RevisedEqpCostBudget_Less_EqpCost = [CostBudget_Revised_E] - [EqpTimecard_CostTotal]
  • RevisedEqpCostBudget_Less_ProjectedEqpCost = [CostBudget_Revised_E] - [EqpTimecard_Projected_Total]

  • EstimatedFieldPercentComplete

  • DailyLog_Activity_JobCostCodeQuantity
  • DailyLog_Manpower_JobCostCodeManpowerHours (Job Cost Code will be added to the add, edit and import forms.)
  • DailyLog_MajorEqp_JobCostCodeEquipmentHours (Job Cost Code will be added to the add, edit and import forms.)
  • PrimeInvoice_UnitPrice_JobCostCodeQuantity