Document
P26 Production Record
ICR 202608-0563-001 · OMB 0563-0083 · Object 171466900.
Document Viewer [pdf]
Status: Original and derived artifacts are available for this document.
Download: pdf
Loading document viewer…
Document Metadata
| File Type | application/pdf |
|---|---|
| File Title | P26 Production Record |
| Subject | PASS Record |
| Keywords | P26, production, record |
| Author | USDA Risk Management Agency |
| Last Modified By | Acrobat PDFMaker 25 for Excel |
| File Modified | 2025-06-20 |
| File Created | 2025-06-20 |
| Conversion State | complete |
Extracted Text
File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number Field Name Data Type Max Length P26 1 AIP Code Character 2 P26 P26 2 3 Reinsurance Year Record Type Code Numeric Character 4 6 P26 4 AIP Policy Producer Key Character P26 5 AIP Insurance In Force Key P26 6 P26 Format BUS Key Req? Rules Y Y AIP Code must be valid; edit with the AIP ICE, "D00100". Y Y Y Y 15 Y Y Character 15 Y Y AIP Acreage Key Character 15 Y 7 AIP Land Key Character 15 Y P26 8 AIP WFRP Farm Report Key Character 15 Y P26 9 AIP WFRP Farm Report Detail Key Character 15 Y P26 10 AIP Production Key Character 15 Y Current Reinsurance Year. Record Type Code must equal "P26". 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. Required if Insurance Plan Codes "04", "05", "06", "16", "17","35","36". Required if Insurance Plan Codes "01", "02", "03", "47", "90" and Insurability Code is "B" or "C". Required if AIP Land Key is not empty. Must be empty when Insurance Plan Code is "76". AIP Land Key must be unique within the submitted Land "P27" records. Fill when production is reported by CLU, else blank. Must be empty when Insurance Plan Code is "76". AIP Farm Report Key must be unique within the submitted Farm Report, "P19" records. Required if Insurance Plan Code "76". Not applicable for other insurance plans. AIP Farm Report Detail Key must be unique within the submitted Farm Report Detail, "P19A" records. Required if Insurance Plan Code "76". Not applicable for other insurance plans. AIP Production Key must be unique within the parent Insurance In Force, "P14" record. AIP Production Key must be a minimum of 1 character in length and a maximum of 15 characters in length. "*" = Output Only Page 1 of 10 CCYY Y File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number Field Name Data Type Max Length P26 11 AIP Yield Key Character 15 P26 12 Insurability Code Character 1 P26 13 Insured Production Report Signature Date Date 8 Format BUS Key Req? Y CCYYMMDD Rules Required if Insurance Plan Codes "01", "02", "03", "47", "90" and Insurability Code is not "B" or "C". Required if AIP Acreage Key is not empty and corresponding AIP Yield Key exists on P11. Insurability Code must be valid for each delimited value; edit with the Insurability ICE, "D00149". Required if not Insurance Plan Code "76". Must be empty when Insurance Plan Code is "76". Insured Production Report Signature Date is required when the Production Record Type Code is not "L" or "T". Insured Production Report Signature Date must be empty when the Production Record Type Code is "L" or "T". P26 14 Production Record Type Code Character 1 P26 15 Yield Descriptor Code Character 2 "*" = Output Only Page 2 of 10 Insured Production Report Signature Date must be less than or equal to Batch Received Date. Insured Production Report Signature Date is required for Insurance Plan Code "76" (WFRP). Production Record Type Code must be valid; edit with the Production Record Type ICE, "D00150". Required if not Insurance Plan code "76". Must be empty when Insurance Plan Code is "76". Production Record Type Code of "Z" is not allowed. Yield Descriptor code must be valid; edit with the Yield Descriptor ICE, "D00151". Required if Insurance Plan Code is not "76" and Production Record Type Code is not "L" or "T" or "S". Must be empty when Insurance Plan Code is "76". File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number P26 P26 "*" = Output Only 16 17 Field Name Reported Acreage Total Production Amount Data Type Max Length Format Numeric 11 99999999.99 Numeric 13 9999999999.99 Page 3 of 10 BUS Key Req? Rules Reported Acreage must equal the total planted acreage from the Land, "P27" record when the AIP Land Key exists. Required if not Insurance Plan Code "76". Must be empty when Insurance Plan Code is "76". The total Reported Acreage on the P26 for the Reinsurance Year, AIP Code, AIP Policy Producer Key, AIP Insurance In Force Key, AIP Acreage Key must be less than or equal to the Reported Acreage for the same AIP Acreage Key on the P11 excluding prevented plant acreage when AIP Acreage Key is not empty and Sanity Yield Check Flag is empty or "N". The total Reported Acreage on the P26 for the Reinsurance Year, AIP Code, AIP Policy Producer Key, AIP Insurance In Force Key, AIP Yield Key must be less than or equal to the total Reported Acreage for the same AIP Yield Key on the P11 excluding prevented plant acreage when AIP Yield Key is not empty and Sanity Yield Check Flag is empty or "N". If the user has submitted an Sanity Yield Check Flag of "Y" either (1) the total Reported Acreage on the P26 for the Reinsurance Year, AIP Code, AIP Policy Producer Key, AIP Insurance In Force Key, AIP Acreage Key must be greater than the Reported Acreage for the same AIP Acreage Key on the P11 excluding prevented plant acreage when AIP Acreage Key is not empty or (2) the total Reported Acreage on the P26 for the Reinsurance Year, AIP Code, AIP Policy Producer Key, AIP Insurance In Force Key, AIP Yield Key must be greater than the total Reported Acreage for the same AIP Yield Key on the P11 excluding prevented plant acreage when AIP Yield Key is not empty. Total Production after quality adjustment when Insurance Plan Code is not "76" (WFRP). File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number Field Name Data Type Max Length Format BUS Key Req? Rules Total Production Amount is required with the following exceptions: Not required when Insurance Plan Code "04", "05", "06", "16", "17", "35", "36" (ARPI, MP, STAX). Not required when the Production Record Type Code is "L" or "T". Total Production Amount must be empty when the Production Record Type Code is "L" or "T". Total Production Amount must include production from all planted acreage for the insured commodity. Final Production Amount when Insurance Plan Code "76". Total Production Amount/Reported Acreage must be less than the maximum allowable yield for the submitted state, commodity and insurance plan, as defined by the Maximum Yield ICE (D00120) when Sanity Yield Check Flag is empty or Sanity Yield Check Flag is "N" for Insurance Plan Code not equal to "47" (Actual Revenue History). If the Location State Code is "06" and the Commodity Code is "0227", the maximum allowable yield will vary by Insurance Plan Code.|D00120 Total Production Amount/Reported Acreage or Pre Quality Unadjusted Total Production/Reported Acreage must be greater than the maximum allowable yield for the submitted state, commodity and insurance plan, as defined by the Maximum Yield ICE (D00120), if the user has submitted an Sanity Yield Check Flag of "Y" and Insurance Plan Code is not "47" (Actual Revenue History).|D00120 "*" = Output Only Page 4 of 10 File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number Field Name Data Type Max Length Format BUS Key Req? Rules Total Production Amount cannot be greater than 0 if Reported Acreage equals 0. P26 18 Pre Quality Unadjusted Total Production Numeric 13 9999999999.99 Total production prior to quality adjustment. Enter Pre Quality Unadjusted Total Production = Total Production Amount when this value is not available. For sugar beets, this is the early harvest adjusted production. Pre Quality Unadjusted Total Production is Required with the following exceptions: Not required when Insurance Plan Code "76" (WFRP). Not required when the Production Record Type Code is "L" or "T". Pre Quality Unadjusted Total Production must be empty when the Production Record Type Code is "L" or "T". Pre Quality Unadjusted Total Production must be greater than or equal to Total Production Amount when Pre Quality Unadjusted Total Production exists. Pre Quality Unadjusted Total Production/Reported Acreage must be less than the maximum allowable yield for the submitted state, commodity and insurance plan, as defined by the Maximum Yield ICE (D00120) when Sanity Yield Check Flag is empty or Sanity Yield Check Flag is "N" for Insurance Plan Code not equal to "47" (Actual Revenue History). If the Location State Code is "06" and the Commodity Code is "0227", the maximum allowable yield will vary by Insurance Plan Code.|D00120 "*" = Output Only Page 5 of 10 File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number P26 19 Field Name Final Revenue Amount Data Type Numeric Max Length 11 Format 99999999.99 BUS Key Req? Rules Total Production Amount/Reported Acreage or Pre Quality Unadjusted Total Production/Reported Acreage must be greater than the maximum allowable yield for the submitted state, commodity and insurance plan, as defined by the Maximum Yield ICE (D00120), if the user has submitted an Sanity Yield Check Flag of "Y" and Insurance Plan Code is not "47" (Actual Revenue History).|D00120 Pre Quality Unadjusted Total Production cannot be greater than 0 when Reported Acreage equals 0. Final Revenue Amount must equal the Revenue in Dollars and is required for Insurance Plan Codes "47" (Actual Revenue History) and "76" (WFRP) when the Production Record Type Code is not "L" or "T". Final Revenue Amount/Reported Acreage must be less than the maximum allowable yield for the submitted state, commodity and insurance plan, as defined by the Maximum Yield ICE (D00120) for Insurance Plan Codes "47" (Actual Revenue History). If the Location State Code is "06" and the Commodity Code is "0227", the maximum allowable yield will vary by Insurance Plan Code. Final Revenue Amount/Reported Acreage must be greater than the maximum allowable amount for the submitted Location State Code, Commodity Code and Insurance Plan Code, as defined by the Maximum Yield ICE, "D00120", when the user has submitted a Sanity Yield Check Flag equal to Yes, "Y" and Insurance Plan Code is "47" (Actual Revenue History). Final Revenue Amount must be empty when the Production Record Type Code is "L" or "T". "*" = Output Only Page 6 of 10 File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number Field Name Data Type Max Length Format BUS Key Req? Rules Final Revenue Amount cannot be greater than 0 when Reported Acreage equals 0. P26 P26 "*" = Output Only 20 21 Quality Control Production Verified Flag Sanity Yield Check Flag Character Character 1 1 Page 7 of 10 Y Quality Control Production Verified Flag must equal one of the following values: Yes, "Y" or No, "N". Production has been verified by USDA/Approved Insurance Provider. Not required if Production Record Type Code is "L" or "T". For all insurance plans except 47, Sanity Yield Check Flag must equal Yes, "Y" when Total Production Amount/Reported Acreage or Pre Quality Unadjusted Total Production/ Reported Acreage exceeds the MAXIMUM_YLD value in the Maximum_Yield ICE, D000120, and the Total Production Amount/Reported Acreage and Pre Quality Unadjusted Total Production/ Reported Acreage has been reviewed for accuracy, otherwise empty. For all insurance plans except 47, Sanity Yield Check Flag must not equal Yes, "Y" when Total Production Amount/Reported Acreage and Pre Quality Unadjusted Total Production/ Reported Acreage are less than or equal to the MAXIMUM YLD value in the Maximum Yield ICE, D000120. File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number P26 "*" = Output Only 22 Field Name Sanity Acreage Check Flag Data Type Character Max Length 1 Page 8 of 10 Format BUS Key Req? Rules Sanity Acreage Check Flag must equal Yes, "Y" when either (1) the total Reported Acreage on the P26 for the Reinsurance Year, AIP Code, AIP Policy Producer Key, AIP Insurance In Force Key, AIP Acreage Key is greater than the Reported Acreage for the same AIP Acreage Key on the P11 excluding prevented plant acreage when AIP Acreage Key is not empty and the Reported Acreage has been reviewed for accuracy or (2) when the total Reported Acreage on the P26 for the Reinsurance Year, AIP Code, AIP Policy Producer Key, AIP Insurance In Force Key, AIP Yield Key is greater than the total Reported Acreage for the same AIP Yield Key on the P11 excluding prevented plant acreage when AIP Yield Key is not empty and the Reported Acreage has been reviewed for accuracy, otherwise empty. File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number P26 Field Name Data Type Max Length Format 23 Conversion Factor Numeric 6 9.9999 99999 P26 * 24 Initial Accepted Batch Number Numeric 5 P26 * 25 Initial Accepted Date Date/Time 21 P26 * 26 Batch Received Date Date/Time 21 P26 * 27 Batch Number Numeric 5 P26 * 28 Batch Record ID Numeric 15 "*" = Output Only CCYYMMDD hh:mm:ss.fff CCYYMMDD hh:mm:ss.fff Page 9 of 10 99999 BUS Key Req? Rules Sanity Acreage Check Flag must not equal Yes, "Y" when (1) the total Reported Acreage on the P26 for the Reinsurance Year, AIP Code, AIP Policy Producer Key, AIP Insurance In Force Key, AIP Acreage Key is less than or equal to than the Reported Acreage for the same AIP Acreage Key on the P11 excluding prevented plant acreage when AIP Acreage Key is not empty and (2) the total Reported Acreage on the P26 for the Reinsurance Year, AIP Code, AIP Policy Producer Key, AIP Insurance In Force Key, AIP Yield Key is less than or equal to than the total Reported Acreage for the same AIP Yield Key on the P11 excluding prevented plant acreage when AIP Yield Key is not empty. Conversion Factor is required when associated P11 has field 'Upland Insured as ELS Cotton' = 'Y' and Non Premium Acreage Code is NULL and Production Record type is OTHER than 'T' or 'Z'. Conversion Factor must be empty commodity is other than Cotton Ex Long Staple (0022). Initial Accepted Batch Number is the original sequence number assigned when this record was first received at RMA. Initial Accepted Date is the original date assigned when this record was first received at RMA. 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. File Type: Delimited Reinsurance Year: 2026 Version: Approved Release Date: 7/1/2025 Record Number Output Application Source: File Group: Record Name: Production Record Code: P26 Field Number P26 * 29 Field Name Process Result Code Data Type Max Length Character 1 Record Level Rules BUS Key Req? Rules Process Result Code equals the final result code as determined by PASS processing, refer to the Process Result ICE , "D00002". Record will not be accepted when processing has been suspended for this record type per RMA directive. A Production, "P26" record can only be submitted for an Insurance In Force, "P14" record for Insurance Plan Codes "01", "02", "03", "04", "05", "06", "16", "17", "35", "36", "47", "90", or "76". Insurance plan codes "16", "17", "35", "36" must be standalone plans. Record should not be sent when associated P11 record Non Premium Acreage Code = 'V'. 1 2 3 "*" = Output Only Format Page 10 of 10