Download:
pdf |
pdfRecord
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Conflict of Interest
P51
Data Type
Max
Length
P51
1
AIP Code
Character
2
P51
P51
2
3
Reinsurance Year
Record Type Code
Numeric
Character
4
6
P51
4
AIP COI Key
Character
15
P51
5
AIP Adjuster Key
Character
15
P51
P51
"*" = Output Only
6/27/2018
6
7
AIP Insurance Agent Key
AIP Employee Key
Character
Character
15
15
Page 1 of 4
File Type:
Reinsurance Year:
Version:
Release Date:
Format
CCYY
BUS
Key Req?
Y
Y
Y
Y
Y
Y
Y
Y
Y
Delimited
2019
Approved
7/1/2018
Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must equal "2019".
Record Type Code must equal "P51".
AIP COI Key must be unique within the submitted
Conflict of Interest, "P51" records.
AIP Adjuster Key must match the corresponding
Adjuster, "P56" record for the Adjuster who
completed the COI Questionnaire.
AIP Adjuster Key is Required when AIP Insurance
Agent Key is empty and AIP Employee Key is
empty.
AIP Insurance Agent Key must match the
corresponding Insurance Agent, "P55" record for
the Agent who completed the COI Questionnaire.
AIP Insurance Agent Key is Required when AIP
Adjuster Key is empty and AIP Employee Key is
empty.
AIP Employee Key must match the corresponding
Employee, "P54" record for the company or
agency employee who completed the COI
Questionnaire.
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Conflict of Interest
P51
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
7/1/2018
Rules
AIP Employee Key is Required when AIP Insurance
Agent Key is empty and AIP Adjuster Key is
empty.
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
Code; edit with Plan of Ops/AIP Company table.
COI Question Code List must be valid; edit with
the COI Question ICE,"D00015".
P51
8
Policy Number
Character
7
Y
Y
P51
9
PIC Code
Character
3
Y
Y
P51
10
Location State Code
Character
2
Y
Y
P51
11
COI Question Code List
Character
50
12
First Submission Flag
Character
1
First Submission Flag must equal Yes, "Y" the first
time this record is submitted, otherwise No, "N".
Numeric
5
99999
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.
Date/Time
21
CCYYMMDD
hh:mm:ss.fff
Initial Accepted Date is the original date assigned
when this record was first received at RMA.
P51
*
P51
*
13
Initial Accepted Batch Number
P51
*
14
Initial Accepted Date
"*" = Output Only
6/27/2018
Page 2 of 4
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
P51
*
15
Batch Received Date
P51
*
16
P51
*
P51
*
Conflict of Interest
P51
File Type:
Reinsurance Year:
Version:
Release Date:
Data Type
Max
Length
Date/Time
21
CCYYMMDD
hh:mm:ss.fff
Batch Number
Numeric
5
99999
17
Batch Record ID
Numeric
15
18
Process Result Code
Character
1
"*" = Output Only
6/27/2018
Field Name
Page 3 of 4
Format
BUS
Key Req?
Delimited
2019
Approved
7/1/2018
Rules
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.
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
Conflict of Interest
P51
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Delimited
2019
Approved
7/1/2018
Rules
Record Level Rules
The Conflict of Interest "P51" record will be
deleted if the corresponding Policy Producer,
"P10" record is deleted.
An Employee "P54", or Insurance Agent "P55", or
Adjuster "P56" record must exist prior to
submitting a Conflict of Interest "P51" record.
All Conflict of Interest "P51" records reported to
the RMA, will replace any previously reported
Conflict of Interest "P51" record.
1
2
3
Policy Delete "P49" record has no impact on the
Conflict of Interest "P51" record.
The Conflict of Interest, "P51" record will not be
accepted when processing has been suspended
for this record type per RMA directive.
4
5
"*" = Output Only
6/27/2018
Page 4 of 4
File Type | application/pdf |
File Title | P51 Conflict of Interest Record |
Subject | PASS Record |
Author | USDA Risk Management Agency |
File Modified | 2018-06-27 |
File Created | 2018-06-27 |