Download:
pdf |
pdfFile Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
P19
1
AIP Code
Character
2
P19
P19
2
3
Reinsurance Year
Record Type Code
Numeric
Character
4
6
P19
4
AIP Policy Producer Key
Character
15
P19
5
AIP Insurance In Force Key
Character
15
Y
Y
P19
6
AIP WFRP Farm Reports Key
Character
15
Y
Y
P19
7
AIP Insurance Agent Key
Character
15
P19
8
Type Code
Character
3
Y
P19
9
Practice Code
Character
3
Y
"*" = Output Only
3/20/2019
Page 1 of 20
Y
CCYY
Y
Y
Y
Y
Y
Y
Rules
AIP Code must be valid; edit with the AIP ICE,
"D00100".
Reinsurance Year must be "2019".
Record Type Code must be "P19".
AIP Policy Producer Key must match the parent
primary Policy Producer, "P10" record.
AIP Insurance In Force Key must be unique within
the AIP Policy Producer Key.
AIP WFRP Farm Reports Key must be unique
within the submitted WFRP Farm Reports, "P19"
records.
AIP Insurance Agent Key must match the
corresponding Insurance Agent, "P55" record.
AIP Insurance Agent Key must refer to an active
Agent “P55” record, or an Agent who is inactive
and the Agent Acreage/Inventory Value/WFRP
Farm Reports Signature Date is less than the
inactive date.
Type Code is required; edit with the Insurance
Offer ADM, "A00030".
Type Code must equal to the Type Code from the
corresponding Insurance In Force, "P14" record, if
submitted.
Practice Code is required; edit with the Insurance
Offer ADM, "A00030".
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
P19
10
Commodity Type Code
Character
3
P19
11
Class Code
Character
3
P19
12
Sub Class Code
Character
3
P19
13
Intended Use Code
Character
3
P19
14
Irrigation Practice Code
Character
3
P19
15
Cropping Practice Code
Character
3
P19
16
Organic Practice Code
Character
3
P19
17
Interval Code
Character
3
P19
18
Insurance Option Code List
Character
29
"*" = Output Only
3/20/2019
Page 2 of 20
Format
Rules
Practice Code must equal to the Practice code on
the corresponding Insurance In Force, "P14"
record, if submitted.
Commodity Type Code must be valid; edit with
Commodity Type ADM, "A00430".
Class Code must be valid; edit with Class ADM,
"A00410".
Sub Class Code must be valid; edit with Sub Class
ADM, "A00530".
Intended Use Code must be valid; edit with
Intended Use ADM, "A00470".
Irrigation Practice Code must be valid; edit with
Irrigation Practice ADM, "A00490".
Cropping Practice Code must be valid; edit with
Cropping Practice ADM, "A00450".
Organic Practice Code must be valid; edit with
Organic Practice ADM, "A00500".
Interval Code must be valid; edit with Interval
ADM, "A00480".
Insurance Option Code List must contain only
unique delimited values.
Insurance Option Code List must be valid for each
delimited value; edit with the Option Rate ADM,
"A01060".
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
P19
19
Insured Operation Signature Date
Date
8
CCYYMMDD
Y
P19
20
Agent Operation Signature Date
Date
8
CCYYMMDD
Y
P19
21
Premium Based Code
Character
1
"*" = Output Only
3/20/2019
Page 3 of 20
Y
Rules
Insured Operation Signature Date must not be
less than the Reinsurance Year minus 1 or greater
than the submission date.
Insured Operation Signature Date is greater than
or equal to the Contract Change Date minus 1
year and less than or equal to the Batch Received
Date.
Agent Operation Signature Date must not be less
than the Reinsurance Year minus 1 or greater
than the submission date.
Agent Operation Signature Date is greater than or
equal to the Contract Change Date minus 1 year
and less than or equal to the Batch Received
Date.
Agent Operation Signature Date must be less than
Inactive Date from the Agent, "P55" record when
the Inactive Date exists.
Premium Based Code for WFRP Commodity Code
"0076" that represents what the premium is
based on. Premium Based Code must equal "I"
for Intended or "R" for Revised.
Premium Based Code must equal "R" before an
indemnity (P23) will be accepted. This excludes a
replant payment.
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
P19
Output
Application Source:
File Group:
Field
Number
22
Field Name
AIP Total Expected Revenue Amount
Numeric
10
Format
9999999999
Y
Rules
Premium Based Code must not equal "I"
(intended) when the Batch Received Date is
greater than the Premium Billing Date + 30 days.
AIP Total Expected Revenue Amount is the sum of
all commodity Expected Revenue Amounts (P19A)
for Premium Based Code.
If Premium Based Code equals "I" then this will be
the sum of all commodity Intended Expected
Revenue Amounts (P19A).
If Premium Based Code equals "R" then this will
be the sum of all commodity Revised Expected
Revenue Amounts (P19A).
P19
23
AIP Historic Average Revenue Amount
Numeric
10
9999999999
AIP (Whole Farm) Historic Average (Allowable)
Revenue. The greater of Average Revenue
Amount, Indexed Average (Allowable) Revenue
Amount, or Expanded Operation Average
(Allowable) Revenue Amount.
P19
24
AIP Historic Average Expenses Amount
Numeric
10
9999999999
AIP (Whole Farm) Historic Average (Allowable)
Expenses Amount will be based on corresponding
Historic Average Revenue Amount.
"*" = Output Only
3/20/2019
Page 4 of 20
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
P19
25
AIP Approved Revenue Amount
Numeric
10
9999999999
Y
P19
26
AIP Approved Expenses Amount
Numeric
10
9999999999
Y
Rules
AIP Approved Revenue Amount will equal lesser
of Total Expected Revenue Amount or (Whole
Farm) Historic Average (Allowable) Revenue
Amount unless Liability Amount Limitation Flag
equal, "Y", then AIP Approved Revenue Amount
will equal lesser of Total Expected Revenue
Amount or (Whole Farm) Historic Average
(Allowable) Revenue Amount or "$8.5 million
divided by Coverage Level Percent".
AIP Approved Revenue Amount cannot be greater
than "$8.5 million divided by Coverage Level
Percent".
AIP Approved Expenses Amount will be based on
determination of Approved Revenue.
If Approved Revenue Amount equal to Total
Expected Revenue Amount then Total Expected
Revenue Amount divided by Average (Allowable)
Revenue Amount) times Average (Allowable)
Expenses Amount.
P19
27
"*" = Output Only
3/20/2019
AIP Liability Amount
Numeric
10
9999999999
Page 5 of 20
Y
If Approved Revenue Amount equal to Historic
Average Revenue Amount then Historic Average
(Allowable) Expenses Amount.
AIP Liability Amount must equal the RMA
calculated Liability Amount unless Liability
Amount Limitation Flag equal, "Y".
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
P19
28
AIP Total Premium Amount
Numeric
10
9999999999
Y
P19
29
AIP Subsidy Amount
Numeric
10
9999999999
Y
Rules
AIP Liability Amount cannot exceed $8.5 million
for WFRP Commodity Code "0076" (liability cap)
at any time.
AIP Total Premium Amount must equal the RMA
calculated Total Premium Amount.
AIP Subsidy Amount must equal RMA calculated
Subsidy Amount. When AIP Subsidy Amount is
less than $1.00, round to $1.00.
When AIP Subsidy Amount is less that $1.00 when
Beginning Farmer and Rancher (BFR) and/or
Native Sod (NS) applies then cup at $0.00
AIP Subsidy Amount will be based on AIP Total
Premium Amount and ADM Subsidy Percent,
"A00070", for the Qualifying Commodity Count
and Coverage Level Percent.
Reserved.
Reserved.
P19
P19
30
31
Additional Subsidy Flag
State Private Subsidy Flag
Character
Character
1
1
P19
32
Settlement Flag
Character
1
Settlement Flag must equal Yes, "Y" if there is a
Settlement or Finding, otherwise empty.
Settlement Flag is required when the record exists
in the Settlement table.
MPCI Liability Amount will be the MPCI liability
summed for MPCI commodities under WFRP.
If Fiscal Year then month and year for when fiscal
year starts. Actual day not required.
P19
33
MPCI Liability Amount
Numeric
10
9999999999
P19
34
Fiscal Start Year Month
Character
6
CCYYMM
"*" = Output Only
3/20/2019
Page 6 of 20
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
If Calendar Year Filer then Fiscal Year Start Date
does not apply.
If Early Fiscal Year Filer then Fiscal Year Start Date
must be after January and prior to September of
Crop Year.
If Late Fiscal Year Filer then Fiscal Year Start Date
must be September or later of Crop Year.
If Fiscal Year then month and year for when the
fiscal year ends. Actual day not required.
If Calendar Year Filer then Fiscal Year End Date
does not apply.
Fiscal Year End Date must end in the 12 month
(consecutive) after start date.
Expanded Operation Flag must equal Yes, "Y" if
applicable, else No, "N".
Consecutive tax year (last year used) equal Crop
Year minus 6 years unless Late Fiscal Year Filer
(Type 672) then Crop Year minus 7.
Allowable Revenue Amount for the tax year.
Allowable Expenses Amount for the tax year.
Consecutive tax year equal Crop Year minus 5
years unless Late Fiscal Year Filer (Type 672) then
Crop Year minus 6.
P19
35
Fiscal End Year Month
Character
6
P19
36
Expanded Operation Flag
Character
1
P19
37
Tax Year 1 ID
Numeric
4
CCYY
Y
P19
P19
38
39
Allowable Revenue Amount 1
Allowable Expenses Amount 1
Numeric
Numeric
10
10
9999999999
9999999999
Y
Y
P19
40
Tax Year 2 ID
Numeric
4
CCYY
Y
P19
41
Allowable Revenue Amount 2
Numeric
10
9999999999
Y
Allowable Revenue Amount for the tax year.
P19
42
Allowable Expenses Amount 2
Numeric
10
9999999999
Y
Allowable Expenses Amount for the tax year.
"*" = Output Only
3/20/2019
CCYYMM
Rules
Y
Page 7 of 20
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
Rules
P19
43
Tax Year 3 ID
Numeric
4
CCYY
Y
Consecutive tax year equal Crop Year minus 4
years unless Late Fiscal Year Filer (Type 672) then
Crop Year minus 5.
P19
44
Allowable Revenue Amount 3
Numeric
10
9999999999
Y
Allowable Revenue Amount for the tax year.
P19
45
Allowable Expenses Amount 3
Numeric
10
9999999999
Y
Allowable Expenses Amount for the tax year.
P19
46
Tax Year 4 ID
Numeric
4
CCYY
Y
Consecutive tax year equal Crop Year minus 3
years unless Late Fiscal Year Filer (Type 672) then
Crop Year minus 4.
P19
47
Allowable Revenue Amount 4
Numeric
10
9999999999
Y
Allowable Revenue Amount for the tax year.
P19
48
Allowable Expenses Amount 4
Numeric
10
9999999999
Y
Allowable Expenses Amount for the tax year.
P19
49
Tax Year 5 ID
Numeric
4
CCYY
Y
Consecutive tax year equal Crop Year minus 2
years unless Late Fiscal Year Filer (Type 672) then
Crop Year minus 3.
P19
50
Allowable Revenue Amount 5
Numeric
10
9999999999
Y
Allowable Revenue Amount for the tax year.
P19
51
Allowable Expenses Amount 5
Numeric
10
9999999999
Y
Allowable Expenses Amount for the tax year.
P19
52
"*" = Output Only
3/20/2019
Program Indicator Code List
Character
20
Page 8 of 20
Program Indicator Code List must be valid; edit
with Program Indicator Commodity ICE,
"D00155".
When the Program Indicator Code List contains
"NS" there must also be at least one WFRP Farm
Reports Detail, "P19A" record submitted with an
"NS".
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
Rules
When the Program Indicator Code List contains
"DM" there must also be at least one WFRP Farm
Reports Detail, "P19A" record submitted with a
"DM".
When the Program Indicator Code List contains
"DM" the sum of the WFRP Farm Reports Detail,
"P19A" records' acres must be less than or equal
to five (5) acres.
When the Program Indicator Code List does not
contain "DM" there must not exist any WFRP
Farm Reports Detail, "P19A" records with a
Program Indicator Code List that contains "DM".
P19
53
Liability Amount Limitation Flag
Character
1
P19
54
CC Subsidy Reduction Percent
Numeric
6
"*" = Output Only
3/20/2019
Page 9 of 20
Y
9.9999
Liability Amount Limitation Flag must equal Yes,
"Y", if liability amount was limited to the cap,
otherwise set to No, "N".
Liability Amount Limitation Flag only required
when Premium Based Code, "R", and liability
amount was limited to the cap.
CC Subsidy Reduction Percent is required when
Applied Program Indicator Code List contains 'CC'
or 'TR'.
CC Subsidy Reduction Percent must be empty
when Applied Program Indicator Code List does
not contain 'CC' or 'TR'.
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
Rules
CC Subsidy Reduction Percent must be numeric
when CC Subsidy Reduction Percent exists.
CC Subsidy Reduction Percent must have no more
than one (1) number on the left of the decimal
point and four (4) numbers after the decimal
point, in the format of 9.9999 when CC Subsidy
Reduction Percent exists.
CC Subsidy Reduction Percent must be greater
than zero (0) and less than or equal to one (1)
when CC Subsidy Reduction Percent exists.
CC Subsidy Reduction Percent must equal 1.0000
when Policy Producer, "P10" record's Applied
Program Indicator Code List contains 'CC' or 'TR'
and CC Subsidy Reduction Percent exists.
P19
55
"*" = Output Only
3/20/2019
Index Opt Out Flag
Character
1
Page 10 of 20
Y
CC Subsidy Reduction Percent must be equal on
all associated WFRP Farm Reports, "P19" records,
unless at least one of the associated Policy
Producer Other Person, "P10B" records contain
an Entity Type Code equal to 'F', when CC Subsidy
Reduction Percent exists.
Index of revenue and expenses will be automatic,
if applicable, unless Index Opt Out Flag will equal
Yes, "Y", else No, "N".
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
P19
56
History Record Substitution Flag
Character
1
P19
57
Expanded Operation Adjustment Factor
Numeric
4
P19
58
Coverage Level Percent Waiver Flag
Character
1
P19
*
59
Valid Commodity Type Code
Character
3
P19
*
60
Valid Class Code
Character
3
P19
*
61
Valid Sub Class Code
Character
3
"*" = Output Only
3/20/2019
Page 11 of 20
Format
Y
9.99
Y
Y
Rules
Substitution made due to less than 5 years of tax
history (i.e., Beginning Farmer and Rancher). If
applicable History Record Substitution Flag will
equal Yes, "Y", else No , "N".
If History Record Substitution Flag equals Yes, "Y",
then indexing does not apply.
Expanded Operation Adjustment Factor if
operation was expanded. If Expanded Operation
Flag equal Yes, 'Y' then factor cannot be less than
0.01 or greater than 0.35. If Expanded Operation
Flag equal No, 'N' 0.00.
If Premium Based Code equals 'R' and Qualifying
Commodity Count decreased due to an insured
cause of loss, then Coverage Level Percent Waiver
Flag will equal Yes, "Y", to ensure Coverage Level
Percent validation is skipped, else No, "N".
Valid Commodity Type Code is populated from
the Valid Commodity Type Code in the Insurance
Offer ADM, "A00030".
Valid Class Code is populated from the Class Code
in the Insurance Offer ADM, "A00030".
Valid Sub Class Code is populated from the Sub
Class Code in the Insurance Offer ADM, "A00030".
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
P19
*
62
Valid Intended Use Code
Character
3
P19
*
63
Valid Irrigation Practice Code
Character
3
P19
*
64
Valid Cropping Practice Code
Character
3
P19
*
65
Valid Organic Practice Code
Character
3
P19
*
66
Valid Interval Code
Character
3
P19
*
67
Seed Cycle Code
Character
1
P19
*
68
Unit Liability Amount
Numeric
10
Format
Rules
Valid Intended Use Code is populated from the
Intended Use Code in the Insurance Offer ADM,
"A00030".
Valid Irrigation Practice Code is populated from
the Irrigation Practice Code in the Insurance Offer
ADM, "A00030".
Valid Cropping Practice Code is populated from
the cropping Practice Code in the Insurance Offer
ADM, "A00030".
Valid Organic Practice Code is populated from
ADM Insurance Offer Organic Practice Code
Valid Interval Code is populated from the Interval
Code in the Insurance Offer ADM, "A00030".
9999999999
Seed Cycle Code specifies the cycle in which the
crop was planted.
Unit Liability Amount is the sum of the Liability
reported on the unit by Seed Cycle Code.
P19
*
69
Total Expected Revenue Amount
Numeric
10
9999999999
Total Expected Revenue Amount is the sum of all
expected revenues amount (P19A) for a Premium
Based Code ("I" Intended, or "R" Revised).
P19
*
70
Approved Revenue Amount
Numeric
10
9999999999
Approved Revenue Amount will equal lesser of
Total Expected Revenue Amount or (Whole Farm)
Historic Average (Allowable) Revenue Amount.
"*" = Output Only
3/20/2019
Page 12 of 20
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
P19
*
71
Approved Expenses Amount
Numeric
10
9999999999
P19
*
72
Liability Amount
Numeric
10
9999999999
P19
*
73
Total Premium Amount
Numeric
10
9999999999
Field Name
Format
Rules
Approved Expenses Amount will equal average,
indexed, factored down, or factored up expenses.
Liability Amount is the result of Approved
Revenue times Coverage Level Percent.
Liability Amount must be set $1.00 when Liability
Amount is less than $1.00.
Liability Amount cannot exceed $8.5 million
(liability cap) for WFRP.
Total Premium Amount is the premium amount
calculated for the Commodity Code and Insurance
Plan Code.
Total Premium Amount must be rounded to $1.00
when any Total Premium is less than $1.00.
P19
*
74
Subsidy Amount
Numeric
10
9999999999
Subsidy Amount is the dollar amount of the
Subsidy for the WRFP Commodity Code, "0076",
and the Insurance Plan Code, "76". When Subsidy
Amount is less than $1.00, round to $1.00.
When Subsidy Amount is less that $1.00 when
Beginning Farmer and Rancher (BFR) and/or
Native Sod (NS) applies then cup at $0.00.
"*" = Output Only
3/20/2019
Page 13 of 20
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
P19
*
75
Producer Premium Amount
Numeric
10
9999999999
P19
P19
*
*
76
77
Additional Subsidy Amount
State Private Subsidy Amount
Numeric
Numeric
10
10
9999999999
9999999999
P19
*
78
A & O Expense Subsidy Amount
Numeric
13
9999999999.99
P19
P19
*
*
79
80
Total Allowable Revenue Amount
Total Allowable Expenses Amount
Numeric
Numeric
10
10
9999999999
9999999999
P19
*
81
Average Revenue Amount
Numeric
10
9999999999
P19
*
82
Average Expense Amount
Numeric
10
9999999999
P19
*
83
Revenue Index Factor
Numeric
5
9.999
"*" = Output Only
3/20/2019
Page 14 of 20
Rules
Subsidy Amount will be based on Total Premium
Amount and ADM Subsidy Percent, "A00070", for
the Qualifying Commodity Count and Coverage
Level Percent.
Producer Premium Amount equals the Total
Premium Amount minus the Subsidy Amount.
Reserved.
Reserved.
A & O Expense Subsidy Amount must be valid.
Edit with the A&O Expense Subsidy ICE,
"D00097".
Sum of 5 years of allowable revenue.
Sum of 5 years of allowable expenses.
Average (Allowable) Revenue Amount is the result
of Total Allowable Revenue Amount divided by 5.
Average (Allowable) Expense Amount is the result
of Total Allowable Expenses Amount divided by 5.
Revenue Index Factor according to WFRP
Standards Handbook. This will be the factor used
to determine Index Average (Allowable) Revenue
Amount. Default 1.000. If Index Opt Out Flag
equal Yes, "Y", then this field will be the default
1.000.
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
P19
P19
P19
P19
Output
Application Source:
File Group:
*
*
*
*
Field
Number
84
85
86
87
"*" = Output Only
3/20/2019
Field Name
Expense Index Factor
Indexed Average Revenue Amount
Indexed Average Expenses Amount
Expanded Operation Average Revenue
Amount
Numeric
Numeric
Numeric
Numeric
Format
5
10
10
10
9.999
Rules
Expense Index Factor according to WFRP
Standards Handbook. This will be the factor used
to determine Index Average (Allowable) Expenses
Amount. Use Revenue Index Factor if determined
Expense Index Factor exceeds Revenue Index
Factor. Default to 1.000. If Index Opt Out Flag
equal Yes, "Y", then this field will be the default
1.000.
9999999999
Indexed Average (Allowable) Revenue Amount.
The result of Average (Allowable) Revenue
Amount times Revenue Index Factor.
9999999999
Indexed Average (Allowable) Expenses Amount.
The result of Average (Allowable) Expenses
Amount times Expense Index Factor.
9999999999
Expanded Operation Average (Allowable)
Revenue Amount. If Expanded Operation
Adjustment Factor applies then Expanded
Operation Average Revenue cannot exceed the
result of Average (Allowable) Revenue Amount
times 1.35 (MAX).
Page 15 of 20
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
P19
Output
Application Source:
File Group:
*
Field
Number
88
Field Name
Expanded Operation Average Expenses
Amount
Numeric
10
Format
Rules
9999999999
Expanded Operation Average (Allowable)
Expenses Amount. If Expanded Operation
Adjustment Factor applies then Expanded
Operation Average Expenses cannot exceed the
result of Average (Allowable) Expenses Amount
times 1.35 (MAX).
P19
*
89
Historic Average Revenue Amount
Numeric
10
9999999999
(Whole Farm) Historic Average (Allowable)
Revenue Amount. The greater of Average
Revenue Amount, Indexed Average (Allowable)
Revenue Amount, or Expanded Operation
Average (Allowable) Revenue Amount.
P19
*
90
Historic Average Expenses Amount
Numeric
10
9999999999
(Whole Farm) Historic Average (Allowable)
Expenses Amount will be based on corresponding
Historic Average Revenue Amount.
P19
*
91
Total Weighted Farm Rate
Numeric
6
99.999
Total Weighted Farm Rate based on calculation.
See Exhibit P19-1.
999
Total number of unique commodity codes
reported by way of P19A and for Premium Based
Code. Used to determine Minimum Qualifying
Amount (MQA). See Exhibit P14-7.
P19
*
92
"*" = Output Only
3/20/2019
Total Commodity Count
Numeric
3
Page 16 of 20
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
P19
P19
Output
Application Source:
File Group:
*
*
Field
Number
93
94
Field Name
Eligible Commodity Count
Grouped Commodity Count
Numeric
Numeric
Format
3
3
999
Eligible Commodity Count based on Exhibit P14-7,
"WFRP Coverage Level Eligibility" and used in
determination of Diversity Factor. The count of
commodities that equal or exceeded Minimum
Qualifying Amount (MQA) without being grouped.
999
Grouped Commodity Count based on Exhibit P147, "WFRP Coverage Level Eligibility" and used in
determination of Diversity Factor. The count of
commodities determined after being grouped
based on Minimum Qualifying Amount (MQA).
P19
*
95
Qualifying Commodity Count
Numeric
3
999
P19
*
96
Diversity Factor
Numeric
5
9.999
P19
*
97
Premium Rate
Numeric
4
.999
P19
*
98
Native Sod Percent of Revenue
Numeric
5
9.999
P19
*
99
Native Sod Liability Amount
Numeric
10
9999999999
"*" = Output Only
3/20/2019
Page 17 of 20
Rules
Commodity Count based on Exhibit P14-7, "WFRP
Coverage Level Eligibility" and used in
determination of Diversity Factor. This will be
count of Eligible Commodity Count plus Grouped
Commodity Count.
Diversity Factor based on calculation. See Exhibit
P19-1.
Premium Rate based on calculation. See Exhibit
P19-1.
Native Sod Percent of Revenue based on
calculation. See Exhibit P19-1.
Native Sod Liability Amount based on calculation.
See Exhibit P19-1.
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
P19
*
100
Non Native Sod Liability Amount
Numeric
10
9999999999
P19
*
101
Native Sod Premium Liability Amount
Numeric
10
9999999999
P19
*
102
Non Native Sod Premium Liability
Amount
Numeric
10
9999999999
P19
*
103
Native Sod Preliminary Total Premium
Amount
Numeric
10
9999999999
P19
*
104
Non Native Sod Preliminary Total
Premium Amount
Numeric
10
9999999999
P19
*
105
BFR Subsidy Amount
Numeric
10
9999999999
P19
*
106
Native Sod Subsidy Amount
Numeric
10
9999999999
P19
*
107
Remaining Fiscal Year Capacity
Numeric
12
999999999.99
P19
*
108
CC Subsidy Reduction Amount
Numeric
10
9999999999
"*" = Output Only
3/20/2019
Field Name
Format
Page 18 of 20
Rules
Non Native Sod Liability Amount based on
calculation. See Exhibit P19-1.
Native Sod Premium Liability Amount based on
calculation. See Exhibit P19-1.
Non Native Sod Premium Liability Amount based
on calculation. See Exhibit P19-1.
Native Sod Preliminary Total Premium Amount
based on calculation.
See Exhibit P19-1.
Non Native Sod Preliminary Total Premium
Amount based on calculation.
See Exhibit P19-1.
Beginning Farmer Rancher Subsidy Amount. 0.10
(10%) of the Total Premium Amount added to the
base subsidy amount. See Exhibit P19-1.
Native Sod Subsidy Amount is 0.50 (50%) of the
Total Premium Amount subtracted from base
Subsidy Amount. See Exhibit P19-1.
Remaining Fiscal Year Capacity for WFRP with
livestock at time of this premium if data passes
basic validation. Excludes this premium if
rejected.
CC Subsidy Reduction Amount is the amount of
subsidy reduced due to Conservation Compliance.
See Exhibit P19-1.
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
Rules
Numeric
5
99999
Initial Accepted Batch Number is the original
sequence number assigned when this record was
first received at RMA.
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.
111
Batch Received Date
Date/Time
21
CCYYMMDD
hh:mm:ss.fff
*
112
Batch Number
Numeric
5
99999
P19
*
113
Batch Record ID
Numeric
15
P19
*
114
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.
P19
*
109
Initial Accepted Batch Number
P19
*
110
P19
*
P19
"*" = Output Only
3/20/2019
Page 19 of 20
File Type:
Reinsurance Year:
Delimited
2019
Record Name: WFRP Farm Reports
Record Code: P19
Version:
Release Date:
Approved
4/4/2019
Max
Data Type Length
BUS
Key Req?
Record
Number
Output
Application Source:
File Group:
Field
Number
Field Name
Format
Rules
Record Level Rules
1
When the COI Questionnaire Completion Date on
the Insurance Agent, "P55" record is empty, the
associated Acreage, "P11", Inventory Value,
"P13", and WFRP Farm Reports, "P19" records will
be rejected.
2
The WFRP Farm Reports, "P19" record will not be
processed when processing has been suspended
for this record type per RMA directive.
3
The preceding Insurance In Force, "P14" record in
this batch must be accepted for the WFRP Farm
Reports, "P19" record to be accepted.
"*" = Output Only
3/20/2019
Page 20 of 20
| File Type | application/pdf |
| File Title | P19 WFRP Farm Reports Record |
| Subject | PASS Record |
| Author | USDA Risk Management Agency |
| File Modified | 2019-03-20 |
| File Created | 2019-03-20 |