Raw Database State
{
"studies": [
{
"study_id": "study_q3_001",
"property": {
"name": "Q3 Power Solar Thermal + Water Purification",
"address": "1234 Innovation Drive, Phoenix, AZ 85001",
"city": "Phoenix",
"state": "AZ",
"zip": "85001",
"type": "Solar Commercial",
"subtype": "Renewable Energy + Water Treatment",
"basis": 2450000,
"land_value": 334500,
"purchase_date": "2024-01-15",
"square_footage": 12500
},
"tax_benefit": {
"year_1_total": 762975,
"itc_amount": 254250,
"itc_percentage": 30,
"depreciation": 508725,
"bonus_depreciation": 100,
"roi": "10320%",
"five_year_savings": 1842000,
"npv_10_year": 2100000
},
"documents": [
{
"id": "doc_001",
"name": "Settlement_Statement_2024.pdf",
"type": "closing_statement",
"required": true,
"uploaded": true,
"validated": true
},
{
"id": "doc_002",
"name": "Depreciation_Schedule_Pre.xlsx",
"type": "depreciation_schedule",
"required": true,
"uploaded": true,
"validated": true
},
{
"id": "doc_003",
"name": "Fixed_Asset_Ledger.xlsx",
"type": "fixed_asset_ledger",
"required": true,
"uploaded": true,
"validated": true
},
{
"id": "doc_004",
"name": "Construction_Invoices_Solar.pdf",
"type": "construction_invoices",
"required": true,
"uploaded": true,
"validated": true
},
{
"id": "doc_005",
"name": "Purchase_Agreement.pdf",
"type": "purchase_agreement",
"required": true,
"uploaded": true,
"validated": true
},
{
"id": "doc_006",
"name": "Title_Insurance.pdf",
"type": "title_insurance",
"required": true,
"uploaded": true,
"validated": true
},
{
"id": "doc_007",
"name": "Survey_Report.pdf",
"type": "survey",
"required": true,
"uploaded": true,
"validated": true
},
{
"id": "doc_008",
"name": "Environmental_Report.pdf",
"type": "environmental",
"required": false,
"uploaded": true,
"validated": true
},
{
"id": "doc_009",
"name": "Appraisal_Report.pdf",
"type": "appraisal",
"required": false,
"uploaded": true,
"validated": true
},
{
"id": "doc_010",
"name": "Q3_Tech_Specs.pdf",
"type": "solar_equipment_specs",
"required": true,
"uploaded": true,
"validated": true,
"solar": true
},
{
"id": "doc_011",
"name": "Solar_Permits.pdf",
"type": "permits",
"required": true,
"uploaded": true,
"validated": true,
"solar": true
},
{
"id": "doc_012",
"name": "IRS_Form_3468.pdf",
"type": "tax_form",
"required": true,
"uploaded": true,
"validated": true,
"solar": true
},
{
"id": "doc_013",
"name": "Utility_Interconnection.pdf",
"type": "utility",
"required": false,
"uploaded": true,
"validated": true,
"solar": true
},
{
"id": "doc_014",
"name": "Water_Treatment_License.pdf",
"type": "license",
"required": true,
"uploaded": true,
"validated": true
}
],
"assets": [
{
"id": "asset_001",
"name": "Evacuated Tube Solar Collectors",
"cost": 425000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)(I)",
"confidence": 99,
"status": "verified",
"reason": "Solar energy property IRC §168(e)(3)(B)(vi)(I)",
"itc_eligible": true,
"location": "Rooftop South Array",
"floor": "ROOF",
"photos_required": 4,
"photos_taken": 0,
"serial_number": "ETC-2024-001",
"manufacturer": "Apricus Solar",
"model": "AP-30",
"install_date": "2024-01-15"
},
{
"id": "asset_002",
"name": "Solar Thermal Storage Tanks",
"cost": 185000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)",
"confidence": 98,
"status": "verified",
"reason": "Integral to solar thermal system",
"itc_eligible": true,
"location": "Basement Mechanical Room",
"floor": "B1",
"photos_required": 3,
"photos_taken": 0,
"serial_number": "TST-2024-002",
"manufacturer": "Bradford White",
"model": "SW-1000",
"install_date": "2024-01-20"
},
{
"id": "asset_003",
"name": "Solar Mounting Racks & Hardware",
"cost": 45000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)",
"confidence": 97,
"status": "verified",
"reason": "Essential solar system component",
"itc_eligible": true,
"location": "Rooftop South",
"floor": "ROOF",
"photos_required": 3,
"photos_taken": 0,
"serial_number": "MNT-2024-003",
"manufacturer": "IronRidge",
"model": "XR1000",
"install_date": "2024-01-10"
},
{
"id": "asset_004",
"name": "Solar Control System & Sensors",
"cost": 32000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)",
"confidence": 96,
"status": "verified",
"reason": "Solar system monitoring and control",
"itc_eligible": true,
"location": "Control Room",
"floor": "FL1",
"photos_required": 2,
"photos_taken": 0,
"serial_number": "CTL-2024-004",
"manufacturer": "Resol",
"model": "DeltaSol MX",
"install_date": "2024-01-25"
},
{
"id": "asset_005",
"name": "Integrated Water Purification System",
"cost": 107500,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)",
"confidence": 85,
"status": "verified",
"reason": "Integral to solar thermal system (Dual-Impact)",
"itc_eligible": true,
"itc_percentage": 15,
"location": "Ground Floor Purification Bay",
"floor": "FL1",
"photos_required": 4,
"photos_taken": 0,
"serial_number": "WPS-2024-005",
"manufacturer": "Evoqua",
"model": "PureFlo-500",
"install_date": "2024-02-01"
},
{
"id": "asset_006",
"name": "Heat Exchangers (Solar to Water)",
"cost": 28000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)",
"confidence": 94,
"status": "verified",
"reason": "Solar thermal heat transfer",
"itc_eligible": true,
"location": "Basement Mechanical",
"floor": "B1",
"photos_required": 2,
"photos_taken": 0,
"serial_number": "HEX-2024-006",
"manufacturer": "Alfa Laval",
"model": "CB76",
"install_date": "2024-01-22"
},
{
"id": "asset_007",
"name": "Circulation Pumps (Solar Loop)",
"cost": 18000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)",
"confidence": 93,
"status": "verified",
"reason": "Solar fluid circulation",
"itc_eligible": true,
"location": "Basement Mechanical",
"floor": "B1",
"photos_required": 2,
"photos_taken": 0,
"serial_number": "PMP-2024-007",
"manufacturer": "Grundfos",
"model": "MAGNA3",
"install_date": "2024-01-23"
},
{
"id": "asset_008",
"name": "Insulated Piping Network (Solar)",
"cost": 22000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)",
"confidence": 91,
"status": "verified",
"reason": "Solar thermal distribution",
"itc_eligible": true,
"location": "Throughout Facility",
"floor": "ALL",
"photos_required": 5,
"photos_taken": 0,
"serial_number": "PIPE-2024-008",
"manufacturer": "ThermWell",
"model": "Frost King",
"install_date": "2024-01-18"
},
{
"id": "asset_009",
"name": "Expansion Tanks & Pressure Control",
"cost": 8000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)",
"confidence": 90,
"status": "verified",
"reason": "Solar system safety equipment",
"itc_eligible": true,
"location": "Basement Mechanical",
"floor": "B1",
"photos_required": 2,
"photos_taken": 0,
"serial_number": "EXP-2024-009",
"manufacturer": "Amtrol",
"model": "SX-90V",
"install_date": "2024-01-24"
},
{
"id": "asset_010",
"name": "Pressure Relief & Safety Valves",
"cost": 5000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(vi)",
"confidence": 89,
"status": "verified",
"reason": "Solar system safety",
"itc_eligible": true,
"location": "Rooftop & Mechanical",
"floor": "ROOF",
"photos_required": 3,
"photos_taken": 0,
"serial_number": "PRV-2024-010",
"manufacturer": "Watts",
"model": "LF174A",
"install_date": "2024-01-26"
},
{
"id": "asset_011",
"name": "Water Treatment Filters (Multi-Stage)",
"cost": 12000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(i)",
"confidence": 88,
"status": "verified",
"reason": "Water treatment equipment",
"itc_eligible": false,
"location": "Purification Bay",
"floor": "FL1",
"photos_required": 3,
"photos_taken": 0,
"serial_number": "FLT-2024-011",
"manufacturer": "Pentair",
"model": "Pelican",
"install_date": "2024-02-05"
},
{
"id": "asset_012",
"name": "UV Sterilization Unit",
"cost": 15000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(i)",
"confidence": 87,
"status": "verified",
"reason": "Water purification equipment",
"itc_eligible": false,
"location": "Purification Bay",
"floor": "FL1",
"photos_required": 2,
"photos_taken": 0,
"serial_number": "UV-2024-012",
"manufacturer": "Trojan Technologies",
"model": "UVSwift SC",
"install_date": "2024-02-06"
},
{
"id": "asset_013",
"name": "Water Storage Reservoir (Treated)",
"cost": 35000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(i)",
"confidence": 86,
"status": "verified",
"reason": "Water storage tank",
"itc_eligible": false,
"location": "Ground Level Exterior",
"floor": "FL1",
"photos_required": 3,
"photos_taken": 0,
"serial_number": "RES-2024-013",
"manufacturer": "Norwesco",
"model": "40223",
"install_date": "2024-02-08"
},
{
"id": "asset_014",
"name": "Electrical Distribution System",
"cost": 42000,
"category": "15-year MACRS",
"irs_code": "§168(e)(3)(E)",
"confidence": 99,
"status": "verified",
"reason": "Land improvements - utility distribution",
"itc_eligible": false,
"location": "Electrical Room",
"floor": "FL1",
"photos_required": 4,
"photos_taken": 0,
"serial_number": "ELEC-2024-014",
"manufacturer": "Square D",
"model": "NF Panel",
"install_date": "2024-01-12"
},
{
"id": "asset_015",
"name": "Building Shell (Walls, Roof, Foundation)",
"cost": 895000,
"category": "39-year MACRS",
"irs_code": "§168(e)(2)(B)",
"confidence": 99,
"status": "verified",
"reason": "Nonresidential real property",
"itc_eligible": false,
"location": "Entire Structure",
"floor": "ALL",
"photos_required": 6,
"photos_taken": 0,
"serial_number": "BLDG-2024-015",
"manufacturer": "N/A",
"model": "Custom Build",
"install_date": "2024-01-05"
},
{
"id": "asset_016",
"name": "HVAC System (Office Areas)",
"cost": 68000,
"category": "39-year MACRS",
"irs_code": "§168(e)(2)(B)",
"confidence": 92,
"status": "verified",
"reason": "Building system",
"itc_eligible": false,
"location": "Rooftop & Office Zones",
"floor": "ROOF",
"photos_required": 4,
"photos_taken": 0,
"serial_number": "HVAC-2024-016",
"manufacturer": "Carrier",
"model": "Weathermaster",
"install_date": "2024-01-14"
},
{
"id": "asset_017",
"name": "Plumbing System (Facility)",
"cost": 56000,
"category": "39-year MACRS",
"irs_code": "§168(e)(2)(B)",
"confidence": 92,
"status": "verified",
"reason": "Structural component",
"itc_eligible": false,
"location": "Throughout Building",
"floor": "ALL",
"photos_required": 5,
"photos_taken": 0,
"serial_number": "PLMB-2024-017",
"manufacturer": "Various",
"model": "Code Compliant",
"install_date": "2024-01-11"
},
{
"id": "asset_018",
"name": "Fire Protection System",
"cost": 24000,
"category": "39-year MACRS",
"irs_code": "§168(e)(2)(B)",
"confidence": 95,
"status": "verified",
"reason": "Building safety system",
"itc_eligible": false,
"location": "Throughout Building",
"floor": "ALL",
"photos_required": 3,
"photos_taken": 0,
"serial_number": "FIRE-2024-018",
"manufacturer": "Viking",
"model": "Sprinkler System",
"install_date": "2024-01-13"
},
{
"id": "asset_019",
"name": "Security System & Access Control",
"cost": 18000,
"category": "5-year MACRS",
"irs_code": "§168(e)(3)(B)(i)",
"confidence": 94,
"status": "verified",
"reason": "Security equipment",
"itc_eligible": false,
"location": "Entry Points & Perimeter",
"floor": "ALL",
"photos_required": 4,
"photos_taken": 0,
"serial_number": "SEC-2024-019",
"manufacturer": "Honeywell",
"model": "Pro Series",
"install_date": "2024-01-28"
},
{
"id": "asset_020",
"name": "LED Lighting System (Facility)",
"cost": 28000,
"category": "15-year MACRS",
"irs_code": "§168(e)(3)(E)",
"confidence": 93,
"status": "verified",
"reason": "Land improvement - lighting",
"itc_eligible": false,
"location": "Interior & Exterior",
"floor": "ALL",
"photos_required": 4,
"photos_taken": 0,
"serial_number": "LIGHT-2024-020",
"manufacturer": "Cree",
"model": "EdgeLit",
"install_date": "2024-01-16"
},
{
"id": "asset_021",
"name": "Parking Lot Paving & Striping",
"cost": 32000,
"category": "15-year MACRS",
"irs_code": "§168(e)(3)(E)",
"confidence": 98,
"status": "verified",
"reason": "Land improvement",
"itc_eligible": false,
"location": "Front Parking Area",
"floor": "EXTERIOR",
"photos_required": 3,
"photos_taken": 0,
"serial_number": "PARK-2024-021",
"manufacturer": "N/A",
"model": "Asphalt",
"install_date": "2024-01-08"
},
{
"id": "asset_022",
"name": "Landscaping & Irrigation",
"cost": 15000,
"category": "15-year MACRS",
"irs_code": "§168(e)(3)(E)",
"confidence": 97,
"status": "verified",
"reason": "Land improvement",
"itc_eligible": false,
"location": "Perimeter & Entry",
"floor": "EXTERIOR",
"photos_required": 2,
"photos_taken": 0,
"serial_number": "LAND-2024-022",
"manufacturer": "N/A",
"model": "Desert Xeriscape",
"install_date": "2024-01-30"
}
],
"summary": {
"total_assets": 22,
"total_cost": 2115500,
"itc_eligible_cost": 845500,
"five_year_property_cost": 903500,
"fifteen_year_property_cost": 102000,
"thirty_nine_year_property_cost": 1043000,
"land_value": 334500,
"photos_required": 71,
"photos_taken": 0,
"completion_percentage": 0
},
"status": "draft",
"created_at": "2025-12-17T00:43:13.783Z",
"created_by": "user_001",
"updated_at": "2025-12-17T00:43:13.783Z",
"mission_id": null,
"inspector_id": null,
"progress": {
"documents_uploaded": 14,
"documents_total": 14,
"documents_percentage": 100,
"assets_photographed": 0,
"assets_total": 22,
"photos_percentage": 0,
"assets_reviewed": 0,
"review_percentage": 0
}
}
],
"missions": [],
"documents": [],
"extracted_fields": [],
"users": [
{
"id": "user_001",
"name": "Sarah Chen",
"role": "accountant",
"email": "sarah@costseg.com"
},
{
"id": "user_002",
"name": "Alex Rivera",
"role": "photographer",
"email": "alex@costseg.com"
},
{
"id": "user_003",
"name": "Dr. James Wilson",
"role": "inspector",
"email": "james@costseg.com",
"title": "PE"
}
],
"photos": [],
"currentUser": null
}