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