Agent Data - Type 55 - Format - Edits

June 28, 2007

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)

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/2007 and
6/30/2008. 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. Agent
ID Code can not equal Agent SSN.
Required for all records. Last name of the
agent. Must be left justified beginning in the
first position. Alpha including (-), (.), ( ), (‘),
(,).
First name of the Agent. Must not be blank.
Must be left justified beginning in first
position. Alpha including (-), (.), ( ), (‘), (,).
Middle name of the Agent. Must be left
justified beginning in first position or may =
blanks. Alpha including (-), (.), ( ), (‘), (,).
Name suffix of the Agent (i.e. Sr, Jr, etc.)
Must be left justified beginning in first
position or may = blanks. Alpha including
(-), (.), ( ), (‘), (,).
Name title of the Agent (i.e. Dr, Mr, etc.)
Must be left justified beginning in first
position or may = blanks. Alpha including
(-), (.), ( ), (‘), (,).

FCIC-APPENDIX III

55 - 1

RY 2008

June 28, 2007

Exhibit 55

FCIC-Appendix III

(AGENT DATA – RECORD 55)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

15

Agency Name

83

35

X(35)

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

Filler

225

2

X(02)

FCIC-APPENDIX III

55 - 2

Field Edits

Required for all records. Must be left justified
beginning in first position. Alphanumeric
including (-), (,), (.), ( ), (‘), (&), (%), (*), (+),
(#).
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. Alphanumeric
including (-), (,), (.), ( ), (&), (%), (#), (/).
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.
Must be spaces.

RY 2008

June 28, 2007

Exhibit 55

FCIC-Appendix III

(AGENT DATA – RECORD 55)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

Picture

27
28

Filler
Agent SSN

227
250

23
9

X(23)
9(09)

29

Agent Directory County

259

3

9(03)

30

1st Alternative Language

262

3

X(03)

31
32
33
34
35
36
37
38
39
40
41
42

2nd Alternative Language
3rd Alternative Language
4th Alternative Language
5th Alternative Language
6th Alternative Language
7th Alternative Language
8th Alternative Language
9th Alternative Language
10th Alternative Language
11th Alternative Language
Filler
SSN Validation Flag

265
268
271
274
277
280
283
286
289
292
295
335

3
3
3
3
3
3
3
3
3
3
40
2

X(03)
X(03)
X(03)
X(03)
X(03)
X(03)
X(03)
X(03)
X(03)
X(03)
X(40)
X(02)

43

337

8

X(08)

44
45

Ineligible Tracking
Validation Flag
Annual Review Date
E-mail Address

345
353

8
100

9(08)
X(100)

46

Filler

453

98

X(98)

FCIC-APPENDIX III

55 - 3

Field Edits

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.
Optional: Agent volunteers only. Must be
left justified. Three position alpha code from
FCIC approved language list; else spaces.
Will be included on the Agent Locator.
See Field 30.
See Field 30.
See Field 30.
See Field 30.
See Field 30.
See Field 30.
See Field 30.
See Field 30.
See Field 30.
See Field 30.
Must be Spaces.
Internal Use.
Positions 335 - 336 will contain the SSN
validation flag.
Internal Use. Reserved.
Reserved. Zero fill.
Optional, will be included on Agent Locator;
else spaces.
Must be spaces.

RY 2008

June 28, 2007

Exhibit 55

FCIC-Appendix III

(AGENT DATA – RECORD 55)
Format/Edits

Field
No.

Field Name

Begin
Pos

Size

47

FCIC Control Time

551

4

9(04)

48

FCIC Control Date

555

8

9(08)

49

Reinsurance Year

563

4

9(04)

50

Batch Number

567

4

9(04)

51

Transaction Sequence
Number

571

8

9(08)

52
53
54

Transaction Rejected Flag
Transaction Source Flag
FCIC Initially Accepted
Date

579
580
581

1
1
8

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

55

Filler

589

12

X(12)

Notes:

Picture

Field Edits

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.

Key fields are - Agent Directory State, Agent SSN, Phone Number, Agent Directory County.
Only 1 record will be accepted for each key combo.
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 = 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.
For multiple records with same SSN all name fields must be exactly the same by AIP.

FCIC-APPENDIX III

55 - 4

RY 2008