Setting Up XML Reporting Framework

The name of the code table.

Enter the description of the code table.

Enter the translate value for the code table.

Enter the description of the translate value.

Displays the XML set code and description.

Select the country for which the XML set is being defined.

Enter the record name eligible to work with this XML Set. The records entered here will be available in other parts of this framework.

Displays the description of the record or table you selected.

When creating a new node, enter a code to identify the node.

Select the XML set to specify the functional area for which you are defining this node.

Displays the country associated with the selected XML set.

Enter a description of the node.

Enter the name of the XML tag for the node.

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.

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.

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.

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.

Select the concatenated node.

This field becomes available only if you select the Concatenate check box.

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.

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 records (added via the XML Set Table page). Then select a field from the list of available fields in the view. The system uses your selection to retrieve data when generating XML files.

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.

For a simple node where the source is manual, you can set up a default value.

This field is available only when you select manual in the Source Data field.

Select this check box if you want to print the Description, instead of the Code.

This field is available only if the field that you selected has a XLAT associated or it has a prompt table with a DESCR field.

Select this check box if you want to print any data from the prompt table associated to this field.

This field is available only if the field you selected has a prompt table.

Select this check box if you want to print just a part of the field value. On selecting this check box, you have to enter the Start Position and Length value.

Select this check box if you want to populate the field value with the character specified in the Char Fill field to complete the length that you need.

Select this check box if you want to remove one or more characters specified in the Character to Clean field.

Select this check box if you want to use one of the special formats defined in the framework:

• Decimal Separator is a Comma.

• Decimal Separator is a Point.

• First Map then Concatenate.

• Hours & Minutes.

• Remove Spaces.

• Transforms Percents in 4 Digits.

• Transforms Zero to Space.

Select this check box if you want to enter attributes to the node.

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.

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.

Select how you want the date field to be formatted.

This field is available only if you select a validation type of Date.

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.

For the field that you are mapping from, select how the field derives its valid values. After you make a selection, use the System Value field in the grid below to specify the system field values from which you want to map to alternate values. Your choices are:

• Manual: Select this option if the system values are derived manually through user entry and you want to map these values to other values. Fields such as these are defined as having no edit, thus enabling manual entry. The System Values field in the grid prompts you to manually enter each system value that you want to map to another value.

• None: Select this option if there is no need to map system values for the field that you specify in the Field Name field on the Node Table page to another value.

• Record: Select this option if the system values are derived from a prompt table and you want to map values in the prompt table to other values. Then use the Edit Table field, which becomes available, to specify the prompt table from which the field derives its valid values. The System Values field in the grid prompts you to select each prompt table value that you want to map to another value.

• Xlat (translate): Select this option if the system values are derived from a translate table and you want to map these translate values to other values. The System Values field in the grid prompts you to select each translate value that you want to map to another value.

If you select to map field values from a record, select the prompt table from which the field derives its valid values.

Select how you want to define the new valid field values that you are mapping to. After you make a selection, use the Node Value field in the grid below to specify the new value to replace the system value. Your choices are:

• Code Table: Select this option to map values to a value that exists on an XML code table. The Code Table field becomes available for edit.

• Manual: Select this option to map system values to a value that you manually define.

• None: Select this option if there is no need to map system values to another value.

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.

If you select to map new field values to values from an XML code table, select the code table. Define XML code tables on the XML Code Table page.

Specify the system field value from which you are mapping to another more appropriate value for the XML file. If you are mapping from a field where the valid values are derived from translate tables or prompt tables, select the value that you want to change. If you are mapping from fields where the valid values are derived by manual entry into the system, enter the value that you want to change. The value that you enter manually must be identical to the value defined through user entry.

For translate values and table record values, the system displays the description of your selection.

Select or enter the node value to which you are mapping the system value. If you have selected to map to a code table in the Mapping To field, the system prompts against the values in the XML code table that you specify. For XML code table values, the system displays the description of your selection.

When defining new XML templates, select the XML set to which the template belongs.

The identifying code of the template.

Enter a description of the XML template.

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, in case of GP Spain, 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 in GP Spain (XML Set = D01), 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.

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.

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.

Select the BI Publisher template to which you want to link the XML template. This enables you to create a PDF document that helps you visualize the report.

Select the XML set to verify.

Select the template type of the XML set to verify. The key fields in the Add Item to Report group box vary based on the template type you select.

Enter the server file path and the file name.