← back to audit · 01KQT1K3JJAQBEMH8G68E0PNBD

Michael MCMILLIN

Asana ↗ v2 failed stage=creating_draft iters=0 conf=84%

Patches (downloadable JSON)

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

Error in stage creating_draft

SolarAPP+ reports address ineligible: no registered jurisdiction for this address

error_payload

{
  "exception_type": "EligibilityError"
}

Iteration history (0)

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

Audit log (15 events)

#	Level	Stage	Message	Time
441	info	extracting	Starting v2 intake (always-Opus extraction)	2026-05-04T17:46:48
442	info	asana_fetched	Resolving Asana task reference 'https://app.asana.com/1/1203754389657527/project/1211568850380857/task/1211970405658455'	2026-05-04T17:46:48
443	info	asana_fetched	Loaded Asana task: Michael MCMILLIN payload { "customer": "Michael MCMILLIN", "gid": "1211970405658455", "title": "Michael MCMILLIN" }	2026-05-04T17:46:49
444	info	drive_resolved	Searching Asana fields for Google Drive URL	2026-05-04T17:46:49
445	info	drive_resolved	Resolved Drive folder (5 items, 5 in CAD/) payload { "cad_folder_id": "1hXShikinB6mnvcHHpkJu7IzOGzblnKy2", "folder_id": "1kDxzFKw4LeOJhHt9rG9ZQ_tt8aVRdslE" }	2026-05-04T17:46:51
446	info	pdf_downloaded	Picking the latest-dated plan-set PDF	2026-05-04T17:46:51
447	info	pdf_downloaded	Downloaded plan-set: MICHAEL MCMILLIN V3._12_23_2025.pdf (8.6 MB) payload { "bytes": 9036457, "filename": "MICHAEL MCMILLIN V3._12_23_2025.pdf" }	2026-05-04T17:46:53
448	info	bom_downloaded	Looking for the BOM CSV in the same folder	2026-05-04T17:46:53
449	warn	bom_downloaded	No BOM CSV in folder — modules section will rely on PDF + Asana only	2026-05-04T17:46:53
450	info	ai_extracted	Extracting text from the plan-set PDF	2026-05-04T17:46:53
451	info	ai_extracted	Pass 1/2: Claude Opus 4.7 (full extraction)	2026-05-04T17:46:59
452	info	ai_extracted	Pass 1: Opus filled 60 fields (avg 88%)	2026-05-04T17:48:12
453	info	ai_extracted	Pass 2/2: Claude Opus 4.7 retrying 37 missing fields	2026-05-04T17:48:12
454	info	ai_extracted	Extracted 77 fields, avg confidence 84% (Opus: 60, Opus retry: +17, 20 still unfilled) payload { "avg_confidence": 0.84, "extra_fields": 0, "fields": 77, "missing": 20, "passes": { "opus_full": 60, "opus_retry": 17 }, "usage": { "cache_creation_input_tokens": 9992, "cache_read_input_tokens": 0, "input_tokens": 70588, "output_tokens": 8181 } }	2026-05-04T17:48:51
455	info	creating_draft	Creating draft in SolarAPP+ (sandbox)	2026-05-04T17:48:51

Field values (77)

▸ Show all extracted + edited fields

Key	AI value	User value	Conf	Edited	In map
Attachment points staggered	Yes	—	0.50	no	yes
Backup contains service disconnect	Yes	—	0.70	no	yes
Backup device manufacturer	Tesla	—	0.95	no	yes
Backup device model	Backup Switch	—	0.90	no	yes
Backup feeder conductor material	Copper	—	0.85	no	yes
Busbar #1 already present on site	Yes	—	0.90	no	yes
Busbar #1 interconnection compliance method	120% rule	—	0.85	no	yes
Busbar #1 main panel upgrade	No	—	0.95	no	yes
Busbar #1 on line side of main service panel	No	—	0.85	no	yes
Busbar #1 panel type	Main Service Panel	—	0.95	no	yes
Busbar #1 rating (Amps)	125	—	0.95	no	yes
Busbar #1 subject to backfeed	Yes	—	0.90	no	yes
Combiner panel contains ESS	No	—	0.60	no	yes
Combiner panel has dedicated OCPD	Yes	—	0.85	no	yes
Combiner panel interconnection location	Main Service Panel	—	0.95	no	yes
Current roof covering material	Asphalt or composition shingles	—	0.95	no	yes
ESS assembly weight (lbs)	291	—	0.90	no	yes
ESS subject to vehicle damage (alternate)	No	—	0.60	no	yes
ESS unit charging from grid	No	—	0.60	no	yes
ESS unit has dedicated OCPD	Yes	—	0.85	no	yes
ESS unit installation location (architecture: Energy Storage System)	Outdoor walls	—	0.70	no	yes
ESS unit interconnection location	Main Service Panel	—	0.85	no	yes
ESS unit is single unit with inverter	Yes	—	0.90	no	yes
ESS unit manufacturer (architecture: Energy Storage System)	Tesla	—	0.95	no	yes
ESS unit model (architecture: Energy Storage System)	Powerwall 3	—	0.90	no	yes
ESS unit OCPD rating (Amps)	60	—	0.90	no	yes
ESS unit quantity (architecture: Energy Storage System)	1	—	0.95	no	yes
ESS units have separation less than 3 feet (alternate)	No	—	0.70	no	yes
Flush mount or tilt-up	Flush mount	—	0.90	no	yes
Home has sprinkler systems	No	—	0.60	no	yes
Homeowner Full Name	Michael McMillin	—	0.95	no	yes
Inverter 1 interconnection location	Main Service Panel	—	0.95	no	yes
Inverter 1 Manufacturer	Tesla	—	0.95	no	yes
Inverter 1 Model Number	1707000-xx-y	—	0.90	no	yes
Inverter 1 OCPD rating (Amps)	60	—	0.95	no	yes
Inverter architecture type	String Inverter without DC-DC Converters	—	0.70	no	yes
Inverter output uses NM cable	No	—	0.80	no	yes
Main breaker derate applied	No	—	0.70	no	yes
Max DC PV Wire / USE-2 conductors in raceway (excl. EGC)	6	—	0.85	no	yes
Max DC THWN-2 conductors in raceway (excl. EGC)	6	—	0.85	no	yes
Maximum distance from module to roof (inches)	7	—	0.60	no	yes
Maximum input DC open circuit voltage (Voc) of PV inverter	550	—	0.85	no	yes
Maximum input DC short circuit current (Isc) of PV inverter	19	—	0.85	no	yes
Maximum number of modules in a DC series string	10	—	0.90	no	yes
Maximum OCPD rating allowed on Inverter 1 (Amps)	60	—	0.90	no	yes
Maximum spacing between adjacent attachment points (inches)	48	—	0.90	no	yes
Module 1 Quantity	40	—	0.95	no	yes
Module fire rating type	2	—	0.85	no	yes
Module is bifacial	No	—	0.85	no	yes
Module Manufacturer	Qcells	—	0.95	no	yes
Module Model Number	Q.TRON BLK M-G2.H+ 430	—	0.95	no	yes
Number of composite shingle layers	1	—	0.90	no	yes
OCPD protecting busbar #1 rating (Amps)	100	—	0.95	no	yes
Project Address	420 Wood Street, Taft, CA 93268	—	0.95	no	yes
Project valuation (USD)	91148	—	0.85	no	yes
PV system weight (lbs/sq ft)	3.0	—	0.50	no	yes
Racking System Manufacturer	Unirac	—	0.95	no	yes
Racking System Model Number	NXT UMOUNT	—	0.90	no	yes
Rafter has ceiling joists	Yes	—	0.50	no	yes
Rafter size (nominal)	2x4	—	0.95	no	yes
Rafter spacing (inches)	24	—	0.95	no	yes
Rafter type	Solid sawn lumber	—	0.70	no	yes
Rapid Shutdown compliance method inside array	PV Hazard Control System (UL 3741)	—	0.70	no	yes
Rapid Shutdown Device Manufacturer	Tesla	—	0.95	no	yes
Rapid Shutdown Device Model Number	MCI-2S	—	0.95	no	yes
Rapid Shutdown Device Quantity	15	—	0.95	no	yes
Roof framing type	Conventional rafter	—	0.70	no	yes
Roof has flat plane	No	—	0.70	no	yes
Roof penetration sealant method name and description	Unirac Stronghold with pre-applied butyl pad attachment	—	0.85	no	yes
Roof pitch	2/12	—	0.70	no	yes
Storage architecture	Energy Storage System	—	0.85	no	yes
Supply side connection per NEC 705.12(A)	No	—	0.85	no	yes
Total roof area (sq ft)	1887	—	0.95	no	yes
Utility available fault current greater than 10 kA at service	No	—	0.60	no	yes
Utility company name	PG&E	—	0.95	no	yes
Utility service feed rating (Amps)	125	—	0.90	no	yes
Whole home backup	Yes	—	0.95	no	yes

Artifacts (3)

Kind	Path	Size	SHA
`asana_json`	/data/runs/01KQT1K3JJAQBEMH8G68E0PNBD/asana.json	42436 B
`pdf`	/data/runs/01KQT1K3JJAQBEMH8G68E0PNBD/pdf/MICHAEL_MCMILLIN_V3._12_23_2025.pdf	9036457 B	0fb85b9a58669029
`extraction`	/data/runs/01KQT1K3JJAQBEMH8G68E0PNBD/extraction.json	35293 B

{
  "run": {
    "id": "01KQT1K3JJAQBEMH8G68E0PNBD",
    "asana_task_gid": "1211970405658455",
    "asana_task_url": "https://app.asana.com/1/1203754389657527/project/1210988794228152/task/1211970405658455",
    "asana_task_title": "Michael MCMILLIN",
    "customer_name": "Michael MCMILLIN",
    "status": "failed",
    "current_stage": "creating_draft",
    "drive_folder_id": "1kDxzFKw4LeOJhHt9rG9ZQ_tt8aVRdslE",
    "drive_cad_folder_id": "1hXShikinB6mnvcHHpkJu7IzOGzblnKy2",
    "plan_set_filename": "MICHAEL MCMILLIN V3._12_23_2025.pdf",
    "bom_filename": null,
    "solarapp_uuid": null,
    "project_url": null,
    "error_stage": "creating_draft",
    "error_message": "SolarAPP+ reports address ineligible: no registered jurisdiction for this address",
    "error_payload": {
      "exception_type": "EligibilityError"
    },
    "ai_token_usage": {
      "input_tokens": 70588,
      "output_tokens": 8181,
      "cache_read_input_tokens": 0,
      "cache_creation_input_tokens": 9992
    },
    "avg_confidence": 0.84,
    "warnings": [
      "Roof pitch derived from 10° tilt — approximated to 2/12.",
      "Module count and inverter differ between Asana (40x 410W Q.PEAK) and plan set (40x 430W Q.TRON, Powerwall 3) — used plan set as authoritative for equipment.",
      "BOM CSV was empty; equipment values pulled from plan set.",
      "Asana lists Powerwall 2 but plan set shows Powerwall 3; trusted plan set.",
      "Module is actually Q.TRON BLK M-G2.H+ 430W per plan set, not Q.PEAK from Asana — discrepancy.",
      "Battery is Powerwall 3 per plan set, not Powerwall 2.0 as listed in Asana custom fields.",
      "Single Powerwall 3 — no separation question really applies; answered 'No' for 'less than 3 feet' since only one unit.",
      "Several optional bool fields (busbar, supply-side, microinverter) skipped as system uses Powerwall 3 string inverter with load-side breaker tie, no microinverters, no supply-side IX."
    ],
    "flow": "v2",
    "iteration_count": 0,
    "iteration_outcome": null,
    "final_diagnosis": null,
    "created_at": "2026-05-04T17:46:48.832067+00:00",
    "updated_at": "2026-05-04T17:48:54.034229+00:00",
    "submitted_at": null,
    "completed_at": null
  },
  "iterations": [],
  "insights": {
    "stuck_rules": [],
    "newly_revealed": [],
    "conditional_triggers": {}
  },
  "audit_log": [
    {
      "id": 441,
      "ts": "2026-05-04T17:46:48.868161+00:00",
      "stage": "extracting",
      "level": "info",
      "message": "Starting v2 intake (always-Opus extraction)",
      "payload": null
    },
    {
      "id": 442,
      "ts": "2026-05-04T17:46:48.882899+00:00",
      "stage": "asana_fetched",
      "level": "info",
      "message": "Resolving Asana task reference 'https://app.asana.com/1/1203754389657527/project/1211568850380857/task/1211970405658455'",
      "payload": null
    },
    {
      "id": 443,
      "ts": "2026-05-04T17:46:49.429601+00:00",
      "stage": "asana_fetched",
      "level": "info",
      "message": "Loaded Asana task: Michael MCMILLIN",
      "payload": {
        "gid": "1211970405658455",
        "title": "Michael MCMILLIN",
        "customer": "Michael MCMILLIN"
      }
    },
    {
      "id": 444,
      "ts": "2026-05-04T17:46:49.437891+00:00",
      "stage": "drive_resolved",
      "level": "info",
      "message": "Searching Asana fields for Google Drive URL",
      "payload": null
    },
    {
      "id": 445,
      "ts": "2026-05-04T17:46:51.086500+00:00",
      "stage": "drive_resolved",
      "level": "info",
      "message": "Resolved Drive folder (5 items, 5 in CAD/)",
      "payload": {
        "folder_id": "1kDxzFKw4LeOJhHt9rG9ZQ_tt8aVRdslE",
        "cad_folder_id": "1hXShikinB6mnvcHHpkJu7IzOGzblnKy2"
      }
    },
    {
      "id": 446,
      "ts": "2026-05-04T17:46:51.093186+00:00",
      "stage": "pdf_downloaded",
      "level": "info",
      "message": "Picking the latest-dated plan-set PDF",
      "payload": null
    },
    {
      "id": 447,
      "ts": "2026-05-04T17:46:53.345359+00:00",
      "stage": "pdf_downloaded",
      "level": "info",
      "message": "Downloaded plan-set: MICHAEL MCMILLIN V3._12_23_2025.pdf (8.6 MB)",
      "payload": {
        "bytes": 9036457,
        "filename": "MICHAEL MCMILLIN V3._12_23_2025.pdf"
      }
    },
    {
      "id": 448,
      "ts": "2026-05-04T17:46:53.351839+00:00",
      "stage": "bom_downloaded",
      "level": "info",
      "message": "Looking for the BOM CSV in the same folder",
      "payload": null
    },
    {
      "id": 449,
      "ts": "2026-05-04T17:46:53.364306+00:00",
      "stage": "bom_downloaded",
      "level": "warn",
      "message": "No BOM CSV in folder — modules section will rely on PDF + Asana only",
      "payload": null
    },
    {
      "id": 450,
      "ts": "2026-05-04T17:46:53.370866+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracting text from the plan-set PDF",
      "payload": null
    },
    {
      "id": 451,
      "ts": "2026-05-04T17:46:59.104066+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1/2: Claude Opus 4.7 (full extraction)",
      "payload": null
    },
    {
      "id": 452,
      "ts": "2026-05-04T17:48:12.945999+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1: Opus filled 60 fields (avg 88%)",
      "payload": null
    },
    {
      "id": 453,
      "ts": "2026-05-04T17:48:12.962608+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 2/2: Claude Opus 4.7 retrying 37 missing fields",
      "payload": null
    },
    {
      "id": 454,
      "ts": "2026-05-04T17:48:51.747180+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracted 77 fields, avg confidence 84% (Opus: 60, Opus retry: +17, 20 still unfilled)",
      "payload": {
        "usage": {
          "input_tokens": 70588,
          "output_tokens": 8181,
          "cache_read_input_tokens": 0,
          "cache_creation_input_tokens": 9992
        },
        "fields": 77,
        "passes": {
          "opus_full": 60,
          "opus_retry": 17
        },
        "missing": 20,
        "extra_fields": 0,
        "avg_confidence": 0.84
      }
    },
    {
      "id": 455,
      "ts": "2026-05-04T17:48:51.964498+00:00",
      "stage": "creating_draft",
      "level": "info",
      "message": "Creating draft in SolarAPP+ (sandbox)",
      "payload": null
    }
  ],
  "field_values": [
    {
      "payload_key": "Attachment points staggered",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": "Standard practice for Unirac Stronghold attachments at 48\" O.C. on rafters; staggered pattern typical though not explicitly stated.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Backup contains service disconnect",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Tesla Backup Switch installed behind utility meter functions as service disconnect for backup.",
      "source_excerpt": "(N) TESLA BACKUP SWITCH (MICROGRID INTERCONNECTION DEVICE)",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Backup device manufacturer",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "(N) TESLA BACKUP SWITCH",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Backup device model",
      "source": "pdf",
      "raw_value": "Backup Switch",
      "ai_value": "Backup Switch",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "TESLA BACKUP SWITCH (MICROGRID INTERCONNECTION DEVICE)",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Backup feeder conductor material",
      "source": "pdf",
      "raw_value": "Copper",
      "ai_value": "Copper",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Plan set notes",
      "source_excerpt": "ALL CONDUCTORS COPPER",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Busbar #1 already present on site",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Existing main service panel",
      "source_excerpt": "(E) 125A MAIN SERVICE PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Busbar #1 interconnection compliance method",
      "source": "pdf",
      "raw_value": "120% rule",
      "ai_value": "120% rule",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "120% rule calculation shown",
      "source_excerpt": "125X1.20=150 BUS RATING x 120%",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Busbar #1 main panel upgrade",
      "source": "asana",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Asana custom field",
      "source_excerpt": "MPU: N",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Busbar #1 on line side of main service panel",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "PV breaker is on load side of main breaker (load-side interconnection).",
      "source_excerpt": "INTERCONNECTION: PV BREAKER TIE IN MSP",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Busbar #1 panel type",
      "source": "pdf",
      "raw_value": "Main Service Panel",
      "ai_value": "Main Service Panel",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "MSP interconnection",
      "source_excerpt": "PV BREAKER TIE IN MSP",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Busbar #1 rating (Amps)",
      "source": "pdf",
      "raw_value": "125",
      "ai_value": "125",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "MSP busbar rating",
      "source_excerpt": "(E) 125A MAIN SERVICE PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Busbar #1 subject to backfeed",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "PV backfed into MSP busbar",
      "source_excerpt": "PV BREAKER TIE IN MSP",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Combiner panel contains ESS",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Interconnection is at MSP via PV breaker; ESS (Powerwall 3) is separate equipment, not in combiner panel.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Combiner panel has dedicated OCPD",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Dedicated 60A PV breaker in MSP for the combined inverter/ESS output.",
      "source_excerpt": "60A(N) 60A PV BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Combiner panel interconnection location",
      "source": "pdf",
      "raw_value": "Main Service Panel",
      "ai_value": "Main Service Panel",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set explicitly states interconnection at MSP.",
      "source_excerpt": "INTERCONNECTION: PV BREAKER TIE IN MSP",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Current roof covering material",
      "source": "pdf",
      "raw_value": "Asphalt or composition shingles",
      "ai_value": "Asphalt or composition shingles",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Composition shingle roof",
      "source_excerpt": "ROOF TYPE: COMP. SHINGLE ROOF (MAIN HOME)",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS assembly weight (lbs)",
      "source": "pdf",
      "raw_value": "291",
      "ai_value": "291",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Single Powerwall 3 weight from datasheet.",
      "source_excerpt": "Total Weight of Installed Unit 132 kg (291.2 lb)",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS subject to vehicle damage (alternate)",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "ESS located on north outside wall of dwelling, not in driveway path; standard residential install.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS unit charging from grid",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "PG&E NEM/SGIP residential install typically solar-only charging; placard suggests storage not charging from grid.",
      "source_excerpt": "PRODUCERS STORAGE DEVICE(S) WILL NOT CAUSE THE HOST LOAD TO EXCEED ITS NORMAL PEAK DEMAND",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS unit has dedicated OCPD",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Dedicated 60A breaker",
      "source_excerpt": "(N) 60A PV BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS unit installation location (architecture: Energy Storage System)",
      "source": "pdf",
      "raw_value": "Outdoor walls",
      "ai_value": "Outdoor walls",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Outside wall installation",
      "source_excerpt": "LOCATION OF AC DISCONNECTS: NORTH OUTSIDE WALL",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS unit interconnection location",
      "source": "pdf",
      "raw_value": "Main Service Panel",
      "ai_value": "Main Service Panel",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Tied via MSP",
      "source_excerpt": "PV BREAKER TIE IN MSP",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS unit is single unit with inverter",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Powerwall 3 is integrated inverter+battery",
      "source_excerpt": "INVERTER/ENERGY STORAGE SYSTEM",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS unit manufacturer (architecture: Energy Storage System)",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "TESLA POWERWALL 3",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS unit model (architecture: Energy Storage System)",
      "source": "pdf",
      "raw_value": "Powerwall 3",
      "ai_value": "Powerwall 3",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "TESLA POWERWALL 3 11.5KW/ 13.5KWH 1707000-XX-Y",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS unit OCPD rating (Amps)",
      "source": "pdf",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Plan set",
      "source_excerpt": "(N) 60A PV BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS unit quantity (architecture: Energy Storage System)",
      "source": "pdf",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "(N) 1- TESLA POWERWALL 3",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "ESS units have separation less than 3 feet (alternate)",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Only one Powerwall 3 in this design; note enforces ≥3' separation. Single unit—not less than 3'.",
      "source_excerpt": "MULTIPLE ESS SYSTEMS SHALL BE SEPARATED FROM EACH OTHER BY AT LEAST 3'",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Flush mount or tilt-up",
      "source": "pdf",
      "raw_value": "Flush mount",
      "ai_value": "Flush mount",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Roof mount with rails parallel to roof",
      "source_excerpt": "PHOTOVOLTAIC ROOF MOUNT SYSTEM",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Home has sprinkler systems",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Existing residence in Taft, CA with comp shingle roof; residential sprinklers uncommon for older homes; not mentioned in plans.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Homeowner Full Name",
      "source": "asana",
      "raw_value": "Michael McMillin",
      "ai_value": "Michael McMillin",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Asana task name and notes",
      "source_excerpt": "Customer Name: Michael MCMILLIN / Mike MCMILLIN",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Inverter 1 interconnection location",
      "source": "pdf",
      "raw_value": "Main Service Panel",
      "ai_value": "Main Service Panel",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set states MSP tie-in",
      "source_excerpt": "INTERCONNECTION: PV BREAKER TIE IN MSP",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Inverter 1 Manufacturer",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Powerwall 3 functions as inverter",
      "source_excerpt": "TESLA POWERWALL 3 11.5KW/ 13.5KWH 1707000-XX-Y INVERTER",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Inverter 1 Model Number",
      "source": "pdf",
      "raw_value": "1707000-xx-y",
      "ai_value": "1707000-xx-y",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Powerwall 3 model",
      "source_excerpt": "Model Number 1707000-xx-y",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Inverter 1 OCPD rating (Amps)",
      "source": "pdf",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "60A backfeed breaker on plan set",
      "source_excerpt": "(N) 60A PV BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Inverter architecture type",
      "source": "inferred",
      "raw_value": "String Inverter without DC-DC Converters",
      "ai_value": "String Inverter without DC-DC Converters",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Powerwall 3 has 6 MPPTs; strings + MCI rapid shutdown devices, no DC-DC optimizers per module",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Inverter output uses NM cable",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.8,
      "edited": false,
      "reasoning": "AC output from inverter to disconnect uses THWN-2 in EMT/PVC, not NM cable.",
      "source_excerpt": "3/4\" EMT/PVC CONDUIT RUN ... 6 AWG THWN-2 COPPER",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Main breaker derate applied",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "120% rule used instead of derate",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Max DC PV Wire / USE-2 conductors in raceway (excl. EGC)",
      "source": "pdf",
      "raw_value": "6",
      "ai_value": "6",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Largest PV wire raceway count",
      "source_excerpt": "DC MCI TO JUNCTION BOX #2 6- 10 AWG PV WIRE",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Max DC THWN-2 conductors in raceway (excl. EGC)",
      "source": "pdf",
      "raw_value": "6",
      "ai_value": "6",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Largest THWN-2 DC raceway",
      "source_excerpt": "DC JUNCTION BOX#2 TO INVERTER/BATTERY 6 ... 10 AWG THWN-2",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Maximum distance from module to roof (inches)",
      "source": "pdf",
      "raw_value": "7",
      "ai_value": "7",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Standard flush mount with rail; estimated",
      "source_excerpt": "3/4\" EMT CONDUIT RUN 7/8\" ABOVE ROOF",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Maximum input DC open circuit voltage (Voc) of PV inverter",
      "source": "pdf",
      "raw_value": "550",
      "ai_value": "550",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Powerwall 3 datasheet PV input range max",
      "source_excerpt": "PV DC Input Voltage Range 60 — 550 V DC",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Maximum input DC short circuit current (Isc) of PV inverter",
      "source": "pdf",
      "raw_value": "19",
      "ai_value": "19",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Powerwall 3 spec",
      "source_excerpt": "Maximum Short Circuit Current per MPPT (Isc) 19 A",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Maximum number of modules in a DC series string",
      "source": "pdf",
      "raw_value": "10",
      "ai_value": "10",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Largest string from line diagram",
      "source_excerpt": "(01) STRING OF 10 MODULES",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Maximum OCPD rating allowed on Inverter 1 (Amps)",
      "source": "pdf",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Powerwall 3 spec for 11.5kW model",
      "source_excerpt": "Overcurrent Protection Device 60 A",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Maximum spacing between adjacent attachment points (inches)",
      "source": "pdf",
      "raw_value": "48",
      "ai_value": "48",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Stated on plan set",
      "source_excerpt": "UNIRAC STRONGHOLD W/ BUTYL ATTACHMENTS @ 48\" O.C MAX",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Module 1 Quantity",
      "source": "pdf",
      "raw_value": "40",
      "ai_value": "40",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "(N) 40- QCELLS: Q.TRON BLK M-G2.H+ 430",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Module fire rating type",
      "source": "pdf",
      "raw_value": "2",
      "ai_value": "2",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Module datasheet shows Type 2",
      "source_excerpt": "Fire Rating based on ANSI/UL 61730 C / TYPE 2",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Module is bifacial",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Q.TRON BLK has composite film back, not bifacial",
      "source_excerpt": "Back Cover Composite film",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Module Manufacturer",
      "source": "pdf",
      "raw_value": "Qcells",
      "ai_value": "Qcells",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "QCELLS: Q.TRON BLK M-G2.H+ 430 (430W)",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Module Model Number",
      "source": "pdf",
      "raw_value": "Q.TRON BLK M-G2.H+ 430",
      "ai_value": "Q.TRON BLK M-G2.H+ 430",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "QCELLS: Q.TRON BLK M-G2.H+ 430 (430W)",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Number of composite shingle layers",
      "source": "pdf",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Stated in design criteria",
      "source_excerpt": "NUMBER OF LAYERS: -01",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "OCPD protecting busbar #1 rating (Amps)",
      "source": "pdf",
      "raw_value": "100",
      "ai_value": "100",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Main breaker rating",
      "source_excerpt": "(E) 100A MAIN BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Project Address",
      "source": "asana",
      "raw_value": "420 Wood Street, Taft, CA 93268",
      "ai_value": "420 Wood Street, Taft, CA 93268",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Asana custom fields Street/City/State; PDF confirms 420 WOOD ST, TAFT, CA 93268",
      "source_excerpt": "Street: 420 Wood Street, City: Taft, State: CA",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Project valuation (USD)",
      "source": "asana",
      "raw_value": "91148",
      "ai_value": "91148",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Contract amount from Asana",
      "source_excerpt": "Contract Amount: 91148.71",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "PV system weight (lbs/sq ft)",
      "source": "inferred",
      "raw_value": "3.0",
      "ai_value": "3.0",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": "Typical residential PV roof-mount system weight ~3 psf including modules and racking.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Racking System Manufacturer",
      "source": "pdf",
      "raw_value": "Unirac",
      "ai_value": "Unirac",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM specifies Unirac",
      "source_excerpt": "(N) UNIRAC NXT UMOUNT RAIL 168\" RAIL",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Racking System Model Number",
      "source": "pdf",
      "raw_value": "NXT UMOUNT",
      "ai_value": "NXT UMOUNT",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Model from plan set",
      "source_excerpt": "UNIRAC NXT UMOUNT RAIL",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Rafter has ceiling joists",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": "2x4 rafters at 24\" O.C. on a typical residential home in Taft, CA usually have ceiling joists for ceiling support.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Rafter size (nominal)",
      "source": "pdf",
      "raw_value": "2x4",
      "ai_value": "2x4",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set design criteria",
      "source_excerpt": "2X4 RAFTER @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Rafter spacing (inches)",
      "source": "pdf",
      "raw_value": "24",
      "ai_value": "24",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set design criteria",
      "source_excerpt": "2X4 RAFTER @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Rafter type",
      "source": "pdf",
      "raw_value": "Solid sawn lumber",
      "ai_value": "Solid sawn lumber",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "2x4 rafter implies solid sawn",
      "source_excerpt": "ROOF FRAME: 2X4 RAFTER @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Rapid Shutdown compliance method inside array",
      "source": "pdf",
      "raw_value": "PV Hazard Control System (UL 3741)",
      "ai_value": "PV Hazard Control System (UL 3741)",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "MCI-2S is UL 3741 certified",
      "source_excerpt": "Certifications UL 1741 PVRSE, UL 3741, PVRSA",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Manufacturer",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "TESLA MCI-2S (RAPID SHUTDOWN DEVICE)",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Model Number",
      "source": "pdf",
      "raw_value": "MCI-2S",
      "ai_value": "MCI-2S",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "TESLA MCI-2S",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Quantity",
      "source": "pdf",
      "raw_value": "15",
      "ai_value": "15",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set BOM",
      "source_excerpt": "(N) 15- TESLA MCI-2S",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Roof framing type",
      "source": "pdf",
      "raw_value": "Conventional rafter",
      "ai_value": "Conventional rafter",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Inferred from rafter spec",
      "source_excerpt": "2X4 RAFTER @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Roof has flat plane",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Roof has 10° pitch, not flat (flat is typically <2°).",
      "source_excerpt": "ROOFTILT 10°",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Roof penetration sealant method name and description",
      "source": "pdf",
      "raw_value": "Unirac Stronghold with pre-applied butyl pad attachment",
      "ai_value": "Unirac Stronghold with pre-applied butyl pad attachment",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Stronghold butyl attachment used per plan set",
      "source_excerpt": "(N) UNIRAC STRONGHOLD W/ BUTYL ATTACHMENTS",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Roof pitch",
      "source": "pdf",
      "raw_value": "2/12",
      "ai_value": "2/12",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "10 degree tilt approximates ~2/12 pitch (tan(10°)≈0.176)",
      "source_excerpt": "ROOF TILT 10°",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Storage architecture",
      "source": "pdf",
      "raw_value": "Energy Storage System",
      "ai_value": "Energy Storage System",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "AC-coupled ESS",
      "source_excerpt": "TESLA POWERWALL 3 ... INVERTER/ENERGY STORAGE SYSTEM",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Supply side connection per NEC 705.12(A)",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Load-side breaker tie, not supply side",
      "source_excerpt": "INTERCONNECTION: PV BREAKER TIE IN MSP",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Total roof area (sq ft)",
      "source": "pdf",
      "raw_value": "1887",
      "ai_value": "1887",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set lists total roof plan area as 1887.04 sq ft.",
      "source_excerpt": "AREA OF ROOF (PLAN VIEW) 1887.04",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Utility available fault current greater than 10 kA at service",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Typical residential 125A service in PG&E territory has available fault current <10 kA; Powerwall 3 SCCR is 10 kA which is standard for residential.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Utility company name",
      "source": "asana",
      "raw_value": "PG&E",
      "ai_value": "PG&E",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Asana custom field",
      "source_excerpt": "Utility: PG&E",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Utility service feed rating (Amps)",
      "source": "pdf",
      "raw_value": "125",
      "ai_value": "125",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "MSP is 125A",
      "source_excerpt": "(E) 125A MAIN SERVICE PANEL WITH (E) 100A MAIN BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    },
    {
      "payload_key": "Whole home backup",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Plan set states whole home backup",
      "source_excerpt": "BATTERY CONFIGURATION: WHOLE HOME BACKUP",
      "in_field_map": true,
      "updated_at": "2026-05-04T17:48:51.754200+00:00"
    }
  ],
  "artifacts": [
    {
      "id": 89,
      "kind": "asana_json",
      "local_path": "/data/runs/01KQT1K3JJAQBEMH8G68E0PNBD/asana.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 42436,
      "downloaded_at": "2026-05-04T17:46:49.413641+00:00"
    },
    {
      "id": 90,
      "kind": "pdf",
      "local_path": "/data/runs/01KQT1K3JJAQBEMH8G68E0PNBD/pdf/MICHAEL_MCMILLIN_V3._12_23_2025.pdf",
      "drive_file_id": "1vd1dM6DmIZwgXTi8VJ1LpXaqFOy7_BaD",
      "sha256": "0fb85b9a5866902975ab74b934d3a71e2ee0623002c69b702adcec0f3f084101",
      "bytes": 9036457,
      "downloaded_at": "2026-05-04T17:46:53.331651+00:00"
    },
    {
      "id": 91,
      "kind": "extraction",
      "local_path": "/data/runs/01KQT1K3JJAQBEMH8G68E0PNBD/extraction.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 35293,
      "downloaded_at": "2026-05-04T17:48:51.738650+00:00"
    }
  ],
  "has_final_patch": false,
  "final_patch_field_count": 0,
  "_meta": {
    "collected_at": "2026-05-06T21:25:38.128494+00:00",
    "iteration_count": 0,
    "audit_log_count": 15,
    "field_values_count": 77,
    "artifacts_count": 3,
    "has_final_patch": false
  }
}