Create the Vendor Extract File

Eagle STAR for Insurance maintains compliance with the National Association of Insurance Commissioners (NAIC) guidelines to provide clients with Statement Vendor Extracts for Separate and Non-Separate accounts. After you create a family of Schedule extract files, you can create the vendor extract file to use for vendor submission to the NAIC to load the NAIC's Financial Data Repository (FDR) relational database. You form the vendor extract tab-delimited file by concatenating the records from the set of tab-delimited Schedule extracts, inserting Header record information and naming the file per NAIC naming conventions. The Schedule CSV extract files to include in the NAIC data submission file follow.

• Financial statement data files
• Validation results data files
• Validation failure explanation files

The formed file contains two tab-delimited header records, followed by the sets of Schedule extract records from each of the extract files. An example of a vendor extract tab-delimited file follows. Eagle assigns the schedule specific headers, for example [X2012AVR], the overall file header must be added manually.

You form the vendor extract file by concatenating the set of Schedule extract files together and inserting two tab-delimited header records, formatted as shown in the following example.

Header Record – HEADER

The first record of a statement data submission file consists of the character string "[HEADER]". The following shows a sample HEADER record.

Header Record – Submission File Header

The second record of a statement data submission file is the Submission File Header record. The following shows a sample submission file header record.

The following table describes each field in the Submission File Header record, as copied from the section, "General Instructions For The Electronic Filing" in the NAIC Electronic Filing Submission Directive for 2012.