DataBroker™

HR experts, business customers, and executives are all equally frustrated by the challenges associated with getting the reports to satisfy their ever-changing business needs. Despite having a more powerful platform than ever in SAP and brilliant IT professionals, reporting remains the most common complaint we hear today due to IT department backlog and the continual shifting of business data requirements. We have developed a simple, yet powerful report-generating platform called DataBroker to overcome these challenges.

As pioneers in the self-services arena, we recognize the advantages of providing people most familiar with the problem with tools to help them solve it. Following this model, DataBroker allows human resource experts without ABAP or programming knowledge to create and modify complex reports through a menu-driven criteria selection process.

DataBroker resides inside of SAP, which brings many benefits:

• Produces standard SAP reports. Reports made with DataBroker are standard SAP reports that can be added to the report tree for all users to access.
• No hidden costs. Because its build in SAP core technologies so there’s no new hardware, software, desktop updates or anything that would increase you support costs.
• Auditor approved. Leverages the existing SOX controls and compliance processes in place now and enhances them with new controls.
• IT standards compliance. DataBroker leverages existing IT standards giving your IT professionals the assurance that nothing will be accidentally broken.

Pre-developed Reports available with DataBroker:

HR Metrics
› Current Headcount › Current Headcount FTE › Current Headcount EEO Demographics › Headcount Trend (Weekly, Monthly, Annually) › Headcount FTE Trend (Weekly, Monthly, Annually) › Headcount EEO Demographic Trend (Weekly, Monthly, Annually)		› Hiring Trend (Weekly, Monthly, Annually) › Termination Trend (Weekly, Monthly, Annually) › Promotion Trend (Weekly, Monthly, Annually) › LOA Trend (Weekly, Monthly, Annually) › Compensation Trend (Weekly, Monthly, Annually)
HR Reports
› New Hire Report › Turnover Report › Promotion Report › LOA Report › Date Specification (Infotype 41) › Employee with EEO Job and Position Info Report › Employee EEO Demographic with Paycheck Report		› HR Master Data Change report (Current period & Retroactive periods) › Employee Supervisor/Chief › Employer Costs by Chief › Total Planned Employee Compensation Report › Total Actual Employee Compensation Report
Payroll
› HR Master Data & Paycheck Reconciliation › Gross-to-Net payroll register › Union reporting › Deduction & Arrears Report › Employee Master Data with Pay Results (RT, CRT, TAX, TCRT, ARREARS) Report		› Vacation Liability Report › Garnishment Setup & Payroll Deduction Reconciliation › FICA Reconciliation › Employee Tax Payment Auditor
Benefits
› Benefit Census › Benefit plan enrollment cost & payroll deduction Reconciliation › FSA & payroll deduction Reconciliation › Benefit plan Opt-out & Un-enrolled Reconciliation › 401K Match Report › 401K Discrimination Testing Report		› Benefit Participation (single row per employee) Report › LOA with Employee Pay and Arrears Report › Employer Benefit Costs (Combined current period, MTD, QTD & YTD) Report › Benefit Eligibility (Actual Hours/Pay) Audit › Dependents Over Age Audit
Time Management
› Perfect attendance Report › Overtime Trend Report (Daily, Weekly, Monthly) › Productive Hours Trend Report (Daily, Weekly, Monthly)		› Paid Leave Trend Report (Daily, Weekly, Monthly) › Unpaid Leave Trend Report (Daily, Weekly, Monthly) › Absence/Attendance Report

Sample Screen Shots

These DataBroker screenshots show the easy-to-use, menu-driven process to create new and modify existing complex SAP HR reports.

Product Brochure

		Product Brochure Download this DataBroker brochure for complete functional and technical product specifications in a graphical format.

 

SAP Product Overview:

• Data Broker product is developed using SAP ABAP and deployed in the customers exist SAP HR environment
• No Customer ABAP development effort required to implement Data Broker
• No Customer ABAP development effort required to create Data Broker reports
• All development objects (ABAP reports and screens, tables, security roles, etc) are delivered via SAP transports
• Reports can be given an SAP Transaction code and added the User’s SAP Easy Access menu Favorites
• No code modifications or copies of SAP objects required to implement
• User ability to run reports for employee and employee data is defined by client’s current SAP security authorizations scheme
• Access to employee is restricted using the standard SAP authority checks of the PNP logical database report
• Access to each infotype is restricted using the standard SAP function module HR_CHECK_AUTHORITY_INFTY
• Reports data is displayed as SAP ALV grid allowing the full capabilities for sorting, filtering, summing and download to excel or other file formats

SAP Release Requirements:

• Earliest Release: SAP R/3 4.7B
• Latest Release: SAP ECC 6.0, EhP4

Additional Software or Hardware Requirements:

• None

Implementation time

Getting started with DataBroker takes less than 1 hour to add the product to your SAP environment. Your reports are then available immediately to run. With our 2 hour training course, human resource experts will be ready to started modifying existing reports and building their own new reports.

SAP Product Overview

DataBroker product is developed using SAP ABAP and deployed in the customer’s exist SAP HR environment.