(ESP) Managing Spanish Reporting

This chapter discusses how to:

• Set up XML files.

• Manage Contrata communications.

• Manage Delta communications.

• Confirm the sending of XML files.

• Manage Contract Printing.

• Generate Affiliation to Social Security (AFI) flat files.

Setting Up XML Files

This section provides an overview of XML file setup and discusses how to:

• Set up XML code tables.

• Define XML sets.

• Set up XML node tables.

• Set up node mapping.

• Define XML templates.

• Map contracts to XML nodes.

Understanding XML File Setup

This overview discusses the XML file setup necessary to generate XML files. The system uses the XML file setup for Delta (Sistema Delt@) reporting, Contrata (Sistema Contrat@) reporting, contract printing, and Tripartite Foundation reporting.

Note. Tripartite Foundation reporting is documented in the PeopleSoft Enterprise Human Resources Administer Training PeopleBook

See (ESP) Managing Tripartite Foundation Communications.

General XML Setup Steps

Before you can generate XML files for reporting, you must set up the components for XML file creation.

To set up XML files:

1. Set up XML code tables.

2. Define XML sets.

3. Set up XML node tables and node mapping.

4. Define XML templates.

5. Map contracts to XML nodes (Contrata reporting only).

6. Map contract-level nodes to the appropriate contract type (Contract Printing only).

7. Perform the steps to generate the XML file.

The XML generation process uses this dynamic setup data to create the XML files based on the specific needs of the report you are generating.

XML Code Tables

XML code tables are tables that list the valid values of an XML node. Code tables enable you to compile setup data through a single menu entry point. Use the XML Code Table (XML_CODE_TBL) component to define the auxiliary XML code tables and the valid values that your company uses. Once you define the XML code tables, you can use them to:

• Map system values to XML code table values for a node.

• Serve as validation tables for the values of a node.

You can perform both of these options when defining XML nodes through the XML Node Table component. Later in the business process, when you are completing a person's node data for an XML file during XML file generation, the system prompts you to select from the valid values that you have defined in the code table for the node.

XML Sets

An XML set is a group XML files. You can associate XML sets with functional areas. Human Resources for Spain delivers an XML set for the Contrata, Delta, Contract Printing, and Tripartite Foundation functional areas. Use the XML Set Table component to define XML set definitions for XML files. You associate XML sets with XML nodes and XML templates. Assign XML sets to XML nodes through the XML Node Table component and to XML templates through the XML Template Table component.

XML Node Tables

XML nodes are the core of the XML file setup. XML nodes are sets of tags within an XML file that determine the hierarchical structure of the file. They represent the XML tags that are mapped to Human Resources data. All tags between the open tag and closed tag of a node comprise the node. Use the XML Node Table component to define XML nodes and create the relationships between the nodes. The nodes that you create and relate to each other define the XML file structure. Through the XML generation process the system can retrieve data that is already stored in the Human Resources database and write the data into the appropriate XML nodes.

You can define complex nodes or simple nodes. Complex nodes are composed of other simple or complex nodes. Complex nodes can be root nodes or children nodes. There can only be one root node per XML template that you define. A root node defines a specific XML file layout. For further embedding of XML tags, children nodes can also contain their own children nodes. Simple nodes are associated with values. To derive the values of simple nodes, you can use as source data manual values that you enter or system values.

Sometimes the data with the system as the source from which you are deriving the values of the nodes does not match the data that you need for the XML file. In cases such as these, you can also use the XML Node Table component to map the system data values to alternate values that fit your reporting needs. For example, PeopleSoft system data uses as gender values M (male) and F (female). However, I.N.E.M. uses H (hombre/male) and M (mujer/female). You can use the XML Node Table component to map these PeopleSoft system values to the corresponding I.N.E.M. values.

XML Templates

XML templates define the type of communications within each functional area, identifying the complete XML structure of the XML file that you generate for each communication. An XML template holds the keys and root node for runtime data retrieval for the XML generation process. When defining each template, you assign a root node. The root node thus contains the whole information for all of the nodes in the template thereby defining the XML file structure. At runtime the system uses these keys to retrieve the correct values for the fields as part of the SQL Select statement when retrieving the data for the children nodes of the root node that you associate with the XML template in its definition.

Contract Mapping

Contract mapping is the means of associating a contract type with XML templates and XML nodes. Within the Contrat@ Mapping component, you select the Contrata template ID for which you want to perform mapping and then link selected contract types to specific XML starting nodes. Through this action you are thus assigning a specific XML format to each contract type. You must assign a specific XML node to each contract type because each contract type could report different information. Delta XML file generation does not use contracts and therefore does not require mapping.

Contract Printing Mapping

Contract printing mapping is the means of associating a contract type with XML templates and XML nodes. Within the Contract Printing Mapping component, you select the Contrata template ID for which you want to perform mapping and then link selected contract types to specific XML starting nodes. Through this action you assign a specific format to each contract type. You must assign a specific XML node to each contract type because each contract type could report different information. Delta XML file generation does not use contracts and does not require mapping.

Note. Contract Printing generates reports in PDF format, not XML format. But the system takes advantage of the functionality of XML generation used in Contrat@ and Delt@ to provide a flexible way to set up and customize the content of the PDF files. So the system uses the XML setup tables to define the data that Contract printing functionality needs to extract

Pages Used to Set Up XML Files

Setting Up XML Code Tables

Access the XML Code Tables page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, XML Code Tables, XML Code Tables).

Code Table	The name of the code table.
Description	Enter the description of the code table.

Code - Description

Defining XML Sets

Access the XML Set Table page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, XML Set Table, XML Set Table).

Human Resources for Spain provides XML sets for both Delta and Contrata reporting. Human Resources for Spain also delivers the XML set P01 for use with all contract printing.

Setting Up XML Node Tables

Access the Node Table page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, XML Node Table, Node Table).

Node Id	When creating a new node, enter a code to identify the node.
XML Set	Select the XML set to specify the functional area for which you are defining this node.
Description	Enter a description of the node.
Tag	Enter the name of the XML tag for the node.
Node Type	Select whether the node is Simple or Complex. Simple nodes are associated with values, whereas complex nodes are composed of other simple or complex nodes.
Root Node	Select this check box to indicate that this complex node is a root node, meaning that it is the node from which all other nodes in the XML file structure are derived. This field appears only when the node type is Complex.
Preview XML	Click this button to access the XML Preview ESP page, where you can preview the XML file structure for the complex node. You can only preview XML files structure for complex node types. This button appears only when the node type is Complex.
Concatenate	Select this check box if the data in this node is the concatenation of two or more fields in the database. The system displays the Node ID field for you to select the concatenated node. This check box becomes available for edit only for simple nodes.
Node Id	Select the concatenated node. This field becomes available only if you select the Concatenate check box.
Source Data	Select how you want to define the source data for the node. During XML file generation, the system uses the option that you select to retrieve and validate node values in the XML file. This field becomes available for edit only for simple nodes. Valid values are: Manual: Select this option for those nodes for which the data is not stored in the HR system, so the system will request its value to be entered manually when generating the file. Selecting this option enables you to validate a node value against the specific XML code table, translate field, or date format that you specify. Or you can specify that there be no validation, enabling the user to enter any node value into an open entry field. System: Select this option to indicate that the valid values for the node already exist in the application as part of a special view designed specifically for XML files. After selecting this option, you then need to specify which record (view) and field contains the valid values for the node. The Record Name field, Field Name field, and Node Mapping page become available for edit. You must select this option if you need to map a system value to an alternate value.
Record Name and Field Name	The system displays these fields when you select system data as the as source data of a simple node. If you select the System value in the Source Data field, you then need to specify which record and field contain the valid values for the XML node. To specify a record and field, first select a record from the list of valid views. Then select a field from the list of available fields in the view. The system uses your selection to validate data when generating XML files. When selecting a valid record and field, you cannot use any record. You must use special views built for this purpose. The delivered special views and any that you create must meet the following two conditions: Name.Record name must start with XML_ and end with _VW.2. Keys.Record keys must be defined using only the fields defined in the template.
Validation Type	Manually select the type of data validation that you want to occur when the system validates the node values that users enter for a person in an XML file. This field becomes available only when the Source Data field value is manual. Valid values are: Code Table: Select this option if you want the node value to come from a table of values as defined on the XML Code Table page. The system displays the Code Table field for you to select the specific table. Date: Select this option if you want the node value to be a date. The system displays the Formatted field for you to select the date format. None: Select this option if you do not need validation of the node value. The system displays the Node Value field as an open entry field on the Details page of the XML file generation pages. Users can enter any value for the node because the field that has no edits for validation. Xlat Field (translate field): Select this option if you want node value to come from a translate table for a specific field. The system displays the Field Name field for you to select the field from which the system prompts users with translate values.
Default Value	For a simple node where the source is manual you can set up a default value.
Reg Region (regulatory region)	Select the regulatory region to use to filter possible code tables to a specific setID. Code tables contain a setID. By selecting the regulatory region, the system enables you to select only the code tables with the same setID as the regulatory region. This field is available only for simple node types that use code tables.
Code Table	If you select a validation type of code table, select the table from which you want the system to prompt users with values to select for a node. This field is available only for simple node types that use code tables.
Formatted	Select how you want the date field to be formatted. This field is available only if you select a validation type of Date..
Field Name	Select the field from which the system prompts users with translate values. This field is available only if you select a validation type of Xlat Field..

Children Nodes

Use this group box to define the children node members of a complex node. All children nodes that you define for a given node appear at the same level in an XML file structure. If children nodes are complex nodes that require their own children nodes, you must define members for these nodes in their own node definition.

This group box appears only when the node type is Complex.

Setting Up Node Mapping

Access the Node Mapping page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, XML Node Table, Node Mapping).

Note. This page becomes available only when you define the Node Type as Simple and the Source Data as System on the Node Table page.

Use this page is cases where the values for the node exists in the application but the system values do not match the values that the XML file requires. Through this page you can map the existing system values to other, more appropriate values that you must use for the XML file.

Defining XML Templates

Access the XML Template page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, XML Template Table, XML Template).

XML Set	When defining new XML Templates, select the XML set to which the template belongs.
Template Type	The identifying code of the template.
Description	Enter a description of the XML template.
Key 1 Field Name, Key 2 Field Name and Key 3 Field Name	Specify the fields that you want to use as keys for the different levels of data that you are reporting with the XML template. These fields indicate the key structure of the table from which the system retrieves data for reporting through XML files. For example, with Contrata reporting you define EmplID and EFFDT as the key fields to indicate that you are reporting employee information based on the effective date of the contracts. With Delta reporting, you define three levels—company, employee, and effective date (or the incident) — to deliver XML files that include information keyed at the company level, employee level, and incident level. When you map a node to a record and field that exist in the database through the XML Node Table component, the record that you select must have at least one of these keys as a record key because the Where clause is built dynamically to use these fields. The system also uses the key fields that you define here as filter criteria when you confirm or unconfirm the sending of XML files that are based on this XML template. Confirm XML files through the XML File Confirmation ESP component.
Root Node	Select the root node for the XML template. By identifying the root node for the XML template you are setting the whole structure of the XML file because the root node contains in a recursive mode the whole structure. The root node is the starting point of the XML structure. Define root nodes on the XML Node Table page.
XML Version	Specify the version of the XML files that are based on this template. Each XML file needs to include a first line that states the version.

Mapping Contracts to XML Nodes

Access the Contrat@ Mapping page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Contrat@ Mapping, Contrat@ Mapping).

Template Type	You can access this page for templates that you have already defined. Define templates on the XML Template page.
SetID	Select the setID of the contract type. The system selects ESP by default.
Contract Type and Description	Select the contract type for which you want to specify the starting node. The system prompts you to select from contract types that are defined for the selected setID.
Node ID and Description	Select the Contrata node to which you want to map the specified contract type. By associating this node to each contract type, you are defining the XML file format and structure for the contract type. Each contract type can require different information to be reported so you must assign different XML structure to each of them.

Managing Contrata Communications

This section provides an overview of Contrata (Sistema Contrat@) communication management, lists steps to manage Contrata XML file generation, lists prerequisites, and discusses how to:

• Define the XML file.

• Populate the XML file for Contrata reporting.

• Load Contrata XML file data.

• Edit Contrata XML file data.

• Generate the Contrata XML file.

• Preview generated XML.

• Confirm Contrata XML file data.

• Delete Contrata XML files.

Understanding Contrata Communication Management

Contrata is a web service of the Public Service of Employment (I.N.E.M.) that enables companies to file new employees' employment contracts, change an employee's situation from temporary to permanent, notify I.N.E.M. of extensions to contracts, and carry out other legally required processes. When companies submit the communication online to I.N.E.M. they receive an immediate response notifying them of errors. Companies can then correct the errors before confirming the communication. It is mandatory that companies communicate contract data to I.N.E.M.

Human Resources for Spain provides Contrata communication functionality that enables you to track multiple persons' labor contract data and to generate an XML flat file to send to I.N.E.M. This feature combined with the Contrata web service eliminates the paper communication between companies and I.N.E.M. and enables companies to communicate data for multiple persons at once, thus reducing time and costs.

Contrata XML files contain all of the data related to the hiring of employees between two dates for a specific type of contract communication. Human Resources for Spain delivers the templates to create XML files to use for Contrata communications of labor contracts, basic copy, and extensions. The XML file generation process obtains data from the HRMS database and from data that you enter when generating the XML file. Once you generate the XML file you can then upload the file through the Contrata web service.

To use the Contrata communication management functionality you must first review the delivered XML file setup data during implementation to ensure that it complies with your company's requirements. This setup includes defining the XML sets, code tables, nodes, and templates necessary for the XML generation process to gather data and generate the XML file. Human Resources for Spain delivers a large percentage of this setup data to facilitate implementation.

Once you complete the XML setup, you can then use the Create Contrata XML Id ESP component to search for and select the persons for whom you need to report Contrata data, load their data into an XML file template, add additional required data, validate the data, and generate the XML file.

Next you can send your completed XML files to I.N.E.M. through the Contrata web service. Use the XML File Confirmation ESP component to confirm the sending status of communications. The system automatically tracks which persons you have included in communications in order to avoid situations where you report data multiple times for the same person, resulting in unintentional overriding and overlapping of data.

After I.N.E.M. sends your company a response XML file regarding your Contrata communication, you can use the Create Contrata XML Id ESP component to review the XML response file for errors and make necessary changes. Depending on the error and communication status, you can then communicate the correct data either by contact I.N.E.M. or regenerate the XML file communication for persons whose data is in error.

Delivered XML Codes for Contrata Reporting

The Spanish social security administration (I.N.E.M.) delivers tables with a simple structure of code equals value, with each of these tables containing numerous values. Human Resources for Spain delivers the social security tables as XML code tables for Contrata reporting, providing many of the table values as sample data. During implementation, you must review the setup data to ensure that it complies with your company's requirements.

The following table describes the data tables within the XML Code Tables component that relate to the Contrata communication functionality:

Delivered XML Nodes for Contrata Reporting

Human Resources for Spain delivers XML file structures for Contrata communication management functionality. You can also define your own XML file structures through this component by creating additional nodes and relating them to each other.

Delivered XML Templates for Contrata Reporting

Human Resources for Spain delivers three different types of communications for Contrata reporting. Use the XML Template Table component to define templates for the types of communication that you use for XML file generation. You can define as many XML templates as necessary to meet your company needs. Human Resources for Spain delivers as system data the following XML templates:

After you have defined XML templates, you can use the Contrat@ Mapping component to link Contrata contract types with XML root nodes.

Steps to Manage Contrata XML File Generation

Once you have entered all of the data necessary for Contrata reporting, you can use the Create Contrat@ Report ESP component to create the Contrata report in XML file format for reporting to I.N.E.M.

To complete the Contrata XML file generation process:

1. Select the template (type of communication) to use for the XML file on the Create Contrata XML Id ESP - Definition page.

2. Specify report parameter and search for persons to include in the report using the Create Contrata XML Id ESP - Population page.

3. Select from the search results on the Population page, the persons to include in the report.

4. Run the load process on the Load Contrata Data ESP page to load data for the selected persons into the XML file.

5. View and edit the loaded data on the Edit Contrata Data ESP page. (Click the Details link to edit a person's data details for the XML file and enter additional information.)

6. Generate the XML file by specifying parameters and running the print process on the Print Contrata Data ESP page.

7. Preview the generated XML file for an employee on the Generated XML file page.

8. Send the XML file to I.N.E.M through the Contrata web service.

9. Confirm or unconfirm the sending of the XML file and evaluate the I.N.E.M. node status of each person included on the Contrata XML file using the Confirm Contrata XML File ESP page.

10. View any errors on the Contrat@ Error page, and then manually fix the errors in the system either at the source or through the Edit Contrata Data ESP - Details page.

11. Regenerate and resend the Contrata XML file for persons with errors as necessary.

12. Confirm or unconfirm the sending of the XML file through Confirm Contrata XML File ESP page.

The XML file generation process stores a record of the data sent in the communication to track which persons you have already processed. Note that you can include only one type of communication per XML file.

Prerequisites

Before you can use the Contrata communications functionality you must first define Spanish workforce data related to Contrata XML files in the appropriate setup pages. This Spanish workforce data includes XML templates, codes, and nodes.

See Also

Setting Up XML Files

Pages Used to Manage Contrata XML File Generation

Defining the XML File

Access the Create Contrata XML Id ESP - Definition page (Workforce Administration, Workforce Reports, Create Contrata XML Id ESP, Definition).

XML File ID	When generating a new XML file, enter an identifier for the XML file generation upon entering the component. You use this identifier to confirm or unconfirm the sending of an XML file on the Confirm Contrata XML File ESP page.
Description	Enter a description for the XML file that you are generating.
Template Type	Select the XML template that you want the XML file generation process to use when generating the XML file. The valid values that you can select depend on the component through which you are generating the XML file. You define XML templates on the XML Template Table page.

Populating the XML File for Contrata Reporting

Access the Create Contrata XML Id ESP - Population page (Workforce Administration, Workforce Reports, Create Contrata XML Id ESP, Population).

Status

Shows the status of the communication for the XML file. Possible values are: XML File No Generated: The XML file has not yet been generated. XML File Created: The XML file has been generated. The system updates the field to this value when you generate the XML file or when you click the Unconfirm All button on the Confirm Contrata XML File ESP page. XML File Sent and Confirmed: The XML file has been sent and confirmed as sent. The system updates the field to this value when you click the Confirm All button on the Confirm Contrata XML File ESP page. This is the same field that appears on the Confirm Contrata XML File ESP page. Upon saving your changes, the system reflects the new value on that page as well.

Filter Data

Use this group box to search for persons who have contract information that you need to report to I.N.E.M. Use the search criteria to narrow your search results.

Employee Data

Use this group box to view the results of your search and select the persons to include in the XML file for Contrata reporting.

Loading Contrata XML File Data

Access the Load Contrata Data ESP page (Workforce Administration, Workforce Reports, Load Contrata Data ESP, Load Contrata Data ESP).

Specify the template type and XML file ID into which you want to load the data that is specified on the Create Contrata XML Id ESP - Population pages for the template type and file ID.

Editing Contrata XML File Data

Access the Edit Contrata Data ESP page (Workforce Administration, Workforce Reports, Edit Contrata Data ESP, Edit Contrata Data ESP).

View a list of the data that was loaded into the specified XML file. Click the Details link to view the details that will be reported to I.N.E.M. for that person.

Generating the Contrata XML File

Access the Print Contrata XML File ESP page (Workforce Administration, Workforce Reports, Print Contrata XML File ESP, Print Contrata XML File ESP).

Enter the path where you want the process to store the Contrata XML report file, and enter the name that you want to process to give the XML file that it places at that path.

Previewing Generated XML

After you run the process from the Print Contrata XML File ESP page to create the Contrata.xml file, you can go to Process Scheduler and click Details, View Log/Trace to view the XML that was generated for the selected person. Use the template ID that you selected on the Definition page of this component.

Note that to generate the XML file with the correct template, you must select the correct template type and use the appropriate XML file ID.

See Also

Previewing Generated XML

Confirming Contrata XML File Data

Access the Confirm Contrata XML File ESP page (Workforce Administration, Workforce Reports, Confirm Contrata XML File ESP, Confirm Contrata XML File ESP).

XML File ID	Upon entering the component, search for the XML file ID for which you want to confirm of unconfirm the sending of the XML file for persons with data in the file. You define XML file IDs when you create XML files for generation.
Status	Shows the status of the communication for the XML file. Possible values are: XML File No Generated: The XML file has not yet been generated. XML File Created: The XML file has been generated. The system updates the field to this value when you generate the XML file on the Generation File page or when you click the Unconfirm All button. XML File Sent and Confirmed: The XML file has been sent and confirmed as sent. The system updates the field to this value when you click the Confirm All button. This is the same field that appears on the Generation File page. Upon saving your changes, the system reflects the new value on that page as well. Note. To maintain data integrity between this component and the XML generation component, the system does not retrieve XML files with a communication status of XML File No Generated.
Node Status	The system automatically displays the status of data for each employee being reported. Possible values are: Data OK: The employee's data has been successfully included in the XML file but the XML file has not yet been sent and confirmed. XML Sent Confirmed: The employee's data has been successfully included in the XML file and there is confirmation that the XML file has been sent. For employees in the XML file whose data is already complete and validated, you can confirm or unconfirm the sending of the data. To confirm the sending of the XML file, select the XML Sent Confirmed value. To unconfirm the sending of the XML file, select the Data OK value. You must then save your changes. This is the same field that appears on the Generation File page. Upon saving your changes, the system updates the values on that page as well.
Confirm All	Click this button to confirm the sending of the XML file for all employees in the file whose node status indicates that their data is validated and contains all required data. When you click this button, the system updates the Node Status value from Data OK to XML Sent Confirmed for all of these employees. The system also updates the Status field value to XML File Sent and Confirmed. After clicking this button, you must then save your changes.
Unconfirm All	Click this button to unconfirm the sending of the XML file for all employees in the file whose node status indicates that there data is validated and contains all required data. When you click this button, the system updates the Node Status value from XML Sent Confirmed to Data OK for all of these employees. The system also updates the Status field value to XML File Created. After clicking this button, you must then save your changes.

Managing Response Files

Access the Read External XML File ESP page (Workforce Administration, Workforce Reports, Read External XML File ESP).

Fields appear on this page based on whether the Response File check box is selected or deselected.

With Response File Selected

Deleting Contrata XML Files

Access the Delete a Contrata XML File ESP page (Workforce Administration, Workforce Reports, Delete a Contrata XML File ESP, Delete a Contrata XML File ESP).

Specify the template type and XML file ID of the Contrata XML file to delete.

Managing Delta Communications

This section provides an overview Delta (Sistema Delt@) communication management, lists the steps to manage industrial accident information, lists prerequisites, and discusses how to:

• Define the XML file.

• Populate the XML file for Delta reporting.

• Load Delta XML file data.

• Edit Delta XML file data.

• Generate the Delta XML file.

• Preview XML files.

• Confirm Delta XML file data.

• Delete Delta XML files.

Understanding Delta Communication Management

Every company must report to the Work Minister, external insurance companies, and other management entities the details of industrial accidents that occur to employees. Regulations require that companies report these industrial accidents through Delta reports within a given timeframe.

There are three types of Delta accident reports:

• Industrial accident report where the company must send a report that lists all employees with absences due to an industrial accident (PAT).

• Industrial accident report where the company must send a report that lists employees involved in an industrial accident resulting in no absence (RATSB).

• Report that lists employees who have finished the industrial accident absence because of medical discharge or death (RAF).

Human Resources for Spain provides Delta communication functionality that enables you to efficiently communicate to management entities the information about industrial accidents. This functionality helps speed the distribution of information, reduce costs, and simplify communications while guaranteeing the confidentiality of the content of documents.

The basic flow of industrial accident data is as follows:

1. The accident takes place and the person informs the company with or without a sick note.

2. The company records all incident and injury details about the industrial accident in the system.

3. The company generates the appropriate XML file and sends it to the management entities.

4. If errors exist the management entities return their copies to the company.

5. The company corrects the errors and resends copies to the management entities.

Using Human Resources for Spain, you record all data necessary for the Delta accident reports through components in the Human Resources Health and Safety business process. The Health and Safety business process enables you to create and track incidents related to health and safety for employees and non-employees. It also enables you to associate multiple individuals with a single incident. Specifically, use the Incident Details component and the Injury Details component to enter the necessary data for XML file generation. Through the Incident Details component you can enter or update industrial accident data. Through the Injury Details component you can enter the necessary data about people involved in an industrial accident.

Once you have entered all of the data necessary for Delta reporting, you can use the Create Delta XML File Id ESP component and the Create Delt@ RATSB Report ESP component to create the Delta report in XML file format for accident reporting to the management entities. Within these two components you can search for employees and incident types matching your filter criteria, select the employees for whom you want to send data to the insurance company, and generate the XML files. Human Resources for Spain provides a unique XML file template for each of the Delta accident reports. The template provides the file structure in XML format.

Use the Confirm/Unconfirm component to track whether you have sent the XML file to the management entity or cancelled the sending of the file. You can track this information by the sending ID that the XML generation process creates for each XML file that you generate.

If you make changes to the report data or the management entities find errors in the report and return the XML file, you can use these same components to correct the errors and resend the XML file.

The Delta communication functionality is integrated with other PeopleSoft applications for integral management of data. In addition, both the Delta communication functionality and the Contrata functionality share components related to data setup, XML file setup, and XML file generation. The Contrata documentation provides further details about these topics.

Delivered XML Codes for Delta Reporting

The Spanish social security administration (I.N.E.M.) delivers tables with a simple structure of code equals value, with each of these tables containing numerous values. Human Resources for Spain delivers the social security tables as XML code tables for Delta reporting, providing many of the table values as sample data. During implementation, you must review the setup data to ensure that it complies with your company's requirements.

The following table describes the data tables within the XML Code Tables component that relate to the Delta communication functionality:

Delivered XML Nodes for Delta Reporting

Human Resources for Spain delivers XML file structures for Delta communication management functionality. You can also define your own XML file structures through this component by creating additional nodes and relating them to each other.

Delivered XML Templates for Delta Reporting

Human Resources for Spain delivers three different types of communications for Delta reporting. Use the XML Template Table component to define templates for the types of communication that you use for XML file generation. You can define as many XML templates as necessary to meet your company needs. Human Resources for Spain delivers as system data the following XML templates:

See Also

Managing Contrata Communications

Steps to Manage Industrial Accident Information

This section describes the steps necessary to enter industrial accident data and generate the related XML files for reporting.

To manage industrial accident information:

1. Complete the prerequisite setup for the Delta communication functionality.

2. Set the Delta data Preventive option for a company on the Company Setup page.

3. Enter the insurance company code on the Establishment Address page.

4. Use the Incident Details component to complete these steps:

   1. Enter the incident number of the accident, incident date, and incident time, and select whether the incident is a recurrence on the Incident Details - Incident page.

   2. Enter a long description of the incident in the Description text box on the Incident Details - Description page.

   3. On the Incident Details - Location page enter the location, address, and establishment information where the accident occurred, and, if applicable, select the Car Incident check box to indicate that the incident is a car accident.

   4. Enter any other data related to the incident on the remaining pages of the component.

5. For an PAT incident, use the Injury Details - Injury component to:

   1. Access the Injury Details - Injury page and specify for each accident the employee or non-employee involved, the date reported, and the time reported.

   2. Select the PAT value in the Incident Type Esp field.

   3. Specify the absence begin date, working hours, and whether the incident is a relapse occurrence.

   4. Click the Accident with sick note link to access the Detailed PAT Data page, where you must specify PAT data details about the employee, employer, and place of incident.

   5. Enter an end date on the Injury Details - Injury page so that the PAT becomes a RAF only if the PAT results in a medical discharge or death.

   6. Click the Medical Discharge or Death link to access the Detailed RAF Data page, where you must define the reason for discharge, the injury grade, and the diagnosis code.

   7. Move to the Injury Details - Details page and click the Accident with sick note link to access the Detailed Pat Data page, where you can specify further details of the PAT incident.

   8. Move to the Injury Details - Diagnosis page and click the Accident with sick note link to access the Detailed PAT Data page, where you can specify medical assistance and economic data for the PAT incident.

   9. Enter any other data related to the injury in the remaining pages of the component.

6. For an RATSB incident, use the Injury Details - Injury component to:

   1. Access the Injury Details - Injury page and specify for each accident the employee or non-employee involved, the date reported, and the time reported.

   2. Select the RATSB value in the Incident Type Esp field.

   3. Move to the Injury Details - Details page and click the Accident without sick note link to access the Detailed RATSB Data page, where you can specify further details of the RATSB incident.

   4. Enter any other data related to the injury in the remaining pages of the component.

7. Use the Create Delta XML File Id ESP component to:

   1. Select the template to use for the XML file.

   2. Specify report parameters and search for persons to include in the report.

   3. Select from the search results the persons to include in the report.

   4. Load data for the selected persons into the XML file.

   5. View a person's data details for the XML file and enter additional information.

   6. Validate the data for the XML file.

   7. Preview the XML file.

   8. Generate the XML file.

8. Send the XML file to the management entity using the Confirm Delta XML File ESP page, or unconfirm the sending of an XML file for persons based on XML file ID.

9. If you make changes or corrections to an XML file that requires you to resend the Delta communication report:

   1. Go to the Confirm Delta XML File ESP page and change the employee node status value from XML Sent Confirmed to Data OK.

   2. Use the Create Delta XML File Id ESP component to regenerate the modified XML file.

Note. For the system to include a person in XML file reports that the Delta service generates, the person must work for a company where you have specified the Delta data option on the Company Setup page.

See Also

Entering Social Security Company Information

Defining Establishments

Entering Health and Safety Incident Details

Entering Injury Details

Prerequisites

Before you can use the Delta communications functionality first you must define Spanish workforce data related to Delta accident report XML files in the appropriate setup pages. This Spanish workforce data includes XML templates, codes, and nodes.

See Also

Setting Up XML Files

Pages Used to Manage Delta Communications

Defining the XML File

Access the Create Delta XML File Id ESP - Definition page (Workforce Monitoring, Health and Safety, Reports, Create Delta XML Id ESP, Definition).

XML File ID	When generating a new XML file, enter an identifier for the XML file generation upon entering the component. You use this identifier to confirm or unconfirm the sending of an XML file on the Confirm Delta XML File ESP page.
Description	Enter a description of the XML file that you are generating.
Template Type	Select the XML template that you want the XML file generation process to use when generating the XML file. The valid values that you can select depend on the component through which you are generating the XML file. You define XML templates on the XML Template Table page. Valid options for Delta reporting are: DELT@ PAT,DELT@RAF, and DELT@RATSB.

Generating the XML File for Delta Reporting

Access the Create Delta XML File Id ESP - Population page (Workforce Monitoring, Health and Safety, Reports, Create Delta XML File Id ESP, Population).

Status

Shows the status of the communication for the XML file. Possible values are: XML File No Generated: The XML file has not yet been generated. XML File Created: The XML file has been generated. The system updates the field to this value when you generate the XML file or when you click the Confirm All button on the Confirm Delta XML File ESP page. XML File Sent and Confirmed: The XML file has been sent and confirmed as sent. The system updates the field to this value when you click the Unconfirm All button on the Confirm Delta XML File ESP page. This is the same field that appears on the Confirm Delta XML File ESP page. Upon saving your changes, the system reflects the new value on that page as well.

Filter Data (for PAT or RAF)

Use this group box to search for persons who have been involved in an accident who need PAT/RAF Delta reports sent to management entities. Use the search criteria to narrow your search results.

Filter Data (for RATSB)

Use this group box to search for persons who have been involved in an accident who need RATSB Delta reports sent to management entities. Use the search criteria to narrow your search results.

Employee Data

Use this group box to view the results of your search and select the persons to include in the XML file for Delta reporting.

Loading Delta XML File Data

Access the Load Delta Data ESP page (Workforce Administration, Workforce Reports, Load Delta Data ESP, Load Delta Data ESP).

Specify the template type and XML file ID into which you want to load the data that is specified on the Create Delta XML Id ESP - Population pages for the template type and file ID.

Editing Delta XML File Data

Access the Edit Delta Data ESP page (Workforce Administration, Workforce Reports, Edit Delta Data ESP, Edit Delta Data ESP).

View a list of the data that was loaded into the specified XML file. Click the Details link to view the details that will be reported to I.N.E.M. for that person.

Generating the Delta XML File

Access the Print Delta XML File ESP page (Workforce Administration, Workforce Reports, Print Delta XML File ESP, Print Delta XML File ESP).

Enter the path where you want the process to store the Delta XML report file, and enter the name that you want to process to give the XML file that it places at that path.

Previewing Generated XML

After you run the process from the Print Delta XML File ESP page to create the Delta.xml file, you can go to Process Scheduler and click Details, View Log/Trace to find the file and preview the XML that was generated for the selected person. Use the template ID that you selected on the Definition page of this component.

Note that to generate the XML file with the correct template, you must select the correct template and use the appropriate report component. For example, to generate an XML file for a PAT report, you must use the Create Delt@ PAT/RAF Report ESP component and select the Delt@ PAT template.

Confirming Delta XML File Data

Access the Confirm Delta XML File ESP page (Workforce Administration, Workforce Reports, Confirm Delta XML File ESP, Confirm Delta XML File ESP).

XML File ID	Upon entering the component, search for the XML file ID for which you want to confirm of unconfirm the sending of the XML file for persons with data in the file. You define XML file IDs when you create XML files for generation.
Status	Shows the status of the communication for the XML file. Possible values are: XML File No Generated: The XML file has not yet been generated. XML File Created: The XML file has been generated. The system updates the field to this value when you generate the XML file on the Generation File page or when you click the Unconfirm All button. XML File Sent and Confirmed: The XML file has been sent and confirmed as sent. The system updates the field to this value when you click the Confirm All button. This is the same field that appears on the Generation File page. Upon saving your changes, the system reflects the new value on that page as well. Note. To maintain data integrity between this component and the XML generation component, the system does not retrieve XML files with a communication status of XML File No Generated.
Node Status	The system automatically displays the status of data for each employee being reported. Possible values are: Data OK: The employee's data has been successfully included in the XML file but the XML file has not yet been sent and confirmed. XML Sent Confirmed: The employee's data has been successfully included in the XML file and there is confirmation that the XML file has been sent. For employees in the XML file whose data is already complete and validated, you can confirm or unconfirm the sending of the data. To confirm the sending of the XML file, select the XML Sent Confirmed value. To unconfirm the sending of the XML file, select the Data OK value. You must then save your changes. This is the same field that appears on the Generation File page. Upon saving your changes, the system updates the values on that page as well.
Confirm All	Click this button to confirm the sending of the XML file for all employees in the file whose node status indicates that their data is validated and contains all required data. When you click this button, the system updates the Node Status value from Data OK to XML Sent Confirmed for all of these employees. The system also updates the Status field value to XML File Sent and Confirmed. After clicking this button, you must then save your changes.
Unconfirm All	Click this button to unconfirm the sending of the XML file for all employees in the file whose node status indicates that there data is validated and contains all required data. When you click this button, the system updates the Node Status value from XML Sent Confirmed to Data OK for all of these employees. The system also updates the Status field value to XML File Created. After clicking this button, you must then save your changes.

Deleting Delta XML Files

Access the e (Workforce Administration, Workforce Reports, Delete a Delta XML File ESP, Delete a Delta XML File ESP).

Specify the template type and XML file ID of the Delta XML file to delete.

Printing Contracts

Printing contract functionality enables generating PDF reports corresponding to the contracts between the company and the employee.

Utilizing the flexible setup delivered to generate XML files to define the data structure of the PDF reports, the system uses the same pages to define the data of these reports by defining specific nodes.

This section provides overviews of contract printing, contract printing XML setup, and contract generation, and discusses how to:

• Map contract types to XML nodes.

• Create PDF form definitions.

• Define PDF form details.

• Map PDF form fields to XML nodes.

• Generate and print contracts for employees.

• Review and edit contract data.

• Print contracts in batch.

Understanding Contract Printing

The Spanish government delivers a complete set of contract forms in PDF format that employers can download from the government website. The employer must complete the appropriate forms for new hires and submit them to the government after the newly hired employees sign the forms.

To assist employers in the completion of these contract forms, Human Resources for Spain provides Contract Printing functionality to:

1. Load the forms into the system.

2. Map data to the form fields.

3. Enter data into the fields to complete the forms.

4. Print the forms.

Employers can then have employees sign the printed forms and return them to the human resources administrator, who can then submit the completed forms to the government.

The following diagram shows the four basic tasks involved in Contract Printing functionality:

Four tasks for contract printing

System administrators must perform form uploading and form mapping tasks whenever there are new contract types that require contract-printing capability. Human Resources administrators perform the form filling and form printing tasks as necessary.

To set up the system for the printing of new contracts, system administrators must:

1. Define the XML nodes that relate to the contract form, including the node values and whether the nodes are mandatory, through the XML Node Table component.

   They can also create empty nodes to enable Human Resources administrators to edit the node data online before printing.

2. Map the form-level XML nodes to contract types through the Contract Printing Mapping component.

3. Create new PDF Form definitions through the PDF Form Definition component to:

   1. Upload PDF form files into the system.

   2. Map each form field to Human Resources data by assigning the field-level XML nodes to PDF form fields.

   3. Test PDF form fields.

   4. View the PDF form filled with XML tag names in a browser to ensure accuracy and completeness.

To generate and print contracts, Human Resources administrators must:

1. Select the employees that need the printed contracts through the Contract Printing ESP component.

2. Generate the contract data for the selected population through the Contract Printing ESP component.

   At runtime the XML generation process resolves the mapping of the form fields to the XML nodes, retrieving the values for the correct form fields according to the XML node setup and mapping.

3. Review the contract data, complete any missing data, validate the data, and view the form through the same Contract Printing ESP component.

   The system uses the PDF Form process to read the form data and fill it into the appropriate form fields for viewing.

4. Print a single form through the Contract Printing ESP component or a batch of forms for a selected group of employees through the Print Contracts ESP component.

   They can then give the printed form to the employee for signature.

   The system uses the PDF Form process to read the form data and fill it into the appropriate form fields for printing.

Understanding Contract Printing XML Setup

Human Resources for Spain uses the XML generation process to retrieve the Human Resources data needed for completing the forms to print contracts, delivering all of the setup necessary to print contracts for unlimited contract types. System administrators can define additional data for the perform contract printing for other contract types.

Contract Printing XML Setup Structure

The setup for contract printing is based on:

• An XML set.

  Human Resources for Spain delivers the XML set P01 for use with all contract printing.

  To maintain XML set definitions, use the XML Set Table component.

• XML nodes.

  XML nodes for contract printing are always keyed by the XML set for contract printing. Human Resources for Spain delivers the XML nodes for printing unlimited contracts.

  Specifically, Human Resources for Spain delivers the PE-170 XML node for printing unlimited contracts and unlimited full-time contracts and the PE-172 XML node for printing transformation to unlimited contracts. These nodes contain children nodes that correspond to each of the fields on the contract, and themselves are children nodes to the P0 01 contract-printing root node.

  Human Resources for Spain also delivers the children nodes for PE-170 and PE-172 contracts.

  System administrators can maintain the delivered nodes and also define additional nodes for other contract types. To define nodes that comprise the XML file structure for contract printing of specific contract types, use the XML Node Table component.

• An XML template.

  The XML template for contract printing is keyed by the XML set for contract printing. Human Resources for Spain delivers the XML template for use with all contract printing. Human Resources for Spain delivers the XML template P01 for use with all contract printing.

  To define templates for use during XML file generation, use the XML Template Table component.

• Contract print mapping.

  Contract print mapping is the means of associating a contract type with XML templates and XML nodes. When you access the Contract Printing Mapping page the system automatically opens it for the delivered for the contract printing XML template. Use the page to link selected contract types to specific contract-level XML nodes. You are thus assigning a specific XML format to each contract type. You must assign a specific XML node to each contract type because each contract type could report different information. Human Resources for Spain delivers contract print mapping for unlimited contracts.

  To map contract types to XML nodes for the contract-printing template, use the Contract Printing Mapping component.

Steps to Set Up New Contract Types for Contract Printing

To set up new contract types for contract printing, system administrators must:

• 1. Define one node for each piece of contract data that the system needs to retrieve from the Human Resources tables.

• 2. Create one contract-level node for each contract type, grouping the nodes for the contract data retrieval as children to this node.

• 3. Add the contract-level node as a child node to root node P0 01 because the XML generation process uses this root node for all contract types when retrieving data for contract printing.

• 4. Map each contract-level node to the appropriate contract type on the Contract Printing Mapping page.

See Also

Setting Up XML Files

Understanding Contract Generation

Human Resources administrators can use the Contract Printing ESP component to generate, review, edit, and validate contract data.

To create contracts:

1. Access the Contract Printing page for a specific Contract Printing Run ID.

2. Enter criteria to search employees for whom you want to generate contracts.

3. Click the Search button to retrieve the applicable employees.

   The system displays the search results in the Employee Data grid.

4. Select from the listed employees the ones for whom you want to generate contract data.

5. Click the Generate Data button to launch the XML Application Engine process that retrieves contract data for the selected employees.

   The system displays a message informing that you have successfully launched a batch process to generate the contract data for the selected employees. Make note of the process instance.

6. To view the status of the batch process in PeopleTools Process Scheduler, click the Yes button.

   The system launches a new browser window and displays the Process List page of the Process Monitor component. Verify that for your process instance the Run Status equals Success.

   Or, to simply return to the Contract Printing Data page, click the No button.

7. Click the Edit Data button on the Contract Printing page for a specific employee to access the Contract Printing Data page, where you can review the generated contract data and enter missing data into the contract fields.

8. Click OK to return to the Contract Printing page.

9. Click the Print button on the Contract Printing page to have the PDF Form engine fill data into the PDF Form fields and print a PDF file of the contract.

   The system immediately launches another window to display the contract as a PDF file.

Note. To print contracts for the entire population, use the Print Contracts ESP component.

See Also

Running the Batch Contract Printing Process

Pages Used To Print Contracts

Mapping Contract Types to XML Nodes

Access the Contract Printing Mapping page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, Contract Printing Mapping, Contract Printing Mapping).

Human Resources for Spain delivers contract printing mapping for unlimited contracts.

Creating PDF Form Definitions

Access the PDF Form Definition page (Set Up HRMS, Product Related, Workforce Administration, Workforce Data ESP, PDF Form Definition, PDF Form Definition).

Form ID	The ID of the PDF form definition.
Effective Date	Enter the date that the PDF form definition becomes valid and its effective status, either Active or Inactive.
Description	Enter a description of the PDF form definition.
Comment	Enter any additional comments about the PDF form definition or the contract form that it represents.
Language Code	Select the language for the PDF form that you are attaching. If you have the same contract form in multiple languages, you must specify a row for and attach a form for each language.
Default Language	Select this check box for a row to indicate that the system should use the corresponding language whenever there are contract forms missing for a specific language. You must select a default language.
Attached File	The system displays the file name of the attached contract form.
Add	Click this button to attach the PDF file of the contract form to upload the form into the system. If you have the same contract form in multiple languages, you must specify a row for and attach a form for each language.
Delete	Click this button to remove the attached form from the PDF form definition.
View	Click this button to access the view the attached PDF form file. The system launches another window to display the form.
Details	Click this button to access the Form Details page, where you can define the fields and processing details for the attached PDF form.

Defining PDF Form Details

Access the Form Details page (click the Details button on the PDF Form Definition page).

Root Node	Select the root XML node to use for mapping the PDF form fields to specific XML nodes within the root node. When printing contracts, the system uses this root node to complete the fields of the PDF according to the mapping that you define. Human Resources for Spain delivers the P0 01 root node for contract printing.
Refresh	Click this button to refresh the list of PDF form fields that the system displays in the Field List grid. The system reads the attached PDF form and displays all of its fields in the grid.
Test Fields	Click this button to view a copy of the form in which each field on the form displays the technical Field Name value. System administrators can use this feature to locate the form field name on the PDF form.

Field List - Node Mapping Tab

Use the fields on this tab to view a list of the fields that appear on the attached PDF form and to map each of these fields to an XML node.

Field List - Field Processing Tab

Due to their complexity certain PDF form fields require formatting. Use the fields on this tab to link application classes to complex PDF form fields. The application classes perform this required formatting. The PDF Form engine executes all application classes of this type at runtime to format the data that the system retrieves from the XML nodes.

Mapping PDF Form Fields to XML Nodes

Access the Node Selection page (click the Select XML Node button on the PDF Form Definition page).

XML Path	The system displays the path of the currently selected XML node as it appears within the context of XML tags. When selecting an XML node for the first time, the system displays the children nodes of the root node specified on the Form Details page.
Go back to Parent Node	Click this button to remove the last child-level XML node from the XML Path display box. The system repopulates the Child Nodes grid with the child nodes of the parent node.

Contract Printing

Note. The system requires the full path to the XML node because the same node can appear in multiple path locations.

Generating and Printing Contracts for Employees

Access the Contract Printing ESP page (Workforce Administration, Workforce Reports, Contract Printing ESP, Contract Printing ESP).

Contract Printing Run ID	Upon entering the component, select or create a Contract Printing Run ID. This ID enables you to group selected employees for whom you want to generate and print contracts.
Description	Enter a description for the Contract Printing Run ID.

Filter Data

Use this group box to search for persons who have contracts that you need to generate and print. Use the search criteria to narrow your search results.

Employee Data

Use this group box to view the results of your search and select the persons for whom you want to generate and print contracts.

Reviewing and Editing Contract Data

Access the Contract Printing Data page (click the Edit Data link on the Contract Printing ESP page).

Remove All Rows	If you want to recalculate the field values for the selected employee's contract, click this button to delete all data rows that the system generated. The system displays a blank page. Click OK to accept this deletion or click Cancel to reject the deletion and return to the previous page.
	Nodes that display this symbol are not required. They have no data but are available for optional data entry.
	Nodes that display this symbol have data that you entered manually or that the system retrieved from the database. This data is validated.
	Nodes that display this symbol require a value but currently have no value entered. Enter the required data necessary to complete the contract. Depending on the node definition, you must either enter a value directly through this page or go to the source page to enter the value.
Tag	Tags are the node names as they appear in the XML file that is used to generate the contract. The system retrieves tags based on the node definition as defined on the XML Node Table page.
Required	Indicates whether the node is required for reporting.
Node Value	The system displays the value for the corresponding tag. Enter or select additional data that you want to include in the report. You must provide node values for all required tags.
OK	Click this button to save data and return to the previous page.
Cancel	Click this button to cancel any changes that you have made and return to the previous page.

See Also

My Oracle Support, PeopleSoft Enterprise Human Resources: Product Enhancements for Spain, Setting Up XML Files

Running the Batch Contract Printing Process

Access the Print Contracts ESP page (Workforce Administration, Workforce Reports, Print Contracts ESP, Print Contracts ESP).

Language	Select the language in which you want to print the contract. The system by default selects Spanish.
Contract Printing Run ID and Description	Select the Contract Printing Run ID for which you want to print contracts. Define these IDs through the Contract Printing component.
Validated Contracts Only	Select this check box to print only the contracts that you have validated through the Contract Printing component. With this option the process generates only the contracts a Node Status value of Data OK on the Contract Printing page.
Run	Click this button to run the Contract Printing Report (CTPR_REP_ESP) Application Engine process. The process generates contracts in PDF format that are part of the specified Contract Printing Run IDs. Note. You can run this process for a given Contract Printing Run ID as many times as necessary.

Generating AFI Flat Files

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

• Maintain employee AFI data.

• Maintain detailed AFI data for employees.

• Create the AFI report.

• Create employee inquiries on the AFI report.

• Create company inquiries on the AFI report.

• Review employee data on AFI files.

Understanding the AFI Process

For Spanish employers, PeopleSoft Enterprise Human Resources includes an AFI process (SOCS_AFI_ESP) for reporting workforce changes to the Social Security General Treasury. The PeopleSoft process simplifies submissions by automatically creating a flat file in the format that is required by the Spanish authorities.

Every time you add, delete, or update an effective-dated row to the JOB_DATA record, the system verifies whether the action pertains to AFI reporting. If so, the system adds, deletes, or updates the corresponding effective-dated row in the AFI_DATA_ESP record via PeopleTools Integration Broker. The system uses the ESPAFIData_Sync message subscription within the WORKFORCE_SYNC message to perform the synchronization. The system stores all AFI data in the AFI_DATA_ESP record.

After an AFI-related action takes place, you can access the Employee AFI Data ESP component to view and update AFI data for that employee. You can also use this component to manually enter new rows of data for special situations not handled by job data processing, such as strikes or contract changes.

When ready you can run the AFI process through the Create AFI Report ESP component. The AFI process generates a flat file that lists changes in workforce—such as hiring, terminations, personal changes, or job data changes—for a particular period. The system ensures that employees for whom you have already generated the report are not included in subsequent file generations.

In addition to workforce changes, you can use the AFI process to send information requests to the Social Security General Treasury. Employers use these requests to obtain information about their employees' or companies' social security contributions.

When you generate an AFI report through the AFI file generation process, the system assigns an AFI file name to each row of employee AFI data that it includes in the file. The assignment of this value prevents repeat communication of the data in subsequent AFI files. The system also assigns to the communicated row of data a node status value of Included in AFI and a time stamp value that specifies the date and time of the processing.

You can use the Review AFI File ESP component to view all of the employee AFI data that is part of the AFI flat file being communicated to the Social Security General Treasury. Through this component you can also unlink data from the files as necessary so that the data becomes available again for processing in a subsequent AFI flat file. The system removes the AFI Flat File field value from the unlinked row to enable repeat communication of the data, although the employee data is not extracted from the file itself.

Note. To use AFI reporting functionality you must configure PeopleTools Integration Broker to support Integration Broker.

Pages Used to Generate AFI Flat Files

Maintaining Employee AFI Data

Access the Employee AFI Data ESP page (Workforce Administration, Job Information, Employee AFI Data ESP, Employee AFI Data ESP).

Job Information - General Tab

Job Information - Reporting Tab

Maintaining Detailed AFI Data for Employees

Access the AFI Data Details page (click the Details link on the Employee AFI Data ESP page).

Reporting

Use this group box to specify reporting details about the AFI data.

Job Data

Use this group box to specify job data to include in the AFI report.

Contract with Bonification

Use this group box to specify contract data to include in the AFI report. This group box is available only if you select the Change in Contract or Hire value in the Social Security Action field on the Employee AFI Data ESP page.

Additional Data

Use this group box to specify additional data to include in the AFI report. This group box is available only if you select the Change in Contract or Hire value in the Social Security Action field on the Employee AFI Data ESP page.

Like-Active Status

Use this group box to communicate like-active situations. This group box is available only if you select the Like-Active Communication value in the Social Security Action field on the Employee AFI Data ESP page.

Termination Data

Use this group box to enter termination data. This group box is available only if you select the Termination value in the Social Security Action field on the Employee AFI Data ESP page.

Part Time Reporting

Use this group box to enter part-time reporting information. This group box is available only if you select the Worked Days Erasing or Worked Days Registration value in the Social Security Action field on the Employee AFI Data ESP page.

Creating the AFI File

Access the Create AFI File ESP - Employees page (Workforce Administration, Workforce Reports, Create AFI File ESP, Employees).

File Name	Enter the name of the file that you want the process to use for the report. The system stores the data in an AFI file.
File Path	Enter the path where you want the process to store the report file.
Authorization Key	Select to narrow search results to employees working for companies with this authorization key. Social Security General Treasury provides companies with authorization codes to access Winsuite.
Date From and Date-To	Enter a date range to find all employees with a change in social security status between these dates.
Filter By	Select a filter to narrow search results further. When you select a filter, the Filter Data Grid becomes available to specify filter details. Available filters are: CCC: Select to run the process for a selected company and Codigo Cuenta de Cotizacion (CCC). The system displays the Filter Data Grid for you to select the company and social security number. Company: Select to run the process for selected companies. The system displays the Filter Data Grid for you to select the companies. Department: Select to run the process for selected departments. The system displays the Filter Data Grid for you to select the setID and departments. Employee: Select to run the process for selected employees. The system displays the Filter Data Grid for you to select the employee IDs. None: Select to search without a filter.
Search	Click to retrieve results based on your search criteria.

Filter Data Grid

Actions

Employees

The system displays employees that meet your search criteria and have AFI data that you still need to report to social security. The system displays only employees with social security actions that you have not yet communicated to social security in an AFI report. Select the check box next to the employee AFI data row to include the information in the AFI flat file.

Creating Employee Inquiries on the AFI Report

Access the Create AFI File ESP - Employee Inqueries page (Workforce Administration, Workforce Reports, Create AFI File ESP, Employee Inqueries).

Clear All	Click this button to deselect all rows in the Employees grid on this page.
EmplID and Name	Select the employee for which you want to submit an inquiry to social security. The system displays the name of the employee that you select.
Social Security Action	Select the inquiry that you want to submit to the Social Security General Treasury regarding the selected employee. Possible inquires are: Inquire Current Situation: Select to request the information that the Social Security General Treasury has about the employee. Inquire IT Per Ill: Select in request information about a temporary disability situation. Inquire Previous Movements: Select to request the information that the Social Security General Treasury has about previous movement in the CCC. Inquire TA2 Copy: Select to request a copy of a specific TA2 report. The system displays the Action Date field.
Action Date	If you select to inquire about a duplicate TA2 copy, the system prompts you to enter the action date of the original TA2.

Creating Company Inquiries on the AFI Report

Access the Create AFI File ESP - Company Inqueries page (Workforce Administration, Workforce Reports, Create AFI File ESP, Company Inqueries).

Clear All	Click this button to deselect all rows in the Companies grid on this page.
Company	Select the company for which you want to submit an inquiry to social security.
Social Security Number	Select the employer's social security number for which to submit an inquiry. This field is required.
Social Security Action	Select the inquiry that you want to submit to social security regarding the selected company. Possible inquires are: Inquire CCC Situation: Select to request the information that the Social Security General Treasury has about the company. Inquire Current CCC Workers: Select to request the information that the Social Security General Treasury has about current workers in the CCC. Inquire Labor Life in CCC: Select to request the information that the Social Security General Treasury has about labor life in the CCC. Inquire Previous CCC Movement: Select to request the information that the Social Security General Treasury has about previous movement in the CCC.
Action Date	If you select to inquire about labor life in the CCC, the system prompts you to enter the start date of the period you are asking for information about.
End Date	If you select to inquire about labor life in the CCC, the system prompts you to enter the end date of the period you are asking for information about.

Reviewing Employee Data on AFI Files

Access the Review AFI Files page (Workforce Administration, Workforce Reports, Review AFI File ESP, Review AFI Files).

The system displays a row for each employee and social security action combination that the AFI file generation process included in the AFI flat file. If an employee has more than one action in the file, each action appears as a distinct row.

To unlink the employee's AFI data from the selected AFI flat file, deselect the corresponding check box for that row of data. By default the system select all rows of data. Upon saving the page, the system deselects the AFI File Name field for the deselected row, thus making this row of employee AFI data available for inclusion a future AFI file generation. You might do this, for instance, if you have included employee AFI data in the communication by mistake and need to resend the data for the employee.

Warning! When you click the Save button the system permanently frees the deselected rows from association with the selected AFI flat file. You will not be able to reverse this action. Note, also, that the data for the deselected rows are still part of the actual AFI flat file. To remove that data from the file, you must regenerate the AFI file with refined filter criteria that excludes this data.

Employee Data

Use this group box to select the employees whose AFI data you want to include in the AFI flat file, or to deselect the employee's association with the generated AFI flat file so that you can process that employee's information again.