Generating ERE Reports

These topics provide an overview of ERE reports and discuss how to generate ERE reports.

Page Name

Definition Name

Usage

Autonomous Community ESP Page

AUTON_REG_S_ESP

View autonomous communities.

ERE Data Report ESP Page

ERE_RC_DTA1_ESP

Generate an ERE request.

Process ERE Activity Data ESP Page

ERE_RC_XML2

Load activity periods data.

ERE Activity Periods ESP Page

ACTIVT_PERIOD_ESP

Modify activity periods data.

ERE SPEE Communications ESP Page

ERE_RC_XML

Generate ERE XML files.

Oracle enables you to generate following ERE-specific reports:

  • Free format ERE request.

  • Benefit registration XML report

  • Activity periods XML report.

  • ERE procedure report

Free Format ERE Request

You generate this report for both permanent and temporary ERE to generate an official request for the ERE event that you defined.

Benefit Registration XML Report

You generate this report for employees affected by both permanent and temporary ERE to register them with the SPEE as eligible to receive unemployment benefits.

Activity Periods XML Report

You generate this report on a monthly basis to communicate to the SPEE the activity periods for employees affected by temporary ERE. SPEE uses this information to determine the employees’ monthly unemployment benefit. Generating this report is a three-step process:

  1. Load activity periods data for a given month and year using the Process ERE Activity Data (ERE_SCHD_ESP) process.

  2. Make any necessary modifications to the loaded activity periods data using the ERE Activity Periods ESP page.

  3. Generate the Activity Periods Report using the ERE SPEE Communications ESP page.

ERE Procedure Report

You generate this report to initiate an ERE by communicating it to the SPEE.

Use the Autonomous Community ESP page (AUTON_REG_S_ESP) to view autonomous communities.

Navigation

Set Up HCM > Install > Country Specific > Autonomous Community ESP

Image: Autonomous Community ESP page

This example illustrates the fields and controls on the Autonomous Community ESP page. You can find definitions for the fields and controls later on this page.

Autonomous Community ESP page

Some data related to ERE are linked to the autonomous community in which the ERE is requested. It is also possible for one ERE event to impact more than one autonomous community. The Autonomous Community ESP page enables you to view the delivered autonomous communities and the states with which they are associated.

Use the ERE Data Report page (ERE_RC_DTA1_ESP) to generate an ERE request.

Navigation

Workforce Administration > ERE Procedure ESP > ERE Data Report ESP

Image: ERE Data Report ESP page

This example illustrates the fields and controls on the ERE Data Report ESP page. You can find definitions for the fields and controls later on this page.

ERE Data Report ESP page

Field or Control

Definition
ERE ID

Enter the ID of the ERE event for which you are generating a request.
Company

Enter the ID of the company associated with the ERE request. If you leave this field blank, the system generates the report for all companies affected by the ERE event.
Autonomous Community

Enter the autonomous community associated with the ERE request. If you leave this field blank, the system generates the report for all autonomous communities affected by the ERE event.
As Of Date

Enter the date for which you are generating the ERE request. By default, the system populates this field with the begin date defined for the selected ERE ID.

Use the Process ERE Activity Data ESP page (ERE_RC_XML2) to load activity periods data.

Navigation

Workforce Administration > ERE Procedure ESP > Process ERE Activity Data ESP

Image: Process ERE Activity Data ESP page

This example illustrates the fields and controls on the Process ERE Activity Data ESP page. You can find definitions for the fields and controls later on this page.

Process ERE Activity Data ESP page

Field or Control

Definition
ERE ID

Enter the ID of the ERE event for which you want to load activity periods data.
Company

Enter the ID of the company for which you want to load activity periods data.
Social Security Number

Enter the social security number of the employer for which you want to load activity periods data.
Year and Month

Select the year and month for which you want to load activity periods data.

Use the ERE Activity Periods ESP page (ACTIVT_PERIOD_ESP) to modify activity periods data.

Navigation

Workforce Administration > ERE Procedure ESP > ERE Activity Periods ESP

Image: ERE Activity Periods ESP page

This example illustrates the fields and controls on the ERE Activity Periods ESP page. You can find definitions for the fields and controls later on this page.

ERE Activity Periods ESP page

Use this page to make modifications to the activity periods data loaded by the Process ERE Activity Data (ERE_SCHD_ESP) process.

Activity Period

Field or Control

Definition
Calendar Year and Month

Select the year and month for the activity periods data you want to modify.
Activity Coefficient

Select the coefficient for the activity period.
Report as XML

Indicate whether the activity periods data XML file has been generated and communicated. Valid values are: Not Communicated, XML Generated, and XML Sent/Confirmated.
Activity Days, Vacation Days, No Activity Days, and IT/Maternity Days

Display the number of days for each type of activity for the selected month and year.

Activity Intervals

Use this group box to enter activity codes for the periods within the selected month and year.

Field or Control

Definition
Begin Date and End Date

Enter a date range for a given activity code.
Activity Code

Enter the activity code for the period. Valid values are: Activity, Maternity/IT, No Activity, No Activity due Push Back Call, and Vacations/Weekends.

Use the ERE SPEE Communications ESP page (ERE_RC_XML) to generate ERE XML files.

Navigation

Workforce Administration > ERE Procedure ESP > ERE SPEE Communications ESP

Image: ERE SPEE Communications ESP page (Benefit Registration template)

This example illustrates the fields and controls on the ERE SPEE Communications ESP page (Benefit Registration template). You can find definitions for the fields and controls later on this page.

ERE SPEE Communications ESP page (Benefit Registration template)

Image: ERE SPEE Communications ESP page (Activity Periods Reports template)

This example illustrates the fields and controls on the ERE SPEE Communications ESP page (Activity Periods Reports template). You can find definitions for the fields and controls later on this page.

ERE SPEE Communications ESP page (Activity Periods Reports template)

Image: ERE SPEE Communications ESP page (ERE Procedure template)

This example illustrates the fields and controls on the ERE SPEE Communications ESP page (ERE Procedure template). You can find definitions for the fields and controls later on this page.

ERE SPEE Communications ESP page (ERE Procedure template)

You can use this page to generate three different XML reports:

  • Activity Periods Report

  • Benefits Registration Report

  • ERE Procedure Report

Report Request Parameters

Field or Control

Definition
Template Type

Select whether you want to generate an XML file for Benefits Registration or Activity Periods Reports or ERE Procedure. The fields displayed in the Employee List group box change depending on your selection.
ERE ID

Enter the ID of the ERE event for which you are generating the XML file.
Send Type

Select if you are sending a new communication or updating an already sent communication. The values available are:

  • New Communication

  • Update Communication

Note: This field appears only in case of ERE Procedure reports.
Transaction

If you want to update an already sent communication, select if you would like to update or delete the XML file. The field appears when you select Update Communication in the Send Type field.

Note: This field appears only in case of ERE Procedure reports.
Company and Company City Code

Enter the ID and city code of the company for which you are generating an XML file.

Note: The Company City Code field is available only for ERE Procedure reports.
Year and Month

Enter the year and month for which you are generating an XML file. These fields appear only if you select Activity Periods Reports on in the Template Type field.
Social Security Number

Enter the social security number of the employer for which you are generating an XML file.
Center City Code

Select the city code for the work center.

Note: This field appears only in case of ERE Procedure reports.
File Path and File Name

You can enter the directory to which the XML file is to be saved in the File Path field and the name of the file to be sent to SPEE in the File Name field.

Note: The file name extension must be .XML.
XML Report Status

Select the status of the XML report. The values available are:

  • Not Communicated

  • XML Generated
Search

Click the button to populate the Employee List group box with employees that meet the criteria you specify in the Report Request Parameters group box.

Employee List

When you click the Search button, this group box displays the employees that meet your search criteria. The fields that appear in this group box depend on which value you select in the Template Type field. Select the Generate Report check box next to the employees for which you want to generate an XML file.