Category: Pre-built Reports

Prebuilt HCM Report to view all Transfer details

HCM prebuilt reports

One of the most important processes in an Organization is Employee Transfer. These transfers usually occur under different organizational requirements such as: • The requirement of additional resources in a department • Need for resources with a particular skill set • Releasing unutilized resources across departments etc. Every Management should constantly monitor the resources available and how they are utilized in each department in order to effectively maintain the recruitment process and the existing resources in an Organization. Report Description: DataTerrain’s Prebuilt report lists the changes or transfers of an employee for a particular effective date. The transfers in Job Location, Position, Manager, Company and Job codes will be captured in the output. This prebuilt report can be run for the below parameter • Effective Date This report can also be modified to run for a date range so that Users can view the transfers that occurred in a particular date range. This report is built as a BIP report and hence it can be run from the BI Publisher Catalog. Output: The output data will have both a new Job/Location/Position/Company details along with the previous Job/Location/Position/Company details. The output format of this report is Excel and it can also […]

Read More +

Expedite Peoplesoft Reports to Oracle HCM Migration Using Pre-Built Reports

Most of the big enterprises have started migrating their Peoplesoft system to Oracle Fusion HCM. After the migration process, one of the important challenges faced by the Users is that they would be not able to have the reports in Oracle Fusion HCM that they were previously using in Peoplesoft Environment. Oracle provides a bundle of pre-built reports which users can make use for viewing the required Payroll/HR/Compensation data from Fusion. In certain scenarios, users would like to have their existing PeopleSoft report replicated in Oracle Fusion HCM for requirements such as tax filing or other internal audit purposes. DataTerrainhas created a variety of pre-built Oracle HCM reports which are similar to Peoplesoft reports in report functionality and formatting features such as page breaks and totals. These reports can be quickly rolled out with minimal customization, saving significant time and cost. Some of the useful Peoplesoft reports that are already pre-built in Oracle Fusion HCM are: • PAY007 – Deduction in Arrears • PAY013(CN) – Employee Earnings Snapshot • TAX010FD – Tax Summary – Federal (can be run for a date range) • TAX010ST – Tax Summary – State (can be run for a date range) • TAX900 – Tax […]

Read More +

Balance Groups in Oracle Fusion HCM

Balance Groups in HCM are amounts or hours that are aggregated based on Month, Quarter or Year. Balance Group and Balance Group Usages for the specific Balances can be created from the Payroll Calculation work area in the Oracle Fusion HCM environment. Oracle HCM Fusion provides us the option of using either Pre-defined balance groups or User-defined custom balance groups for our reports. Pre-defined Balance groups in HCM contain information about all the earnings and deductions but if we would like to see only the amounts or hours of a list of earnings. User-defined custom balance group can be created with the list of earnings that we require and use it in our custom extract to view only the values for those earnings. Data Terrain 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 worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

PreBuilt HCM Report to view Officer Wages

HCM prebuilt

DataTerrain’s Prebuilt HCM report is designed to display the Gross wages of Employees with Officer Codes for the fiscal year to utilize these information for specific tax credits. 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 Unit This Prebuilt report is available as an HCM Extract and hence it can be run from the Checklist.Output: The output data will have Officer Code, Tax level, and Gross Wages 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 as per their business requirement. 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 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 +

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 +

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 +