Agent Data - Type 55 - Format/Edits

June 18, 2004

Exhibit 55

FCIC-Appendix III

(AGENT DATA – RECORD 55)
Format/Edits

Field
No.
1
2

Field Name

Begin
Pos

Size

Picture

Field Edits

1
3

2
2

9(02)
X(02)

Required. Must be 55.
Required. Edit with AIP/Company table.

3

Record Type
Approved Insurance
Provider
Agent Directory State

5

2

9(02)

4

Active Flag

7

1

X(01)

5

Inactive Date

8

8

9(08)

6
7
8

Filler
Reinsurance Year
Type of ID Code

16
18
22

2
4
1

X(02)
9(04)
X(01)

9

Agent ID Code

23

9

X(09)

10

Agent Last Name

32

20

X(20)

11

Agent First Name

52

12

X(12)

12

Agent Middle Name

64

10

X(10)

13

Agent Suffix

74

5

X(05)

14

Agent Title

79

4

X(04)

15

Agency Name

83

35

X(35)

Required for all records. Must be a valid FIPS
state code for directory state. Must submit
one record for each state serviced.
Required for all records.
Must be:
Y = Yes, Active
N = No, Inactive
If field #4 = N, then this field cannot be blank.
Must be between 07/01/2004 and 6/30/2005.
Must be: MMDDCCYY format.
If field #4 = Y, then zero fill.
Must be Spaces.
Must equal the Reinsurance Year.
Required for all records.
Must be:
A = Agent
U = Unlisted Agent (will not be listed on
RMA website)
Required for all records. Must be left
justified. AIP issued identification number for
certified MPCI agent. An agent-id can only
reference one SSN for an AIP.
Required for all records. Last name of the
agent. Must be left justified beginning in the
first position. Special characters acceptable:
hyphen (-), comma (,), quote (“), period (.),
apostrophe (‘) only.
First name of the Agent. Must not be blank.
Must be left justified beginning in first
position.
Middle name of the Agent. Must be left
justified beginning in first position or may =
blanks.
Name suffix of the Agent (i.e. Sr, Jr, etc.)
Must be left justified beginning in first
position or may = blanks.
Name title of the Agent (i.e. Dr, Mr, etc.)
Must be left justified beginning in first
position or may = blanks.
Required for all records. Must be left justified
beginning in first position. Special characters
acceptable: forward slash (/), and (&) or
hyphen (-).

FCIC-APPENDIX III

55 - 1

RY 2005

June 18, 2004

Exhibit 55

FCIC-Appendix III

(AGENT DATA – RECORD 55)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

16

Agent Address

118

35

X(35)

17

City

153

35

X(35)

18

Address County

188

3

9(03)

19

Address State

191

2

X(02)

20

Zip Code

193

5

9(5)

21

Zip Extension

198

4

9(4)

22
23

Filler
Phone Number

202
208

6
10

X(06)
9(10)

24

Phone Extension

218

6

X(06)

25

File Retention Flag

224

1

X(01)

26
27
28

Review Flag
Filler
Agent SSN

225
227
250

2
23
9

9(02)
X(23)
9(09)

29

Agent Directory County

259

3

9(03)

30
31

Filler
SSN Validation Flag

262
335

73
2

X(73)
X(02)

32

Ineligible Tracking
Validation Flag
Annual Review Date

337

8

X(08)

Required for all records. Must be left justified
beginning in first position. Enter location or
street address of agent office. Reject if post
office box. Special character acceptable:
forward slash (/).
Required for all records. Must be left
justified. If state code eq “ZZ” (field 19),
enter foreign city and country.
Required for all records. Edit with county
table. Must be valid for zip code submitted
for record.
Required for all records. Must be valid alpha
state abbreviation for the zip code submitted
for the record. If state = “ZZ” the edits for
fields 18, 19 and 20 do not apply.
Required for all records. Must be a valid zip
code. Must be zeros if state eq “ZZ”.
Optional; if reported must be valid for zip
code, state, county and city.
Must be Spaces.
Required for all records. Must be left justified
with no hyphens, parentheses, or special
characters.
Must be left justified beginning in first
position.
Enter “Y” if Agent retains the official file
folder for the policy serviced; Enter “N” if
not.
Reserved. Zero fill.
Must be Spaces.
Valid SSN required for all records. SSN for
the certified agent. Required for A/O expense
reimbursement at annual settlement
R&D-97-043.
Required for all records. Must be a valid FIPS
county code for directory county. Must
submit one record for each county to be listed
in RMA Agent Directory.
Must be Spaces.
Internal Use.
Positions 335 - 336 will contain the SSN
validation flag.
Internal Use. Reserved.

345

8

9(08)

Reserved. Zero fill.

33

FCIC-APPENDIX III

55 - 2

RY 2005

June 18, 2004

Exhibit 55

FCIC-Appendix III

(AGENT DATA – RECORD 55)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

34

E-mail Address

353

100

X(100)

35
36

Filler
FCIC Control Time

453
551

98
4

X(98)
9(04)

37

FCIC Control Date

555

8

9(08)

38

Reinsurance Year

563

4

9(04)

39

Batch Number

567

4

9(04)

40

Transaction Sequence
Number

571

8

9(08)

41
42
43

Transaction Rejected Flag
Transaction Source Flag
FCIC Initially Accepted Date

579
580
581

1
1
8

X(01)
X(01)
9(08)

44

Filler

589

12

X(12)

Field Edits

Optional, will be included on Agent Locator;
else spaces.
Must be spaces.
Internal Use. The time the transaction batch
file was received. (From when transmission
started) HHMM Format.
Internal Use. The date the transaction batch
file was received. (From when transmission
started) MMDD CCYY Format.
Internal Use. The Reinsurance Year. CCYY
format.
Internal Use. The sequential number
identifying the file that was submitted by the
AIP to FCIC/RMA.
Internal Use. The sequential number
assigned to each transaction number
processed by DAS after it has been sorted.
Internal Use. Reserved.
Internal Use. Reserved.
Internal Use. The date this record was
initially accepted by DAS. MMDDCCYY
format.
Internal Use.

Notes: Key fields are - Agent Directory State, Agent SSN, Phone Number, Agent
Only 1 record will be accepted for each key combo.

Directory County.

A 55 record must be accepted for the AIP, List State and Agent SSN before an 11, 13, or 14
record will be accepted.
If field 4, Active Flag = Y and field 8, Type of ID Code = A, the record will be included in the creation of
the RMA agent directory.
If field 19, Address State = field 3, Agent Directory State the record will be used in the resident listing. If
the Address State is not equal to the Agent Directory State the record will be used for the non resident
listing.
Address and Phone Number are critical for referring potential clients. For this reason, the address field
validation will reject post office box addresses and the phone number field must contain a valid phone
number.
Do not include punctuation in name fields, except for apostrophes and hyphens in the last name field.
Only report licensed and/or certified agents who are actively participating in the delivery of FCIC
approved products. Records submitted for others will be deleted.

FCIC-APPENDIX III

55 - 3

RY 2005

June 18, 2004

Exhibit 55

FCIC-Appendix III

(AGENT DATA – RECORD 55)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

Field Edits

For multiple records with same SSN all name fields must be exactly the same by AIP.

FCIC-APPENDIX III

55 - 4

RY 2005