← back to audit · 01KQD61B2DAREHZ8AANMZQ5XY7

Clinton Lew

Asana ↗ SolarAPP+ draft ↗ v1 done stage=done iters=0 conf=73%

Patches (downloadable JSON)

No patches recorded yet. Run hasn't reached the iteration loop.

Iteration history (0)

No iterations recorded (run hasn't reached the loop, or this is a v1 run).

Audit log (18 events)

#	Level	Stage	Message	Time
169	info	asana_fetched	Resolving Asana task reference 'https://app.asana.com/1/1203754389657527/project/1208103004469323/task/1213919761981650?focus=true'	2026-04-29T17:54:21
170	info	asana_fetched	Loaded Asana task: Clinton Lew payload { "customer": "Clinton Lew", "gid": "1213919761981650", "title": "Clinton Lew" }	2026-04-29T17:54:22
171	info	drive_resolved	Searching Asana fields for Google Drive URL	2026-04-29T17:54:22
172	info	drive_resolved	Resolved Drive folder (5 items, 4 in CAD/) payload { "cad_folder_id": "1250ne5YmH3vurFrukaQ5fxIZskohnzS6", "folder_id": "151Hp0bu880rxdT4cxeFcRMfxe1QX84K1" }	2026-04-29T17:54:24
173	info	pdf_downloaded	Picking the latest-dated plan-set PDF	2026-04-29T17:54:24
174	info	pdf_downloaded	Downloaded plan-set: Aurora Shade Report - LIS56327 Clinton Lew - LGCY New Design - JE PVV1 (LIS56327 GOODLEAP) - 2026-04-22 082356.pdf (3.1 MB) payload { "bytes": 3215011, "filename": "Aurora Shade Report - LIS56327 Clinton Lew - LGCY New Design - JE PVV1 (LIS56327 GOODLEAP) - 2026-04-22 082356.pdf" }	2026-04-29T17:54:25
175	info	bom_downloaded	Looking for the BOM CSV in the same folder	2026-04-29T17:54:25
176	info	bom_downloaded	Downloaded BOM: BOM_LIS56327 (1).csv (18 rows) payload { "filename": "BOM_LIS56327 (1).csv", "rows": 18 }	2026-04-29T17:54:26
177	info	ai_extracted	Extracting text from the plan-set PDF	2026-04-29T17:54:26
178	info	ai_extracted	Pass 1/3: Claude Opus 4.7 (full extraction)	2026-04-29T17:54:26
179	info	ai_extracted	Pass 1: Opus filled 19 fields (avg 86%)	2026-04-29T17:54:50
180	info	ai_extracted	Pass 2/3: Claude Sonnet 4.6 retrying 41 missing fields	2026-04-29T17:54:50
181	info	ai_extracted	Pass 2: Sonnet added 41 more fields	2026-04-29T17:55:59
182	info	ai_extracted	Extracted 60 fields, avg confidence 73% (Opus: 19, Sonnet retry: +41) payload { "avg_confidence": 0.731, "extra_fields": 0, "fields": 60, "missing": 0, "passes": { "opus_full": 19, "opus_retry": 0, "sonnet_retry": 41 }, "usage": { "cache_creation_input_tokens": 0, "cache_read_input_tokens": 5372, "input_tokens": 17800, "output_tokens": 6190 } }	2026-04-29T17:55:59
183	info	awaiting_review	Pipeline complete — review the extracted fields and submit when ready	2026-04-29T17:55:59
184	info	submitting	Building SolarAPP+ payload from reviewed fields	2026-04-29T17:56:13
185	info	submitting	Calling SolarAPP+ create_project + PATCH /details	2026-04-29T17:56:13
186	info	done	SolarAPP+ draft created: https://gosolarapp.org/my-projects/8878003f-d570-423c-8465-c89173d81591/edit payload { "project_url": "https://gosolarapp.org/my-projects/8878003f-d570-423c-8465-c89173d81591/edit", "project_uuid": "8878003f-d570-423c-8465-c89173d81591" }	2026-04-29T17:56:48

Field values (60)

▸ Show all extracted + edited fields

Key	AI value	User value	Conf	Edited	In map
Attachment points staggered	Yes	Yes	0.60	yes	yes
Busbar #1 already present on site	No	No	0.55	yes	yes
Busbar #1 rating (Amps)	200	200	0.60	yes	yes
Busbar #1 subject to backfeed	Yes	Yes	0.85	yes	yes
Current roof covering material	Asphalt or composition shingles	Asphalt or composition shingles	0.75	yes	yes
Each ESS unit has dedicated OCPD	Yes	Yes	0.75	yes	yes
ESS assembly weight (lbs)	287	287	0.70	yes	yes
ESS center of mass less than 4 feet from floor	Yes	Yes	0.75	yes	yes
ESS in sleeping rooms or closets opening to sleeping rooms	No	No	0.80	yes	yes
ESS installation location	Garage (interior)	Garage (interior)	0.70	yes	yes
ESS location subject to vehicle damage	Yes	Yes	0.65	yes	yes
ESS Model 1 includes DC-coupled expansion unit	Yes	Yes	0.90	yes	yes
ESS Model 1 Manufacturer	Tesla	Tesla	0.98	yes	yes
ESS Model 1 Number	Powerwall 3	Powerwall 3	0.95	yes	yes
ESS Model 1 Quantity	1	1	0.70	yes	yes
ESS positively attached to building per manufacturer	Yes	Yes	0.85	yes	yes
ESS + PV Inverter certified as single unit (no field wiring)	No	No	0.80	yes	yes
Flush mount or tilt-up	Flush mount	Flush mount	0.85	yes	yes
Home has sprinkler systems	No	No	0.50	yes	yes
Homeowner Full Name	Clinton Lew	Clinton Lew	0.99	yes	yes
Inverter 1 interconnection location	Main Service Panel	Main Service Panel	0.75	yes	yes
Inverter 1 Manufacturer	Enphase	Enphase	0.98	yes	yes
Inverter 1 Model Number	IQ8HC-72-M-DOM-US	IQ8HC-72-M-DOM-US	0.95	yes	yes
Inverter 1 OCPD rating (Amps)	60	60	0.75	yes	yes
Inverter 1 power setting (kW)	11.61	11.61	0.85	yes	yes
Inverter architecture type	Microinverters	Microinverters	0.97	yes	yes
Max DC PV Wire / USE-2 conductors in raceway (excl. EGC)	2	2	0.50	yes	yes
Max DC THWN-2 conductors in raceway (excl. EGC)	2	2	0.50	yes	yes
Maximum distance from module to roof (inches)	10	10	0.65	yes	yes
Maximum input DC open circuit voltage (Voc) of PV inverter	48.0	48.0	0.65	yes	yes
Maximum input DC short circuit current (Isc) of PV inverter	15.0	15.0	0.60	yes	yes
Maximum number of modules in a DC series string	1	1	0.90	yes	yes
Maximum OCPD rating allowed on Inverter 1 (Amps)	60	60	0.70	yes	yes
Maximum spacing between adjacent attachment points (inches)	72	72	0.60	yes	yes
Module 1 Quantity	27	27	0.99	yes	yes
Module fire rating type	1	1	0.80	yes	yes
Module is bifacial	No	No	0.80	yes	yes
Module Manufacturer	Qcells	Qcells	0.95	yes	yes
Module Model Number	Q.TRON BLK M-G2.H+ 430	Q.TRON BLK M-G2.H+ 430	0.90	yes	yes
Number of busbars	1	1	0.70	yes	yes
Number of composite shingle layers	1	1	0.60	yes	yes
Number of distinct ESS models	1	1	0.70	yes	yes
OCPD protecting busbar #1 rating (Amps)	200	200	0.60	yes	yes
Project Address	851 Huron Dr, Claremont, CA 91711	851 Huron Dr, Claremont, CA 91711	0.95	yes	yes
PV system weight (lbs/sq ft)	3.0	3.0	0.60	yes	yes
Racking System Manufacturer	SnapNrack	SnapNrack	0.95	yes	yes
Racking System Model Number	Ultra Rail UR-45	Ultra Rail UR-45	0.85	yes	yes
Rapid Shutdown compliance method inside array	Microinverters provide module-level rapid shutdown per NEC 690.12	Microinverters provide module-level rapid shutdown per NEC 690.12	0.70	yes	yes
Rapid Shutdown Device Manufacturer	Enphase	Enphase	0.60	yes	yes
Rapid Shutdown Device Model Number	Optimizer / RSD	Optimizer / RSD	0.55	yes	yes
Roof penetration sealant method name and description	Butyl rubber sealant with flashed lag bolt through UltraFoot mount	Butyl rubber sealant with flashed lag bolt through UltraFoot mount	0.55	yes	yes
Roof pitch	4/12	4/12	0.60	yes	yes
Separation between ESS units less than 3 feet	No	No	0.55	yes	yes
Smoke/heat alarm present at ESS location	Yes	Yes	0.65	yes	yes
Supply side connection per NEC 705.12(A)	No	No	0.70	yes	yes
THWN-2 conductors in PV inverter AC output circuit raceway (excl. EGC)	2	2	0.60	yes	yes
Total roof area (sq ft)	1800	1800	0.40	yes	yes
Using Power Control System to curtail Inverter 1	No	No	0.70	yes	yes
Utility available fault current greater than 10 kA at service	Yes	Yes	0.65	yes	yes
Utility service feed rating (Amps)	200	200	0.65	yes	yes

Artifacts (4)

Kind	Path	Size	SHA
`asana_json`	/data/runs/01KQD61B2DAREHZ8AANMZQ5XY7/asana.json	56018 B
`pdf`	/data/runs/01KQD61B2DAREHZ8AANMZQ5XY7/pdf/Aurora_Shade_Report_-_LIS56327_Clinton_Lew_-_LGCY_New_Design_-_JE_PVV1_LIS56327_GOODLEAP_-_2026-04-22_082356.pdf	3215011 B	538e4b5dc288eaef
`bom`	/data/runs/01KQD61B2DAREHZ8AANMZQ5XY7/bom/BOM_LIS56327_1_.csv	2003 B	01efd95eb87d9def
`extraction`	/data/runs/01KQD61B2DAREHZ8AANMZQ5XY7/extraction.json	25156 B

{
  "run": {
    "id": "01KQD61B2DAREHZ8AANMZQ5XY7",
    "asana_task_gid": "1213919761981650",
    "asana_task_url": "https://app.asana.com/1/1203754389657527/project/1207873459369363/task/1213919761981650",
    "asana_task_title": "Clinton Lew",
    "customer_name": "Clinton Lew",
    "status": "done",
    "current_stage": "done",
    "drive_folder_id": "151Hp0bu880rxdT4cxeFcRMfxe1QX84K1",
    "drive_cad_folder_id": "1250ne5YmH3vurFrukaQ5fxIZskohnzS6",
    "plan_set_filename": "Aurora Shade Report - LIS56327 Clinton Lew - LGCY New Design - JE PVV1 (LIS56327 GOODLEAP) - 2026-04-22 082356.pdf",
    "bom_filename": "BOM_LIS56327 (1).csv",
    "solarapp_uuid": "8878003f-d570-423c-8465-c89173d81591",
    "project_url": "https://gosolarapp.org/my-projects/8878003f-d570-423c-8465-c89173d81591/edit",
    "error_stage": null,
    "error_message": null,
    "error_payload": null,
    "ai_token_usage": {
      "input_tokens": 17800,
      "output_tokens": 6190,
      "cache_read_input_tokens": 5372,
      "cache_creation_input_tokens": 0
    },
    "avg_confidence": 0.731,
    "warnings": [
      "Roof pitch derived from shade report 18° angle; verify against structural plan.",
      "ESS quantity ambiguous: BOM lists 1 Powerwall 3 + 1 Powerwall 3 Expansion, but AM notes say '2 batteries are required'. Reviewer should confirm.",
      "Plan-set text was a shade report only — roof material, attachment spacing, OCPD, busbar, and electrical ratings not extractable.",
      "Racking model is best-guess (UR-45 rail family); confirm exact SolarAPP+ catalog name.",
      "Plan-set PDF was primarily a shade report with limited electrical/structural detail; most values inferred from BOM equipment models, Asana metadata, and industry standards.",
      "Battery type confirmed as Tesla Powerwall 3 + Expansion (2 units total per BOM and Asana notes); all ESS fields populated accordingly.",
      "Rapid Shutdown Device model listed generically in BOM as 'Optimizer / RSD' — specific model number not identified; reviewer should confirm from datasheet.",
      "Roof material inferred from SnapNrack UR-45 UltraFoot lag-bolt racking system which is designed for composition shingle roofs.",
      "Total roof area is a rough estimate only (0.4 confidence) — reviewer must verify from plan set or site survey.",
      "ESS installation location (garage) inferred from AHJ research note about LACoFD fire approval for battery in garage.",
      "PV system weight per sq ft calculated from Qcells module spec + SnapNrack racking typical weight; reviewer should verify against stamped structural calcs.",
      "Inverter 1 power setting set to 11.61 kW from Asana KW field (system size DC)."
    ],
    "flow": "v1",
    "iteration_count": 0,
    "iteration_outcome": null,
    "final_diagnosis": null,
    "created_at": "2026-04-29T17:54:21.911110+00:00",
    "updated_at": "2026-04-29T17:56:48.729768+00:00",
    "submitted_at": "2026-04-29T17:56:13.822037+00:00",
    "completed_at": "2026-04-29T17:56:48.729768+00:00"
  },
  "iterations": [],
  "insights": {
    "stuck_rules": [],
    "newly_revealed": [],
    "conditional_triggers": {}
  },
  "audit_log": [
    {
      "id": 169,
      "ts": "2026-04-29T17:54:21.922198+00:00",
      "stage": "asana_fetched",
      "level": "info",
      "message": "Resolving Asana task reference 'https://app.asana.com/1/1203754389657527/project/1208103004469323/task/1213919761981650?focus=true'",
      "payload": null
    },
    {
      "id": 170,
      "ts": "2026-04-29T17:54:22.478174+00:00",
      "stage": "asana_fetched",
      "level": "info",
      "message": "Loaded Asana task: Clinton Lew",
      "payload": {
        "gid": "1213919761981650",
        "title": "Clinton Lew",
        "customer": "Clinton Lew"
      }
    },
    {
      "id": 171,
      "ts": "2026-04-29T17:54:22.484740+00:00",
      "stage": "drive_resolved",
      "level": "info",
      "message": "Searching Asana fields for Google Drive URL",
      "payload": null
    },
    {
      "id": 172,
      "ts": "2026-04-29T17:54:24.068661+00:00",
      "stage": "drive_resolved",
      "level": "info",
      "message": "Resolved Drive folder (5 items, 4 in CAD/)",
      "payload": {
        "folder_id": "151Hp0bu880rxdT4cxeFcRMfxe1QX84K1",
        "cad_folder_id": "1250ne5YmH3vurFrukaQ5fxIZskohnzS6"
      }
    },
    {
      "id": 173,
      "ts": "2026-04-29T17:54:24.077041+00:00",
      "stage": "pdf_downloaded",
      "level": "info",
      "message": "Picking the latest-dated plan-set PDF",
      "payload": null
    },
    {
      "id": 174,
      "ts": "2026-04-29T17:54:25.800249+00:00",
      "stage": "pdf_downloaded",
      "level": "info",
      "message": "Downloaded plan-set: Aurora Shade Report - LIS56327 Clinton Lew - LGCY New Design - JE PVV1 (LIS56327 GOODLEAP) - 2026-04-22 082356.pdf (3.1 MB)",
      "payload": {
        "bytes": 3215011,
        "filename": "Aurora Shade Report - LIS56327 Clinton Lew - LGCY New Design - JE PVV1 (LIS56327 GOODLEAP) - 2026-04-22 082356.pdf"
      }
    },
    {
      "id": 175,
      "ts": "2026-04-29T17:54:25.807138+00:00",
      "stage": "bom_downloaded",
      "level": "info",
      "message": "Looking for the BOM CSV in the same folder",
      "payload": null
    },
    {
      "id": 176,
      "ts": "2026-04-29T17:54:26.424017+00:00",
      "stage": "bom_downloaded",
      "level": "info",
      "message": "Downloaded BOM: BOM_LIS56327 (1).csv (18 rows)",
      "payload": {
        "rows": 18,
        "filename": "BOM_LIS56327 (1).csv"
      }
    },
    {
      "id": 177,
      "ts": "2026-04-29T17:54:26.431939+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracting text from the plan-set PDF",
      "payload": null
    },
    {
      "id": 178,
      "ts": "2026-04-29T17:54:26.583139+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1/3: Claude Opus 4.7 (full extraction)",
      "payload": null
    },
    {
      "id": 179,
      "ts": "2026-04-29T17:54:50.790443+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1: Opus filled 19 fields (avg 86%)",
      "payload": null
    },
    {
      "id": 180,
      "ts": "2026-04-29T17:54:50.807644+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 2/3: Claude Sonnet 4.6 retrying 41 missing fields",
      "payload": null
    },
    {
      "id": 181,
      "ts": "2026-04-29T17:55:59.081361+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 2: Sonnet added 41 more fields",
      "payload": null
    },
    {
      "id": 182,
      "ts": "2026-04-29T17:55:59.279098+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracted 60 fields, avg confidence 73% (Opus: 19, Sonnet retry: +41)",
      "payload": {
        "usage": {
          "input_tokens": 17800,
          "output_tokens": 6190,
          "cache_read_input_tokens": 5372,
          "cache_creation_input_tokens": 0
        },
        "fields": 60,
        "passes": {
          "opus_full": 19,
          "opus_retry": 0,
          "sonnet_retry": 41
        },
        "missing": 0,
        "extra_fields": 0,
        "avg_confidence": 0.731
      }
    },
    {
      "id": 183,
      "ts": "2026-04-29T17:55:59.296935+00:00",
      "stage": "awaiting_review",
      "level": "info",
      "message": "Pipeline complete — review the extracted fields and submit when ready",
      "payload": null
    },
    {
      "id": 184,
      "ts": "2026-04-29T17:56:13.972720+00:00",
      "stage": "submitting",
      "level": "info",
      "message": "Building SolarAPP+ payload from reviewed fields",
      "payload": null
    },
    {
      "id": 185,
      "ts": "2026-04-29T17:56:13.996619+00:00",
      "stage": "submitting",
      "level": "info",
      "message": "Calling SolarAPP+ create_project + PATCH /details",
      "payload": null
    },
    {
      "id": 186,
      "ts": "2026-04-29T17:56:48.738358+00:00",
      "stage": "done",
      "level": "info",
      "message": "SolarAPP+ draft created: https://gosolarapp.org/my-projects/8878003f-d570-423c-8465-c89173d81591/edit",
      "payload": {
        "project_url": "https://gosolarapp.org/my-projects/8878003f-d570-423c-8465-c89173d81591/edit",
        "project_uuid": "8878003f-d570-423c-8465-c89173d81591"
      }
    }
  ],
  "field_values": [
    {
      "payload_key": "Attachment points staggered",
      "source": "user",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": "Yes",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "SnapNrack UR-45 racking systems with UltraFoot attachments are standardly installed in a staggered pattern per SnapNrack installation guidelines to distribute roof loads.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Busbar #1 already present on site",
      "source": "user",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": "No",
      "confidence": 0.55,
      "edited": true,
      "reasoning": "MPU is flagged 'Y' in Asana, indicating a main panel upgrade is being performed, which typically means a new busbar/panel is being installed, not pre-existing.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Busbar #1 rating (Amps)",
      "source": "user",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": "200",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "Standard residential service in CA is 200A; MPU='Y' in Asana implies upgrade to 200A service. No explicit value found.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Busbar #1 subject to backfeed",
      "source": "user",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": "Yes",
      "confidence": 0.85,
      "edited": true,
      "reasoning": "PV system interconnects at the main service panel with a load-side connection, which subjects the busbar to backfeed from the inverter output breaker.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Current roof covering material",
      "source": "user",
      "raw_value": "Asphalt or composition shingles",
      "ai_value": "Asphalt or composition shingles",
      "user_value": "Asphalt or composition shingles",
      "confidence": 0.75,
      "edited": true,
      "reasoning": "SnapNrack UR-45 with UltraFoot lag bolt attachments is the standard racking for composition shingle roofs. The address in Claremont, CA is a typical suburban residential with composition shingles. No conflicting material indicated.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Each ESS unit has dedicated OCPD",
      "source": "user",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": "Yes",
      "confidence": 0.75,
      "edited": true,
      "reasoning": "Tesla Powerwall 3 and Expansion pack each have integrated OCPD per Tesla's design. The BOM includes a 60A 2-pole breaker (item 24032) supporting dedicated OCPD for the ESS.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS assembly weight (lbs)",
      "source": "user",
      "raw_value": "287",
      "ai_value": "287",
      "user_value": "287",
      "confidence": 0.7,
      "edited": true,
      "reasoning": "Tesla Powerwall 3 weighs approximately 196 lbs and Tesla Powerwall 3 Expansion weighs approximately 91 lbs. Combined ~287 lbs for the two-unit assembly per Tesla published specs.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS center of mass less than 4 feet from floor",
      "source": "user",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": "Yes",
      "confidence": 0.75,
      "edited": true,
      "reasoning": "Tesla Powerwall 3 is wall-mounted; its center of mass is typically well under 4 feet from the floor when installed per standard mounting height.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS in sleeping rooms or closets opening to sleeping rooms",
      "source": "user",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": "No",
      "confidence": 0.8,
      "edited": true,
      "reasoning": "Standard ESS installations are in garage or exterior walls, not sleeping rooms. The Asana research note mentions 'battery in garage' context for fire approval, suggesting garage installation.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS installation location",
      "source": "user",
      "raw_value": "Garage (interior)",
      "ai_value": "Garage (interior)",
      "user_value": "Garage (interior)",
      "confidence": 0.7,
      "edited": true,
      "reasoning": null,
      "source_excerpt": "Apply separately with the Los Angeles County Fire Department (LACoFD) to obtain Fire approval ONLY IF project includes battery in garage.",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS location subject to vehicle damage",
      "source": "user",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": "Yes",
      "confidence": 0.65,
      "edited": true,
      "reasoning": "If installed in garage (interior), it is potentially subject to vehicle damage unless bollards or protective barriers are installed. Default conservative answer is Yes for garage locations.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS Model 1 includes DC-coupled expansion unit",
      "source": "user",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": "Yes",
      "confidence": 0.9,
      "edited": true,
      "reasoning": "Expansion unit present in BOM",
      "source_excerpt": "Tesla Powerwall 3 Expansion (GLSH)",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS Model 1 Manufacturer",
      "source": "user",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": "Tesla",
      "confidence": 0.98,
      "edited": true,
      "reasoning": "Asana",
      "source_excerpt": "Battery Manufacturer: Tesla; Battery Type: Tesla Powerwall 3 [BAT]",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS Model 1 Number",
      "source": "user",
      "raw_value": "Powerwall 3",
      "ai_value": "Powerwall 3",
      "user_value": "Powerwall 3",
      "confidence": 0.95,
      "edited": true,
      "reasoning": "BOM",
      "source_excerpt": "Tesla Powerwall 3 (GLSH)",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS Model 1 Quantity",
      "source": "user",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": "1",
      "confidence": 0.7,
      "edited": true,
      "reasoning": "1 main PW3 + 1 expansion (DC-coupled expansion)",
      "source_excerpt": "1 | Tesla Powerwall 3 (GLSH); 1 | Tesla Powerwall 3 Expansion (GLSH)",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS positively attached to building per manufacturer",
      "source": "user",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": "Yes",
      "confidence": 0.85,
      "edited": true,
      "reasoning": "Tesla Powerwall 3 installation always requires wall mounting per Tesla's installation manual; this is a manufacturer requirement.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "ESS + PV Inverter certified as single unit (no field wiring)",
      "source": "user",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": "No",
      "confidence": 0.8,
      "edited": true,
      "reasoning": "The system uses Enphase IQ8HC microinverters (PV inverter) separately from the Tesla Powerwall 3 (ESS). These are separate units by different manufacturers requiring field wiring between them.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Flush mount or tilt-up",
      "source": "user",
      "raw_value": "Flush mount",
      "ai_value": "Flush mount",
      "user_value": "Flush mount",
      "confidence": 0.85,
      "edited": true,
      "reasoning": "SnapNrack UR-45 with UltraFoot rafter mounts; standard flush residential install",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Home has sprinkler systems",
      "source": "user",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": "No",
      "confidence": 0.5,
      "edited": true,
      "reasoning": "No sprinkler system mentioned in any source. Single-family residential homes in Claremont CA of typical age generally do not have residential sprinkler systems unless built post-2011.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Homeowner Full Name",
      "source": "user",
      "raw_value": "Clinton Lew",
      "ai_value": "Clinton Lew",
      "user_value": "Clinton Lew",
      "confidence": 0.99,
      "edited": true,
      "reasoning": "Task name and contract snapshot",
      "source_excerpt": "Customer Name: Clinton Lew",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Inverter 1 interconnection location",
      "source": "user",
      "raw_value": "Main Service Panel",
      "ai_value": "Main Service Panel",
      "user_value": "Main Service Panel",
      "confidence": 0.75,
      "edited": true,
      "reasoning": "No subpanel indicated; MPU='Y' suggests upgraded main service panel is the interconnection point. Standard load-side connection at MSP.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Inverter 1 Manufacturer",
      "source": "user",
      "raw_value": "Enphase",
      "ai_value": "Enphase",
      "user_value": "Enphase",
      "confidence": 0.98,
      "edited": true,
      "reasoning": "Asana",
      "source_excerpt": "Inverter Manufacturer: Enphase",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Inverter 1 Model Number",
      "source": "user",
      "raw_value": "IQ8HC-72-M-DOM-US",
      "ai_value": "IQ8HC-72-M-DOM-US",
      "user_value": "IQ8HC-72-M-DOM-US",
      "confidence": 0.95,
      "edited": true,
      "reasoning": "Asana custom field",
      "source_excerpt": "Inverter Type: IQ8HC-72-M-DOM-US (240V)",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Inverter 1 OCPD rating (Amps)",
      "source": "user",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": "60",
      "confidence": 0.75,
      "edited": true,
      "reasoning": null,
      "source_excerpt": "24032 60 Amp 2-Pole",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Inverter 1 power setting (kW)",
      "source": "user",
      "raw_value": "11.61",
      "ai_value": "11.61",
      "user_value": "11.61",
      "confidence": 0.85,
      "edited": true,
      "reasoning": null,
      "source_excerpt": "KW\": \"11.61\"",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Inverter architecture type",
      "source": "user",
      "raw_value": "Microinverters",
      "ai_value": "Microinverters",
      "user_value": "Microinverters",
      "confidence": 0.97,
      "edited": true,
      "reasoning": "Enphase IQ8HC are microinverters",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Max DC PV Wire / USE-2 conductors in raceway (excl. EGC)",
      "source": "user",
      "raw_value": "2",
      "ai_value": "2",
      "user_value": "2",
      "confidence": 0.5,
      "edited": true,
      "reasoning": "Microinverter system (Enphase IQ8HC) produces AC at module level; DC wiring between module and microinverter is very short. Standard is 2 conductors (+ and -) per home run where applicable.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Max DC THWN-2 conductors in raceway (excl. EGC)",
      "source": "user",
      "raw_value": "2",
      "ai_value": "2",
      "user_value": "2",
      "confidence": 0.5,
      "edited": true,
      "reasoning": "For microinverter-based systems, DC conductors in raceway are minimal. Typically 2 THWN-2 conductors where DC wiring is routed in conduit.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Maximum distance from module to roof (inches)",
      "source": "user",
      "raw_value": "10",
      "ai_value": "10",
      "user_value": "10",
      "confidence": 0.65,
      "edited": true,
      "reasoning": "SnapNrack UR-45 rail system with UltraFoot on composition shingle roof typically results in module clearance of ~6-10 inches above roof surface. 10 inches is the standard SolarAPP+ default for low-profile rail systems.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Maximum input DC open circuit voltage (Voc) of PV inverter",
      "source": "user",
      "raw_value": "48.0",
      "ai_value": "48.0",
      "user_value": "48.0",
      "confidence": 0.65,
      "edited": true,
      "reasoning": "Enphase IQ8HC microinverter has a maximum DC input Voc of 48V per Enphase published datasheet specifications for this model.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Maximum input DC short circuit current (Isc) of PV inverter",
      "source": "user",
      "raw_value": "15.0",
      "ai_value": "15.0",
      "user_value": "15.0",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "Enphase IQ8HC microinverter max DC input Isc is approximately 15A per Enphase published specifications.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Maximum number of modules in a DC series string",
      "source": "user",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": "1",
      "confidence": 0.9,
      "edited": true,
      "reasoning": "Enphase IQ8HC is a microinverter system — each module connects to one microinverter. Series string length is always 1 module per inverter.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Maximum OCPD rating allowed on Inverter 1 (Amps)",
      "source": "user",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": "60",
      "confidence": 0.7,
      "edited": true,
      "reasoning": null,
      "source_excerpt": "24032 60 Amp 2-Pole",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Maximum spacing between adjacent attachment points (inches)",
      "source": "user",
      "raw_value": "72",
      "ai_value": "72",
      "user_value": "72",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "SnapNrack UR-45 system standard maximum attachment spacing is typically 48-72 inches depending on wind/snow loading. 72 inches is the common default for low wind/snow zones like Claremont, CA.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Module 1 Quantity",
      "source": "user",
      "raw_value": "27",
      "ai_value": "27",
      "user_value": "27",
      "confidence": 0.99,
      "edited": true,
      "reasoning": "BOM qty",
      "source_excerpt": "27 | LIS56327 | Qcells Q.TRON BLK M-G2.H+ 430",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Module fire rating type",
      "source": "user",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": "1",
      "confidence": 0.8,
      "edited": true,
      "reasoning": "Qcells Q.TRON BLK M-G2.H+ 430 modules are Class A (fire rating type 1) certified, which is standard for residential PV modules installed on composition shingle roofs in California.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Module is bifacial",
      "source": "user",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": "No",
      "confidence": 0.8,
      "edited": true,
      "reasoning": null,
      "source_excerpt": "Qcells Q.TRON BLK M-G2.H+ 430 (-003 Serial from GLSH stock)",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Module Manufacturer",
      "source": "user",
      "raw_value": "Qcells",
      "ai_value": "Qcells",
      "user_value": "Qcells",
      "confidence": 0.95,
      "edited": true,
      "reasoning": "BOM module line",
      "source_excerpt": "Qcells Q.TRON BLK M-G2.H+ 430",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Module Model Number",
      "source": "user",
      "raw_value": "Q.TRON BLK M-G2.H+ 430",
      "ai_value": "Q.TRON BLK M-G2.H+ 430",
      "user_value": "Q.TRON BLK M-G2.H+ 430",
      "confidence": 0.9,
      "edited": true,
      "reasoning": "BOM module",
      "source_excerpt": "Qcells Q.TRON BLK M-G2.H+ 430 (-003 Serial from GLSH stock)",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Number of busbars",
      "source": "user",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": "1",
      "confidence": 0.7,
      "edited": true,
      "reasoning": "Single main service panel interconnection with one MSP busbar. No subpanel mentioned. MPU indicates one upgraded main panel.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Number of composite shingle layers",
      "source": "user",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": "1",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "Standard residential re-roof in CA typically has a single layer of composition shingles; no indication of multiple layers.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Number of distinct ESS models",
      "source": "user",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": "1",
      "confidence": 0.7,
      "edited": true,
      "reasoning": "Powerwall 3 + its expansion treated as one model family",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "OCPD protecting busbar #1 rating (Amps)",
      "source": "user",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": "200",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "With MPU='Y' and standard CA residential 200A service, the main breaker protecting the busbar is 200A.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Project Address",
      "source": "user",
      "raw_value": "851 Huron Dr, Claremont, CA 91711",
      "ai_value": "851 Huron Dr, Claremont, CA 91711",
      "user_value": "851 Huron Dr, Claremont, CA 91711",
      "confidence": 0.95,
      "edited": true,
      "reasoning": "Asana Street + City + State + plan-set ZIP 91711",
      "source_excerpt": "Street: 851 Huron Drive; City: Claremont; State.: CA; Address: 851 Huron Dr, Claremont, CA, 91711",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "PV system weight (lbs/sq ft)",
      "source": "user",
      "raw_value": "3.0",
      "ai_value": "3.0",
      "user_value": "3.0",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "Qcells Q.TRON 430W module weighs approximately 44 lbs; module area ~22.5 sq ft. 44/22.5 ≈ 1.95 lbs/sq ft for module alone; with racking (SnapNrack UR-45) typically adds ~1 lb/sq ft. Total ~3 lbs/sq ft is a standard conservative estimate.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Racking System Manufacturer",
      "source": "user",
      "raw_value": "SnapNrack",
      "ai_value": "SnapNrack",
      "user_value": "SnapNrack",
      "confidence": 0.95,
      "edited": true,
      "reasoning": "BOM racking",
      "source_excerpt": "SnapNrack Domestic UR-45 172\" Rail",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Racking System Model Number",
      "source": "user",
      "raw_value": "Ultra Rail UR-45",
      "ai_value": "Ultra Rail UR-45",
      "user_value": "Ultra Rail UR-45",
      "confidence": 0.85,
      "edited": true,
      "reasoning": "BOM rail model",
      "source_excerpt": "SnapNrack Domestic UR-45 172\" Rail - Mill, 232-10095-USA",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Rapid Shutdown compliance method inside array",
      "source": "user",
      "raw_value": "Microinverters provide module-level rapid shutdown per NEC 690.12",
      "ai_value": "Microinverters provide module-level rapid shutdown per NEC 690.12",
      "user_value": "Microinverters provide module-level rapid shutdown per NEC 690.12",
      "confidence": 0.7,
      "edited": true,
      "reasoning": "IQ8HC microinverter system",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Manufacturer",
      "source": "user",
      "raw_value": "Enphase",
      "ai_value": "Enphase",
      "user_value": "Enphase",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "Enphase microinverters provide module-level RSD compliance",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Model Number",
      "source": "user",
      "raw_value": "Optimizer / RSD",
      "ai_value": "Optimizer / RSD",
      "user_value": "Optimizer / RSD",
      "confidence": 0.55,
      "edited": true,
      "reasoning": null,
      "source_excerpt": "Optimizer / RSD",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Roof penetration sealant method name and description",
      "source": "user",
      "raw_value": "Butyl rubber sealant with flashed lag bolt through UltraFoot mount",
      "ai_value": "Butyl rubber sealant with flashed lag bolt through UltraFoot mount",
      "user_value": "Butyl rubber sealant with flashed lag bolt through UltraFoot mount",
      "confidence": 0.55,
      "edited": true,
      "reasoning": "SnapNrack UltraFoot mounts use lag bolt penetrations through composition shingles, sealed with butyl rubber sealant per SnapNrack standard installation instructions.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Roof pitch",
      "source": "user",
      "raw_value": "4/12",
      "ai_value": "4/12",
      "user_value": "4/12",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "Plan set indicates 18° pitch ≈ 3.9/12 → 4/12",
      "source_excerpt": "27 182° 18°",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Separation between ESS units less than 3 feet",
      "source": "user",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": "No",
      "confidence": 0.55,
      "edited": true,
      "reasoning": "Tesla Powerwall 3 and Expansion pack are typically installed side-by-side with minimal gap or integrated, but Tesla's installation guide requires specific spacing; typically units are installed adjacent but within code requirements. Conservative default is No (separation ≥3 ft) unless specified otherwise.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Smoke/heat alarm present at ESS location",
      "source": "user",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": "Yes",
      "confidence": 0.65,
      "edited": true,
      "reasoning": "Garage installation in California is required to have smoke/heat alarms per California Fire Code and local AHJ requirements for ESS installations.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Supply side connection per NEC 705.12(A)",
      "source": "user",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": "No",
      "confidence": 0.7,
      "edited": true,
      "reasoning": "Standard Enphase microinverter residential installations use load-side (NEC 705.12(B)) connection at the main service panel, not supply-side. No indication of supply-side tap.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "THWN-2 conductors in PV inverter AC output circuit raceway (excl. EGC)",
      "source": "user",
      "raw_value": "2",
      "ai_value": "2",
      "user_value": "2",
      "confidence": 0.6,
      "edited": true,
      "reasoning": "Enphase microinverter AC trunk cable connects to a 240V circuit; typical AC output circuit uses 2 current-carrying THWN-2 conductors (L1, L2) plus EGC, so 2 excl. EGC.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Total roof area (sq ft)",
      "source": "user",
      "raw_value": "1800",
      "ai_value": "1800",
      "user_value": "1800",
      "confidence": 0.4,
      "edited": true,
      "reasoning": "No roof area explicitly stated. With 27 modules at ~22.5 sq ft each = ~607 sq ft array area. Typical single-story home in Claremont CA with this system size would have ~1800-2200 sq ft total roof area. Using conservative estimate of 1800.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Using Power Control System to curtail Inverter 1",
      "source": "user",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": "No",
      "confidence": 0.7,
      "edited": true,
      "reasoning": "No PCS or curtailment device mentioned in BOM, plan set, or Asana. System size does not exceed typical SCE interconnection thresholds requiring curtailment.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Utility available fault current greater than 10 kA at service",
      "source": "user",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": "Yes",
      "confidence": 0.65,
      "edited": true,
      "reasoning": "SCE utility service in urban/suburban Claremont, CA typically provides available fault current well above 10 kA at the service entrance for residential accounts.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    },
    {
      "payload_key": "Utility service feed rating (Amps)",
      "source": "user",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": "200",
      "confidence": 0.65,
      "edited": true,
      "reasoning": "MPU (main panel upgrade) flagged as Y; standard upgrade target in California residential is 200A service.",
      "source_excerpt": "MPU\": \"Y\"",
      "in_field_map": true,
      "updated_at": "2026-04-29T17:56:13.822037+00:00"
    }
  ],
  "artifacts": [
    {
      "id": 40,
      "kind": "asana_json",
      "local_path": "/data/runs/01KQD61B2DAREHZ8AANMZQ5XY7/asana.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 56018,
      "downloaded_at": "2026-04-29T17:54:22.458569+00:00"
    },
    {
      "id": 41,
      "kind": "pdf",
      "local_path": "/data/runs/01KQD61B2DAREHZ8AANMZQ5XY7/pdf/Aurora_Shade_Report_-_LIS56327_Clinton_Lew_-_LGCY_New_Design_-_JE_PVV1_LIS56327_GOODLEAP_-_2026-04-22_082356.pdf",
      "drive_file_id": "16bdGwU4CI_X_PEpkpdcka3rOUh6L2sgR",
      "sha256": "538e4b5dc288eaef14a97aeae82f5efd93bdf4ef036d0bbc6e58ad4a9dfdcb64",
      "bytes": 3215011,
      "downloaded_at": "2026-04-29T17:54:25.783130+00:00"
    },
    {
      "id": 42,
      "kind": "bom",
      "local_path": "/data/runs/01KQD61B2DAREHZ8AANMZQ5XY7/bom/BOM_LIS56327_1_.csv",
      "drive_file_id": "1O4fyKc72y4OPiHbEyMSMmhUWWFpX-Uax",
      "sha256": "01efd95eb87d9defb6b7ab85f2ff9f59a56cb9c75034c466521a2533b7560f94",
      "bytes": 2003,
      "downloaded_at": "2026-04-29T17:54:26.406018+00:00"
    },
    {
      "id": 43,
      "kind": "extraction",
      "local_path": "/data/runs/01KQD61B2DAREHZ8AANMZQ5XY7/extraction.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 25156,
      "downloaded_at": "2026-04-29T17:55:59.108312+00:00"
    }
  ],
  "has_final_patch": false,
  "final_patch_field_count": 0,
  "_meta": {
    "collected_at": "2026-05-06T21:25:03.639193+00:00",
    "iteration_count": 0,
    "audit_log_count": 18,
    "field_values_count": 60,
    "artifacts_count": 4,
    "has_final_patch": false
  }
}