XML-Enabled System Extracts

You can use System Extract to generate an XML file for data transfer. Unlike ASCII files that rely on character ordering and spacing, XML files use tags to identify data types.

When you define the Extract Definition, you can create either a TXT or an XML formatted file. If you select XML, the Extract Process generates the following files:

The XML file contains the data along with the XML tags. The recipient of the extract--such as a benefits provider--uses the XSL file to determine the layout of the XML file. The XSD file allows you to view the XML file in a web browser.

Each tab in the Extract Layout and Extract Definition forms contains a field called XML Tag. The XML tag defaults to the name you assign each record. You can change the name of the XML tag at anytime prior to running the Extract Process. A tag can contain up to 80 characters and does not allow spaces, numbers, or special characters.

Tag names do not need to be unique. If you extract XML for an existing extract that has no tags defined, the Extract Process uses the lookup codes contained in the BEN_EXT_XML_TAGS Lookup Type to populate the tags in the extract results.

Converting XML to PDF

Using Oracle XML Publisher, you can predefine a PDF template, then merge the template with XML output from a system extract to create a PDF file of your extract.

In HRMS, you link the PDF template that you created in XML Publisher to the extract definition. The Extract Process process calls the Extract XML Publisher process if you select Submit Write Process Automatically, or if you run the Extract Write Process for an extract with PDF Output as the extract type.

See: XML Publisher Introduction

See: Running the Extract XML Publisher Process