CSV Batch Import: Idaho Filings

This article is designed to help you learn how to use the Transaction CSV batch import tool in InsCipher.

How Do I Perform a Batch Import?

  1. Taking the sample file and filling out the necessary fields, follow these steps to import your CSV batch into the portal.
  2. Click "Save As," choose a name for your file, and remember where you saved it – you'll need that in a minute. Also, be sure to save it as a plain CSV file. Your batch is now ready to be uploaded into the InsCipher portal!
  3. Now, go to the InsCipher portal and click "Upload Filings":
    Connect 1

  4. In the dropdown that opens up, select "Batch Import":

    Connect 2

  5. This should bring you to a new page shown below. You will need to select the correct option based on what you are trying to import, filings, documents, or both.
    Filing Services 3
  6. To import the files you can either drag and drop them into the white box or click inside the box and it will bring up a window like the one shown below.
  7. Depending on your selection, please reference the correct instructions below:
    1. For Only filings, the sample file above should be used.
    2. For Only Documents,  you will need to submit a zip file that will contain the documents and a csv for mapping. The screenshot below is an example of the zip file to upload the document "test1.pdf"

      Connect 5 
      Inside that zip file there is a csv labeled "documents.csv", sample here, that has columns for the filing id, the code, and the file name. In this example the csv is linking the pdf "test1" to the filing id 192025.

    3. Connect 6

    4. For Both at once you will need to select a csv and a zip file. The "documents.csv", sample here, in the zip file will have a different first column that should be "invoice_number" and should relate to invoice numbers on the transactions document that is uploaded.
    5. Connect 7
  8. Once you have uploaded your files you can press the "Validate" button and if there are no errors you will see the following screen where you can press "Submit":
    Connect 4

    Congrats! You've uploaded a batch. If your upload was successful, you will see a new screen shown below. You can select "Import Once More" if you need to go through the process for another import or "Filings Import Log" which will take you to the filings import log where you can see your batch's status, imported filings, not imported filings, and error log if there were any filings that weren't able to be imported.



    Happy filing!

How Do I Correct a Batch if There are Errors?

  1. If there are many errors that came through on a batch, you can delete the entire batch by clicking the "Delete" button on the batch:
  2. You can also click under the "Not Imported Filings" or the "Error Log" to download a list of errors in the batch.


  3. When pulling up the error code list, you will see the reason for the error followed by the policy number that was trying to be uploaded.
  4. You will then need to go into the batch and correct the error.
  5. Follow the "How Do I Perform a Batch Import?" instructions above to make the corrections.

Field Descriptions

To download the latest version of the CSV batch import, click here.

Below, you will find a list of the different fields used, the description, and whether or not it is required for the CSV batch import to work. Take note, that there are some optional fields that are required depending on the transaction that you are trying to import. There are additional codes that you can find at the bottom of this document such as insurer NAIC codes and lines of business.

Field Title

Description

Optional

Required

policy_number

Policy number. Non-unique field.

 

expiring_policy_number

Expiring Policy Number

Optional value that only applies to Renewal type policies.

 

transaction_type

The transaction type you for this submission:
PN = New Policy*
PR = Renewal Policy*
APE = Additional Premium Endorsement
RPE = Return Premium Endorsement
AE = Audit Endorsements
FC = Flat Cancellations

*NOTE: file using PN = New Policy if the Agency considers the policy a Renewal and the Company changed from Expiring Term’s Company

 

account_written_as

Account Written values are listed below

If omitted, default Agency setting will be used

DC = Direct to Consumer
B = Brokerage (through a Retail Agent)

 

policy_effective_date

Policy effective date

If omitted, today's date is used as policy eff. date

 

policy_expiration_date

Policy expiration date.

If left blank, the default value will be calculated to be 12 months from the Policy Effective Date.

 

transaction_effective_date

Transaction effective date

If omitted, today's date is used as transaction eff. date

 

invoice_date

This is the Broker Received Date for ID.

If omitted, the transaction effective date will be used.

 

rpg

Risk Purchasing Group?

1 = Yes
0 = No

If omitted, No (0) value will be used. Unless you know what an RPG is, set this value to 0.

 

purchasing_group_name

Required if RPG (rpg field) is set to Yes (1).

If not included and RPG = Yes (1), then the transaction will still import but will show RPG error.

 

ecp

Exempt Commercial Purchaser?

1 = Yes
0 = No

Unless you know what this is, set this value to 0.

 

exempt

Is the coverage considered tax-exempt by the state?

1 = Exempt Yes
0 = Exempt No

Unless you know that the line of business is Tax Exempt, set value to 0.

 

export_list

Is the line of business on the state’s Export List?

1 = Exempt Yes
0 = Exempt No

Unless you know that the line of business code is on the export list, set the value to 0 or leave blank. Currently Required only for the state of Utah.

 

multi_state

Does the insured’s risk reside in multiple states?

1 = Multi state Yes
0 = Multi state No

InsCipher does not calculate Multi-state surplus lines tax breakdowns. With NIMA dissolving in 2016, InsCipher reports 100% of the premium to the home state of the insured's risk and bases the tax percentages off that state. If omitted, the default is No (0). There are only a few states where InsCipher has enabled this field. Currently only required for the state of Utah.

 

policy_limit

This is the aggregate policy limit/liability amount associated with the policy.

The requirement depends on State and Agency settings. There are about a dozen states that require this information when filing. For this reason, we recommend that you include the policy limit on every submission. If it isn't required by the state then this amount will be ignored.

 

non_admitted_insurer_code_list

This is the NAIC code associated with the insurer.

For Lloyd's policies, use “AA-1122000”. 

Refer to the Insurance Company import list which can be viewed here.

Lloyds Example: AA-112200
Non-Lloyds Example: 26883

For policies with multiple insurance companies, provide the NAIC insurer code list. Multiple values are separated by the pipe symbol “|”.

This requirement depends on the state requires an insurance company breakdown. As this varies by state, we recommend importing all transactions with multiple insurance companies, where applicable.

Example: 26883|35351

Must also provide details in non_admitted_insurer_code_coverage
Sample fields with Multi-Companies:

“non_admitted_insurer_code_list": "26883|35351",
"non_admitted_insurer_code_coverage”: ”60|40”

 

non_admitted_insurer_code_coverage

This value would be the percentage breakdown in 100 based values (without the “%” sign). List these in the same order as the non_admitted_insurer_code_list. Multiple values are separated by the pipe symbol “|”.

The requirement depends on if the state requires an insurance company breakdown. As this varies by state, we recommend importing all transactions with multiple insurance companies, where applicable.

Example: 100

Example: 60|40

 

transaction_line_of_business

This is the Line of Business / Coverage Code associated with the policy. If you wish to download the linked list, hover over the top right corner of the table, click on the three dots, and then click "Export" to CSV.

 

premium

Policy premium

Put in 0 if it is not applicable

 

agency_fee

Policy / Broker / Agency Fee

Put in 0 if it is not applicable

 

inspection_fee

Inspection / Audit / Underwriting Fee

Put in 0 if it is not applicable

 

sl_tax

Surplus Lines Tax is 1.5% of premium and fees. 

 

stamping_fee

Stamping Fee is .5% of premium and fees

 

total

Total = premium + agency_fee + inspection_fee + sl_tax + stamping fee.

If left blank, InsCipher will auto-calculate the total

 

mailing_insured_name

Insured name as it appears in policy documents

 

dba

Doing Business As

 

mailing_address

Mailing address

 

mailing_address2

Mailing address line 2 (if applicable)

 

mailing_city

Mailing city

 

mailing_zip_code

Mailing zip code

 

mailing_state_code

Mailing state. 2 letter state code.

 

physical_same_as_mailing

If the Physical State is the same as the Mailing State, then set this value = 1

If the Physical State is NOT the same as the Mailing State, set this value = 0.

IMPORTANT: If you make the physical state the same as the mailing state then you will need to make sure that both addresses are added with valid "State" codes or you will receive an import error.

 

physical_address

Physical address

Required if Physical State is NOT the same as Mailing State.

 

physical_address2

Physical address line 2

 

physical_city

Physical city

Required if Physical State is NOT the same as Mailing State.

 

physical_zip_code

Physical zip code

Required if Physical State is NOT the same as Mailing State.

 

physical_state_code

Physical state. 2 letter state code

Required if Physical State is NOT the same as Mailing State.

 

agent_notes

Populates the Agent Notes section on the Filing Details page of a Filing Agent/Filing Agency Admin user. Include only if you want to add other information about the policy not captured in any of the other fields above.

 

Document Type Mapping for ID

Use the following codes to differentiate the types of documents you are uploading:

DOCUMENT TYPE CODE DESCRIPTION OF THE DOCUMENT
POLIC Policy document for New/Renewal
DILEF Diligent search form
ENDOR Endorsement document for Endorsements
ECPC ECP Affidavit (if applicable)
 

Lines of Business

To download a list of our Lines of Business, click here.

Insurance Companies

To download a list of approved insurance companies, click here.