Creating Payee Reports

This chapter provides an overview of payee data reporting and discusses how to:

Define payee reports.
Generate payee reports.

Understanding Payee Data Reporting

For certain payroll business processes, it is necessary to generate reports to comply with legislative reporting requirements, verify data, or convey payroll information within the organization. Legislated reports are required for processes such as employee state insurance (ESI), provident fund, medical allowance, leave travel allowance, and year-end processing. Global Payroll for India provides setup and run control reporting pages to address your reporting needs.

To create payee reports:

Define report fields.
Define break levels to control how data is sorted for the report.
Define the report format.
Map Global Payroll elements to the defined report fields.
Launch the report run control.

Global Payroll for India provides delivered functionality for the following payee reports:

Newly enrolled payees.
Terminated payees.
New hires.
Profession tax.
ESI remittance.
Provident fund remittance.
Leave travel allowance and medical allowance taxable amounts.

Defining Payee Reports

To define payee reports, use the Payee Report Fields IND (GPIN_PR_FLD_TABLE), Payee Report Break Levels IND (GPIN_PR_BRK_LVLS), Payee Report Setup IND (GPIN_PR_SETUP), and Payee Report Element Map IND (GPIN_PR_EMAP) components.

This section provides an overview of element mapping and discusses how to:

Define report fields.
Define report break levels.
Define the report format.
Define report element mapping.

Understanding Element Mapping

After you define valid report fields and a report setup (format), you must map Global Payroll elements to the report fields. The mapping of elements enables you to specify multiple elements that make up a report field. For example, if a salary field is to be printed on a report and several elements must be added together in order to print this field on a report, you can select the Global Payroll elements that comprise this field.

The Entry Type field prevents an element of the wrong type from being selected, based on the variable type. For example, a report field that has been defined as a field type of character, only allows Global Payroll elements that resolve to character values to be selected.

The following table specifies the types of Global Payroll elements that can be mapped to a report field, based on the field type defined:

Field Type	Types of Elements Allowed
Numeric	Auto Assigned Accumulator Segment Accumulator Bracket − Numeric Deduction Earning Formula − Monetary and Decimal System Element − Numeric Variable − Numeric
Character	Bracket − Character Formula − Character System Element − Character Variable − Character
Date	Calendar Date Bracket − Date Date Formula − Date System Element − Date Variable − Date

Pages Used to Define Payee Reports

Page Name	Object Name	Navigation	Usage
Payee Report Fields	GPIN_PR_FIELDS	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, Payee Report Fields IND, Payee Report Fields	Define the individual payee data items as report fields that will appear in a report.
Break Levels	GPIN_PR_BRK_LVLS	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, Payee Report Break Levels IND, Break Levels	Define the break levels for a report. You can select any system element or variable that resolves to a character value. Only select elements that are resolved for a payee. Otherwise, the report will not break properly.
Report Setup	GPIN_PR_SETUP	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, Payee Report Setup IND, Report Setup	Define the report format. Identify the break levels and report fields valid for the report.
Element Mapping	GPIN_PR_ELEM_MAP	Set Up HRMS, Product Related, Global Payroll & Absence Mgmt, Reports, Payee Report Element Map IND, Element Mapping	Map Global Payroll elements to report fields.

Defining Report Fields

Access the Payee Report Fields page.

Field Name

Uniquely identifies a field for a report. Maximum of 15 characters.

Description

Description of the report field that is printed on a report.

Short Description

Brief description of the report field. If left blank, this field defaults to the first 10 characters of the Description field.

Field Type

Defines the format of the data for the field. Select Numeric, Character, or Date. After you select a field type for a report field, you cannot alter it.

Comment

Additional information about the field.

Defining Report Break Levels

Access the Break Levels page.

Break Level

A number that identifies the break level code.

Date Type CD

Values are System Data (for PeopleSoft-delivered break level) or Customer Data (for all other break levels).

Element

Entry Type	Select the entry type of the element that you’re associating with the break level. Values are System Element - Character and Variable - Character.
Element Name	Select the system element or variable that you’re associating with the break level. For example, if you define pay group as the break level, select the GP PAYGROUP element.

Note. Any element that you select must be resolved and stored.

Source and Use

If you select a system element, information that is contained on the Source and Use page of GP_PIN appears in this group box.

Defining the Report Format

Access the Report Setup page.

Report ID

Name of the Structured Query Report (SQR) that you are defining.

Description

Description of the SQR.

Report Break Levels

Break Level 1, Break Level 2 and Break Level 3

First, second, and third break levels for the report.

Fields

Field Name

Select a report field (defined on the Payee Report Fields page) to be used in the report. The corresponding description and field type appear when you select a report field.

Defining Report Element Mapping

Access the Element Mapping page.

Report ID

Name of the SQR that you are mapping.

Report Field

Field Name	Report field that has been defined by using the Report Setup page.
Field Type	The format of the report field as defined by using the Payee Report Fields page.

Elements

Entry Type	The type of element to be mapped to the report field. This changes depending on the field type.
Element Name	Name of the element to be mapped to the report field. The corresponding description appears when you select an element name.
Add/Subtract	Select whether you want the element to add or subtract from the total on the report.

Generating Payee Reports

This section provides an overview of the report generation process and discusses how to:

Run enrollment and termination reports.
Run ESI remittance statement reports.
Run provident fund remittance statement reports.

Understanding the Report Generation Process

When you run the payee report process, an Application Engine payee report extract process runs first. The extract process retrieves the run control and determines which report to execute. The appropriate report setup is also retrieved along with the break levels and element mapping that is associated with the report. So the process executes in this order:

Payee report extract process (Application Engine) gathers information about the report.
SQR runs the actual report.

Pages Used to Generate Reports

Page Name	Object Name	Navigation	Usage
Enroll/Term Report	GPIN_PR_GPINPY01	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, Enroll and Term Reports IND, Enroll/Term Report	Generate enrollment and termination reports.
ESI Remittance (employee state insurance remittance)	GPIN_PR_RC	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, ESI Remittance Statement IND, ESI Remittance	Generate ESI remittance statement reports.
PF Remittance (provident fund remittance)	GPIN_PR_RC	Global Payroll & Absence Mgmt, Absence and Payroll Processing, Reports, PF Remittance Statement IND, PF Remittance	Generate provident fund remittance statement reports.

Running Enrollment and Termination Reports

Access the Enroll/Term Report page.

Period ID

Select the period ID that identifies the pay period to be used for the report. When you enter a value in this field, the associated begin date and end date appear.

Report Type

Select whether you want the system to generate a new enrollment or termination report.

Report

Select whether you want the system to generate an ESI or provident fund report.

Running ESI Remittance Statement Reports

Access the ESI Remittance page.

Period ID

Select the period ID that identifies the pay period to be used for the report. When you enter a value in this field, the associated begin date and end date appear.

Payee Sort Option

Select a sort order for the report. Options are:

Employee ID, Employee Rcd Nbr: Employee ID, employee record number.

Name, Employee Rcd Nbr: Name, employee record number.

Running Provident Fund Remittance Statement Reports

Access the PF Remittance page.

Field Name	Uniquely identifies a field for a report. Maximum of 15 characters.
Description	Description of the report field that is printed on a report.
Short Description	Brief description of the report field. If left blank, this field defaults to the first 10 characters of the Description field.
Field Type	Defines the format of the data for the field. Select Numeric, Character, or Date. After you select a field type for a report field, you cannot alter it.
Comment	Additional information about the field.

Break Level	A number that identifies the break level code.
Date Type CD	Values are System Data (for PeopleSoft-delivered break level) or Customer Data (for all other break levels).

Report ID	Name of the Structured Query Report (SQR) that you are defining.
Description	Description of the SQR.

Period ID	Select the period ID that identifies the pay period to be used for the report. When you enter a value in this field, the associated begin date and end date appear.
Report Type	Select whether you want the system to generate a new enrollment or termination report.
Report	Select whether you want the system to generate an ESI or provident fund report.