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.
...
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 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.
Field | Example | Description |
|---|---|---|
Primary Vendor Software Version Number | FREEDOM | |
Secondary Vendor Software Version Number | Version1 | |
Filing Year | 2017 | This is the four-digit year of the filing. The number in this field must match the number in the year field in the name of the statement data file. |
Period Type Code | 0 | For annual filings, this code is 0 (zero). |
Co Code | 00000 | The company code. The five-digit number in this field must match the five-digit number in the company code field in the name of the statement data file. |
Primary Vendor Code | 0 | |
Secondary Vendor Code | 0 | |
Submission Filing Type Code | O | Following are valid codes for this field.
The code in this field must match the submission filing type code in the name of the statement data file. |