公开(公告)号：US20110035408A1

公开(公告)日：2011-02-10

申请号：US12908203

申请日：2010-10-20

申请人： Thomas HOTZ

发明人： Thomas HOTZ

IPC分类号： G06F17/30

CPC分类号： G06Q10/06 ,  G06F17/30371 ,  G06F17/30578 ,  G06Q40/04

摘要： A system and method to reconcile Human Resource databases, including payroll, accounting, tax and travel databases, are provided. The system and method may include a database aggregation component that automatically gathers and stores a plurality of databases in a corporation business information system wherein these databases may be logically related to each other and a database reconciliation component that is capable of querying a database for retrieving data entries based on user instructions or on requests automatically generated according to preset conditions. The reconciliation method may further compare data from logically related databases. If discrepancies exist in a comparison result, the method may provide a drill-down step where data at next level of detail may be retrieved according to automatically generated queries. This reconciliation process of comparison and drill-down for more detail may continue until a preset condition is satisfied or there is no further detail to retrieve. The system may produce a report relating to the reconciliation results.

摘要翻译： 提供了一个调和人力资源数据库的系统和方法，包括工资单，会计，税务和差旅数据库。 系统和方法可以包括数据库聚合组件，其自动地收集并存储在公司业务信息系统中的多个数据库，其中这些数据库可以在逻辑上彼此相关，并且数据库对帐组件能够查询数据库以检索数据 基于用户指令或根据预设条件自动生成的请求的条目。 协调方法可以进一步比较逻辑相关数据库中的数据。 如果比较结果中存在差异，则该方法可以提供一个向下钻取步骤，其中可以根据自动产生的查询来检索下一级细节的数据。 比较和深入了解更多细节的对帐过程可能会持续到预设条件满足或没有进一步的细节检索。 该系统可能会产生一个与调节结果有关的报告。

公开(公告)号：US20090157689A1

公开(公告)日：2009-06-18

申请号：US11956980

申请日：2007-12-14

申请人： Thomas HOTZ

发明人： Thomas HOTZ

IPC分类号： G06F17/30

CPC分类号： G06Q10/06 ,  G06F17/30371 ,  G06F17/30578 ,  G06Q40/04

摘要： A system and method to reconcile Human Resource databases, including payroll, accounting, tax and travel databases, are provided. The system and method may include a database aggregation component that automatically gathers and stores a plurality of databases in a corporation business information system wherein these databases may be logically related to each other and a database reconciliation component that is capable of querying a database for retrieving data entries based on user instructions or on requests automatically generated according to preset conditions. The reconciliation method may further compare data from logically related databases. If discrepancies exist in a comparison result, the method may provide a drill-down step where data at next level of detail may be retrieved according to automatically generated queries. This reconciliation process of comparison and drill-down for more detail may continue until a preset condition is satisfied or there is no further detail to retrieve. The system may produce a report relating to the reconciliation results.

摘要翻译： 提供了一个调和人力资源数据库的系统和方法，包括工资单，会计，税务和差旅数据库。 系统和方法可以包括数据库聚合组件，其自动地收集并存储在公司业务信息系统中的多个数据库，其中这些数据库可以在逻辑上彼此相关，并且数据库对帐组件能够查询数据库以检索数据 基于用户指令或根据预设条件自动生成的请求的条目。 协调方法可以进一步比较逻辑相关数据库中的数据。 如果比较结果中存在差异，则该方法可以提供一个向下钻取步骤，其中可以根据自动产生的查询来检索下一级细节的数据。 比较和深入了解更多细节的对帐过程可能会持续到预设条件满足或没有进一步的细节检索。 该系统可能会产生一个与调节结果有关的报告。