P57 Quality Control Reporting

Record
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

PIC Code

P57

7

Location State Code

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?
Y

Y

Y
Y

15

Y

Y

Character

7

Y

Y

Character

3

Y

Y

PIC Code must contain a valid PIC Code; edit with
the PlC ICE, "D00101", otherwise empty."

Y

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".

Character

2

CCYY

Y

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

11

"*" = Output Only
2/17/2012

Commodity Year

AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2012".
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
zeros.

Y

P57

P57

Rules

Numeric

Page 1 of 5

4

Y

Y

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".

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

WA Flag must equal Yes, "Y" when a Written
Agreement exists on the policy being reviewed.

P57

12

WA Flag

Character

1

P57

13

Reviewer Name

Character

40

Y

P57

14

Reviewer Title

Character

20

Y

P57

15

Review Completion Date

Date

8

P57

P57

16

17

Eligible Crop Insurance Contract Error Flag

Quality Control Review Code List

Character

Character

Rules

CCYYMMDD

Y

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.

1

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.

23

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.

Y

Quality Control Review Code List must be a
minimum of 2 characters in length and a
maximum of 23 characters in length.
P57

18

Application Review Result Code

Character

1

Y

Application Review Result Code must be valid; edit
with the Review Result ICE, "D00082".

P57

19

APH Review Result Code

Character

1

Y

APH Review Result Code must be valid; edit with
the Review Result ICE, "D00082".

"*" = Output Only
2/17/2012

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

P57

20

Acreage Report Review Result Code

Character

1

Y

P57

21

Claim Review Result Code

Character

1

Y

P57

22

Original Liability Amount

Numeric

10

P57

P57

P57

23

24

25

"*" = Output Only
2/17/2012

Original Total Premium Amount

Original Indemnity Amount

Final Liability Amount

Numeric

Numeric

Numeric

Page 3 of 5

10

11

10

9999999999

Rules
Acreage Report Review Result Code must be valid;
edit with the Review Result ICE, "D00082".
Claim Review Result Code must be valid; edit with
the Review Result ICE, "D00082".
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.

9999999999

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.

S9999999999

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.

Record
Number

Output

Application Source:
File Group:
Record Name:
Record Code:

P57

Field
Number

26

Field Name

Final Total Premium Amount

Quality Control Reporting
P57

Data Type

Max
Length

Numeric

10

File Type: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules

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.

S9999999999

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.

P57

27

Final Indemnity Amount

Numeric

11

P57

28

Comment

Character

200

Numeric

4

9999

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

4

9999

P57

*

33

Batch Record ID

Numeric

15

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.

P57

*

34

Process Result Code

Character

1

"*" = Output Only
2/17/2012

Page 4 of 5

Process Result Code equals the final result code as
determined by PASS processing, refer to the
Process Result ICE, "D00002" for values.

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: Delimited
Reinsurance Year: 2012
Version: Approved
Release Date: 3/1/2012

Format

BUS
Key Req?

Rules

Record Level Rules
A type P57 record must be reported within 20
business days of completing each review.
Acceptance of the P57 record is not dependent
upon acceptance of any other policy record.
All type P57 records in a batch will replace all
previously reported type P57 records.
The type 49 delete record has no impact on the
type P57 record.

"*" = Output Only
2/17/2012

Page 5 of 5