Creating or Modifying Data Extraction Programs
Because your company might have modified the delivered base software, and because the audit authority might request different data from time to time, the software cannot be programmed to determine the exact data that might be required for an audit. The provided solution is meant to provide you with the tools and examples to produce the data and data descriptions that might be required. You must modify the data extraction programs and the .XML file provided to meet the requirements of data reporting. Additionally, you might need to create other data extraction (table conversion) programs to produce required data.
If creating new program or modifying a provided data extraction program, consider these factors:
File formats can be variable length or fixed length.
Variable length fields can be formatted as alphanumeric, numeric, or as a date.
The data extraction programs provided are variable length.
In variable length files, text files can be encapsulated.
The text files produced by the provided data extraction programs are encapsulated with double quotes ("). The text files are semi-colon (;) delimited.
For each table for which you provide data, you must include in the Index.XML file a description of the data, including:
URL
Name of the table.
Description of the table.
Date range of the data extracted.
Date format.
Decimal separator.
Digit grouping symbol.
This symbol defines the thousand-separator.
Description of the variable length or fixed length text, including whether the fields are alphanumeric, numeric, or a date.
Refer to the official government publication for details of the data to include in your text and Index.XML files.