Download:
pdf |
pdfRecord
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Quality Control Reporting
P57
Data Type
Max
Length
P57
1
AIP Code
Character
2
P57
P57
2
3
Reinsurance Year
Record Type Code
Numeric
Character
4
6
P57
4
AIP Quality Control Reporting Key
Character
P57
5
Policy Number
P57
6
P57
7
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
Y
Y
Y
Y
Y
15
Y
Y
Character
7
Y
Y
PIC Code
Character
3
Y
Y
Location State Code
Character
2
Y
Y
CCYY
P57
8
Location County Code
Character
3
Y
Y
P57
9
Insurance Plan Code
Character
2
Y
Y
P57
10
Commodity Code
Character
4
Y
Y
P57
11
Commodity Year
Numeric
4
P57
12
WA Flag
Character
1
"*" = Output Only
6/27/2018
Page 1 of 5
Y
Y
Delimited
2019
Approved
7/1/2018
Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2019".
Record Type Code must be "P57".
AIP Quality Control Reporting Key must be unique
within the submitted Quality Control Reporting,
"P57" records.
Policy number must be 7 numbers with leading
zeroes.
PIC Code must contain a valid PIC Code; edit with
the PlC ICE, "D00101", otherwise empty."
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."
Location County Code must be valid; edit with the
County ADM, "A00440". Location County Code
must be valid for the Commodity Year/Commodity
Code/Location State Code/Insurance Plan Code;
edit with the Insurance Offer ADM, "A00030".
Insurance Plan Code must be valid; edit with the
Insurance Plan ADM, "A00460".
Commodity Code must be valid; edit with the
Commodity ADM, "A00420".
Commodity Year must be valid for the Insurance
Plan Code/Commodity code/Location State
Code/Location County Code; edit with the
Insurance Offer ADM, "A00030".
WA Flag must equal Yes, "Y" when a Written
Agreement exists on the policy being reviewed.
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Quality Control Reporting
P57
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
BUS
Key Req?
P57
13
Reviewer Name
Character
40
Y
P57
14
Reviewer Title
Character
20
Y
P57
15
Review Completion Date
Date
8
P57
16
Eligible Crop Insurance Contract Error Flag
Character
CCYYMMDD
Y
Delimited
2019
Approved
7/1/2018
Rules
Reviewer Name must equal the name of the
individual completing the last review.
Reviewer Title must equal the title of the
individual completing the last review.
Review Completion Date must equal the last date
of the review.
ECIC Error Flag must equal ECIC contained errors,
"Y" when Application Review Result Code, APH
Review Result Code, Acreage Report Review
Result Code or Claim Review Result Code equals
Reviewed Application was corrected, "C" or
Reviewed, no correction made as any errors are
within Tolerance, "T", otherwise empty.
1
Quality Control Review Codes that are applicable
must be entered for each Eligible Crop Insurance
Contract, must be valid; edit with Quality Control
Review Ice, "D00130"; comma separated for
multiple review codes.
Quality Control Review Code List must be a
minimum of 2 characters in length and a
maximum of 23 characters in length.
Application Review Result Code must be valid; edit
with the Review Result ICE, "D00082".
APH Review Result Code must be valid; edit with
the Review Result ICE, "D00082".
P57
17
Quality Control Review Code List
Character
23
Y
P57
18
Application Review Result Code
Character
1
Y
P57
19
APH Review Result Code
Character
1
Y
P57
20
Acreage Report Review Result Code
Character
1
Y
Acreage Report Review Result Code must be valid;
edit with the Review Result ICE, "D00082".
P57
21
Claim Review Result Code
Character
1
Y
Claim Review Result Code must be valid; edit with
the Review Result ICE, "D00082".
"*" = Output Only
6/27/2018
Page 2 of 5
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Quality Control Reporting
P57
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
P57
22
Original Liability Amount
Numeric
10
9999999999
P57
23
Original Total Premium Amount
Numeric
10
9999999999
P57
24
Original Indemnity Amount
Numeric
11
S9999999999
P57
P57
25
26
"*" = Output Only
6/27/2018
Final Liability Amount
Final Total Premium Amount
Numeric
Numeric
Page 3 of 5
10
10
BUS
Key Req?
Delimited
2019
Approved
7/1/2018
Rules
Original Liability Amount must be the Liability
reported to RMA by the AIP prior to the ECIC
review. Original Liability Amount must be the
earliest Liability reported to RMA by the AIP prior
to the ECIC review if multiple reviews have
occurred.
Original Total Premium Amount must be the Total
Premium reported to RMA by the AIP prior to the
ECIC review. Original Total Premium Amount
must be the earliest Total Premium reported to
RMA by the AIP prior to the ECIC review if multiple
reviews have occurred.
Original Indemnity Amount must be the Indemnity
reported to RMA by the AIP prior to the ECIC
review. Original Indemnity Amount must be the
earliest Indemnity reported to RMA by the AIP
prior to the ECIC review if multiple reviews have
occurred.
9999999999
Final Liability Amount must be the Liability
reported to RMA by the AIP after the ECIC review.
Final Liability Amount must be the latest Liability
reported to RMA by the AIP after the ECIC review
if multiple reviews have occurred.
9999999999
Final Total Premium Amount must be the Total
Premium reported to RMA by the AIP after the
ECIC review. Final Total Premium Amount must
be the latest Total Premium reported to RMA by
the AIP after the Commodity Policy review if
multiple reviews have occurred.
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Quality Control Reporting
P57
Data Type
Max
Length
File Type:
Reinsurance Year:
Version:
Release Date:
Format
P57
27
Final Indemnity Amount
Numeric
11
S9999999999
P57
28
Comment
Character
200
Numeric
5
99999
BUS
Key Req?
Delimited
2019
Approved
7/1/2018
Rules
Final Indemnity Amount must be the Indemnity
reported to RMA by the AIP after the ECIC review.
Final Indemnity Amount must be the latest
Indemnity reported to RMA by the AIP after the
ECIC review if multiple reviews have occurred.
Comment can include the following special
characters: (-), (.), ( ), ('), (,).
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.
P57
*
29
Initial Accepted Batch Number
P57
*
30
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.
P57
*
31
Batch Received Date
Date/Time
21
CCYYMMDD
hh:mm:ss.fff
P57
*
32
Batch Number
Numeric
5
99999
P57
*
33
Batch Record ID
Numeric
15
P57
*
34
Process Result Code
Character
1
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" for values.
Record Level Rules
A Quality Control Reporting, "P57" record must be
reported within 20 business days of completing
each review.
1
"*" = Output Only
6/27/2018
Page 4 of 5
Record
Number
Output
Application Source:
File Group:
Record Name:
Record Code:
Field
Number
Field Name
Quality Control Reporting
P57
Data Type
Max
Length
Format
BUS
Key Req?
Delimited
2019
Approved
7/1/2018
Rules
Acceptance of the Quality Control Reporting,
"P57" record is not dependent upon acceptance
of any other policy record.
All Quality Control Reporting, "P57" records in a
batch will replace all previously reported Quality
Control Reporting , "P57" records.
The Policy Delete, "P49" record has no impact on
the Quality Control Reporting, "P57" record.
2
3
4
"*" = Output Only
6/27/2018
File Type:
Reinsurance Year:
Version:
Release Date:
Page 5 of 5
File Type | application/pdf |
File Title | P57 Quality Control Reporting Record |
Subject | PASS Record |
Author | USDA Risk Management Agency |
File Modified | 2018-06-27 |
File Created | 2018-06-27 |