Download:
pdf |
pdfRecord
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012
Policy Producer
P10
Data Type
Max
Length
Format
BUS
Key Req?
P10
1
AIP Code
Character
2
P10
P10
2
3
Reinsurance Year
Record Type Code
Numeric
Character
4
6
P10
4
AIP Policy Producer Key
Character
15
P10
5
Policy Number
Character
7
Y
Y
P10
6
PIC Code
Character
3
Y
Y
P10
7
Location State Code
Character
2
Y
Y
P10
8
Tax ID
Character
9
"*" = Output Only
2/17/2012
Page 1 of 9
CCYY
Y
Y
Y
Y
Y
Y
Y
Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must equal "2012".
Record Type Code must equal "P10".
AIP Policy Producer Key must be unique within
the submitted Policy Producer, "P10" record.
Policy Number must be exactly 7 characters in
length.
Policy Number must contain only numeric
characters.
Policy Number must not equal "0000000".
PIC Code must be valid; edit with PIC ICE,
"D00101".
Location State Code must be valid; edit with the
State ADM, "A00520".
Location State Code must be valid for the AIP/PIC
Code; edit with the AIP State table.
Tax ID must be a valid SSN when Tax ID Type Code
equals SSN "1", edit with SSN Table.
Tax ID must be a valid RMA Assigned Number
when Tax ID Type Code equals "3".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012
Policy Producer
P10
Data Type
Max
Length
Format
BUS
Key Req?
Rules
Tax ID must be a valid Bureau of Indian Affairs
number when Tax ID Type Code equals BIA, "5",
edit the first five positions with the County ADM
"A00440". Positions 1-2 must be a valid Location
State Code, positions 3-5 must be a valid Location
County Code and positions 6-9 cannot contain any
spaces.
Tax ID must contain only numeric characters.
Tax ID may not equal the Tax ID from the prior SII
Policy when Entity Type Code equals D, J, R, T and
SII Prior Policy Number is not empty.
P10
9
Tax ID Type Code
Character
1
Y
Tax ID number must not equal "000000000".
Tax ID Type Code must be valid; edit with the Tax
ID Type ICE, "D00005".
The Policy Producer, "P10" Tax ID Type Code must
be valid for the Policy Producer Other Person,
"P10B" Tax ID Type Code; edit with the ID Type
Entity Type Primary Producer SBI ICE, "D00019".
P10
"*" = Output Only
2/17/2012
10
Entity Type Code
Character
1
Page 2 of 9
Y
Entity Type Code must be valid; edit with the
Entity Type ICE, "D00012".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P10
11
Field Name
Business Name
Policy Producer
P10
Data Type
Max
Length
Character
50
File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012
Format
BUS
Key Req?
Rules
Business Name is required when Last Name is
empty.
Business Name must be empty when Last Name
exists.
Business Name must be empty when not allowed
for the Entity Type Code; edit with ID Type Entity
Type Primary Producer ICE, "D00019".
P10
12
Last Name
Character
25
Business Name must contain only alpha-numeric
characters and can include the following special
characters: ( ), (-), (,), (.), ('), (&), (%), (*), (+), (#),
(/).
Last Name is required when Business Name is
empty.
Last Name must be empty when Business Name
exists.
Last Name when required must include at least
two characters.
Last Name must contain only alpha characters
and can include the following special characters: (), (.), ( ), ('), (,).
Last Name must be empty when not allowed for
the Entity Type Code; edit with the ID Type Entity
Type Primary Producer ICE, "D00019".
"*" = Output Only
2/17/2012
Page 3 of 9
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P10
13
Field Name
First Name
Policy Producer
P10
Data Type
Max
Length
Character
20
File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012
Format
BUS
Key Req?
Rules
First Name is required when Business Name is
empty.
First Name must be empty when Business Name
exists.
First Name must include only alpha characters
and can include the following special characters: (), (.), ( ), ('), (,).
First Name must be empty when not allowed for
the Entity Type Code; edit with ID Type Entity
Type Primary Producer ICE, "D00019".
P10
14
Middle Name
Character
20
P10
15
Suffix
Character
10
P10
16
Title
Character
15
"*" = Output Only
2/17/2012
Page 4 of 9
Middle Name must contain only alpha characters
and can include the following special characters: (), (.), ( ), ('), (,).
Middle Name must be empty if Last Name is
empty.
Suffix must contain only alpha characters and can
include the following special characters: (-), (.), (
), ('), (,).
Suffix must be empty if Last Name is empty.
Title must contain only alpha characters and can
include the following special characters: (-), (.), (
), ('), (,).
Title must be empty if Last Name is empty.
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012
Policy Producer
P10
Data Type
Max
Length
Format
BUS
Key Req?
P10
17
Relationship Type Code
Character
1
Y
P10
18
Branch Office Code
Character
2
Y
P10
19
Uninsurable SBI Flag
Character
1
P10
20
USDA Common Customer ID
Character
6
P10
21
FSA RMA Entity Difference Code
Character
2
P10
22
Acreage Measurement Provided Code
Character
1
Numeric
4
9999
Rules
Relationship Type Code must be valid; edit with
the Relationship Type ICE, "D00004".
Branch Office Code must be valid; edit with the
AIP State table.
Uninsurable SBI Flag must be Yes, "Y" when an SBI
on the policy does not provide a valid Tax ID and
Insured Share has been reduced, otherwise No,
"N".
Reserved.
FSA RMA Entity Difference Code must be valid;
edit with the FSA Entity Difference ICE, "D00112".
Acreage Measurement Provided Code must equal
Not Provided, "N", otherwise empty.
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.
P10
*
23
Initial Accepted Batch Number
P10
*
24
Initial Accepted Date
Date/Time
21
CCYYMMDD
hh:mm:ss.fff
Initial Accepted Date is the original date assigned
when this record was first received at RMA.
P10
*
25
Batch Received Date
Date/Time
21
CCYYMMDD
hh:mm:ss.fff
P10
*
26
Batch Number
Numeric
4
9999
Batch Received Date is the date that the AIP file is
received by RMA.
Batch Number is a sequential number assigned
when an AIP file is received.
"*" = Output Only
2/17/2012
Page 5 of 9
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012
Policy Producer
P10
Data Type
Max
Length
P10
*
27
Batch Record ID
Numeric
15
P10
*
28
Process Result Code
Character
1
"*" = Output Only
2/17/2012
Page 6 of 9
Format
BUS
Key Req?
Rules
Batch Record ID is a sequential number assigned
to each record in the AIP file by RMA during
processing. Batch Record ID is unique within the
record type for the batch.
Process Result Code equals the final result code
as determined by PASS processing, refer to the
Process Result ICE , "D00002".
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Policy Producer
P10
Data Type
Max
Length
File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012
Format
BUS
Key Req?
Rules
Record Level Rules
Original submission of a Policy Producer, "P10"
record must not be submitted after Annual
Settlement Date.
For the Policy Producer, "P10" record to be
accepted, its associated Policy Producer Address,
"P10A" and Policy Producer Other Person, "P10B"
records must be accepted in the same batch.
Entity Type Code may change with in a category
without incurring LRR as long as the Tax ID does
not change.
An RMA issued Tax ID will use the same PASS
edits/requirements as an SSN.
Fields that must be accepted to meet timely
reporting of an Eligible Crop Insurance Contract
equal AIP Code, Location State Code, Policy
Number, Reinsurance Year or Reinsurance Year
plus or minus one for the applicable Commodity
Code, Tax ID.
"*" = Output Only
2/17/2012
Page 7 of 9
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Policy Producer
P10
Data Type
Max
Length
File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012
Format
BUS
Key Req?
Rules
All Insured must have a valid Tax ID Type Code
otherwise, the AIP must obtain a valid RMA
assigned number for any Insurable entity without
a valid EIN or SSN. See MGR-05-008.
The AIP must notify all of its Employees and
Affiliates in writing of the duty to disclose to the
Company and in turn FCIC, any Business,
Financial, Legal, or Familial relationship with a
Policy Holder or a person with interest in the
policy, in accordance with Appendix IV, of the
SRA. See SRA, section IV, F, 4, H.
The combination of Tax ID Type Code and Entity
Type Code must be valid; edit with the ID Type
Entity Type Primary Producer ICE, "D00019".
The P10 record must have no less than the
minimum and no more than the maximum
number of child P10B records by Entity Type Code
and Tax ID Type Code combination.
The P10 record must be submitted between 07-012011 and 02-12-2015.
"*" = Output Only
2/17/2012
Page 8 of 9
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Policy Producer
P10
Data Type
Max
Length
File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012
Format
BUS
Key Req?
Rules
The Policy Producer, "P10" record will not be
accepted when processing has been suspended
for this record type per RMA directive.
The business key AIP Code, Reinsurance Year,
Policy Number, PIC Code, Location State Code
must not have been previously accepted for a
different record key (AIP Code, Reinsurance Year,
AIP Policy Producer Key).
"*" = Output Only
2/17/2012
Page 9 of 9
File Type | application/pdf |
Author | Todd Stinson |
File Modified | 2012-02-17 |
File Created | 2012-02-17 |