Major Release Notes - Replicate 24.9
This is a preview of the upcoming release. General release is available starting 07-OCT-2024.
-
Deprecated fields and breaking changes – Changes to the SelfService.vwPlanComponent view fields in this release include renamed, new, and deprecated fields, as shown in the table. In the Explore.vwPlanComponent view, only TurnoverId and ConstructionCommodityName fields have been updated. Read more
-
Logic update for active records – Corrective updates have been made to the logic that determines active records in the database. If you notice abnormalities in data that you are capturing via the ETL process in the views listed, do a full table refresh to truncate and load the data, rather than a delta or incremental update of the impacted records. Read more
-
InEight Contract views – New SelfService views and an Explore view have been added for Contract. Read more
-
InEight Control views – New SelfService views have been added for Control. Read more
-
InEight Design views – New SelfService views and Explore views have been added for Design. Read more
-
InEight Plan views – A new SelfService view and Explore views have been added for Plan. Read more
-
InEight Platform views – New SelfService views have been added for Platform. Read more
-
SelfService.vwChangeWorkflow - New fields have been added for StepNumber, Recipient, and Approvers in the view.
-
SelfService.vwCoreProject – New fields have been added to the SelfService_Core_Project view. Read more
-
SelfService.vwPlanPlanNote – The new field WorkPlanId has been added to the view to enable joining to the WorkPackageConstraintManagement view.
-
SelfService.vwPlanWorkPackageContraintManagement – The new field WorkPlanConstraintStatus has been added to the view.
General release is available starting 05-AUG-2024.
Updated 19-AUG-2024
-
API Enhancements – New fields were added to the following APIs. Read more
-
API Deprecations/Changes – The following APIs have been deprecated in the 24.7 release as these APIs/fields represent unused table structures because the corresponding functionality is not available in Estimate SaaS. Read more
-
InEight Contract APIs – New SelfService APIs and an Explore API have been added for Contract. Read more
-
InEight Design APIs – New SelfService APIs have been added for Design. Read more
-
InEight Plan API – New SelfService APIs have been added for Plan. Read more
-
InEight Estimate APIs – New SelfService APIs have been added for Estimate. Read more
-
SelfService_Core_Project – New SelfService Schedule APIs have been added for Core. Read more
-
Compliance/Completion Event Task APIs - A data type change has been made to all responses for date characteristic types and are now converted from MM/DD/YYYY to the ISO 8601 format YYYY-MM-DD, which includes button push timestamps. The conversion only occurs in the Response field and the RawResponse fields are not affected. Read more
-
SelfService_Core_DocumentApplicationIntegration - A data type change has been made to the IsActive field. The field data type was set to an Integer but has been changed to a Bit.
-
Release 24.9 Deprecated fields – Starting with Release 24.9, multiple changes that includes deprecating fields will occur in the SelfService.vwPlanComponent view and the Explore.vwPlanComponent view (TurnoverId and ConstructionCommodityName are the only impacted fields in this view). Read more
-
SelfService.vwPlanComponentCharacteristic view changes - Due to changes in the source system, data from the ComponentCharacteristicTypeId and ComponentCharacteristicListItemId fields in the view have migrated to the new fields CustomCharacteristicTypeId and CustomCharacteristicTypeElementId, respectively.
- API Enhancements – New fields were added to the following APIs. Read more
-
API Deprecations/Changes – The following APIs from Estimate SaaS will be deprecated as they are not reporting any data. These changes will be made in the 24.7 release. Read more
-
InEight Contract APIs – New SelfService APIs and an Explore API have been added for Contract. Read more
-
InEight Control APIs – A new SelfService_Control_ProjectCashFlow API has been added for Control.
-
InEight Design APIs – A new SelfService_Design_QuantityItemCustomGroupElement and SelfService_Design_LinkedEngineeringProject have been added for Design.
-
InEight Plan API – New SelfService APIs have been added for Plan. Read more
-
SelfService_Core_Project – The new SelfService_Core_CostCategory has been added to this API.
- InEight Compliance APIs – New SelfService APIs have been added for Compliance. Read more
InEight Completions APIs – New SelfService APIs have been added for Completions. Read more
-
InEight Contract APIs – New SelfService APIs and an Explore API have been added for Contract. Read more
-
InEight Control APIs – A new SelfService_Control_SchedulerDetail API has been added for Control.
-
InEight Estimate APIs – New SelfService APIs have been added for Estimate (cloud). Read more
-
InEight Plan API – The SelfService_Plan_TimeCardIntegrationStatus API has been added for Plan.
-
InEight Platform APIs – New SelfService APIs have been added for Platform. Read more
-
SelfService_Contract_Contract – The ContributedAmount field has been added to the SelfService_Contract_Contract API.
-
SelfService_Contract_IssueSummary – The CreatedBy field has been added to the SelfService_Contract_IssueSummary API.
- API Deprecations/Changes - To consume changes made in the Control application, in 23.12 the CreatedDate and ModifiedDate fields in the SelfService_Control_ScheduleDetail API will be converted to a DateTimeOffset data type. The following APIs have been deprecated in the 23.12 release as the Contract and Change product team will be deprecating the source tables. Read more
InEight Estimate Explore APIs – These APIs will only report active records. The data in these APIs will match what can be seen in the Estimate interface and will not report any previous versions of the data. These APIs are intended for business intelligence use cases, such as Power BI reporting. Read more
InEight Control API – A new Control API has been added in this release for SelfService_Control_CostItemAssignedVendor.
InEight Contract API – Added a new field labeled Notes to the SelfService_Contract_ContractCloseOut API.
- Deprecated APIs - These APIs will be deprecated in the Release 23.12, SelfService_Change_History and SelfService_Contract_ChangeStatusHistory.
-
InEight Schedule APIs – New SelfService Schedule APIs have been added for Schedule. Read more
-
InEight Completions APIs – New Completions APIs have been added in this release for SelfService_Completion_GeneralHeaderData UserID
-
InEight Compliance APIs – New Compliance APIs have been added in this release for SelfService_Compliance_GeneralHeaderData UserID
-
InEight Contract API – New SelfService Schedule APIs have been added for Contract. Read more
-
InEight Estimate APIs – New SelfService APIs have been added for Estimate. Read more
-
SelfService_Core_Project – New SelfService Schedule APIs have been added for Core. Read more
-
InEight Schedule APIs – New SelfService Schedule APIs have been added for Schedule. Read more
-
InEight Completions APIs – New Completions APIs have been added in this release for SelfService_Completion_ScheduledEventTaskData, Explore_Completion_CurrentEventTaskData, Explore_Completion_FormsandProject, Explore_Completion_ScheduledTaskData.
-
InEight Compliance APIs – New Compliance APIs have been added in this release for SelfService_Compliance_ScheduledEventTaskData, Explore_Compliance_CurrentEventTaskData, Explore_Compliance_FormsandProject, and Explore_Compliance_ScheduledTaskData.
-
InEight Contract API – A new Contract API has been added in this release for SelfService_Contract_InvoiceLineItem.
-
InEight Control APIs – New Control APIs have been added in this release for SelfService_Control_CorporateForecastCostDetail and Explore_Control_CorporateForecastCostDetail.
-
InEight Platform APIs – New Platform APIs have been added in this release for SelfService_Core_ProjectAssignedContact, SelfService_Core_ProjectCraftRateCode, SelfService_Core_ProjectRateCode, and SelfService_Core_ProjectEquipmentOperationalRateCode.
-
SelfService_Core_Project – The new field ExternalProjectId has been added to this API.
Updated 07-AUG-2023
-
SelfService_Control_CurretProjectForecastDetail – The fields Is_Active and Modified_Date have been renamed to IsActive and ModifiedDate to adhere with standard API naming conventions, and the PlugColumnName field has been added to this API.
-
InEight Schedule APIs – The following set of new Schedule APIs have been added in this release that need to be used in place the existing APIs when your Schedule platform is migrated to the InEight cloud platform. Data that was available from the deprecated APIs will be migrated to the new APIs. These new APIs will refresh once per day. Read more
-
Deprecated InEight Schedule APIs – The following APIs will no longer report any data after your Schedule platform has been migrated. These APIs will be available in APIM, but they will not return any data and will be removed from APIM in a future release. All existing data will be migrated to the new APIs. Read more
-
InEight Estimate APIs – The following new SelfService APIs have been added for Estimate (cloud). Read more
-
SelfSerice_Estimate_Contact API - The contact information will now be sourced from InEight Platform, which can be found in the SelfService_Core_Contact API and will therefore be deprecated in the SelfSerice_Estimate_Contact API in a future release. The following fields will return null values in the SelfService_Estimate_Contact API. Read more
-
SelfService_Contract_DetailCostItem – This new API has been added for InEight Contract.
-
SelfService_Report_DateProject – This new API has been added for InEight Report.
-
InEight Contract APIs – The following APIs have been modified for Contract. Read more
-
SelfService_Control_CostItem – The RowNumber field has been added to this API.
-
SelfService_Core_ProjectEmployee – The ProjectEmployeeBillingClassId, ProjectRateCodeId, and CustomField1 fields have been added to this API.
-
SelfService_Estimate_JobReferencedData – The ProjectDisplay and OrganizationDisplay fields have been added to this API. These fields populate with the values from Platform if the Estimate job has been connected to a project.
-
SelfService_Plan_WorkPackage – The ProjectDisplay field has been added to this API.
-
SelfService_Core_ProjectEmployeeVersion – With the additions to the SelfService_Core_ProjectEmployee, this API is now redundant as they both report the same data and columns. The fields in the SelfService_Core_ProjectEmployeeVersion API will return null values and the API will be removed in a future release.
-
Release 23.8 Deprecated APIs – Starting in Release 23.8, the SelfService_Compliance_UserAssignment and SelfService_Completion_UserAssignment APIs will be deprecated and no longer report data.
Updated 15-JUN-2023
-
API Deprecation – Beginning with Release 23.6, the existing Explore Schedule APIs will be deprecated and a new set of APIs will be released. The deprecated APIs will still be available in APIM, however they will not contain any data. Read more
-
InEight Control API – The SelfService_Control_PersonalForecast API was added. This API expose data from the Private forecasts in Control for analysis purposes before pushing changes to the Live forecast.
-
InEight Contract API – The SelfService_Contract_VendorChangeOrderLineItem API was added. This API includes data from Contracts > Vendor Change Order Log > Line Items.
-
InEight Estimate APIs – The following SelfService APIs have been added for Estimate (Cloud). Read more
-
Updated InEight Control API – The Project Id and Forecast Date fields have been added to the SelfService_Control_CurrentProjectForecastDetail.
-
Updated InEight Contract API – The DocuSign Status, Sent By, and Company fields from the DocuSign integration have been added to SelfService_Contract_DocumentSignWorkflowHistory.
-
Updated InEight Completions API – The Is Active field has been added to the SelfService_Completions_UserAssignment API to indicate records that have been soft-deleted.
-
Updated InEight Compliance API – The Is Active field has been added to the SelfService_Compliance_UserAssignment API to indicate records that have been soft-deleted.
-
Deprecated APIs – The following Estimate Sync Tool APIs for Estimate (on premise) are not in use and will be deprecated in Release 23.4. Read more
-
InEight Estimate APIs – The following new SelfService APIs have been added for Estimate. Read more
-
InEight Control APIs – The following new SelfService APIs have been added for Control. Read more
-
InEight Completions APIs – APIs have been added for the new Completions product. Read more
-
Updated InEight Control API – The Project Id and Forecast Date fields have been added to the SelfService_Control_CorporateForecastDetail API.
-
Deprecated APIs – The SelfeService Plan_DailyPlanHours and SelfService_Control_CostItmeActual APIs have been deprecated in this release.
-
Decimal precision – Breaking Change As a result of architectural changes the following APIs/Replicate views and fields have been adjusted to a decimal precision of (28,15). This will not impact Power BI dashboards, but it will impact any ETL operations.
-
SelfService_Plan_Component: ComponentQuantity, ToDateQuantity, PercentageComplete
-
SelfService_Plan_QuantityClaim: Claimed_Quantity
-
oSelfService_Plan_QuantityClaimDetail: ComponentIncrementQuantity, ComponentTotalQuantity, InstallQuantity, ComponentQuantityHistory, StepQuantityHistory, StepQuantity
-
Explore_Plan_WorkPlanCostItem: Quantity
-
-
Data type change in SelfService_Core_UserProject Currently, the Project_ID field in the API reports the Project Display field in the UI. This field in the API has been remapped to the internal project ID and the data type has been updated to a bigint. A new field ProjectDisplay has been added to report the project display ID with a data type of nvarchar (200).
-
Document reporting APIs – The first set of Document reporting APIs are now available for the Document, Mail, Forms, Packages, and Transmittals modules.
-
CustomList1Value and CustomList2Value – The SelfService_Contract_IssueDetail, SelfService_Contract_PCODetail, and SelfService_Contract_CCODetail APIs now include text values associated to these IDs for the custom list selections.
-
SelfService_Contract_PayForm – The Comments field contents from the Contract > Payment Form > Details page are now included in this API.
-
InEight Plan Timecard Notes APIs – Two new APIs, Explore_Plan_TimeCardNote and SelfService_Plan_TimeCardNote, have been added to expose notes from timecards.
-
SelfService_Contract_InvoicePayment – These new fields have been added to the SelfService_Contract_InvoicePayment: PostingDate, DocumentYear, ProjectCurrencyAmount, ProjectCurrencyReference, and InvoiceTax Amount.
-
New API – The Explore_Core_User API reports the same fields as the SelfService_Core_User API but only reports records that are currently active.
-
SelfService_Plan_Timecard and Explore_Plan_Timecard APIs – The following new fields were added to these APIs:
-
WorkOrderId
-
WorkOrderDisplayId
-
EquipmentRepairedId
-
EquipmentRepairedDisplay
-
EquipmentRepairedDescription
-
LaborCostTypeId
-
LaborCostTypeName
-
LaborCostCenterTypeDisplay
-
EquipmentCostTypeId
-
EquipmentCostTypeName
-
EquipmentCostTypeDisplay
-
OverriddenLaborCostTypeId
-
OverriddenLaborCostTypeName
-
OverriddenLaborCostCenterTypeDisplay
-
OverriddenEquipmentCostTypeId
-
OverriddenEquipmentCostTypeName
-
OverriddenEquipmentCostTypeDisplay
-
Approver1Id
-
Approver1FullName
-
ApproverRole1Id
-
Approver1RoleName
-
Approver2Id
-
Approver2FullName
-
ApproverRole2Id
-
Approver2RoleName
-
ExecutorId
-
Executor1FullName
-
ExecutorRoleId
-
Executor1RoleName
-
ClientApproverName
-
SentToPayrollById
-
SentToPayrollByFullName
-
SentToPayrollDate
-
ConfirmationRecievedDate
-
IsAdditionalPayrollInstructionCodeOverriden
-
EmployeeBillingClassId
-
EmployeeUDF1
-
DailyPlanName
-
TimeCardStatusId
-
CreatedById
-
DailyPlanShiftId
-
TempEmployeeId
-
TempEquipmentId
-
SourceSystemId
-
EmployeeBillingClassName
-
EmployeeBillingClassDescription
-
EquipmentBillingClassId
-
EquipmentBillingClassName
-
EquipmentBillingClassDescription
-
SelfService_Plan_QuantityClaim API – The ProjectId field has been added to this API.
Updated 15-NOV-2022
-
Deprecation of the SelfService_Control_CostItemActual API Due to architectural changes made in the Control application, the SelfService_Control_CostItemActual API will be deprecated this release. The API will still exist in this release, but no data will flow through it. Refer to "Control Actuals Reporting" for detailed information. The following new APIs will be replacing the existing API:
-
SelfService_Control_ActualQuantity
-
SelfService_Control_ActualManhours
-
SelfService_Control_ActualCost
-
SelfService_Control_ActualsVendorHour
-
-
Data type change in Explore_Plan_WorkPackaging API – As a result of changes made in the Work Packaging page with the ability to tag a section as Started, the data type will be an integer that coincides with the status of the section for the following fields:
-
EnvironmentalComplete
-
SafetyComplete
-
QualityComplete
-
GoalsComplete
-
LaborComplete
-
TemporaryStructuresComplete
-
ToolsComplete
-
QualityFormComplete
-
LessonsLearnedComplete
-
ConstraintsComplete
-
MaterialsComplete
-
EquipmentComplete
-
SchedulesComplete
-
ComponentsComplete
-
BudgetsComplete
-
WorkSequencesComplete
-
New APIs – The following SelfService APIs have been added:
-
SelfService_Contract_CostItemPricingCategory – This API shows the cost categories as they are shown in the Cost Item Pricing feature.
-
SelfService_Contract_CostItemPricingResourceCategoryCost - This API shows the cost at the resource level from the Cost Item Pricing feature.
-
SelfService_Contract_CostItemPricingResource – This API shows the Resources assigned in the Cost Item Pricing feature.
-
SelfService_Control_ActualVendorHours - This API shows Actual Vendor hours from Control, it can be used by joining to the SelfService_Control_CostItem API.
-
SelfService_Control_ActualQuantity – This API shows Actual Quantities from Control, it can be used by joining to the SelfService_Control_CostItem API.
-
SelfService_Control_ActualManhours – This API shows Actual Manhours from Control, it can be used by joining to the SelfService_Control_CostItem API.
-
SelfService_Control_ActualCost – This API shows Actual Cost from Control, it can be used by joining to the SelfService_Control_CostItem API.
-
SelfService_Core_Market This API shows the data as entered in the Market section of the project Details page.
-
SelfService_Core_ProjectMarket – This API shows markets and the project associated with them.
-
SelfService_Core_Union – This API shows the data from Master data libraries > Unions.
-
SelfService_Core_RevenueCategory – This API shows the data from Master data libraries > Revenue Categories.
-
SelfService_Core_Qualification – This API shows data from Master data libraries > Qualification.
-
SelfService_Core_PaymentTerms – This API shows data from Master data libraries > Payment terms.
-
SelfService_Core_Material – This API shows data from Master data libraries > Operational resources > Material.
-
SelfService_Core_MeasurementType – This API shows the data from Master data libraries > Units of measure > Measurement types.
-
SelfService_Core_Incoterms – This API shows data from Master data libraries > Incoterms.
-
SelfService_Core_GeneralLedgerAccount – This API shows data from Master data libraries > General ledger accounts.
-
SelfService_Core_Discipline – This API shows data from Master data libraries > Disciplines and commodities > Disciplines.
-
SelfService_Core_ContactType – This API shows data from Master data libraries > Cost centers> Contact types.
-
SelfService_Core_Contact – This API shows data from Master data libraries > Contacts > Contacts.
-
SelfService_Core_Commodity – This API shows data from Master data libraries > Disciplines and commodities > Commodities.
-
Updated API – The Notes field on the project Details page has been added to the SelfService_Core_Project API.
The columns can now be populated with the values 0 (Draft), 1 (Completed), or 2 (Started). In Release 22.10, a new API will be available to populate the text of the status to its integer value.
Updated 07-OCT-2022
-
Deprecation of the SelfService_Control_CostItemActual API in Release 22.8 – Due to architectural changes made in the Control application, the SelfService_Control_CostItemActual API will be deprecated. The API will still exist, but no data will flow through it. The following new APIs will be replacing the existing API, and additional information will be provided in the 22.8 release notes.
-
SelfService_Control_ActualQuantity
-
SelfService_Control_ActualManhours
-
SelfService_Control_ActualCost
-
-
New APIs – The following SelfService APIs have been added:
-
SelfService_Core_EmployeeCertification – This API exposes the data from Operational Resources > Edit Employee > Certifications.
-
SelfService_Core_Vendor – This API exposes the data from Master data libraries > Vendors > Vendors.
-
SelfService_Core_AccountCodeCharacteristicTypeList – This API exposes the values assigned to account code tags and can be used with the SelfService_Control_AccountCodeCharacteristic API.
-
SelfService_Contract_VendorAssociatedChangeItem – This API exposes the data from Contract > Contracts > Details > Associated change items.
-
SelfService_Control_ForecastNote – This API exposes the notes associated to a forecast, as well as information about the forecast such as the forecast type, snapshot ID, and cost item ID.
-
Explore_Plan_Timecard – This API exposes the timecard data and contains the same fields as the SelfService_Plan_Timecard API, with the exception that this API only reports active records and refreshes every 20 minutes.
-
Updated APIs – The following SelfService APIs have been updated:
-
SelfService_Plan_Timecard – The refresh rate for this API has been changed to once per day due to performance degradation. If you need to receive the 20-minute refresh interval, you must use the new Explore_Plan_Timecard API.
-
SelfService_Contract_LineItem – When there are multiple WBS phase codes associated to a line item, the WBSPhaseCode field must be separated by pipes (||) instead of a comma.
-
Explore_Contract_AccrualDetail – Three new fields have been added to the API, ContractDetailId, LineItemCode, and CostItemId. When there are multiple cost items per accrual detail record, the CostItemId field must be separated by pipes (||).
-
SelfService_Contract_IssueSummary – The CostItemId field has been added to the API. When there are multiple cost items per accrual detail record, the CostItemId field must be separated by pipes (||).
-
SelfService_Contract_VCOLineItemDetail – Two new fields, CostItemID and LineItemDescription, have been added to the API.
-
-
APIs – The following new SelfService APIs have been added:
-
SelfService_Plan_DailyPlanResourceDetailBillingClass – This API exposes the billing classes as assigned to resources on a daily plan.
-
SelfService_Core_VendorType – This API contains the data for vendor types that is in Master data libraries > Vendors > Vendor types.
-
SelfService_Core_AccountCodeImportLog – This API reports the data from the Account Code Import Log that is in Master data libraries > Account codes > Import log.
-
SelfService_Core_AccountCodeCharacteristicTypeList – This API exposes the Account Code tags as defined at the organization level.
-