Quickly Access Your Payroll Information

The KBX™ Payroll Datastore simplifies access to Oracle® Payroll information by denormalizing the data, and therefore reducing the number of tables that are required to join together in order to obtain useful information. This denormalization greatly increases payroll reporting performance and grants users the flexibility to create detailed reports in a fraction of the time it would require to gather the same information from Oracle® reporting.

• Quickly run reports and perform detailed payroll analysis
  
  KBX dramatically reduces processing times for reports, interfaces, and custom processes. Because the KBX™ datastore stores data in such a denormalized manner, most reports are measured in minutes, not hours.
• Easily create flexible custom interfaces
  
  Writing reports and interfaces has never been easier. KBX consists of a highly denormalized schema that holds all employee and tax balances. This simple structure allows programmers quick and easy access to critical payroll data.
• Perform Ad-Hoc Queries
  
  Empower your users to run reports on the fly. The KBX™ Payroll Datastore dynamically updates itself when changes are posted by Oracle®, allowing you to access data in real-time with no outside IT involvement or detailed API calls required.

Why is KBX™ So Much Faster?

• KBX™ Tax Balance details are stored wide and not deep
  
  As an example, Oracle's® "deep" method of storing information uses a separate row for each tax type category (e.g., the FIT Tax Type has 14 separate row entries in Oracle®, and only one row entry within KBX™).

  One of the major major drawbacks to this "deep" storage method is that each row entry also requires a unique Row ID, or pointer. Because Oracle® is capable of storing terabytes upon terabytes of data, these pointers end up taking up considerable amounts of space in the database, weighing it down and inevitably reducing performance.

  The "wider" design of the KBX™ Payroll Datastore uses fewer rows and more columns, providing a much leaner and faster repository of data to search. Thus, fewer rows are required to be read during each request for information, allowing for more efficient SQL queries (as shown above).

• The KBX™ Payroll Datastore stores derived balances
  
  Oracle® does not store actual balances within its tables, and instead uses a mathematical algorithm to derive balances each time they are requested. This further taxes valuable CPU cycles by requiring multiple look ups and calculations for each and every request. The KBX™ Payroll Datastore, on the other hand, stores derived balances within its tables, delivering balance information with one simple look up.

Advanced Options:

• Online SOEs
• Check Printing
• Deposit Advices