AM Best File Layout

Description: Quarterly full rating service with states licensed

File Format: Excel Spreadsheet

Format Keys: A = ALPHANUMERIC (PIC X (LENGTH))

   NX = NUMERIC WITH X DECIMAL PLACES (PIC 9 (LENGTH - X) V 9(x))

The Sagitta Import requires the Column headers to EXACTLY match the Column headers as defined below (Including upper vs. lower case plus punctuation).
COLUMN NAME / Field Number Field Description Length Format

A/1

AMB NUMBER

5

N

B/2

NAIC COMPANY NUMBER

5

N

C/3

BEST’S FINANCIAL STRENGTH RATING ALPHA

7

A

D/4

BEST’S FINANCIAL STRENGTH NUMERIC

6

N

E/5

FPR NUMERIC VALUE

2

N

F/6

FINANCIAL SIZE ALPHA

4

A

G/7

FINANCIAL SIZE NUMERIC

2

N

H/8

BEST'S FINANCIAL STRENGTH RATING EFFECTIVE DATE

10

A

I/9

BUSINESS COMPOSITE CODE

1

A

J/10

RESPONSIBLE RATING DIVISION

1

A

K/11

STATE/PROVINCE OF DOMICILE

2

A

L/12

AMB COMPANY NAME

100

A

M/13

AMB ULTIMATE PARENT NUMBER

5

N

N/14

AMB ULTIMATE PARENT NAME

40

A

O/15

COUNTRY OF DOMICILE

2

A

P/16

AMB RATING UNIT COMPANY NUMBER

5

N

Q/17

AMB RATING UNIT COMPANY NAME

40

A

R/18

BEST’S FINANCIAL STRENGTH RATING OUTLOOK

1

A

S/19

BEST’S FINANCIAL STRENGTH RATING IMPLICATION

1

A

T/20

BEST’S FINANCIAL STRENGTH RATING ACTION

2

A

U/21

AMB RATING UNIT INDICATOR

1

A

V/22

FEIN NUMBER

10

A

 

Licensed States

COLUMN NAME / Field Number Field Description Length Format
W/SL1 ALABAMA 1 A
X/SL2 ALASKA 1 A
Y/SL3 ARIZONA 1 A
Z/SL4 ARKANSAS 1 A
AA/SL5 CALIFORNIA 1 A
AB/SL6 COLORADO 1 A
AC/SL7 CONNECTICUT 1 A
AD/SL8 DELAWARE 1 A
AE/SL9 DISTRICT OF COLUMBIA 1 A
AF/SL10 FLORIDA 1 A
AG/SL11 GEORGIA 1 A
AH/SL12 HAWAII 1 A
AI/SL13 IDAHO 1 A
AJ/SL14 ILLINOIS 1 A
AK/SL15 INDIANA 1 A
AL/SL16 IOWA 1 A
AM/SL17 KANSAS 1 A
AN/SL18 KENTUCKY 1 A
AO/SL19 LOUISIANA 1 A
AP/SL20 MAINE 1 A
AQ/SL21 MARYLAND 1 A
AR/SL22 MASSACHUSETTS 1 A
AS/SL23 MICHIGAN 1 A
AT/SL24 MINNESOTA 1 A
AU/SL25 MISSISSIPPI 1 A
AV/SL26 MISSOURI 1 A
AW/SL27 MONTANA 1 A
AX/SL28 NEBRASKA 1 A

AY/SL29

NEVADA

1

A

AZ/SL30

NEW HAMPSHIRE

1

A

BA/SL31

NEW JERSEY

1

A

BB/SL32

NEW MEXICO

1

A

BC/SL33

NEW YORK

1

A

BD/SL34

NORTH CAROLINA

1

A

BE/SL35

NORTH DAKOTA

1

A

BF/SL36

OHIO

1

A

BG/SL37

OKLAHOMA

1

A

BH/SL38

OREGON

1

A

BI/SL39

PENNSYLVANIA

1

A

BJ/SL40

RHODE ISLAND

1

A

BK/SL41

SOUTH CAROLINA

1

A

BL/SL42

SOUTH DAKOTA

1

A

BM/SL43

TENNESSEE

1

A

BN/SL44

TEXAS

1

A

BO/SL45

UTAH

1

A

BP/SL46

VERMONT

1

A

BQ/SL47

VIRGINIA

1

A

BR/SL48

WASHINGTON

1

A

BS/SL49

WEST VIRGINIA

1

A

BT/SL50

WISCONSIN

1

A

BU/SL51

WYOMING

1

A

BV/SL52

AMERICAN SAMOA

1

A

BW/SL53

GUAM

1

A

BX/SL54

PUERTO RICO

1

A

BY/SL55

VIRGIN ISLANDS

1

A

BZ/SL70

N MARIANA ISLANDS

1

A

CA/SL56

CANADA

1

A

 

Life/Health Insurer Licensing Codes:

0 = = Not Licensed

1 = L = Licensed

Property/Casualty Insurer Licensing Codes:

0 = = Not Licensed

1 = L = Licensed

2 = R = Licensed for Reinsurance Only

3 = A = Approved for Reinsurance

4 = O = Credit for Reinsurance (Other) - meets state requirements other than licensing or accreditation

5 = S = Approved or not disapproved for surplus lines

6 = F = Operates as authorized under the Federal Liability Risk Retention Act