Category: Pre-built Reports

How to capture and view Employee Safety Statistics using Oracle HCM

HCM Prebuilt

DataTerrain’s Oracle HCM Employee Safety Statistics Prebuilt report is designed to display the number of employees and total hours worked for each site and Department ID (division, cost center). This report can be run for the below parameters● Start Date● End Date● Person● Process Configuration Group● Payroll● Consolidation group● Payroll Statutory Unit● Tax Reporting Unit● Payroll Relation GroupThis Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Number of Employees and Hours details of each site and Department ID.The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule : Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use it for a regular audit. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

How to view Earning Element Details in Oracle HCM

Earning element in oracle HCM

Report Description: DataTerrain’s Prebuilt report is designed to display the earning element details of employees in a particular Pay Period Date range. This report can be run for the below parameters • Pay Period Start Date • Pay Period End Date • Emp ID This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist. Output: The output data will have Earn Code, Department and Business Unit information of each employee. The output format of this report is Excel and it can also be rendered as PDF/CSV. Schedule: HR/Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use it for a regular audit. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 250 customers in the US and an additional 70 customers worldwide. We are flexible in working hours and do not need any long term binding contracts.

Read More +

How to view Element Costing Details in Oracle HCM

payroll reports

DataTerrain’s prebuilt report calculates costing for prepayments, QuickPay prepayments, and external payments, along with void, canceled, unreconciled, and reconciled payments. This report can be run for the below parameters● Process Start Date● Process End DateThis Prebuilt report is available as a BI Publisher Data model report.Output: The output data will have Element details, Credit and Debit amount.The output format of this report is Excel and can also be rendered as PDF/CSV.Schedule: Payroll Team can also schedule the report to be delivered weekly/bi-weekly and use for a regular audit.DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

PreBuilt HCM Report to view Employees in Incorrect Paygroups

HCM Prebuilt

Report Description:DataTerrain’s Prebuilt report is designed to display the list of Hourly employees who are in Salaried pay group and Salaried employees who are in hourly paygroup. It will be helpful to find associates who are not assigned with their appropriate pay group.This report has following parameters❖ Start Date❖ End Date❖ Person Number❖ Payroll NameThis Prebuilt report is available as BIP/HCM Extract and hence it can be run from the Checklist and also this report can be built as a BIP Datamodel report. Output: The output data will have PayGroup information of each employee.The output format of this report is Excel.Schedule: HR/Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use it for a regular audit to check if any employees are assigned an inappropriate paygroup. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.. Sample Output:

Read More +

How to view Multiple Payments Type Details in Oracle HCM

Oracle HCM

Report Description:DataTerrain’s Oracle HCM prebuilt report provides the definition of how payments are handled through organizations and employees. The Payment Distribution Mechanism varies depending on the country in which the organization is operating. It can be electronic, check or multiple third-party “payees”.This report can be run for the below parameters:● Effective Date● Start Date● Process Configuration GroupThis Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Payment Type, Contact details of each employee.The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule: Payroll Team can also schedule the report to get it delivered weekly/bi-weekly and use for a regular audit.DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Pre-built – HCM Payroll Audit Report

The HCM Prebuilt Payroll Audit Report has excellent functionalities to track/capture the employees that are being paid more than standard hours to reduce over-payments. This Prebuilt report can be run for Organization or Payroll or PersonNumber or Date Range which could be scheduled and delivered to an FTP Server/Email as per the user’s requirement. Enhancements such as adding new parameters or conditions to this report are simple. The output type, by default, is Excel which is also customizable to any other format (such as PDF/CSV). Report output contains following columns such as Person Number, Assignment Number, First Name, Legal Employer, Payroll Name, Pay Period Begin, Pay Period End, Standard Working Hours. Some users prefer to run the report from CheckList which would require the report to be built as Extract and some run directly from BI Publisher Catalog for which reports should be BIP. We have developed this report in both an HCM Extract report and BI Publisher Data model report which users can make use of as per their needs. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers […]

Read More +

How to use Oracle HCM Report to view Exempt and Nonexempt employees

HCM Extract

DataTerrain’s prebuilt report provides the legal classifications of employees (Exempt and Nonexempt status) used to distinguish between different types of employees. This report can be run for the below parameters● Effective Date● Start Date● Consolidation Group● Payroll● Payroll Relationship Group● Payroll Statutory Unit● Person Number● Tax Reporting UnitThis Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Payroll information, Exempt and Non-Exempt details for a given date range.The output format of this report is Excel and it can also be rendered as PDF/CSV.Schedule: HR/Payroll Team can also schedule the report to have it delivered weekly/bi-weekly and use it for a regular audit.DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Prebuilt HCM Report to view Worker Eligibility for next Grade Step

HCM Prebuilt reports

Report Description:DataTerrain’s Prebuilt report is designed to display the eligibility details of employees for their next grade step progression. If the person satisfies a specified duration criterion for the next grade step, then the person will be eligible for the next grade. The metrics of determining the next grade step can be modified as per customer needs.This report can be run for the below parameters● Effective Start DateThis Prebuilt report is available as a BI Publisher Data model report.HDL Files: This report has additional (optional) report templates which would fetch the next Work Terms, Assignment, and Salary information of employees.Customers can use these templates for 2 purposes:● Output from these report templates are in text format which they can upload to the HCM instance using HDL Process to update the employee’s next grade, salary and assignment information.● Users can directly run these report templates to just view the next grade related data of the employees.Output: The output data will have Current Grade and Next Grade Step information along with their assignment, salary, and work terms information of each employee.The output format of this report is Excel.Schedule: This report can be scheduled on a regular basis to track the employees on […]

Read More +