PeopleSoft HCM Reports: Selected Reports
This topic provides detailed information on individual reports. The reports are listed by report ID.
The report provides the following information regarding the origin of the seniority rate code:
If the worker receives a seniority pay component as a result of belonging to a group associated with a seniority rate code, the report displays the corresponding group ID for the seniority rate code.
If a worker receives the seniority pay component because the seniority rate code is associated with all workers, the report displays All as the origin of the seniority rate code.
If a worker receives the seniority pay component because you manually added it, the report displays Manually Added as the origin for the seniority rate code.
The report flags six different types of discrepancies. Specifically, it flags job records when the following pairs of data exist:
Field or Control |
Definition |
---|---|
Citizenship Status |
|
Country of Citizenship |
|
Visa Record |
|
The report puts a page break between categories.
One important reason to designate primary and secondary jobs is to create accurate data for regulatory reporting. By running reports for a worker's primary job only, you create an accurate worker count for affirmative action and other government reports. However, the flexibility PeopleSoft Human Resources gives you to designate primary and secondary jobs could compromise the accuracy of your reporting data. It's possible to have workers who have no job designated as a primary job, or more than one primary job, or an inactive job designated as the primary job. We recommend checking regularly to correct these kinds of discrepancies in your worker job records. Use the Primary Job Audit report to check for discrepancies in the primary job designation for workers with multiple jobs.
This report lists all workers whose job records show the following potential problems:
Multiple primary jobs: More than one active job is currently designated as a primary job.
Terminated primary job: The primary job was terminated and a nonprimary job is the active job.
No primary job: None of the person's concurrent jobs has been chosen as the primary job.
This report lists workers by department and supervisor level including workers with additional appointments.
To run the report, at least one Department tree must be created. For the purposes of department security, the DEPT_SECURITY tree usually already exists. You can either select this tree or create a new department hierarchy beneath the DEPARTMENT tree structure.
The report is sorted by Department then:
Employees with supervisor levels registered in the Supervisor Level tree, in tree order.
Employees with supervisor levels not registered in the Supervisor Level tree, in alphanumeric supervisor level order.
Workers without supervisor levels, in alphanumeric emplID order.
Note: The Supervisor Level tree that the system uses for sorting is the one used for the Appointment Notification and Appointment List reports. It must be named SUPERVISOR_LEVEL if the system is to use it. If you have not defined a Supervisor Level tree with that name, sorting will be in alphanumeric supervisor level order.
After you enter all the reporting relationships among positions in the Position Data component, run this SQR. The Build Position Structure report enters a value in the ORG_CODE field and defines the position in the hierarchy. When you run the Build Position Structure report the system updates the position structure with data valid before or on the As of Date you specify.
You should run this report when you first enter the reporting relationships, any time you add new positions, and when you change reporting relationships among existing positions. You must run this SQR before you can run the Indented Position Hierarchy report, POS006.
When you run Build Position Structure, the system may generate one or more diagnostic messages to help you understand the utility output. They are as follows:
If the utility doesn't find a root position (a position that reports to itself), it displays an error message. If you do not have a root node, the utility can not produce a report.
If you have circular reporting conditions, such as when position 1 reports to position 2, and position 2 reports to position 1, the utility displays a warning message and the positions will not appear in the report.
If you do not have data in the Reports To Position field for a position, the utility displays a warning message. These positions will not appear in the report.
You can print incumbent job data where you have prevented automatic cross-updating from occurring (overrides), or you can print only exceptions where the incumbent job and position data is out of sync for other reasons (exceptions).
The Exception/Override report lists the position name and the name of the worker assigned to the position and shows the data in the fields that match in the Position Data component and Job Data component. The report displays those workers whose HR Status is Active, Leave of Absence, Suspended, or Leave with Pay.
When you run this report for exceptions and the Business Title in the incumbent Employment Data doesn't match the Position Title in Position Data, the report prints an asterisk (*) next to the Position Title. The report also prints Match or No Match in the Mail Drop column, depending on whether the data is the same in the incumbent job and position data.
For reporting purposes you need to identify all the different categories of fringe benefits and the taxable value of the benefits. In the FBT Reconciliation report, all FBT categories are identified, based on the component types you define on the Package Component table component. For each component type, or FBT category, you can see the workers who have received this benefit in the FBT year. You also see information on the budgeted and the actual gross taxable value of the benefits. These values are shown for each worker and as a total for each component.
You can combine the information provided in the FBT Reconciliation report with information from your other administrative systems to accurately complete your FBT return for the Australian Taxation Office.
Note: The FBT Reconciliation Report includes values calculated during the Package Expense Calculation. To ensure that you get accurate totals included in the FBT Reconciliation report, execute the Package Expense Calculation at the end of the FBT Year for which to run the FBT Reconciliation report. You must complete this before running the report.
After you submit your full-time and part-time Academic Teaching Survey report flat files to Statistics Canada, you receive a summary report from Statistics Canada. Use the StatsCan FT Survey report to compare your results with Statistics Canada's summary.
The report consists of four pages; each includes full-time survey salary calculations based on different selection criteria:
Including administrative posts and medical and dental categories.
Including administrative posts, excluding medical and dental categories.
Excluding senior administrative duties, including medical and dental categories.
Excluding senior administrative duties and medical and dental categories.
The Organization and Group Goals report is an optional report that you can run before or after the goal measurement period. This report provides the plan goal weights for the variable compensation plan ID and period ID and a list of all organization and group weighted goals in the plan with their weighting percent and attainment percent.
This report provides the following information:
The Plan Goal Weights for the variable compensation plan ID and period ID.
A list of all organization weighted goals in the plan with their weighting percent and attainment percent.
A list of all group weighted goals in the plan by group with their weighting percent and attainment percent.
If the group does not have goals, the report indicates that the child group's goals are the parent group's goals.
This report identifies each individual who had either an erred or rejected award under the variable compensation (VC) plan ID and payout period ID. For each erred or rejected award, the report identifies the worker, award value, award status, and rejection reason (payroll only).
The following are the valid payroll rejection reason codes:
Invalid Earning Code (Invalid EC)
Invalid Employee ID & Record # (Invalid EE)
Invalid Currency Code (Invalid CC)
Transaction already exists (Tran exist)
Amount Exceeds Payroll Maximum (Exceed Max)
Reject All -Request by User (Reject All)
This report lists the total deductions made to date and the total company contributions for workers participating in benefit programs that contain savings plans. It prints the total amount available for investment broken down by investment distribution and expressed both as a monetary amount and as a percentage of the total.
For each plan type, it shows the total amount deducted for workers in the plan type and company contributions. The report inserts page breaks and supplies totals at the company, benefit program, plan type, and benefit plan levels.
The Base Benefits Audit Report provides a summary of potential worker data issues as related to Base Benefits business process that would enable you to catch errors that would otherwise show up when you try to process enrollments or changes.
The audits performed are Employees without Employment records, Employees without Job records, Employees less than 16 years old, People with unusual dependents signed up for coverage, Employee and spouse (or other dependent) both electing health benefits, Employees with over-age dependent coverage, Employees with incorrect health plans set up on the Benefit Program Table, and audits for consistency of marital and dependent relationships.
Perform these audits during implementation, before you enroll participants, and periodically during the plan year.
This report provides data about COBRA beneficiaries at the Event Level. The report will list all workers to whom an event has occurred. The qualified status indicates whether the qualified beneficiary is Qualified (QL), Not Qualified (NQ), Not qualified/duplicate (ND) or QE (Qualify Error).
This report displays information on: Employees enrolled in Active and COBRA Health Coverage; Employee and Spouse (or other dependent) electing health benefits for the same Dependent ID; and workers who have overage dependents.
You can use this report to analyze whether there is an overlap in COBRA and Active coverage, whether dependents are being covered by more than one EMPLID or whether an overage dependent has not been detected.
This report displays information about errors that result from running the COBRA process. The errors include COBRA event conflict, no eligible benefit program or more than one eligible benefit programs, or duplicate COBRA events.
You can use the COBRA Administration Error Report to identify and troubleshoot errors that surface as a result of COBRA processing. You can also identify these errors online. You might want to print the report and request that staff check off each error as they determine a resolution, thereby creating an audit trail for verifying that all errors have been analyzed.
Specify 401(k) or 401(m) for the report output.
If this report is run mid-year and a forecast percentage is specified in the 401 NDT run control, the report also shows forecasted year end earnings, contributions, and related ADP/ACP results.
This report does not attempt to recalculate the Actual Deferral Percentage (ADP) or to determine whether the nondiscrimination tests passed. It assumes these tests were handled by the NDT002 or NDT003 SQRs. However, in cases where the Aggregate Limit Test must be used, this report serves as the only method to invoke the test; there is no separate SQR for this.
If the Aggregate Limit Test is invoked, each report includes results for both the 401(m) and 401(k) tests, as well as the Aggregate Limit Test pass/fail status. The system prevents you from initiating NDT004 if the run control has been updated and you have not initiated these SQRs:
NDT001: This SQR lists plan type, plan name, benefit plan name and ID, effective date, accrual process date, accrual frequency, service interval, special calculations, year the plan begins, and the maximum leave balance and carryover allowed.
NDT002: You initiate this SQR after NDT001 to update the actual and forecasted amounts in the nondiscrimination testing run control table for the 401(k) NDT.
NDT003: This SQR updates the actual and forecast 401(m) amounts in the nondiscrimination testing run control table for the 401(m) NDT.