Download:
pdf |
pdfJune 28, 2007
Exhibit 112
FCIC-Appendix III
AGENT REQUIREMENTS FOR eDAS
Format/Edits
Section/Attribute
AGENT
Description/Edit
“AGENT” is the title of this section. It identifies the opening and closing of
the xml transaction for an agent. This document provides additional reporting
requirements of data under this section.
Agent precedes Crop Policy.
CHANGE_FLAG (ATTRIBUTE)
If Process Flag = 2 or 5 certain data will be allowed to change after initial
acceptance. Tags have been identified by flags below. Flag of ‘1’ will only be
allowed to change data identified by ‘1’. Flag of ‘2’ will be allowed to change
data identified by ‘1 or 2’. Flag of ‘3’ will be allowed to change any data.
Valid flags:
1 = general
2 = company approval
3 = RMA approval
Change flag will default to 2 unless otherwise indicated.
PROCESS_FLAG (ATTRIBUTE)
Valid flags:
1 = original
2 = modify
3 = delete
4 = validate (original)
5 = validate (modify)
6 = quote (only applicable for premium)
7 = retrieve
8 = cancel (only applicable for Livestock crop policy)
9 = re-instate (only applicable for Livestock crop policy)
Process flag will default to 1 unless otherwise indicated.
FCIC-APPENDIX III
112 - 1
RY 2008
June 28, 2007
Exhibit 112
FCIC-Appendix III
AGENT REQUIREMENTS FOR eDAS
Format/Edits
No.
Tag
Key
Level of
Change
1
Y
3
Y/Y
REQ
Y
NA
Y/Y
Y
2
2
3
IN/
OUT
REQ/
OPT/
CON
Max
Size
Picture
Description/Edit
2
X(02)
REQ
4
9(04)
Edit with Approved Insurance
Provider/Company table.
Must = Reinsurance Year.
Y/Y
REQ
9
X(09)
4
1
Y/Y
CON
10
X(10)
5
1
Y/Y
CON
32
X(32)
6
1
Y/Y
REQ
20
X(20)
7
1
Y/Y
REQ
12
X(12)
8
1
Y/Y
OPT
10
X(10)
9
1
Y/Y
OPT
5
X(05)
10
1
Y/Y
OPT
4
X(04)
11
2
Y/Y
CON
5
9(05)
12
NA
N/Y
REQ
19
X(19)
FCIC-APPENDIX III
112 - 2
A valid SSN for the certified
agent. Validate to SSA file and
ITS file. Must be 9 digits.
Need only if using RMA WEB
applications. Must be unique for
each SSN within an approved
insurance provider. Minimum of
3 characters.
Need only if using RMA WEB
applications. Must be unique for
each SSN within an approved
insurance provider. Format:
MD5 Hash, 0 – 9, A – F.
Last name of agent. Requires a
minimum of 2 characters, Alpha
including (-), (.), ( ), (‘), (,).
First name of agent. Must not be
blank, Alpha including (-), (.),
( ), (‘), (,).
Middle name of agent. Alpha
including (-), (.), ( ), (‘), (,).
Suffix (e.g. SR, JR, II, etc.) of
agent. Alpha including (-), (.),
( ), (‘), (,).
Title (e.g. DR, etc.) of agent.
Alpha including (-), (.), ( ), (‘),
(,).
Authorization Number provided
by Reinsurance Services
Division (RSD) approving the
original, change or deletion.
Change Flag must = 3 and
Process Flag must = 1, 2, 3, 4 or
5. If changing a “Key” field
with Level of Change = 2,
Authorization Number assigned
by administrative screen and
Change Flag must = 2.
FCIC Control Date and Time of
process, format MM/DD/YYYY
HH:MM:SS. There is a space
between the YY and HH.
RY 2008
June 28, 2007
Exhibit 112
FCIC-Appendix III
AGENT REQUIREMENTS FOR eDAS
Format/Edits
No.
Tag
13
NA
N/Y
REQ
14
NA
N/Y
NA
N/Y
15
Key
**
**
16
Y
17
Level of
Change
IN/
OUT
REQ/
OPT/
CON
Max
Size
Picture
Description/Edit
8
9(08)
REQ
6
9(06)
Transaction Sequential Number
assigned to each transaction
number processed by eDAS.
Transaction Record Number
REQ
1
X(01)
The beginning of agent
information at a detail level.
NA
Y/Y
REQ
3
9(03)
1
Y/Y
REQ
2
9(02)
18
1
Y/Y
REQ
1000
X(1000)
19
1
Y/Y
REQ
1
X(01)
20
1
Y/Y
CON
10
X(10)
21
1
Y/Y
REQ
50
X(50)
FCIC-APPENDIX III
If transaction accepted, flag = Y.
If rejected, flag = N. If deleted,
flag = D. If cancel, flag = C.
112 - 3
Agent Detail Number. Multiple
sets may be reported with a
unique number. Must be ≥ 1 or
≤ 999. Detail number represents
a separate agency (ie Agent ID
code).
Agent Directory State. Edit with
FIPS State table. Must submit
one record for each state
serviced.
Agent Directory County. Must
be a valid FIPS county code and
used to facilitate Agent
Directory. Multiple counties
may be submitted for an agent
with “comma delimited”, leading
zeros not necessary.
Example:
1,2,215
Must be:
Y = Yes, active
N = No, inactive
Inactive Date required if field 19
(Active Flag) = N. Format
MM/DD/YYYY. Numeric with
slashes. Must be between (and
including) 7/1 and 6/30 for the
reinsurance year submitted.
Insurance Plan Code List.
Multiple insurance plans may be
submitted for an agent with
“comma delimited”.
Example:
61,63,81,82
RY 2008
June 28, 2007
Exhibit 112
FCIC-Appendix III
AGENT REQUIREMENTS FOR eDAS
Format/Edits
No.
Tag
Picture
Description/Edit
22
2
Y/Y
OPT
50
X(50)
REQ
1
X(01)
Y/Y
REQ
9
X(09)
1
Y/Y
REQ
35
X(35)
1
Y/Y
REQ
35
X(35)
27
1
Y/Y
REQ
35
X(35)
28
1
Y/Y
REQ
3
9(03)
29
1
Y/Y
REQ
2
X(02)
30
1
Y/Y
REQ
5
X(05)
31
1
Y/Y
OPT
4
X(04)
Insurance Plan List Web. To
provide companies the ability to
limit access to the RMA web
application for an agent. If
limiting, submit only the
insurance plan(s) for which agent
should have access. An agent
will still have access if this tag
IS NOT submitted. Multiple
insurance plans may be
submitted for an agent with
“comma delimited”. Example:
61,
63,81,82
Type of ID Code. Must be:
A = Agent
U= Unlisted Agent (not listed on
RMA web site)
An Agent Identification Code
can only reference one SSN for
an approved insurance provider.
Alpha/numeric. Agent ID Code
can not equal Agent SSN.
Business name of agent’s
location. Alphanumeric
including (-), (,), (.), ( ), (‘), (&),
(%), (*), (+), (#).
Enter location or street address
of agent office. Do not enter
post office box. Alphanumeric
including (-), (,), (.), ( ), (&),
(%), (#), (/).
If State code = ‘ZZ’ enter foreign
city and country.
Edit with county table unless
State code = ‘ZZ’. Must be valid
for zip code submitted.
Enter alpha state abbreviation for
zip code submitted. If a foreign
country, enter ‘ZZ’.
If State NE ‘ZZ’ must be a valid
US zip code.
Must be numeric.
23
1
Y/Y
24
1
25
26
1
Y/Y
REQ
10
X(10)
Must be numeric.
1
Y/Y
OPT
6
X(06)
Must be numeric.
32
33
FCIC-APPENDIX III
Key
Level of
Change
IN/
OUT
REQ/
OPT/
CON
Max
Size
112 - 4
RY 2008
June 28, 2007
Exhibit 112
FCIC-Appendix III
AGENT REQUIREMENTS FOR eDAS
Format/Edits
No.
Tag
Key
Level of
Change
IN/
OUT
REQ/
OPT/
CON
34
1
Y/Y
REQ
35
1
Y/Y
36
2
37
NA
**
Max
Size
Picture
Description/Edit
1
X(01)
OPT
43
X(43)
Y/Y
CON
5
9(05)
N/Y
REQ
1
X(01)
File Retention Flag. Enter ‘Y’ if
agent retains the official file
folder for the policy services,
enter ‘N’ if not.
Agent volunteers language skills.
Three position alpha code from
FCIC approved language list.
Multiple languages may be
submitted for an agent with
“comma delimited”.
Authorization Number provided
by Reinsurance Services
Division (RSD) approving the
original, change or deletion.
Change Flag must = 3 and
Process Flag must = 1, 2, 3, 4 or
5. If changing a “Key” field
with Level of Change = 2,
Authorization Number assigned
by administrative screen and
Change Flag must = 2.
If transaction accepted, flag = Y.
If rejected, flag = N. If deleted,
flag = D. If cancel, flag = C.
End of agent information at
detail level.
**
Notes: Key fields are: Approved Insurance Provider (field 1), Reinsurance Year (field 2), and Agent SSN (field 3)
Key fields with Level of Change = 3 will be allowed with RMA approval. When a company submits this
information, eDAS will change all other associated data to the new information.
Key fields with Level of Change = 2 requiring a change to that field, company will use an administrative
screen to identify this change. eDAS will use this information to verify the data when submitted.
Information regarding column headers:
1) ‘Tag’ identifies the naming convention used in creation of XML.
2) ‘Key’ identifies the tags that are key to the validation/storage of data.
3) ‘Level of Change’ identifies the data that is allowed to change and at what level according to Change
Flag.
4) ‘IN/OUT’ identifies the direction of data, IN for input and OUT for output with flags ‘N’ (NO) and ‘Y’
(YES).
5) ‘REQ/OPT/CON’ identifies if the data is required (REQ), optional (OPT), or conditional (CON). If
optional or conditional and there is no data to report the tag is not used.
6) ‘Max Size’ is the maximum size of data allowed for that tag.
7) ‘Picture’ identifies the type of data expected.
8) ‘Description/Edit’ gives additional information.
FCIC-APPENDIX III
112 - 5
RY 2008
June 28, 2007
Exhibit 112
FCIC-Appendix III
AGENT REQUIREMENTS FOR eDAS
Format/Edits
No.
Tag
Key
Level of
Change
IN/
OUT
REQ/
OPT/
CON
Max
Size
Picture
Description/Edit
On an update, only the key fields that define the sections are required plus any changed fields or new
section(s).
FCIC-APPENDIX III
112 - 6
RY 2008
File Type | application/pdf |
File Title | Microsoft Word - EXH112.doc |
Author | julie.carew |
File Modified | 2007-06-28 |
File Created | 2007-06-28 |