Page History

A PRL report file is “compliant” if it is either:

• A text file formatted according to the PRL ASCII Text File Specifications
• A Microsoft Excel .xls file created from one of the Excel workbooks provided by the Service Bureau

In addition, the file name should follow the naming conventions shown for text files or Excel files, as applicable. The critical parts of the file name are the “Form Prefix” and “File Extension”.

In both cases, we know how the data is laid out in the file, so we are able to automatically extract the data for storage in a database. Files that are “not compliant” require manual processing to convert them into a compliant format.

...