Back to results
US 2024/0193513 A1Published application
Data integration system and method
AssigneeExpress Scripts Strategic Development, Inc.
InventorsTimothy Vires, David Timson
Life of this patent
Estimating the term…
Abstract
A system and method for integrating data from different data sources is disclosed. Project records are processed by (a) calculating a normalized level of effort value based on a level of effort value contained in the project record and (b) determining a cost center identifier associated with the project record. Cost center records are processed by (a) identifying the project records associated with a cost center identifier contained in the cost center record and (b) allocating an expense amount contained in the cost center record across the identified project records based on the normalized level of effort value for each of the identified project records.
Claims20
A computer system, comprising:
- one or more processors;
- and
- one or more memories storing instructions that, when executed by the one or more processors, cause the one or more processors to perform a plurality of operations comprising:
- (a) storing a plurality of project records based on project data received from a project management system, wherein each of the project records contains a project identifier for a project, a team identifier for a team assigned to the project, and a level of effort value indicative of an overall effort required for the team to complete the project;
- (b) storing a plurality of cost center records based on accounting data received from an accounting system, wherein each of the cost center records contains a cost center identifier, an account type identifier, and an expense amount;
- (c) processing each one of the project records by (i) calculating a normalized level of effort value based on the level of effort value contained in the project record and (ii) determining a cost center identifier associated with the project record;
- and
- (d) processing each one of the cost center records by (i) identifying a cost center group comprising the project records associated with the cost center identifier contained in the cost center record and (ii) allocating the expense amount contained in the cost center record across the project records in the cost center group based on the normalized level of effort value for each of the project records in the cost center group.
5 more elements
A computer-implemented data processing method, comprising:
- processing a plurality of project records each of which contains a project identifier for a project, a team identifier for a team assigned to the project, and a level of effort value indicative of an overall effort required for the team to complete the project, wherein each one of the plurality of project records is processed by:
- calculating a normalized level of effort value based on the level of effort value contained in the project record;
- and
- determining a cost center identifier associated with the project record;
- and
- processing a plurality of cost center records each of which contains a cost center identifier, an account type identifier, and an expense amount, wherein each one of the cost center records is processed by:
- identifying a cost center group comprising the project records associated with the cost center identifier contained in the cost center record;
- and
- allocating the expense amount contained in the cost center record across the project records in the cost center group based on the normalized level of effort value for each of the project records in the cost center group.
6 more elements
A computer-implemented data processing method, comprising:
- processing a plurality of project records each of which contains a project identifier for a project, a team identifier for a team assigned to the project, and a level of effort value indicative of an overall effort required for the team to complete the project, wherein each one of the plurality of project records is processed by:
- calculating a normalized level of effort value based on the level of effort value contained in the project record;
- and
- determining a cost center identifier associated with the project record;
- and
- processing a plurality of cost center records each of which contains a cost center identifier, an account type identifier, and an expense amount, wherein each one of the cost center records is processed by:
- identifying a cost center group comprising the project records associated with the cost center identifier contained in the cost center record;
- allocating the expense amount contained in the cost center record across the project records in the cost center group by:
- summing the normalized level of effort values for the project records in the cost center group to obtain a total normalized level of effort value for the cost center group;
- determining a multiplier for each of the project records in the cost center group, wherein the multiplier for each project record comprises a percentage representing the normalized level of effort value for the project record in relation to the total normalized level of effort value for the cost center group;
- and
- applying the multiplier for each of the project records in the cost center group to the expense amount to determine an allocated expense amount for each of the project records in the cost center group.
9 more elements
Dependencies are inferred from the claim text.