Skip to content

Instantly share code, notes, and snippets.

/gist:42a6354ed49af4f342e0 Secret
Created Nov 1, 2014

Embed
What would you like to do?
Learn more about clone URLs
Download ZIP
Raw
gistfile1.js
{
"id": "1",
"app_date": "01/01/2014",
"due_date": "12/15/2014",
"loan_days": 348,
"crop_year": "2015",
"season": "S",
"total_acres": 927.7,
"has_distributor": true,
"crops": [
{
"id": "1",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "1",
"name": "corn",
"uom": "bu",
"acres": "347.4",
"is_active": "1",
"markettowhom": "CropsRUs",
"prod_price": "4.2",
"prod_yield": "152.3",
"prod_share": "84.4",
"mill_share": "0",
"ins_share": "0",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"harvest": "0",
"rebates": "0",
"claims": "0",
"fsa_payment": "0",
"percent_irrigated": "90.5",
"break_even": "102.8",
"p1_yield": "151",
"p2_yield": "176",
"p3_yield": "130",
"p4_yield": "121",
"p5_yield": "153.7",
"p6_yield": "124.5",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "2",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "2",
"name": "soybeans",
"uom": "bu",
"acres": "580.3",
"is_active": "1",
"markettowhom": "CropsRUs",
"prod_price": "10",
"prod_yield": "36.7",
"prod_share": "80.69",
"mill_share": "0",
"ins_share": "0",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"harvest": "0",
"rebates": "0",
"claims": "0",
"fsa_payment": "0",
"percent_irrigated": "92.3",
"break_even": "26.1",
"p1_yield": "31",
"p2_yield": "36",
"p3_yield": "43",
"p4_yield": "21",
"p5_yield": "26",
"p6_yield": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "3",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "3",
"name": "sorghum",
"uom": "bu",
"acres": "0",
"is_active": "0",
"markettowhom": null,
"prod_price": "0",
"prod_yield": "0",
"prod_share": "0",
"mill_share": "0",
"ins_share": "0",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"harvest": "0",
"rebates": "0",
"claims": "0",
"fsa_payment": "0",
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "4",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "4",
"name": "wheat",
"uom": "bu",
"acres": "0",
"is_active": "0",
"markettowhom": null,
"prod_price": "0",
"prod_yield": "0",
"prod_share": "0",
"mill_share": "0",
"ins_share": "0",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"harvest": "0",
"rebates": "0",
"claims": "0",
"fsa_payment": "0",
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "5",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "5",
"name": "cotton",
"uom": "bu",
"acres": "0",
"is_active": "0",
"markettowhom": null,
"prod_price": "0",
"prod_yield": "0",
"prod_share": "0",
"mill_share": "0",
"ins_share": "0",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"harvest": "0",
"rebates": "0",
"claims": "0",
"fsa_payment": "0",
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "6",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "6",
"name": "rice",
"uom": "bu",
"acres": "0",
"is_active": "0",
"markettowhom": null,
"prod_price": "0",
"prod_yield": "0",
"prod_share": "0",
"mill_share": "0",
"ins_share": "0",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"harvest": "0",
"rebates": "0",
"claims": "0",
"fsa_payment": "0",
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "7",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "7",
"name": "peanuts",
"uom": "bu",
"acres": "0",
"is_active": "0",
"markettowhom": null,
"prod_price": "0",
"prod_yield": "0",
"prod_share": "0",
"mill_share": "0",
"ins_share": "0",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"harvest": "0",
"rebates": "0",
"claims": "0",
"fsa_payment": "0",
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "8",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "8",
"name": "sugarcane",
"uom": "bu",
"acres": "0",
"is_active": "0",
"markettowhom": null,
"prod_price": "0",
"prod_yield": "0",
"prod_share": "0",
"mill_share": "0",
"ins_share": "0",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"harvest": "0",
"rebates": "0",
"claims": "0",
"fsa_payment": "0",
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
}
],
"cropdetails": [
{
"id": "1",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "1",
"is_active": "1",
"total_acres": "347.4",
"irr": "0",
"ni": "1",
"faci": "0",
"facni": "1",
"towhom_market": "CropsRUs",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"rebates": "0",
"harvest": "0",
"prod_yield": "152.3",
"prod_price": "4.2",
"prod_share": "84.4",
"disc_prod_percent": "50",
"disc_ins_percent": "20",
"break_even": "102.8",
"p1_yield": "151",
"p2_yield": "176",
"p3_yield": "130",
"p4_yield": "121",
"p5_yield": "157.3",
"p6_yield": "124.5",
"percent_irrigated": "90.5",
"crop": {
"id": "1",
"crop": "corn",
"measurement": "bu",
"rebate_measurement": "bu"
}
},
{
"id": "2",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "2",
"is_active": "1",
"total_acres": "580.3",
"irr": "0",
"ni": "1",
"faci": "1",
"facni": "0",
"towhom_market": "CropsRUs",
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"rebates": "0",
"harvest": "0",
"prod_yield": "36.7",
"prod_price": "10",
"prod_share": "80.69",
"disc_prod_percent": "50",
"disc_ins_percent": "20",
"break_even": "26.1",
"p1_yield": "31",
"p2_yield": "36",
"p3_yield": "43",
"p4_yield": "21",
"p5_yield": "26",
"p6_yield": null,
"percent_irrigated": "92.3",
"crop": {
"id": "2",
"crop": "soybeans",
"measurement": "bu",
"rebate_measurement": "bu"
}
},
{
"id": "3",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "3",
"is_active": "0",
"total_acres": "0",
"irr": "0",
"ni": "0",
"faci": "0",
"facni": "0",
"towhom_market": null,
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"rebates": "0",
"harvest": "0",
"prod_yield": "0",
"prod_price": "0",
"prod_share": "0",
"disc_prod_percent": "50",
"disc_ins_percent": "20",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"percent_irrigated": "0",
"crop": {
"id": "3",
"crop": "sorghum",
"measurement": "bu",
"rebate_measurement": "bu"
}
},
{
"id": "4",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "4",
"is_active": "0",
"total_acres": "0",
"irr": "0",
"ni": "0",
"faci": "0",
"facni": "0",
"towhom_market": null,
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"rebates": "0",
"harvest": "0",
"prod_yield": "0",
"prod_price": "0",
"prod_share": "0",
"disc_prod_percent": "50",
"disc_ins_percent": "20",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"percent_irrigated": "0",
"crop": {
"id": "4",
"crop": "wheat",
"measurement": "bu",
"rebate_measurement": "bu"
}
},
{
"id": "5",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "5",
"is_active": "0",
"total_acres": "0",
"irr": "0",
"ni": "0",
"faci": "0",
"facni": "0",
"towhom_market": null,
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"rebates": "0",
"harvest": "0",
"prod_yield": "0",
"prod_price": "0",
"prod_share": "0",
"disc_prod_percent": "50",
"disc_ins_percent": "20",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"percent_irrigated": "0",
"crop": {
"id": "5",
"crop": "cotton",
"measurement": "lb",
"rebate_measurement": "lb"
}
},
{
"id": "6",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "6",
"is_active": "0",
"total_acres": "0",
"irr": "0",
"ni": "0",
"faci": "0",
"facni": "0",
"towhom_market": null,
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"rebates": "0",
"harvest": "0",
"prod_yield": "0",
"prod_price": "0",
"prod_share": "0",
"disc_prod_percent": "50",
"disc_ins_percent": "20",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"percent_irrigated": "0",
"crop": {
"id": "6",
"crop": "rice",
"measurement": "lb",
"rebate_measurement": "bu"
}
},
{
"id": "7",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "7",
"is_active": "0",
"total_acres": "0",
"irr": "0",
"ni": "0",
"faci": "0",
"facni": "0",
"towhom_market": null,
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"rebates": "0",
"harvest": "0",
"prod_yield": "0",
"prod_price": "0",
"prod_share": "0",
"disc_prod_percent": "50",
"disc_ins_percent": "20",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"percent_irrigated": "0",
"crop": {
"id": "7",
"crop": "peanuts",
"measurement": "bu",
"rebate_measurement": "bu"
}
},
{
"id": "8",
"crop_year": "2015",
"loan_id": "1",
"crop_id": "8",
"is_active": "0",
"total_acres": "0",
"irr": "0",
"ni": "0",
"faci": "0",
"facni": "0",
"towhom_market": null,
"bkqty": "0",
"bkprice": "0",
"gin_mill": null,
"rebates": "0",
"harvest": "0",
"prod_yield": "0",
"prod_price": "0",
"prod_share": "0",
"disc_prod_percent": "50",
"disc_ins_percent": "20",
"break_even": "0",
"p1_yield": null,
"p2_yield": null,
"p3_yield": null,
"p4_yield": null,
"p5_yield": null,
"p6_yield": null,
"percent_irrigated": "0",
"crop": {
"id": "8",
"crop": "sugar cane",
"measurement": "ton",
"rebate_measurement": "ton"
}
}
],
"entity": {
"id": "5",
"type_id": "5",
"type": "Spousal",
"applicant_id": "2",
"applicant": "Glass Towers",
"applicant_ssn": "222222222",
"applicant_email": "tony@farm.org",
"applicant_dob": {
"date": "01/07/1987",
"timezone_type": 3,
"timezone": "UTC"
},
"applicant_address": "321 Farmers Dell",
"applicant_city": "Monroe",
"applicant_state_id": "19",
"applicant_state_abr": "LA",
"applicant_state": "Louisiana",
"applicant_zip": "99999",
"applicant_phone": "7777777777",
"applicant_spouse": "Stark, Pepper",
"applicant_spouse_ssn": "333333333",
"applicant_spouse_phone": "7777777878",
"applicant_spouse_email": "pepper@farm.org",
"principals": []
},
"farms": [
{
"id": "1",
"loan_id": "1",
"county_id": "1317",
"fsn": "409",
"owner": "B Goliher",
"share_rent": "0",
"cash_rent": "0",
"waived": "0",
"when_due": "",
"acres": "28",
"irr": "0",
"ni": "1",
"facirr": "0",
"facni": "1",
"fsa_paid": "0",
"percent_irrigated": "0",
"county": {
"id": "1317",
"state_id": "19",
"location_id": "4",
"county": "Richland",
"label": "Richland ( LA )",
"locale": "LA | Richland",
"price_corn_irr": "4.2",
"price_corn_ni": "4.2",
"insured_price_corn_irr": "4.25",
"insured_price_corn_ni": "4.25",
"yield_corn_irr": "139",
"yield_corn_ni": "94",
"price_soybeans_irr": "10",
"price_soybeans_ni": "10",
"price_soybeans_facirr": "10",
"price_soybeans_facni": "10",
"insured_price_soybeans_irr": "11.25",
"insured_price_soybeans_ni": "11.25",
"insured_price_soybeans_facirr": "11.25",
"insured_price_soybeans_facni": "11.25",
"yield_soybeans_irr": "31",
"yield_soybeans_ni": "25",
"yield_soybeans_facirr": "23",
"yield_soybeans_facni": "18",
"price_sorghum_irr": "4",
"price_sorghum_ni": "4",
"insured_price_sorghum_irr": "4",
"insured_price_sorghum_ni": "4",
"yield_sorghum_irr": "55",
"yield_sorghum_ni": "55",
"price_wheat_irr": "5.75",
"price_wheat_ni": "5.75",
"insured_price_wheat_irr": "6.64",
"insured_price_wheat_ni": "6.64",
"yield_wheat_irr": "46",
"yield_wheat_ni": "46",
"price_cotton_irr": "90",
"price_cotton_ni": "90",
"insured_price_cotton_irr": "93",
"insured_price_cotton_ni": "93",
"yield_cotton_irr": "649",
"yield_cotton_ni": "467",
"price_rice_irr": "0.135",
"price_rice_ni": "0.135",
"insured_price_rice_irr": "0.14",
"insured_price_rice_ni": "0.14",
"yield_rice_irr": "5820",
"yield_rice_ni": "5820",
"price_peanuts_irr": "2.3",
"price_peanuts_ni": "2.3",
"insured_price_peanuts_irr": "2.8",
"insured_price_peanuts_ni": "2.8",
"yield_peanuts_irr": "3000",
"yield_peanuts_ni": "3000",
"price_sugarcane_irr": "0.28",
"price_sugarcane_ni": "0.28",
"insured_price_sugarcane_irr": "0.16",
"insured_price_sugarcane_ni": "0.16",
"yield_sugarcane_irr": "5133",
"yield_sugarcane_ni": "5133"
}
},
{
"id": "2",
"loan_id": "1",
"county_id": "1317",
"fsn": "560",
"owner": "N Gohlier",
"share_rent": "0",
"cash_rent": "0",
"waived": "0",
"when_due": "",
"acres": "20",
"irr": "0",
"ni": "0",
"facirr": "0",
"facni": "1",
"fsa_paid": "0",
"percent_irrigated": "0",
"county": {
"id": "1317",
"state_id": "19",
"location_id": "4",
"county": "Richland",
"label": "Richland ( LA )",
"locale": "LA | Richland",
"price_corn_irr": "4.2",
"price_corn_ni": "4.2",
"insured_price_corn_irr": "4.25",
"insured_price_corn_ni": "4.25",
"yield_corn_irr": "139",
"yield_corn_ni": "94",
"price_soybeans_irr": "10",
"price_soybeans_ni": "10",
"price_soybeans_facirr": "10",
"price_soybeans_facni": "10",
"insured_price_soybeans_irr": "11.25",
"insured_price_soybeans_ni": "11.25",
"insured_price_soybeans_facirr": "11.25",
"insured_price_soybeans_facni": "11.25",
"yield_soybeans_irr": "31",
"yield_soybeans_ni": "25",
"yield_soybeans_facirr": "23",
"yield_soybeans_facni": "18",
"price_sorghum_irr": "4",
"price_sorghum_ni": "4",
"insured_price_sorghum_irr": "4",
"insured_price_sorghum_ni": "4",
"yield_sorghum_irr": "55",
"yield_sorghum_ni": "55",
"price_wheat_irr": "5.75",
"price_wheat_ni": "5.75",
"insured_price_wheat_irr": "6.64",
"insured_price_wheat_ni": "6.64",
"yield_wheat_irr": "46",
"yield_wheat_ni": "46",
"price_cotton_irr": "90",
"price_cotton_ni": "90",
"insured_price_cotton_irr": "93",
"insured_price_cotton_ni": "93",
"yield_cotton_irr": "649",
"yield_cotton_ni": "467",
"price_rice_irr": "0.135",
"price_rice_ni": "0.135",
"insured_price_rice_irr": "0.14",
"insured_price_rice_ni": "0.14",
"yield_rice_irr": "5820",
"yield_rice_ni": "5820",
"price_peanuts_irr": "2.3",
"price_peanuts_ni": "2.3",
"insured_price_peanuts_irr": "2.8",
"insured_price_peanuts_ni": "2.8",
"yield_peanuts_irr": "3000",
"yield_peanuts_ni": "3000",
"price_sugarcane_irr": "0.28",
"price_sugarcane_ni": "0.28",
"insured_price_sugarcane_irr": "0.16",
"insured_price_sugarcane_ni": "0.16",
"yield_sugarcane_irr": "5133",
"yield_sugarcane_ni": "5133"
}
},
{
"id": "3",
"loan_id": "1",
"county_id": "1317",
"fsn": "568",
"owner": "Lee",
"share_rent": "20",
"cash_rent": "0",
"waived": "0",
"when_due": "",
"acres": "20",
"irr": "0",
"ni": "1",
"facirr": "0",
"facni": "1",
"fsa_paid": "0",
"percent_irrigated": "0",
"county": {
"id": "1317",
"state_id": "19",
"location_id": "4",
"county": "Richland",
"label": "Richland ( LA )",
"locale": "LA | Richland",
"price_corn_irr": "4.2",
"price_corn_ni": "4.2",
"insured_price_corn_irr": "4.25",
"insured_price_corn_ni": "4.25",
"yield_corn_irr": "139",
"yield_corn_ni": "94",
"price_soybeans_irr": "10",
"price_soybeans_ni": "10",
"price_soybeans_facirr": "10",
"price_soybeans_facni": "10",
"insured_price_soybeans_irr": "11.25",
"insured_price_soybeans_ni": "11.25",
"insured_price_soybeans_facirr": "11.25",
"insured_price_soybeans_facni": "11.25",
"yield_soybeans_irr": "31",
"yield_soybeans_ni": "25",
"yield_soybeans_facirr": "23",
"yield_soybeans_facni": "18",
"price_sorghum_irr": "4",
"price_sorghum_ni": "4",
"insured_price_sorghum_irr": "4",
"insured_price_sorghum_ni": "4",
"yield_sorghum_irr": "55",
"yield_sorghum_ni": "55",
"price_wheat_irr": "5.75",
"price_wheat_ni": "5.75",
"insured_price_wheat_irr": "6.64",
"insured_price_wheat_ni": "6.64",
"yield_wheat_irr": "46",
"yield_wheat_ni": "46",
"price_cotton_irr": "90",
"price_cotton_ni": "90",
"insured_price_cotton_irr": "93",
"insured_price_cotton_ni": "93",
"yield_cotton_irr": "649",
"yield_cotton_ni": "467",
"price_rice_irr": "0.135",
"price_rice_ni": "0.135",
"insured_price_rice_irr": "0.14",
"insured_price_rice_ni": "0.14",
"yield_rice_irr": "5820",
"yield_rice_ni": "5820",
"price_peanuts_irr": "2.3",
"price_peanuts_ni": "2.3",
"insured_price_peanuts_irr": "2.8",
"insured_price_peanuts_ni": "2.8",
"yield_peanuts_irr": "3000",
"yield_peanuts_ni": "3000",
"price_sugarcane_irr": "0.28",
"price_sugarcane_ni": "0.28",
"insured_price_sugarcane_irr": "0.16",
"insured_price_sugarcane_ni": "0.16",
"yield_sugarcane_irr": "5133",
"yield_sugarcane_ni": "5133"
}
},
{
"id": "4",
"loan_id": "1",
"county_id": "1317",
"fsn": "2088",
"owner": "Cobb",
"share_rent": "20",
"cash_rent": "0",
"waived": "0",
"when_due": "",
"acres": "324",
"irr": "1",
"ni": "0",
"facirr": "0",
"facni": "1",
"fsa_paid": "0",
"percent_irrigated": "20",
"county": {
"id": "1317",
"state_id": "19",
"location_id": "4",
"county": "Richland",
"label": "Richland ( LA )",
"locale": "LA | Richland",
"price_corn_irr": "4.2",
"price_corn_ni": "4.2",
"insured_price_corn_irr": "4.25",
"insured_price_corn_ni": "4.25",
"yield_corn_irr": "139",
"yield_corn_ni": "94",
"price_soybeans_irr": "10",
"price_soybeans_ni": "10",
"price_soybeans_facirr": "10",
"price_soybeans_facni": "10",
"insured_price_soybeans_irr": "11.25",
"insured_price_soybeans_ni": "11.25",
"insured_price_soybeans_facirr": "11.25",
"insured_price_soybeans_facni": "11.25",
"yield_soybeans_irr": "31",
"yield_soybeans_ni": "25",
"yield_soybeans_facirr": "23",
"yield_soybeans_facni": "18",
"price_sorghum_irr": "4",
"price_sorghum_ni": "4",
"insured_price_sorghum_irr": "4",
"insured_price_sorghum_ni": "4",
"yield_sorghum_irr": "55",
"yield_sorghum_ni": "55",
"price_wheat_irr": "5.75",
"price_wheat_ni": "5.75",
"insured_price_wheat_irr": "6.64",
"insured_price_wheat_ni": "6.64",
"yield_wheat_irr": "46",
"yield_wheat_ni": "46",
"price_cotton_irr": "90",
"price_cotton_ni": "90",
"insured_price_cotton_irr": "93",
"insured_price_cotton_ni": "93",
"yield_cotton_irr": "649",
"yield_cotton_ni": "467",
"price_rice_irr": "0.135",
"price_rice_ni": "0.135",
"insured_price_rice_irr": "0.14",
"insured_price_rice_ni": "0.14",
"yield_rice_irr": "5820",
"yield_rice_ni": "5820",
"price_peanuts_irr": "2.3",
"price_peanuts_ni": "2.3",
"insured_price_peanuts_irr": "2.8",
"insured_price_peanuts_ni": "2.8",
"yield_peanuts_irr": "3000",
"yield_peanuts_ni": "3000",
"price_sugarcane_irr": "0.28",
"price_sugarcane_ni": "0.28",
"insured_price_sugarcane_irr": "0.16",
"insured_price_sugarcane_ni": "0.16",
"yield_sugarcane_irr": "5133",
"yield_sugarcane_ni": "5133"
}
},
{
"id": "5",
"loan_id": "1",
"county_id": "1337",
"fsn": "3097",
"owner": "Vallery",
"share_rent": "20",
"cash_rent": "0",
"waived": "0",
"when_due": "",
"acres": "22.3",
"irr": "1",
"ni": "0",
"facirr": "1",
"facni": "0",
"fsa_paid": "0",
"percent_irrigated": "100",
"county": {
"id": "1337",
"state_id": "19",
"location_id": "4",
"county": "West Carroll",
"label": "West Carroll ( LA )",
"locale": "LA | West Carroll",
"price_corn_irr": "4.2",
"price_corn_ni": "4.2",
"insured_price_corn_irr": "4.25",
"insured_price_corn_ni": "4.25",
"yield_corn_irr": "139",
"yield_corn_ni": "94",
"price_soybeans_irr": "10",
"price_soybeans_ni": "10",
"price_soybeans_facirr": "10",
"price_soybeans_facni": "10",
"insured_price_soybeans_irr": "11.25",
"insured_price_soybeans_ni": "11.25",
"insured_price_soybeans_facirr": "11.25",
"insured_price_soybeans_facni": "11.25",
"yield_soybeans_irr": "31",
"yield_soybeans_ni": "25",
"yield_soybeans_facirr": "23",
"yield_soybeans_facni": "18",
"price_sorghum_irr": "4",
"price_sorghum_ni": "4",
"insured_price_sorghum_irr": "4",
"insured_price_sorghum_ni": "4",
"yield_sorghum_irr": "55",
"yield_sorghum_ni": "55",
"price_wheat_irr": "5.75",
"price_wheat_ni": "5.75",
"insured_price_wheat_irr": "6.64",
"insured_price_wheat_ni": "6.64",
"yield_wheat_irr": "46",
"yield_wheat_ni": "46",
"price_cotton_irr": "90",
"price_cotton_ni": "90",
"insured_price_cotton_irr": "93",
"insured_price_cotton_ni": "93",
"yield_cotton_irr": "649",
"yield_cotton_ni": "467",
"price_rice_irr": "0.135",
"price_rice_ni": "0.135",
"insured_price_rice_irr": "0.14",
"insured_price_rice_ni": "0.14",
"yield_rice_irr": "5820",
"yield_rice_ni": "5820",
"price_peanuts_irr": "2.3",
"price_peanuts_ni": "2.3",
"insured_price_peanuts_irr": "2.8",
"insured_price_peanuts_ni": "2.8",
"yield_peanuts_irr": "3000",
"yield_peanuts_ni": "3000",
"price_sugarcane_irr": "0.28",
"price_sugarcane_ni": "0.28",
"insured_price_sugarcane_irr": "0.16",
"insured_price_sugarcane_ni": "0.16",
"yield_sugarcane_irr": "5133",
"yield_sugarcane_ni": "5133"
}
},
{
"id": "6",
"loan_id": "1",
"county_id": "1337",
"fsn": "3098",
"owner": "B Gwin",
"share_rent": "0",
"cash_rent": "0",
"waived": "0",
"when_due": "",
"acres": "48.4",
"irr": "1",
"ni": "0",
"facirr": "0",
"facni": "1",
"fsa_paid": "0",
"percent_irrigated": "50",
"county": {
"id": "1337",
"state_id": "19",
"location_id": "4",
"county": "West Carroll",
"label": "West Carroll ( LA )",
"locale": "LA | West Carroll",
"price_corn_irr": "4.2",
"price_corn_ni": "4.2",
"insured_price_corn_irr": "4.25",
"insured_price_corn_ni": "4.25",
"yield_corn_irr": "139",
"yield_corn_ni": "94",
"price_soybeans_irr": "10",
"price_soybeans_ni": "10",
"price_soybeans_facirr": "10",
"price_soybeans_facni": "10",
"insured_price_soybeans_irr": "11.25",
"insured_price_soybeans_ni": "11.25",
"insured_price_soybeans_facirr": "11.25",
"insured_price_soybeans_facni": "11.25",
"yield_soybeans_irr": "31",
"yield_soybeans_ni": "25",
"yield_soybeans_facirr": "23",
"yield_soybeans_facni": "18",
"price_sorghum_irr": "4",
"price_sorghum_ni": "4",
"insured_price_sorghum_irr": "4",
"insured_price_sorghum_ni": "4",
"yield_sorghum_irr": "55",
"yield_sorghum_ni": "55",
"price_wheat_irr": "5.75",
"price_wheat_ni": "5.75",
"insured_price_wheat_irr": "6.64",
"insured_price_wheat_ni": "6.64",
"yield_wheat_irr": "46",
"yield_wheat_ni": "46",
"price_cotton_irr": "90",
"price_cotton_ni": "90",
"insured_price_cotton_irr": "93",
"insured_price_cotton_ni": "93",
"yield_cotton_irr": "649",
"yield_cotton_ni": "467",
"price_rice_irr": "0.135",
"price_rice_ni": "0.135",
"insured_price_rice_irr": "0.14",
"insured_price_rice_ni": "0.14",
"yield_rice_irr": "5820",
"yield_rice_ni": "5820",
"price_peanuts_irr": "2.3",
"price_peanuts_ni": "2.3",
"insured_price_peanuts_irr": "2.8",
"insured_price_peanuts_ni": "2.8",
"yield_peanuts_irr": "3000",
"yield_peanuts_ni": "3000",
"price_sugarcane_irr": "0.28",
"price_sugarcane_ni": "0.28",
"insured_price_sugarcane_irr": "0.16",
"insured_price_sugarcane_ni": "0.16",
"yield_sugarcane_irr": "5133",
"yield_sugarcane_ni": "5133"
}
},
{
"id": "7",
"loan_id": "1",
"county_id": "1337",
"fsn": "4719",
"owner": "D Gwin",
"share_rent": "0",
"cash_rent": "0",
"waived": "0",
"when_due": "",
"acres": "465",
"irr": "1",
"ni": "0",
"facirr": "0",
"facni": "1",
"fsa_paid": "0",
"percent_irrigated": "20",
"county": {
"id": "1337",
"state_id": "19",
"location_id": "4",
"county": "West Carroll",
"label": "West Carroll ( LA )",
"locale": "LA | West Carroll",
"price_corn_irr": "4.2",
"price_corn_ni": "4.2",
"insured_price_corn_irr": "4.25",
"insured_price_corn_ni": "4.25",
"yield_corn_irr": "139",
"yield_corn_ni": "94",
"price_soybeans_irr": "10",
"price_soybeans_ni": "10",
"price_soybeans_facirr": "10",
"price_soybeans_facni": "10",
"insured_price_soybeans_irr": "11.25",
"insured_price_soybeans_ni": "11.25",
"insured_price_soybeans_facirr": "11.25",
"insured_price_soybeans_facni": "11.25",
"yield_soybeans_irr": "31",
"yield_soybeans_ni": "25",
"yield_soybeans_facirr": "23",
"yield_soybeans_facni": "18",
"price_sorghum_irr": "4",
"price_sorghum_ni": "4",
"insured_price_sorghum_irr": "4",
"insured_price_sorghum_ni": "4",
"yield_sorghum_irr": "55",
"yield_sorghum_ni": "55",
"price_wheat_irr": "5.75",
"price_wheat_ni": "5.75",
"insured_price_wheat_irr": "6.64",
"insured_price_wheat_ni": "6.64",
"yield_wheat_irr": "46",
"yield_wheat_ni": "46",
"price_cotton_irr": "90",
"price_cotton_ni": "90",
"insured_price_cotton_irr": "93",
"insured_price_cotton_ni": "93",
"yield_cotton_irr": "649",
"yield_cotton_ni": "467",
"price_rice_irr": "0.135",
"price_rice_ni": "0.135",
"insured_price_rice_irr": "0.14",
"insured_price_rice_ni": "0.14",
"yield_rice_irr": "5820",
"yield_rice_ni": "5820",
"price_peanuts_irr": "2.3",
"price_peanuts_ni": "2.3",
"insured_price_peanuts_irr": "2.8",
"insured_price_peanuts_ni": "2.8",
"yield_peanuts_irr": "3000",
"yield_peanuts_ni": "3000",
"price_sugarcane_irr": "0.28",
"price_sugarcane_ni": "0.28",
"insured_price_sugarcane_irr": "0.16",
"insured_price_sugarcane_ni": "0.16",
"yield_sugarcane_irr": "5133",
"yield_sugarcane_ni": "5133"
}
}
],
"farmer": {
"farmer_id": "1",
"farmer": "Stark, Tony",
"ssn": "123456789",
"address": "1 Stark Towers",
"city": "Delhi",
"state_id": "19",
"state": "Louisiana",
"state_abr": "LA",
"zip": "71232",
"email": "ironman@marvel.com",
"phone": "9995550001",
"dob": "07/15/1960196019601960",
"age": 54,
"farm_exp": "36"
},
"financials": {
"total_acres": 927.7,
"guaranty": 259465.97,
"prod": 359237.87,
"adj_prod": 359237.87,
"disc_prod": 179618.94,
"disc_adj_prod": 179618.94,
"ins_disc_prod": 81034.82,
"disc_ins": 64827.85,
"commit_arm": 114706.3,
"commit_dist": 109218.25,
"commit_other": 87223.42,
"commit_total": 311147.97,
"fee_processing": 1,
"proc_fee": 2326.11,
"proc_fee_arm_only": 1233.93,
"fee_processing_onTotal": true,
"fee_service": 1.5,
"srvc_fee": 3489.16,
"srvc_fee_arm_only": 1850.89,
"fee_service_onTotal": true,
"total_fsa_payment": 0,
"total_claims": 0,
"principal_arm": 129207.88,
"principal_dist": 109218.25,
"principal_other": 87223.42,
"principal": 311147.97,
"int_percent_arm": 9,
"int_arm": 5543.55,
"int_percent_dist": 9,
"int_dist": 4685.91,
"int_percent_other": 9,
"int_other": 3742.24,
"interest": 13971.7,
"total_revenue": 359345.88,
"arm_and_dist": 248655.59,
"collateral": 244446.79,
"total_balance": 311147.97,
"remaining_balance": 311147.97,
"balance_paid": 0,
"cash_flow": 34118.2,
"risk": -4208.8
},
"funduses": [
{
"id": "1",
"loan_id": "1",
"crop_id": "1",
"crop_acres": "347.4",
"fertilizer_arm_acre": "0",
"fertilizer_dist_acre": "164.97",
"fertilizer_other_acre": "0",
"seed_arm_acre": "0",
"seed_dist_acre": "0",
"seed_other_acre": "115",
"fungicide_arm_acre": "0",
"fungicide_dist_acre": "0",
"fungicide_other_acre": "0",
"herbicide_arm_acre": "0",
"herbicide_dist_acre": "32.94",
"herbicide_other_acre": "0",
"insecticide_arm_acre": "0",
"insecticide_dist_acre": "0",
"insecticide_other_acre": "0",
"custom_arm_acre": "18",
"custom_dist_acre": "0",
"custom_other_acre": "0",
"fuel_arm_acre": "40",
"fuel_dist_acre": "0",
"fuel_other_acre": "0",
"labor_arm_acre": "20",
"labor_dist_acre": "0",
"labor_other_acre": "0",
"repairs_arm_acre": "20",
"repairs_dist_acre": "0",
"repairs_other_acre": "0",
"insurance_arm_acre": "0",
"insurance_dist_acre": "0",
"insurance_other_acre": "11.88",
"harvesting_arm_acre": "0",
"harvesting_dist_acre": "0",
"harvesting_other_acre": "0",
"misc_acre_arm_acre": "20",
"misc_acre_dist_acre": "0",
"misc_acre_other_acre": "0",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"crop": {
"id": "1",
"crop": "corn",
"measurement": "bu",
"rebate_measurement": "bu"
}
},
{
"id": "2",
"loan_id": "1",
"crop_id": "2",
"crop_acres": "580.3",
"fertilizer_arm_acre": "0",
"fertilizer_dist_acre": "26.5",
"fertilizer_other_acre": "0",
"seed_arm_acre": "0",
"seed_dist_acre": "0",
"seed_other_acre": "60",
"fungicide_arm_acre": "0",
"fungicide_dist_acre": "12.5",
"fungicide_other_acre": "0",
"herbicide_arm_acre": "0",
"herbicide_dist_acre": "20.06",
"herbicide_other_acre": "0",
"insecticide_arm_acre": "0",
"insecticide_dist_acre": "10.67",
"insecticide_other_acre": "0",
"custom_arm_acre": "22",
"custom_dist_acre": "0",
"custom_other_acre": "0",
"fuel_arm_acre": "30",
"fuel_dist_acre": "0",
"fuel_other_acre": "0",
"labor_arm_acre": "20",
"labor_dist_acre": "0",
"labor_other_acre": "0",
"repairs_arm_acre": "10",
"repairs_dist_acre": "0",
"repairs_other_acre": "0",
"insurance_arm_acre": "0",
"insurance_dist_acre": "0",
"insurance_other_acre": "14.35",
"harvesting_arm_acre": "0",
"harvesting_dist_acre": "0",
"harvesting_other_acre": "0",
"misc_acre_arm_acre": "20",
"misc_acre_dist_acre": "0",
"misc_acre_other_acre": "0",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"crop": {
"id": "2",
"crop": "soybeans",
"measurement": "bu",
"rebate_measurement": "bu"
}
}
],
"indicator": {
"addendum": true,
"bankruptcy_history": true,
"required_3party": true,
"added_land_done": true,
"controlled_disbursement": true,
"attachments": true,
"comments": true
},
"insurance": {
"ins_agent": "State Farm",
"ins_agent_locale": "Monroe, LA",
"ins_agent_phone": "3185551212"
},
"loan_type": {
"type_id": "2",
"type": "Ag-Input",
"has_addendum": false,
"is_addendum": false,
"is_reconciliation": false,
"is_cross_collateralized": false
},
"location": {
"loc_id": "4",
"loc_abr": "RAY",
"region_id": "3",
"region": "Mid-West"
},
"pending": {
"is_stale": true,
"need_vote": true,
"has_comment": true
},
"progress": {
"its_list": "1",
"fsa_compliant": "1",
"has_liens": "1",
"valid_leases": "1",
"bankruptcy_order": "0",
"third_party_credit": "0",
"recommended": "0",
"arm_approved": "0",
"dist_approved": "0",
"loan_closed": "0",
"loan_closed_date": null,
"arm_balance": null,
"added_land_verified": "0",
"arm_ucc": "0",
"dist_ucc": "0",
"aoi_received": "0",
"ccc_received": "0",
"rebate_assignment": "0",
"limit_warning": "0",
"crop_inspection": "0",
"reconcilliation": "0",
"account_classification": "0",
"paid": "0",
"loan_paid": "0",
"perfected_attachments": "0",
"grade": "B"
},
"quests": {
"plant_own": false,
"plant_own_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"harvest_own": false,
"harvest_own_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"equip_obligations": false,
"equip_obligations_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"other_cash": false,
"other_cash_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"fsa_good": false,
"fsa_good_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"insInPlace": true,
"insInPlace_details": null,
"fci_good": false,
"fci_good_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"premiums_past": true,
"premiums_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"legal_defendant": true,
"defendant_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"judgments": false,
"judgment_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"bankruptcy": false,
"bankruptcy_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"bankruptcy_order": false,
"liens": true,
"liens_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"fsa_direct_pay": true,
"fsa_direct_pay_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"future_liabilities": true,
"credit_3p_available": true,
"credit_3p_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"income_percent": 90,
"income_distribution_details": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"distributor": "JSI",
"pesticide_number": "2T23765",
"credit_score": "730",
"cpa_financials": true,
"affiliated_entities": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia.",
"farm_supplier_creditors": "Rutrum mi libero hymenaeos dolor posuere montes tristique litora cubilia."
},
"staff": {
"user_id": "2",
"analyst_id": "2",
"analyst": "JWG",
"officer": "Jonathan Gravois",
"email": "jongravois@gmail.com",
"manager": "2"
},
"status": {
"id": "1",
"status": "In-Progress",
"iconClass": "glyphicon-wrench",
"iconColor": "#000099"
},
"comments": [
{
"id": "1",
"loan_id": "1",
"type": "Committee",
"user_id": "2",
"comment": "There are concerns about the ability to manage the reception of a large cash sum as evidenced by last year's performance of this applicant.",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "2",
"username": "Jonathan Gravois",
"abr": "JWG",
"email": "jongravois@gmail.com",
"loc_id": "4",
"manager_id": "2",
"is_admin": "1",
"is_approver": "1",
"is_manager": "1",
"role": "PRE",
"created_at": "2014-10-31 11:26:11",
"updated_at": "2014-10-31 11:26:11"
}
},
{
"id": "2",
"loan_id": "1",
"type": "Committee",
"user_id": "2",
"comment": "I will approve provided there is a controlled disbursement.",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "2",
"username": "Jonathan Gravois",
"abr": "JWG",
"email": "jongravois@gmail.com",
"loc_id": "4",
"manager_id": "2",
"is_admin": "1",
"is_approver": "1",
"is_manager": "1",
"role": "PRE",
"created_at": "2014-10-31 11:26:11",
"updated_at": "2014-10-31 11:26:11"
}
},
{
"id": "3",
"loan_id": "1",
"type": "Loan",
"user_id": "5",
"comment": "The requested loan will pay off the 2014 loan and provide resources for the 2015 Crop Year. Quail Ridge has been a valued customer for 3 years and has moved his crop insurance to our subsidiary.",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "5",
"username": "Robby Miller",
"abr": "RAM",
"email": "rmiller@armlend.com",
"loc_id": "4",
"manager_id": "4",
"is_admin": "0",
"is_approver": "1",
"is_manager": "1",
"role": "ANL",
"created_at": "2014-10-31 11:26:13",
"updated_at": "2014-10-31 11:26:13"
}
},
{
"id": "4",
"loan_id": "1",
"type": "LENDA",
"user_id": "1",
"comment": "Warning: Bankruptcy History Indication requires a Court Order to Incur Debt.",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "1",
"username": "LENDA",
"abr": "LEN",
"email": "lenda@armlend.com",
"loc_id": "4",
"manager_id": "1",
"is_admin": "0",
"is_approver": "0",
"is_manager": "0",
"role": "SYS",
"created_at": "2014-10-31 11:26:11",
"updated_at": "2014-10-31 11:26:11"
}
},
{
"id": "5",
"loan_id": "1",
"type": "Analyst",
"user_id": "5",
"comment": "Applicant would prefer not to tie up his third-party credit and would like to see if the loan will be approved without it. If not, he is willing to commit third-party credits.",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "5",
"username": "Robby Miller",
"abr": "RAM",
"email": "rmiller@armlend.com",
"loc_id": "4",
"manager_id": "4",
"is_admin": "0",
"is_approver": "1",
"is_manager": "1",
"role": "ANL",
"created_at": "2014-10-31 11:26:13",
"updated_at": "2014-10-31 11:26:13"
}
},
{
"id": "6",
"loan_id": "1",
"type": "Account",
"user_id": "7",
"comment": "Transferred $30,000 from Misc to Equipment.",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "7",
"username": "Katie Williams",
"abr": "KWW",
"email": "kwilliams@armlend.com",
"loc_id": "4",
"manager_id": "4",
"is_admin": "0",
"is_approver": "0",
"is_manager": "0",
"role": "SUP",
"created_at": "2014-10-31 11:26:13",
"updated_at": "2014-10-31 11:26:13"
}
}
],
"committee": [
{
"id": "1",
"loan_id": "1",
"role_id": "1",
"user_id": "3",
"vote_status_id": "1",
"vote_request_date": "2014-09-11",
"vote_received_date": null,
"vote_id": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "3",
"username": "Brad Terral",
"abr": "TBT",
"email": "bterral@armlend.com",
"loc_id": "4",
"manager_id": "3",
"is_admin": "1",
"is_approver": "1",
"is_manager": "1",
"role": "PRE",
"created_at": "2014-10-31 11:26:12",
"updated_at": "2014-10-31 11:26:12"
},
"role": {
"id": "1",
"role": "President"
},
"vote_status": {
"id": "1",
"status": "Pending"
},
"vote": null
},
{
"id": "2",
"loan_id": "1",
"role_id": "2",
"user_id": "4",
"vote_status_id": "2",
"vote_request_date": "2014-09-11",
"vote_received_date": "2014-09-13",
"vote_id": "2",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "4",
"username": "Mark Branch",
"abr": "MIB",
"email": "mbranch@armlend.com",
"loc_id": "4",
"manager_id": "3",
"is_admin": "0",
"is_approver": "1",
"is_manager": "1",
"role": "CEO",
"created_at": "2014-10-31 11:26:12",
"updated_at": "2014-10-31 11:26:12"
},
"role": {
"id": "2",
"role": "CEO"
},
"vote_status": {
"id": "2",
"status": "Received"
},
"vote": {
"id": "2",
"vote": "Disapprove"
}
},
{
"id": "3",
"loan_id": "1",
"role_id": "4",
"user_id": "5",
"vote_status_id": "3",
"vote_request_date": "2014-09-11",
"vote_received_date": null,
"vote_id": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "5",
"username": "Robby Miller",
"abr": "RAM",
"email": "rmiller@armlend.com",
"loc_id": "4",
"manager_id": "4",
"is_admin": "0",
"is_approver": "1",
"is_manager": "1",
"role": "ANL",
"created_at": "2014-10-31 11:26:13",
"updated_at": "2014-10-31 11:26:13"
},
"role": {
"id": "4",
"role": "Manager"
},
"vote_status": {
"id": "3",
"status": "Overdue"
},
"vote": null
},
{
"id": "4",
"loan_id": "1",
"role_id": "3",
"user_id": "2",
"vote_status_id": "2",
"vote_request_date": "2014-09-11",
"vote_received_date": "2014-09-12",
"vote_id": "1",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10",
"user": {
"id": "2",
"username": "Jonathan Gravois",
"abr": "JWG",
"email": "jongravois@gmail.com",
"loc_id": "4",
"manager_id": "2",
"is_admin": "1",
"is_approver": "1",
"is_manager": "1",
"role": "PRE",
"created_at": "2014-10-31 11:26:11",
"updated_at": "2014-10-31 11:26:11"
},
"role": {
"id": "3",
"role": "Regional"
},
"vote_status": {
"id": "2",
"status": "Received"
},
"vote": {
"id": "1",
"vote": "Approve"
}
}
],
"stakeholders": [
{
"id": "1",
"loan_id": "1",
"loan_role": "Partner",
"stakeholder": "Dick Grayson",
"ssn": "123121234",
"email": "robin@dccomics.com",
"address": "1 Bat Cave",
"city": "Natural",
"state": "AR",
"zip": "77631",
"phone": "5125551234",
"other": null,
"president": null,
"vicepresident": null,
"secretarytreasurer": null
},
{
"id": "2",
"loan_id": "1",
"loan_role": "Joint Venture",
"stakeholder": "Loki",
"ssn": "432123456",
"email": "loki@asgard.com",
"address": "Royal Dungeon",
"city": "Rainbow Bridge",
"state": "AR",
"zip": "77631",
"phone": "5124441212",
"other": null,
"president": null,
"vicepresident": null,
"secretarytreasurer": null
},
{
"id": "3",
"loan_id": "1",
"loan_role": "Corporation",
"stakeholder": "SHIELD",
"ssn": "1997199919",
"email": "support@shield.com",
"address": "Communications Department",
"city": "Sky Carrier",
"state": "AR",
"zip": "77631",
"phone": "5123331212",
"other": "S.H.I.E.L.D. is an espionage and law-enforcement agency in the Marvel Comics Universe. Created by Stan Lee and Jack Kirby in Strange Tales #135 (Aug. 1965), it often deals with paranormal and superhuman threats. The acronym originally stood for Supreme Headquarters, International Espionage, Law-Enforcement Division. It was changed in 1991 to Strategic Hazard Intervention Espionage Logistics Directorate.",
"president": "Fury, Nick",
"vicepresident": "Coulson, Phil",
"secretarytreasurer": "Hill, Maria"
}
],
"documents": [
{
"id": "1",
"loan_id": "1",
"document": "Signed Application",
"path": null,
"date_requested": "2014-09-02",
"date_received": "2014-09-02",
"reason_pending": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "2",
"loan_id": "1",
"document": "Driver's License",
"path": null,
"date_requested": "2014-09-02",
"date_received": "2014-09-02",
"reason_pending": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "3",
"loan_id": "1",
"document": "CPA Financials",
"path": null,
"date_requested": "2014-09-02",
"date_received": null,
"reason_pending": "Client unprepared",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "4",
"loan_id": "1",
"document": "Equipment List",
"path": null,
"date_requested": "2014-09-02",
"date_received": "2014-09-02",
"reason_pending": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "5",
"loan_id": "1",
"document": "Leases",
"path": null,
"date_requested": null,
"date_received": null,
"reason_pending": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "6",
"loan_id": "1",
"document": "FSA Information",
"path": null,
"date_requested": null,
"date_received": null,
"reason_pending": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "7",
"loan_id": "1",
"document": "Insurance Information",
"path": null,
"date_requested": null,
"date_received": null,
"reason_pending": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "8",
"loan_id": "1",
"document": "Crop Insurance APH Databases",
"path": null,
"date_requested": null,
"date_received": null,
"reason_pending": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "9",
"loan_id": "1",
"document": "Grain Contracts",
"path": null,
"date_requested": null,
"date_received": null,
"reason_pending": null,
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
}
],
"loanConditions": [
{
"id": "1",
"crop_year": "2015",
"loan_id": "1",
"condition_id": "1",
"condition": "Agricultural Security Agreement on Crops and Equipment",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "2",
"crop_year": "2015",
"loan_id": "1",
"condition_id": "2",
"condition": "Assignment of Crop Insurance",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "3",
"crop_year": "2015",
"loan_id": "1",
"condition_id": "4",
"condition": "Approval by Participating Distributor",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "4",
"crop_year": "2015",
"loan_id": "1",
"condition_id": "5",
"condition": "Personal Guarantee by Bo Gwin",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "5",
"crop_year": "2015",
"loan_id": "1",
"condition_id": "5",
"condition": "Personal Guarantee by Sharon Gwin",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "6",
"crop_year": "2015",
"loan_id": "1",
"condition_id": "7",
"condition": "Assignment of FSA Direct and LDP Payment",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
},
{
"id": "7",
"crop_year": "2015",
"loan_id": "1",
"condition_id": "7",
"condition": "PHI Credit Limit of 82K Verified",
"created_at": "2014-10-31 11:26:10",
"updated_at": "2014-10-31 11:26:10"
}
],
"systemics": [
{
"id": "1",
"loan_id": "1",
"user": "Jonathan Gravois",
"action": "Created loan",
"created_at": "2014-06-30 09:10:00",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "2",
"loan_id": "1",
"user": "Jonathan Gravois",
"action": "Uploaded driver's license",
"created_at": "2014-06-30 09:16:00",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "3",
"loan_id": "1",
"user": "Jonathan Gravois",
"action": "Uploaded prepared financials",
"created_at": "2014-06-30 09:17:00",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "4",
"loan_id": "1",
"user": "Jonathan Gravois",
"action": "Uploaded equipment listing",
"created_at": "2014-06-30 09:19:00",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "5",
"loan_id": "1",
"user": "Vinny Barbarino",
"action": "Modified applicant phone number",
"created_at": "2014-07-02 10:09:35",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "6",
"loan_id": "1",
"user": "Jonathan Gravois",
"action": "Verified ITS List",
"created_at": "2014-07-04 16:25:08",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "7",
"loan_id": "1",
"user": "Jonathan Gravois",
"action": "Verified FSA Eligibility",
"created_at": "2014-07-04 16:26:18",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "8",
"loan_id": "1",
"user": "Jonathan Gravois",
"action": "Verified prior lien",
"created_at": "2014-07-04 16:27:00",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "9",
"loan_id": "1",
"user": "Jonathan Gravois",
"action": "Uploaded lease",
"created_at": "2014-07-04 16:28:20",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "10",
"loan_id": "1",
"user": "LENDA",
"action": "Verified lease",
"created_at": "2014-07-04 16:28:20",
"updated_at": "2014-10-31 11:26:11"
},
{
"id": "11",
"loan_id": "1",
"user": "Jonathan Gravois",
"action": "Sent loan to distributor for approval",
"created_at": "2014-07-05 09:01:02",
"updated_at": "2014-10-31 11:26:11"
}
],
"totalExpenses": {
"fertilizer": {
"arm": 0,
"dist": 72688.53,
"other": 0,
"total": 72688.53
},
"seed": {
"arm": 0,
"dist": 0,
"other": 74769,
"total": 74769
},
"herbicide": {
"arm": 0,
"dist": 23084.17,
"other": 0,
"total": 23084.17
},
"fungicide": {
"arm": 0,
"dist": 7253.75,
"other": 0,
"total": 7253.75
},
"insecticide": {
"arm": 0,
"dist": 6191.8,
"other": 0,
"total": 6191.8
},
"custom": {
"arm": 19019.8,
"dist": 0,
"other": 0,
"total": 19019.8
},
"fuel": {
"arm": 31305,
"dist": 0,
"other": 0,
"total": 31305
},
"labor": {
"arm": 18554,
"dist": 0,
"other": 0,
"total": 18554
},
"repairs": {
"arm": 12751,
"dist": 0,
"other": 0,
"total": 12751
},
"insurance": {
"arm": 0,
"dist": 0,
"other": 12454.42,
"total": 12454.42
},
"harvesting": {
"arm": 0,
"dist": 0,
"other": 0,
"total": 0
},
"misc_acre": {
"arm": 18554,
"dist": 0,
"other": 0,
"total": 18554
},
"total": {
"arm": 100183.8,
"dist": 109218.25,
"other": 87223.42,
"total": 296625.47
}
},
"loanpractices": [
{
"crop_year": 2015,
"loan_id": 1,
"crop_id": 1,
"crop": "corn",
"is_active": true,
"ins_type": "RP",
"ins_option": "EU",
"ins_price": 4.25,
"ins_level": 75,
"aph": 135.3,
"ins_premium": 11.88,
"acres": 347.4,
"ins_share": 84.4,
"guaranty": 431.34,
"value": 122985.31
},
{
"crop_year": 2015,
"loan_id": 1,
"crop_id": 2,
"crop": "soybeans",
"is_active": true,
"ins_type": "RP",
"ins_option": "EU",
"ins_price": 11.25,
"ins_level": 75,
"aph": 36.2,
"ins_premium": 14.35,
"acres": 580.3,
"ins_share": 80.7,
"guaranty": 305.83,
"value": 136480.66
},
{
"crop_year": 2015,
"loan_id": 1,
"crop_id": 3,
"crop": "sorghum",
"is_active": false,
"ins_type": "RP",
"ins_option": "EU",
"ins_price": 4,
"ins_level": 75,
"aph": 0,
"ins_premium": 0,
"acres": 0,
"ins_share": 100,
"guaranty": 0,
"value": 0
},
{
"crop_year": 2015,
"loan_id": 1,
"crop_id": 4,
"crop": "wheat",
"is_active": false,
"ins_type": "RP",
"ins_option": "EU",
"ins_price": 6.64,
"ins_level": 75,
"aph": 0,
"ins_premium": 0,
"acres": 0,
"ins_share": 100,
"guaranty": 0,
"value": 0
},
{
"crop_year": 2015,
"loan_id": 1,
"crop_id": 5,
"crop": "cotton",
"is_active": false,
"ins_type": "RP",
"ins_option": "EU",
"ins_price": 0.7,
"ins_level": 75,
"aph": 0,
"ins_premium": 0,
"acres": 0,
"ins_share": 100,
"guaranty": 0,
"value": 0
},
{
"crop_year": 2015,
"loan_id": 1,
"crop_id": 6,
"crop": "rice",
"is_active": false,
"ins_type": "RP",
"ins_option": "EU",
"ins_price": 0,
"ins_level": 75,
"aph": 0,
"ins_premium": 0,
"acres": 0,
"ins_share": 100,
"guaranty": 0,
"value": 0
},
{
"crop_year": 2015,
"loan_id": 1,
"crop_id": 7,
"crop": "peanuts",
"is_active": false,
"ins_type": "RP",
"ins_option": "EU",
"ins_price": 0,
"ins_level": 75,
"aph": 0,
"ins_premium": 0,
"acres": 0,
"ins_share": 100,
"guaranty": 0,
"value": 0
},
{
"crop_year": 2015,
"loan_id": 1,
"crop_id": 7,
"crop": "sugarcane",
"is_active": false,
"ins_type": "RP",
"ins_option": "EU",
"ins_price": 0.16,
"ins_level": 75,
"aph": 0,
"ins_premium": 0,
"acres": 0,
"ins_share": 100,
"guaranty": 0,
"value": 0
}
],
"loancrops": [
{
"id": 1,
"crop_year": 2015,
"crop": "corn",
"uom": "bu",
"is_active": true,
"acres": 347.4,
"markettowhom": "CropsRUs",
"prod_price": 4.2,
"prod_yield": 152.3,
"prod_share": 84.4,
"ins_share": 0,
"mill_share": 0,
"bkqty": "0",
"bkprice": 0,
"gin_mill": null,
"harvest": 0,
"rebates": 0,
"fsa_payment": 0,
"percent_irrigated": "90.5",
"break_even": "102.8",
"p1_yield": 151,
"p2_yield": 176,
"p3_yield": 130,
"p4_yield": 121,
"p5_yield": 153.7,
"p6_yield": 124.5,
"adj_prod": 187551.894096
},
{
"id": 2,
"crop_year": 2015,
"crop": "soybeans",
"uom": "bu",
"is_active": true,
"acres": 580.3,
"markettowhom": "CropsRUs",
"prod_price": 10,
"prod_yield": 36.7,
"prod_share": 80.69,
"ins_share": 0,
"mill_share": 0,
"bkqty": "0",
"bkprice": 0,
"gin_mill": null,
"harvest": 0,
"rebates": 0,
"fsa_payment": 0,
"percent_irrigated": "92.3",
"break_even": "26.1",
"p1_yield": 31,
"p2_yield": 36,
"p3_yield": 43,
"p4_yield": 21,
"p5_yield": 26,
"p6_yield": 0,
"adj_prod": 171845.57369
},
{
"id": 3,
"crop_year": 2015,
"crop": "sorghum",
"uom": "bu",
"is_active": false,
"acres": 0,
"markettowhom": null,
"prod_price": 0,
"prod_yield": 0,
"prod_share": 0,
"ins_share": 0,
"mill_share": 0,
"bkqty": "0",
"bkprice": 0,
"gin_mill": null,
"harvest": 0,
"rebates": 0,
"fsa_payment": 0,
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": 0,
"p2_yield": 0,
"p3_yield": 0,
"p4_yield": 0,
"p5_yield": 0,
"p6_yield": 0,
"adj_prod": 0
},
{
"id": 4,
"crop_year": 2015,
"crop": "wheat",
"uom": "bu",
"is_active": false,
"acres": 0,
"markettowhom": null,
"prod_price": 0,
"prod_yield": 0,
"prod_share": 0,
"ins_share": 0,
"mill_share": 0,
"bkqty": "0",
"bkprice": 0,
"gin_mill": null,
"harvest": 0,
"rebates": 0,
"fsa_payment": 0,
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": 0,
"p2_yield": 0,
"p3_yield": 0,
"p4_yield": 0,
"p5_yield": 0,
"p6_yield": 0,
"adj_prod": 0
},
{
"id": 5,
"crop_year": 2015,
"crop": "cotton",
"uom": "bu",
"is_active": false,
"acres": 0,
"markettowhom": null,
"prod_price": 0,
"prod_yield": 0,
"prod_share": 0,
"ins_share": 0,
"mill_share": 0,
"bkqty": "0",
"bkprice": 0,
"gin_mill": null,
"harvest": 0,
"rebates": 0,
"fsa_payment": 0,
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": 0,
"p2_yield": 0,
"p3_yield": 0,
"p4_yield": 0,
"p5_yield": 0,
"p6_yield": 0,
"adj_prod": 0
},
{
"id": 6,
"crop_year": 2015,
"crop": "rice",
"uom": "bu",
"is_active": false,
"acres": 0,
"markettowhom": null,
"prod_price": 0,
"prod_yield": 0,
"prod_share": 0,
"ins_share": 0,
"mill_share": 0,
"bkqty": "0",
"bkprice": 0,
"gin_mill": null,
"harvest": 0,
"rebates": 0,
"fsa_payment": 0,
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": 0,
"p2_yield": 0,
"p3_yield": 0,
"p4_yield": 0,
"p5_yield": 0,
"p6_yield": 0,
"adj_prod": 0
},
{
"id": 7,
"crop_year": 2015,
"crop": "peanuts",
"uom": "bu",
"is_active": false,
"acres": 0,
"markettowhom": null,
"prod_price": 0,
"prod_yield": 0,
"prod_share": 0,
"ins_share": 0,
"mill_share": 0,
"bkqty": "0",
"bkprice": 0,
"gin_mill": null,
"harvest": 0,
"rebates": 0,
"fsa_payment": 0,
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": 0,
"p2_yield": 0,
"p3_yield": 0,
"p4_yield": 0,
"p5_yield": 0,
"p6_yield": 0,
"adj_prod": 0
},
{
"id": 8,
"crop_year": 2015,
"crop": "sugarcane",
"uom": "bu",
"is_active": false,
"acres": 0,
"markettowhom": null,
"prod_price": 0,
"prod_yield": 0,
"prod_share": 0,
"ins_share": 0,
"mill_share": 0,
"bkqty": "0",
"bkprice": 0,
"gin_mill": null,
"harvest": 0,
"rebates": 0,
"fsa_payment": 0,
"percent_irrigated": "0",
"break_even": "0",
"p1_yield": 0,
"p2_yield": 0,
"p3_yield": 0,
"p4_yield": 0,
"p5_yield": 0,
"p6_yield": 0,
"adj_prod": 0
}
],
"counties": [
{
"id": "1317",
"state_id": "19",
"location_id": "4",
"county": "Richland",
"label": "Richland ( LA )",
"locale": "LA | Richland",
"price_corn_irr": "4.2",
"price_corn_ni": "4.2",
"insured_price_corn_irr": "4.25",
"insured_price_corn_ni": "4.25",
"yield_corn_irr": "139",
"yield_corn_ni": "94",
"price_soybeans_irr": "10",
"price_soybeans_ni": "10",
"price_soybeans_facirr": "10",
"price_soybeans_facni": "10",
"insured_price_soybeans_irr": "11.25",
"insured_price_soybeans_ni": "11.25",
"insured_price_soybeans_facirr": "11.25",
"insured_price_soybeans_facni": "11.25",
"yield_soybeans_irr": "31",
"yield_soybeans_ni": "25",
"yield_soybeans_facirr": "23",
"yield_soybeans_facni": "18",
"price_sorghum_irr": "4",
"price_sorghum_ni": "4",
"insured_price_sorghum_irr": "4",
"insured_price_sorghum_ni": "4",
"yield_sorghum_irr": "55",
"yield_sorghum_ni": "55",
"price_wheat_irr": "5.75",
"price_wheat_ni": "5.75",
"insured_price_wheat_irr": "6.64",
"insured_price_wheat_ni": "6.64",
"yield_wheat_irr": "46",
"yield_wheat_ni": "46",
"price_cotton_irr": "90",
"price_cotton_ni": "90",
"insured_price_cotton_irr": "93",
"insured_price_cotton_ni": "93",
"yield_cotton_irr": "649",
"yield_cotton_ni": "467",
"price_rice_irr": "0.135",
"price_rice_ni": "0.135",
"insured_price_rice_irr": "0.14",
"insured_price_rice_ni": "0.14",
"yield_rice_irr": "5820",
"yield_rice_ni": "5820",
"price_peanuts_irr": "2.3",
"price_peanuts_ni": "2.3",
"insured_price_peanuts_irr": "2.8",
"insured_price_peanuts_ni": "2.8",
"yield_peanuts_irr": "3000",
"yield_peanuts_ni": "3000",
"price_sugarcane_irr": "0.28",
"price_sugarcane_ni": "0.28",
"insured_price_sugarcane_irr": "0.16",
"insured_price_sugarcane_ni": "0.16",
"yield_sugarcane_irr": "5133",
"yield_sugarcane_ni": "5133"
},
{
"id": "1337",
"state_id": "19",
"location_id": "4",
"county": "West Carroll",
"label": "West Carroll ( LA )",
"locale": "LA | West Carroll",
"price_corn_irr": "4.2",
"price_corn_ni": "4.2",
"insured_price_corn_irr": "4.25",
"insured_price_corn_ni": "4.25",
"yield_corn_irr": "139",
"yield_corn_ni": "94",
"price_soybeans_irr": "10",
"price_soybeans_ni": "10",
"price_soybeans_facirr": "10",
"price_soybeans_facni": "10",
"insured_price_soybeans_irr": "11.25",
"insured_price_soybeans_ni": "11.25",
"insured_price_soybeans_facirr": "11.25",
"insured_price_soybeans_facni": "11.25",
"yield_soybeans_irr": "31",
"yield_soybeans_ni": "25",
"yield_soybeans_facirr": "23",
"yield_soybeans_facni": "18",
"price_sorghum_irr": "4",
"price_sorghum_ni": "4",
"insured_price_sorghum_irr": "4",
"insured_price_sorghum_ni": "4",
"yield_sorghum_irr": "55",
"yield_sorghum_ni": "55",
"price_wheat_irr": "5.75",
"price_wheat_ni": "5.75",
"insured_price_wheat_irr": "6.64",
"insured_price_wheat_ni": "6.64",
"yield_wheat_irr": "46",
"yield_wheat_ni": "46",
"price_cotton_irr": "90",
"price_cotton_ni": "90",
"insured_price_cotton_irr": "93",
"insured_price_cotton_ni": "93",
"yield_cotton_irr": "649",
"yield_cotton_ni": "467",
"price_rice_irr": "0.135",
"price_rice_ni": "0.135",
"insured_price_rice_irr": "0.14",
"insured_price_rice_ni": "0.14",
"yield_rice_irr": "5820",
"yield_rice_ni": "5820",
"price_peanuts_irr": "2.3",
"price_peanuts_ni": "2.3",
"insured_price_peanuts_irr": "2.8",
"insured_price_peanuts_ni": "2.8",
"yield_peanuts_irr": "3000",
"yield_peanuts_ni": "3000",
"price_sugarcane_irr": "0.28",
"price_sugarcane_ni": "0.28",
"insured_price_sugarcane_irr": "0.16",
"insured_price_sugarcane_ni": "0.16",
"yield_sugarcane_irr": "5133",
"yield_sugarcane_ni": "5133"
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.