97-02: Electronic Filing of Company Appointments/Terminations

* This bulletin was repealed by 08-05

[Summary][Diskette Specifications][Submission Form][Record Structure]

From:      Carol S. Hartman, Supervisor, Licensing Section

Re:          Electronic Filing of Company Appointments/Terminations

Date:       February 28, 1997

Effective March 30, 1997, Regulation 20 CSR 700-1.135 will require all insurance companies to submit appointments and terminations in an electronic form. The electronic form shall conform to one of the following:

Companies must send their appointments and terminations on a diskette with a properly labeled diskette and the enclosed Company Appointment/Termination Diskette Submission Authorization Form. It is required that all correspondence with the department must reference the company name and company number EXACTLY as it appears at the beginning of this bulletin. abbreviations of the company name will result in rejected appointments and terminations due to improperly identified companies.


General Diskette Specifications


Specific Diskette Instructions for Company Appointments and Cancellations

Any filing not meeting these requirements will be returned without processing.


Missouri Department of Insurance
Company Appointment / Cancellation Diskette Submission Authorization Form

The company is appointing for all qualifications for which the appointees are properly licensed in this state. The company is responsible to assure the appointees only sell products for which they are properly licensed in this state.I hereby appoint and certify that I have investigated the qualifications of these appointees and that the appointees meet all requirements under this state's insurance statutes and regulations. If there are cancellations, I certify that these cancellations comply with state statutes and regulations.
____________________________ __________________________
Authorized Signature* Date
__________________________ __________________________
Title Phone
* May be signed only by individual with authority pursuant to the power of attorney on file with the regulatory authority.Total Appointments on this diskette filing ________________Total Cancellations on this diskette filing ________________

Record Structure for AGENT.TXT

  Field Name Column (s) Field Length Field Type Valid Entries
Appointment/Cancellation APPTERM 1 1 Character A, T
Agent Identification Number
(as shown on Agent's Missouri license)
SSN 2-10 9 Character  
Last Name LNAME 11-30 20 Character  
First Name FNAME 31-45 15 Character  
Middle Initial MI 46 1 Character  
Name Suffix NAMESF 47-49 3 Character JR, SR, II, etc.
Effective Year EFFYR 50-51 2 Character  
Effective Month EFFMO 52-53 2 Character 01-12
Effective Day EFFDAY 54-55 2 Character 01-31
Reason for Cancellation TERMCD 56-57 2 Character AM, LP, CD, AR, OM, WP, MP, FI, DA, RP, FC, FE, TD, Blank for Appointments
Company Name CONAME 58-96 39 Character  
Company Number CONUM 97-103 7 Character  
NAIC Number NAICNO 104-108 5 Character  
Contact Company Name CONTACT 109-147 39 Character  
Contact Address CONADDR 148-172 25 Character  
Contact City, State, Zip CONADDR2 173-199 27 Character  

Record Structure Descriptions for AGENT.TXT

APPTERM - Specifies whether the record to be added is an agent Appointment or Cancellation. Valid entries include A for an APPOINTMENT or T for a CANCELLATION.

SSN - Agent Identification Number of the Agent to be appointed or cancelled. This number must be the same number as shown on the Agent's Missouri license excluding all dashes (-).

LNAME - Last name of the Agent.

FNAME - First name of the Agent.

MI - Middle initial of the Agent.

NAMESF - Name suffix of the agent, if applicable. Valid entries include JR (Junior), SR (Senior), II, III, etc.

EFFYR - The year in which the appointment or cancellation is to become effective.

EFFMO - The month in which the appointment or cancellation is to become effective. Valid entries include 01 through 12.

EFFDAY - The day on which the appointment or cancellation is to become effective. Valid entries include 01 through 31.

TERMCD - The reason for cancellation of an agent. Not Applicable to appointments (leave 2 spaces). Valid entries include the following:

AM Agent moved LP Lack of production CD Company Decision AR Agent Request - Retired, Resigned, etc. OM Agent owes company money WP Agent withheld premium MP Agent misrepresented policy FI False information on job application DA Disciplinary action in other states RP Replaced policies FC For Cause FE Felony Conviction TD Cancellation due to death of the agent.

CONAME - The name of the company to which the agent is to be appointed or cancelled.

CONUM - The 7 digit state company number of the company to which the agent is to be appointed or cancelled.

NAICNO - The last five digits of the NAIC number of the company to which the agent is to be appointed or cancelled.

CONTACT - The name of the company submitting the Agent Appointment or Cancellation.

CONADDR - The address of the company submitting the Agent Appointment or Cancellation.

CONADDR2- The city, state and zip code of the company submitting the Agent Appointment or Cancellation.