{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data Element Comparison","Add or Remove Program Changes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Element Comparison","index":0,"n_rows":57,"n_cols":8,"rows_kept":57,"cut":false,"hidden":false,"merged":[[35,2,35,3],[24,2,24,3],[56,0,56,7],[54,1,54,2]]}
["REGS","Old Element","New Element","REASON","OLD BURDEN (all respondents)","NEW BURDEN (all respondents)","DIFFERENCE","TYPE OF CHANGE"]
["7 CFR Part 457","P05 - CIMS Request","P05 - CIMS Request Record *                                                        ",null,2000,0,{"$f":"F2-E2","v":-2000},"Adj"]
[null,"P-09 - Fund Designation","P09 - Fund Designation Record (per company)*",null,11000,0,-11000,"Adj"]
[null,"P10 - Policy","P10 - Policy Record (Company Application)",null,{"$f":"83000+99000","v":182000},{"$f":"39472.62+39487.61","v":78960.23000000001},-103039.76999999999,"Adj"]
[null,"P11 - Acreage","P11 - Acreage Record (Company Acreage Report)",null,{"$f":"78000+90000","v":168000},{"$f":"835392.6+556225.02","v":1391617.62},1223617.6200000001,"Adj"]
[null,"P12 - Payment","P12 - Payment Record",null,{"$f":"45000+29000","v":74000},{"$f":"63604.5+63604.5","v":127209},{"$f":"F6-E6","v":53209},"Adj"]
[null,"P13 - Inventory Value","P13 - Inventory Value Record",null,{"$f":"5000+28000","v":33000},{"$f":"20912+1307","v":22219},-10781,"Adj"]
[null,"P14 - Insurance in Force","P14 - Insurance in Force Record *",null,{"$f":"74000+29000","v":103000},0,-103000,"Adj"]
[null,"P15 - Yields","P15 - Yield History Record",null,{"$f":"79000+100000","v":179000},{"$f":"1113856.8+1668675.06","v":2782531.8600000003},2603531.8600000003,"Adj"]
[null,"P17 - Land Identifier",null,"Deleted P17 record because this information is no longer collected by RMA (not a record used in Policy Acceptance and Storage System (PASS))",{"$f":"32000+38000","v":70000},0,-70000,"Adj"]
[null,"P20 - Loss Total","P20 - Loss Total Record *",null,{"$f":"35000+0","v":35000},0,-35000,"Adj"]
[null,"P21 - Loss Line","P21 - Loss Line Record (Company Claim for Indemnity)",null,{"$f":"37000+29000","v":66000},{"$f":"835390.5+834258.05","v":1669648.55},1603648.55,"Adj"]
[null,"P22 - Inventory Loss","P22 - Inventory Loss Record",null,{"$f":"3000+0","v":3000},{"$f":"302.5+302.5","v":605},{"$f":"F13-E13","v":-2395},"Adj"]
[null,"P25 - Settlement/Arbitration",null,"Deleted P25 record because this information is no longer collected by RMA (not a record used in Policy Acceptance and Storage System (PASS))",{"$f":"2000+0","v":2000},0,-2000,"Adj"]
[null,"P27 - Common Land Unit ID ","P27 - Land ID Record",null,{"$f":"5000+9000","v":14000},{"$f":"472809.48","v":472809.48},458809.48,"Adj"]
[null,null,"P48 - Delete Record *","Added P48 when Data Acceptance System (DAS) moved to Policy Acceptance and Storage System (PASS) to allow insurance providers to delete records from RMA's system because they weren't able to in DAS",null,0,0,"Adj"]
[null,"P49 - Delete","P49 - Policy Delete Record",null,{"$f":"19000+0","v":19000},{"$f":"11124.9","v":11124.9},-7875.1,"Adj"]
[null,null,"P51 - Conflict of Interest Policy Reporting Record","Added P51 to implement the guidance in Manager's Bulletin MGR-08-001 http://www.rma.usda.gov/bulletins/managers/2008/mgr-08-001.pdf",null,2503.4,2503.4,"Adj"]
[null,null,"P54 - Agency/Company Employee Data Record *","Added P54 to implement the guidance in Manager's Bulletin MGR-08-001 http://www.rma.usda.gov/bulletins/managers/2008/mgr-08-001.pdf",null,0,0,"Adj"]
[null,"P55 - Agent Data","P55 - Agent Data Record *",null,{"$f":"2000+0","v":2000},0,-2000,"Adj"]
[null,"P56 - Loss Adjuster Data","P56 - Loss Adjuster Data Record *",null,{"$f":"2000+0","v":2000},0,-2000,"Adj"]
[null,"P57 - Quality Control Reporting ","P57 - Quality Control Reporting Record",null,{"$f":"2000+0","v":2000},384,-1616,"Adj"]
[null,null,"P58 - Notice of Loss Reporting Record","Added P58 to allow more reporting time in the event of a disaster as described in the narrative",null,{"$f":"33415.62+50049.32","v":83464.94},83464.94,"Adj"]
[null,"Data elements associated with Subpart U - Ineligibility for Prog. Under FCIA: Separate proposed rule ICR submitted.  This will be deleted upon approval of final rule package.",null,null,null,1448,1448]
[null,null,"Combined the following 6 line items (cells B25-30) into one category."]
[null,"P60 - Ineligible Producer Input","Data elements associated with Subpart U - This will be deleted upon approval of separate final rule package (P60 - Ineligible Producer Input, P60E - Ineligible Producer Error, P61 - Ineligible Producer Output, P65 - CAT Fee Receivable, P70 - Reverse 70 Detail, P71 - Reverse 71 Trailer)","Orignally deleted P60 from this package because this information is associated with the collection of information pursuant to 7 CFR, Part 400, Subpart U and created a new package for the information collection requirements necessary for administering 7 CFR, Part 400, Subpart U.  Because Subpart U would now have its own collection package, the burden associated with Subpart U was removed from related data elements in this collection package before it was submitted to OMB for renewal.  However, the final rule is still being written and until a final rule package is submitted and approved by OMB the removed associated burden this needs to be added back into the renewal submission of this collection.  The burden and data elements associated with Subpart U has now been combined into one line item.",{"$f":"37000+0","v":37000},0,-37000,"Adj"]
[null,"P60E - Ineligible Producer Error",null,"Orignally deleted P60E from this package because this information is associated with the collection of information pursuant to 7 CFR, Part 400, Subpart U and created a new package for the information collection requirements necessary for administering 7 CFR, Part 400, Subpart U.  Because Subpart U would now have its own collection package, the burden associated with Subpart U was removed from related data elements in this collection package before it was submitted to OMB for renewal.  However, the final rule for each is still being written and until a final rule package is submitted and approved by OMB the removed associated burden this needs to be added back into the renewal submission of this collection.  The burden and data elements associated with Subpart U has now been combined into one line item.",{"$f":"11000+0","v":11000},0,-11000,"Adj"]
[null,"P61 - Ineligible Producer Output",null,"Orignally deleted P61 from this package because this information is associated with the collection of information pursuant to 7 CFR, Part 400, Subpart U and created a new package for the information collection requirements necessary for administering 7 CFR, Part 400, Subpart U.  Because Subpart U would now have its own collection package, the burden associated with Subpart U was removed from related data elements in this collection package before it was submitted to OMB for renewal.  However, the final rule for each is still being written and until a final rule package is submitted and approved by OMB the removed associated burden this needs to be added back into the renewal submission of this collection.  The burden and data elements associated with Subpart U has now been combined into one line item.",{"$f":"19000+0","v":19000},0,-19000,"Adj"]
[null,"P65 - CAT Fee Receivable",null,"Orignally deleted P65 from this package because this information is associated with the collection of information pursuant to 7 CFR, Part 400, Subpart U and created a new package for the information collection requirements necessary for administering 7 CFR, Part 400, Subpart U.  Because Subpart U would now have its own collection package, the burden associated with Subpart U was removed from related data elements in this collection package before it was submitted to OMB for renewal.  However, the final rule is still being written and until a final rule package is submitted and approved by OMB the removed associated burden this needs to be added back into the renewal submission of this collection.  The burden and data elements associated with Subpart U has now been combined into one line item.",{"$f":"3000+0","v":3000},0,-3000,"Adj"]
[null,"P70 - Reverse 70 Detail",null,"Orignally deleted P70 from this package because this information is associated with the collection of information pursuant to 7 CFR, Part 400, Subpart U and created a new package for the information collection requirements necessary for administering 7 CFR, Part 400, Subpart U.  Because Subpart U would now have its own collection package, the burden associated with Subpart U was removed from related data elements in this collection package before it was submitted to OMB for renewal.  However, the final rule is still being written and until a final rule package is submitted and approved by OMB the removed associated burden for each of these needs to be added back into the renewal submission of this collection.  The burden and data elements associated with Subpart U has now been combined into one line item listed below",{"$f":"5000+0","v":5000},0,-5000,"Adj"]
[null,"P71 - Reverse 71 Trailer",null,"Orignally deleted P71 from this package because this information is associated with the collection of information pursuant to 7 CFR, Part 400, Subpart U and created a new package for the information collection requirements necessary for administering 7 CFR, Part 400, Subpart U.  Because Subpart U would now have its own collection package, the burden associated with Subpart U was removed from related data elements in this collection package before it was submitted to OMB for renewal.  However, the final rule is still being written and until a final rule package is submitted and approved by OMB the removed associated burden this needs to be added back into the renewal submission of this collection.  The burden and data elements associated with Subpart U has now been combined into one line item.",{"$f":"9000+0","v":9000},0,-9000,"Adj"]
[null,"P81 - Policy Holder Tracking Exp. Inq.","P81 - Policy Holder Tracking Experience Inquiry Record *",null,{"$f":"24000+0","v":24000},0,-24000,"Adj"]
[null,"P123, 151 - AGR/AGR-L",null,"Deleted P123, 151 because this record is specific to only AGR and AGR-Lite.  However, RMA included AGR and AGR-Lite policyholders in the records above because the information RMA collects is accounted for in those records.",{"$f":"5000+27000","v":32000},0,-32000,"Adj"]
[null,"P135-140 - LRP/LGM",null,"Deleted P135-140 because this record is specific to only LRP/LGM.  However, RMA included LRP/LGM policyholders in the records above because the information RMA collects is accounted for in those records.",{"$f":"3000+23000","v":26000},0,-26000,"Adj"]
[null,"P150 - Disbursements",null,"Deleted P150 because this information comes from information already collected in the P20 record. ",{"$f":"32000+0","v":32000},0,-32000,"Adj"]
[null,null,"Combined the following 12 line items (cells B37-48) into one category.",null,0,8250,8250,"Adj"]
[null,"Providing documentation in subsequent years including, but not limited to, acreage measurement service, for incorrect acreage reports.","Additional information provided as needed ",null,12,0,-12]
[null,"Providing documentation for duplicate policies.",null,null,125,0,-125]
[null,"Providing documentation and records of double cropping.",null,null,3066,0,-3066]
[null,"Providing records of 3rd or later crop.",null,null,25,0,-25]
[null,"Requesting an extension in writing when claim cannot be finalized in 60 days.",null,null,208,0,-208]
[null,"Providing records for acreage that is less than a unit.",null,null,250,0,-250]
[null,"Notice of harvested production if appraisal used for claim.",null,null,125,0,-125]
[null,"Obtaining records for transitional acreage.",null,null,450,0,-450]
[null,"1st and 2nd crop APH acres and production.",null,null,250,0,-250]
[null,"Determine good farming practices.",null,null,1000,0,-1000]
[null,"Adjusting inconsistent yields. ",null,null,1000,0,-1000]
[null,"Provide organic records.",null,null,2000,0,-2000]
[null,"Provide copy of malt barley contract.",null,null,250,0,-250]
[null,"Reading insurance documents",null,null,624141,278204,-345937,"Adj"]
[null,null,"Record Retention","Added",null,167078.51999999999,167078.51999999999,"Adj"]
[null,null,"Travel Time","Added",null,864154,864154,"Adj"]
[null,null,"* Crop insurance companies transmittal of data elements to RMA","Added",null,3217.5,{"$f":"F53-E53","v":3217.5},"Adj"]
[null,"Data elements associated with Area Risk Protection Insurance (ARPI) - Separate proposed rule ICR submitted. This will be deleted upon approval of final rule package (P09, P10, P11, P12, P14, P15, P20, P21, P27, P51, P54, P55, P57, P60, P60E, P61, P65, P70, P71, P81)",null,"Area Risk Protection Insurance (ARPI) has a proposed rule collection that was submitted to OMB who in turn filed each with comment and continue.  Because ARPI would now have its own collection package, the burden associated with ARPI was removed from related data elements in this collection package before it was submitted to OMB for renewal.  However, the final rule is still being written and until a final rule package is submitted and approved by OMB the removed associated burden for these needs to be added back into the renewal submission of this collection.   The burden and data elements associated with ARPI has now been combined into one line item.",null,176473,{"$f":"F54-E54","v":176473},"Adj"]
[null,"In previous submission, the total from Producer Data Element & Company Data Element tables 501,000 + 664,000 = 1,165,000.  Figures 6 & 5 were inadvertantly transposed before splitting out and transferring to the main burden spreadsheet as 162,634 + 993,438 = 1,156,072 for Additional hours for crop insurance companies to provide info to RMA; and Providing info for insured crops (forms).",null,null,-8928,0,{"$f":"F55-E55","v":8928},"Adj"]
[null,null,null,"Total Adjustment*",{"$f":"SUM(E2:E55)","v":1788974},{"$f":"SUM(F2:F55)","v":8141903.0000000009},{"$f":"SUM(G2:G55)","v":6352929.0000000009}]
["*FCIC terminated the pilot crop insurance programs for California citrus (dollar plan of insurance), cherries (fixed dollar plan of insurance), and strawberries which reduced the burden by 12,886 hours.  However, the burden has increased by 35,943 hours due to added hours for new pilot and 508(h) crop insurance programs for apiculture; fresh market beans; processing pumpkins; livestock gross margin pilot dairy; Actual Revenue History cherries, citrus, and strawberries; grass seed; and sesame.  These hours were added/removed from the applicable data elements above.\n"]

{"sheet":"Add or Remove Program Changes","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Program/Package Change","Savings/Additional Burden Under Re-evaluated Calculations)"]
["Terminated Programs (CA Citrus, Cherries, Strawberries)",-12886]
["New Pilot and 508(h) Crop Insurance Programs (apiculture; fresh market beans; processing pumpkins; livestock gross margin pilot dairy; Actual Revenue History cherries, citrus, and strawberries; grass seed; and sesame)",35943]
["Removed GRP/GRIP",-176579]
["Removed Subpart U",1448]
["Total",{"$f":"SUM(B2:B5)","v":-152074}]