← back to audit · 01KQJ3Q20WJ5ZQRYBTMK7RF8GV

Alex Smith

Asana ↗ v1 awaiting_review stage=awaiting_review iters=0 conf=70%

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 (16 events)

#	Level	Stage	Message	Time
315	info	asana_fetched	Resolving Asana task reference 'https://app.asana.com/1/1203754389657527/project/1208103004469323/task/1214148579995773?focus=true'	2026-05-01T15:50:00
316	info	asana_fetched	Loaded Asana task: Alex Smith payload { "customer": "Alex Smith", "gid": "1214148579995773", "title": "Alex Smith" }	2026-05-01T15:50:00
317	info	drive_resolved	Searching Asana fields for Google Drive URL	2026-05-01T15:50:00
318	info	drive_resolved	Resolved Drive folder (5 items, 4 in CAD/) payload { "cad_folder_id": "1oTjQF8uFQAPo5RLe5OaR8QLECYmaEs5m", "folder_id": "1QTCv4OaclqjT46G-rSDQYCR85uA5U3nO" }	2026-05-01T15:50:01
319	info	pdf_downloaded	Picking the latest-dated plan-set PDF	2026-05-01T15:50:01
320	info	pdf_downloaded	Downloaded plan-set: Shade Report - Alex Smith - LGCY Design.pdf (1.1 MB) payload { "bytes": 1189415, "filename": "Shade Report - Alex Smith - LGCY Design.pdf" }	2026-05-01T15:50:02
321	info	bom_downloaded	Looking for the BOM CSV in the same folder	2026-05-01T15:50:02
322	info	bom_downloaded	Downloaded BOM: BOM_LIS56635.csv (18 rows) payload { "filename": "BOM_LIS56635.csv", "rows": 18 }	2026-05-01T15:50:03
323	info	ai_extracted	Extracting text from the plan-set PDF	2026-05-01T15:50:03
324	info	ai_extracted	Pass 1/3: Claude Opus 4.7 (full extraction)	2026-05-01T15:50:03
325	info	ai_extracted	Pass 1: Opus filled 24 fields (avg 87%)	2026-05-01T15:50:31
326	info	ai_extracted	Pass 2/3: Claude Sonnet 4.6 retrying 73 missing fields	2026-05-01T15:50:31
327	info	ai_extracted	Pass 2: Sonnet added 60 more fields	2026-05-01T15:51:53
328	info	ai_extracted	Pass 3/3: Claude Opus 4.7 final retry on 13 stubborn fields	2026-05-01T15:51:53
329	info	ai_extracted	Extracted 88 fields, avg confidence 70% (Opus: 24, Sonnet retry: +60, Opus retry: +4, 9 still unfilled) payload { "avg_confidence": 0.701, "extra_fields": 0, "fields": 88, "missing": 9, "passes": { "opus_full": 24, "opus_retry": 4, "sonnet_retry": 60 }, "usage": { "cache_creation_input_tokens": 9992, "cache_read_input_tokens": 0, "input_tokens": 29143, "output_tokens": 9197 } }	2026-05-01T15:52:01
330	info	awaiting_review	Pipeline complete — review the extracted fields and submit when ready	2026-05-01T15:52:01

Field values (88)

▸ Show all extracted + edited fields

Key	AI value	User value	Conf	Edited	In map
Attachment points staggered	Yes	—	0.60	no	yes
Backup contains service disconnect	Yes	—	0.80	no	yes
Backup device manufacturer	Tesla	—	0.95	no	yes
Backup device model	Backup Switch	—	0.95	no	yes
Backup device OCPD rating (Amps)	60	—	0.65	no	yes
Backup feeder conductor material	Copper	—	0.65	no	yes
Busbar #1 already present on site	Yes	—	0.75	no	yes
Busbar #1 interconnection compliance method	120% rule	—	0.60	no	yes
Busbar #1 main panel upgrade	No	—	0.45	no	yes
Busbar #1 number of branch circuit breakers	24	—	0.60	no	yes
Busbar #1 on line side of main service panel	No	—	0.65	no	yes
Busbar #1 panel type	Main Service Panel	—	0.65	no	yes
Busbar #1 rating (Amps)	200	—	0.50	no	yes
Busbar #1 subject to backfeed	Yes	—	0.80	no	yes
Busbar feeder interconnection compliance method	120% rule	—	0.55	no	yes
Busbar feeder OCPD rating (Amps)	60	—	0.70	no	yes
Combiner panel contains ESS	Yes	—	0.75	no	yes
Combiner panel has dedicated OCPD	Yes	—	0.70	no	yes
Combiner panel interconnection location	Main Service Panel	—	0.65	no	yes
Current roof covering material	Asphalt or composition shingles	—	0.70	no	yes
DC-coupled battery manufacturer	Tesla	—	0.85	no	yes
DC-coupled battery model	Powerwall 3	—	0.85	no	yes
DC-coupled battery quantity	1	—	0.90	no	yes
ESS assembly weight (lbs)	287	—	0.70	no	yes
ESS subject to vehicle damage (alternate)	No	—	0.45	no	yes
ESS unit charging from grid	Yes	—	0.85	no	yes
ESS unit has dedicated OCPD	Yes	—	0.70	no	yes
ESS unit installation location (architecture: Energy Storage System)	Garage (interior)	—	0.40	no	yes
ESS unit interconnection location	Main Service Panel	—	0.65	no	yes
ESS unit is single unit with inverter	Yes	—	0.85	no	yes
ESS unit manufacturer (architecture: Energy Storage System)	Tesla	—	0.95	no	yes
ESS unit model (architecture: Energy Storage System)	Powerwall 3	—	0.95	no	yes
ESS unit OCPD rating (Amps)	60	—	0.70	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.55	no	yes
Flush mount or tilt-up	Flush mount	—	0.70	no	yes
Home has sprinkler systems	No	—	0.40	no	yes
Homeowner Full Name	Alex Smith	—	0.95	no	yes
Inverter 1 interconnection location	Main Service Panel	—	0.65	no	yes
Inverter 1 Manufacturer	Tesla	—	0.90	no	yes
Inverter 1 Model Number	Powerwall 3	—	0.85	no	yes
Inverter 1 OCPD rating (Amps)	60	—	0.65	no	yes
Inverter architecture type	String Inverter with DC-DC Converters	—	0.60	no	yes
Inverter output uses NM cable	No	—	0.55	no	yes
Main breaker derate applied	No	—	0.50	no	yes
Max DC PV Wire / USE-2 conductors in raceway (excl. EGC)	2	—	0.60	no	yes
Max DC THWN-2 conductors in raceway (excl. EGC)	2	—	0.60	no	yes
Maximum distance from module to roof (inches)	10	—	0.55	no	yes
Maximum input DC open circuit voltage (Voc) of PV inverter	600	—	0.60	no	yes
Maximum input DC short circuit current (Isc) of PV inverter	15	—	0.50	no	yes
Maximum number of modules in a DC series string	1	—	0.80	no	yes
Maximum OCPD rating allowed on Inverter 1 (Amps)	60	—	0.60	no	yes
Maximum spacing between adjacent attachment points (inches)	48	—	0.60	no	yes
Max microinverters per branch circuit	6	—	0.55	no	yes
Microinverter module capacity (W)	410	—	0.90	no	yes
Microinverters protected by 20A OCPD	Yes	—	0.70	no	yes
Microinverter total quantity	3	—	0.90	no	yes
Module 1 Quantity	8	—	0.95	no	yes
Module fire rating type	1	—	0.80	no	yes
Module is bifacial	No	—	0.85	no	yes
Module Manufacturer	Hanwha Q CELLS	—	0.95	no	yes
Module Model Number	Q.PEAK DUO BLK ML-G10.C+ 410	—	0.95	no	yes
Number of composite shingle layers	1	—	0.60	no	yes
OCPD protecting busbar #1 rating (Amps)	200	—	0.50	no	yes
Project Address	2355 Pelham Pl, Oakland, CA	—	0.55	no	yes
Project valuation (USD)	24968	—	0.85	no	yes
PV system weight (lbs/sq ft)	4.0	—	0.60	no	yes
Racking System Manufacturer	SnapNrack	—	0.95	no	yes
Racking System Model Number	Ultra Rail UR-45	—	0.85	no	yes
Rafter has ceiling joists	Yes	—	0.50	no	yes
Rafter size (nominal)	2x6	—	0.45	no	yes
Rafter spacing (inches)	24	—	0.50	no	yes
Rafter type	Solid sawn lumber	—	0.55	no	yes
Rapid Shutdown compliance method inside array	Module-level power electronics (MLPE)	—	0.85	no	yes
Rapid Shutdown Device Manufacturer	Tesla	—	0.85	no	yes
Rapid Shutdown Device Model Number	MCI-2	—	0.90	no	yes
Rapid Shutdown Device Quantity	3	—	0.90	no	yes
Roof framing type	Conventional rafter	—	0.55	no	yes
Roof has flat plane	No	—	0.60	no	yes
Roof penetration sealant method name and description	Flashing with butyl sealant	—	0.60	no	yes
Roof pitch	4/12	—	0.40	no	yes
Storage architecture	Energy Storage System	—	0.85	no	yes
Supply side connection per NEC 705.12(A)	No	—	0.65	no	yes
Total roof area (sq ft)	800	—	0.35	no	yes
Utility available fault current greater than 10 kA at service	Yes	—	0.70	no	yes
Utility company name	PG&E	—	0.90	no	yes
Utility service feed rating (Amps)	200	—	0.60	no	yes
Whole home backup	Yes	—	0.95	no	yes

Artifacts (4)

Kind	Path	Size	SHA
`asana_json`	/data/runs/01KQJ3Q20WJ5ZQRYBTMK7RF8GV/asana.json	55787 B
`pdf`	/data/runs/01KQJ3Q20WJ5ZQRYBTMK7RF8GV/pdf/Shade_Report_-_Alex_Smith_-_LGCY_Design.pdf	1189415 B	beab15fef1fa4910
`bom`	/data/runs/01KQJ3Q20WJ5ZQRYBTMK7RF8GV/bom/BOM_LIS56635.csv	1939 B	9b27a150e1480a27
`extraction`	/data/runs/01KQJ3Q20WJ5ZQRYBTMK7RF8GV/extraction.json	34557 B

{
  "run": {
    "id": "01KQJ3Q20WJ5ZQRYBTMK7RF8GV",
    "asana_task_gid": "1214148579995773",
    "asana_task_url": "https://app.asana.com/1/1203754389657527/project/1207873459369363/task/1214148579995773",
    "asana_task_title": "Alex Smith",
    "customer_name": "Alex Smith",
    "status": "awaiting_review",
    "current_stage": "awaiting_review",
    "drive_folder_id": "1QTCv4OaclqjT46G-rSDQYCR85uA5U3nO",
    "drive_cad_folder_id": "1oTjQF8uFQAPo5RLe5OaR8QLECYmaEs5m",
    "plan_set_filename": "Shade Report - Alex Smith - LGCY Design.pdf",
    "bom_filename": "BOM_LIS56635.csv",
    "solarapp_uuid": null,
    "project_url": null,
    "error_stage": null,
    "error_message": null,
    "error_payload": null,
    "ai_token_usage": {
      "input_tokens": 29143,
      "output_tokens": 9197,
      "cache_read_input_tokens": 0,
      "cache_creation_input_tokens": 9992
    },
    "avg_confidence": 0.701,
    "warnings": [
      "Plan set PDF was image-only; no roof geometry, pitch, OCPD ratings, or electrical specs available. Most racking, electrical, and roof fields skipped.",
      "Project Address ZIP is missing; only street/city/state available from Asana.",
      "Tesla Powerwall 3 treated as single-unit ESS+inverter; inverter architecture inferred.",
      "Plan-set PDF was image-only — no extractable text. All structural, electrical, and roof geometry values are inferred from BOM, Asana metadata, and standard residential construction norms for Oakland CA.",
      "Tesla MCI-2 is a module-level microinverter integrated with the Powerwall 3 system. The system uses 3x MCI-2 units with 8x 410W Q-Cells modules — reviewer should confirm whether all 8 modules connect to 3 MCI-2 units or if there is a discrepancy.",
      "MPU is listed as TBC in Asana — busbar upgrade and rating should be verified once MPU decision is finalized.",
      "Roof pitch, rafter size/spacing, and total roof area are estimates only and must be verified against the actual plan set images.",
      "ESS installation location (garage vs. outdoor/interior wall) must be confirmed from site survey or plan set images.",
      "Project has Tesla Powerwall 3 in Whole Home Backup configuration with Tesla Backup Switch — backup-related fields populated accordingly.",
      "Plan-set PDF was image-only; could not extract rafter span, busbar/feeder, or supply-side IX details.",
      "Battery is Tesla Powerwall 3 — the PW3 is commonly classified as AC-coupled at the system level, but it does have an integrated DC-coupled PV inverter; classification depends on SolarAPP+ convention. Reviewer should verify whether to treat as DC-coupled here.",
      "Project valuation rounded down from $24,968.34."
    ],
    "flow": "v1",
    "iteration_count": 0,
    "iteration_outcome": null,
    "final_diagnosis": null,
    "created_at": "2026-05-01T15:49:59.986388+00:00",
    "updated_at": "2026-05-01T15:52:01.774040+00:00",
    "submitted_at": null,
    "completed_at": null
  },
  "iterations": [],
  "insights": {
    "stuck_rules": [],
    "newly_revealed": [],
    "conditional_triggers": {}
  },
  "audit_log": [
    {
      "id": 315,
      "ts": "2026-05-01T15:50:00.116271+00:00",
      "stage": "asana_fetched",
      "level": "info",
      "message": "Resolving Asana task reference 'https://app.asana.com/1/1203754389657527/project/1208103004469323/task/1214148579995773?focus=true'",
      "payload": null
    },
    {
      "id": 316,
      "ts": "2026-05-01T15:50:00.625491+00:00",
      "stage": "asana_fetched",
      "level": "info",
      "message": "Loaded Asana task: Alex Smith",
      "payload": {
        "gid": "1214148579995773",
        "title": "Alex Smith",
        "customer": "Alex Smith"
      }
    },
    {
      "id": 317,
      "ts": "2026-05-01T15:50:00.633202+00:00",
      "stage": "drive_resolved",
      "level": "info",
      "message": "Searching Asana fields for Google Drive URL",
      "payload": null
    },
    {
      "id": 318,
      "ts": "2026-05-01T15:50:01.783511+00:00",
      "stage": "drive_resolved",
      "level": "info",
      "message": "Resolved Drive folder (5 items, 4 in CAD/)",
      "payload": {
        "folder_id": "1QTCv4OaclqjT46G-rSDQYCR85uA5U3nO",
        "cad_folder_id": "1oTjQF8uFQAPo5RLe5OaR8QLECYmaEs5m"
      }
    },
    {
      "id": 319,
      "ts": "2026-05-01T15:50:01.790676+00:00",
      "stage": "pdf_downloaded",
      "level": "info",
      "message": "Picking the latest-dated plan-set PDF",
      "payload": null
    },
    {
      "id": 320,
      "ts": "2026-05-01T15:50:02.850786+00:00",
      "stage": "pdf_downloaded",
      "level": "info",
      "message": "Downloaded plan-set: Shade Report - Alex Smith - LGCY Design.pdf (1.1 MB)",
      "payload": {
        "bytes": 1189415,
        "filename": "Shade Report - Alex Smith - LGCY Design.pdf"
      }
    },
    {
      "id": 321,
      "ts": "2026-05-01T15:50:02.858558+00:00",
      "stage": "bom_downloaded",
      "level": "info",
      "message": "Looking for the BOM CSV in the same folder",
      "payload": null
    },
    {
      "id": 322,
      "ts": "2026-05-01T15:50:03.605287+00:00",
      "stage": "bom_downloaded",
      "level": "info",
      "message": "Downloaded BOM: BOM_LIS56635.csv (18 rows)",
      "payload": {
        "rows": 18,
        "filename": "BOM_LIS56635.csv"
      }
    },
    {
      "id": 323,
      "ts": "2026-05-01T15:50:03.611928+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracting text from the plan-set PDF",
      "payload": null
    },
    {
      "id": 324,
      "ts": "2026-05-01T15:50:03.850303+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1/3: Claude Opus 4.7 (full extraction)",
      "payload": null
    },
    {
      "id": 325,
      "ts": "2026-05-01T15:50:31.649032+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1: Opus filled 24 fields (avg 87%)",
      "payload": null
    },
    {
      "id": 326,
      "ts": "2026-05-01T15:50:31.664666+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 2/3: Claude Sonnet 4.6 retrying 73 missing fields",
      "payload": null
    },
    {
      "id": 327,
      "ts": "2026-05-01T15:51:53.325628+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 2: Sonnet added 60 more fields",
      "payload": null
    },
    {
      "id": 328,
      "ts": "2026-05-01T15:51:53.340705+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 3/3: Claude Opus 4.7 final retry on 13 stubborn fields",
      "payload": null
    },
    {
      "id": 329,
      "ts": "2026-05-01T15:52:01.766215+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracted 88 fields, avg confidence 70% (Opus: 24, Sonnet retry: +60, Opus retry: +4, 9 still unfilled)",
      "payload": {
        "usage": {
          "input_tokens": 29143,
          "output_tokens": 9197,
          "cache_read_input_tokens": 0,
          "cache_creation_input_tokens": 9992
        },
        "fields": 88,
        "passes": {
          "opus_full": 24,
          "opus_retry": 4,
          "sonnet_retry": 60
        },
        "missing": 9,
        "extra_fields": 0,
        "avg_confidence": 0.701
      }
    },
    {
      "id": 330,
      "ts": "2026-05-01T15:52:01.780536+00:00",
      "stage": "awaiting_review",
      "level": "info",
      "message": "Pipeline complete — review the extracted fields and submit when ready",
      "payload": null
    }
  ],
  "field_values": [
    {
      "payload_key": "Attachment points staggered",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "SnapNrack racking systems with UltraFoot attachments on residential roofs typically use staggered attachment points per standard installation practice and structural requirements.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Backup contains service disconnect",
      "source": "bom",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.8,
      "edited": false,
      "reasoning": "Tesla Backup Switch functions as a service disconnect for the backup system.",
      "source_excerpt": "13103 | 1 | LIS56635 | Tesla Backup Switch",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Backup device manufacturer",
      "source": "bom",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Tesla Backup Switch present in BOM.",
      "source_excerpt": "Tesla Backup Switch",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Backup device model",
      "source": "bom",
      "raw_value": "Backup Switch",
      "ai_value": "Backup Switch",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Model from BOM.",
      "source_excerpt": "Tesla Backup Switch",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Backup device OCPD rating (Amps)",
      "source": "bom",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "The 60A non-fusible disconnect in the BOM is consistent with the backup system OCPD rating.",
      "source_excerpt": "23212.1 Switch Not Fusible 240V 60 Amp N3R",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Backup feeder conductor material",
      "source": "inferred",
      "raw_value": "Copper",
      "ai_value": "Copper",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "Copper is the standard conductor material for residential backup feeder wiring in California installations.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar #1 already present on site",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.75,
      "edited": false,
      "reasoning": "Existing residential service with a main service panel is present on site — no MPU is confirmed (MPU listed as TBC in Asana), implying existing busbar/panel is present.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar #1 interconnection compliance method",
      "source": "inferred",
      "raw_value": "120% rule",
      "ai_value": "120% rule",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "The 120% rule (NEC 705.12(B)(2)) is the most common compliance method for residential load-side interconnection on a main service panel.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar #1 main panel upgrade",
      "source": "asana",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.45,
      "edited": false,
      "reasoning": "MPU is listed as TBC (to be confirmed), leaning toward No upgrade confirmed. Reviewer must verify.",
      "source_excerpt": "MPU: TBC",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar #1 number of branch circuit breakers",
      "source": "bom",
      "raw_value": "24",
      "ai_value": "24",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "The 12/24 designation on the load center indicates 12 full spaces / 24 half spaces, so up to 24 branch circuit breakers.",
      "source_excerpt": "22114 125 Amp Load Center Surface Mount 12/24",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar #1 on line side of main service panel",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "Load-side interconnection is typical for residential systems with Tesla Backup Switch; no supply-side connection indicated.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar #1 panel type",
      "source": "inferred",
      "raw_value": "Main Service Panel",
      "ai_value": "Main Service Panel",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "Typical residential installation with Tesla Backup Switch interconnects at the Main Service Panel. No subpanel-only configuration indicated.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar #1 rating (Amps)",
      "source": "inferred",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": "Standard residential service in California (Oakland) is typically 200A. No explicit value found in PDF (image-only) or BOM. Reviewer should verify.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar #1 subject to backfeed",
      "source": "bom",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.8,
      "edited": false,
      "reasoning": "A new 125A load center is present in the BOM, and the Tesla Powerwall 3 with Backup Switch interconnects to the panel, making the busbar subject to backfeed.",
      "source_excerpt": "22114 125 Amp Load Center Surface Mount 12/24",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar feeder interconnection compliance method",
      "source": "inferred",
      "raw_value": "120% rule",
      "ai_value": "120% rule",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "120% rule is the standard compliance method for residential load-side interconnection in this configuration.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Busbar feeder OCPD rating (Amps)",
      "source": "bom",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "A 60A 2-pole breaker is in the BOM, consistent with a feeder OCPD for the new 125A load center / backup panel.",
      "source_excerpt": "24132 60 Amp 2-Pole",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Combiner panel contains ESS",
      "source": "bom",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.75,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 with Backup Switch creates an ESS architecture; the combiner/backup panel contains ESS components.",
      "source_excerpt": "Tesla Powerwall 3 ... Whole Home Backup",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Combiner panel has dedicated OCPD",
      "source": "bom",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "A dedicated 60A 2-pole OCPD is present in the BOM for the backup/combiner panel circuit.",
      "source_excerpt": "24132 60 Amp 2-Pole",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Combiner panel interconnection location",
      "source": "inferred",
      "raw_value": "Main Service Panel",
      "ai_value": "Main Service Panel",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 with Backup Switch in a whole-home backup configuration typically interconnects at the Main Service Panel.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Current roof covering material",
      "source": "inferred",
      "raw_value": "Asphalt or composition shingles",
      "ai_value": "Asphalt or composition shingles",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Oakland CA residential project with SnapNrack racking (typical for composition shingle roofs). Standard residential roofing in this area is asphalt/composition shingles. Roof type is 'Roof mount' in Asana.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "DC-coupled battery manufacturer",
      "source": "bom",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Tesla Powerwall 3",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "DC-coupled battery model",
      "source": "bom",
      "raw_value": "Powerwall 3",
      "ai_value": "Powerwall 3",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Tesla Powerwall 3",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "DC-coupled battery quantity",
      "source": "bom",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "13100 | 1 | LIS56635 | Tesla Powerwall 3",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS assembly weight (lbs)",
      "source": "inferred",
      "raw_value": "287",
      "ai_value": "287",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 has a published weight of approximately 287 lbs per unit. Qty is 1.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS subject to vehicle damage (alternate)",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.45,
      "edited": false,
      "reasoning": "No explicit installation location confirmed, but standard wall-mounted Powerwall installations are typically not subject to vehicle damage unless in a garage without bollard protection. Low confidence.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS unit charging from grid",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 in whole-home backup configuration supports grid charging by default.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS unit has dedicated OCPD",
      "source": "bom",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "A dedicated 60A 2-pole OCPD is present in the BOM consistent with the ESS unit circuit protection.",
      "source_excerpt": "24132 60 Amp 2-Pole",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS unit installation location (architecture: Energy Storage System)",
      "source": "inferred",
      "raw_value": "Garage (interior)",
      "ai_value": "Garage (interior)",
      "user_value": null,
      "confidence": 0.4,
      "edited": false,
      "reasoning": "No explicit location stated. Garage interior is the most common installation location for Tesla Powerwall in residential CA projects. Reviewer must verify.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS unit interconnection location",
      "source": "inferred",
      "raw_value": "Main Service Panel",
      "ai_value": "Main Service Panel",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 with Backup Switch in whole-home backup config typically connects at the Main Service Panel.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS unit is single unit with inverter",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Powerwall 3 is a combined PV inverter + ESS in single listed unit.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS unit manufacturer (architecture: Energy Storage System)",
      "source": "bom",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "BOM lists Tesla Powerwall 3.",
      "source_excerpt": "Tesla Powerwall 3",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS unit model (architecture: Energy Storage System)",
      "source": "bom",
      "raw_value": "Powerwall 3",
      "ai_value": "Powerwall 3",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "BOM model.",
      "source_excerpt": "Tesla Powerwall 3",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS unit OCPD rating (Amps)",
      "source": "bom",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "60A 2-pole breaker in BOM consistent with Powerwall 3 OCPD rating.",
      "source_excerpt": "24132 60 Amp 2-Pole",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS unit quantity (architecture: Energy Storage System)",
      "source": "bom",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Qty 1 in BOM.",
      "source_excerpt": "1 | LIS56635 | Tesla Powerwall 3",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "ESS units have separation less than 3 feet (alternate)",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "Only 1 Tesla Powerwall 3 unit is present per BOM, so separation between multiple units is not applicable; defaulting to No.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Flush mount or tilt-up",
      "source": "inferred",
      "raw_value": "Flush mount",
      "ai_value": "Flush mount",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Roof Type: Roof mount with SnapNrack UR-45 rail system; standard residential flush mount.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Home has sprinkler systems",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.4,
      "edited": false,
      "reasoning": "No mention of sprinkler systems in any source. Older residential homes in Oakland typically do not have residential sprinkler systems unless recently built. Low confidence — reviewer should verify.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Homeowner Full Name",
      "source": "asana",
      "raw_value": "Alex Smith",
      "ai_value": "Alex Smith",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Listed as task name and in PROJECT SNAPSHOT.",
      "source_excerpt": "Customer Name: Alex Smith",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Inverter 1 interconnection location",
      "source": "inferred",
      "raw_value": "Main Service Panel",
      "ai_value": "Main Service Panel",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 with MCI-2 microinverters interconnects at Main Service Panel in standard whole-home backup configuration.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Inverter 1 Manufacturer",
      "source": "asana",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 includes integrated inverter.",
      "source_excerpt": "Inverter Manufacturer: Tesla; Tesla Powerwall 3 (Backup)",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Inverter 1 Model Number",
      "source": "bom",
      "raw_value": "Powerwall 3",
      "ai_value": "Powerwall 3",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Powerwall 3 has integrated solar inverter.",
      "source_excerpt": "Tesla Powerwall 3",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Inverter 1 OCPD rating (Amps)",
      "source": "bom",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "A 60A non-fusible disconnect switch is present in BOM, consistent with the inverter AC disconnect OCPD rating for the Tesla Powerwall 3 / MCI-2 system.",
      "source_excerpt": "23212.1 Switch Not Fusible 240V 60 Amp N3R",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Inverter architecture type",
      "source": "inferred",
      "raw_value": "String Inverter with DC-DC Converters",
      "ai_value": "String Inverter with DC-DC Converters",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 is a string inverter; uses Tesla MCI-2 (Mid Circuit Interrupter) MLPE-style devices.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Inverter output uses NM cable",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "Commercial/utility-grade installations in California typically use conduit rather than NM cable for inverter output runs. No NM cable indicated in BOM.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Main breaker derate applied",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": "120% rule typically applies without main breaker derate for standard residential systems with adequate busbar headroom. No indication of derate in available sources.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Max DC PV Wire / USE-2 conductors in raceway (excl. EGC)",
      "source": "inferred",
      "raw_value": "2",
      "ai_value": "2",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Standard residential PV DC wiring with microinverters (Tesla MCI-2) uses 2 conductors (positive and negative) per circuit in a raceway.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Max DC THWN-2 conductors in raceway (excl. EGC)",
      "source": "inferred",
      "raw_value": "2",
      "ai_value": "2",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Standard residential DC THWN-2 wiring uses 2 conductors per raceway run for string inverter/microinverter systems.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Maximum distance from module to roof (inches)",
      "source": "inferred",
      "raw_value": "10",
      "ai_value": "10",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "SnapNrack UR-45 racking system with UltraFoot attachments typically positions modules 3-10 inches from the roof surface. Standard code-compliant clearance for composition shingle roofs is typically 10 inches max.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Maximum input DC open circuit voltage (Voc) of PV inverter",
      "source": "inferred",
      "raw_value": "600",
      "ai_value": "600",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Tesla MCI-2 microinverters have a maximum DC input Voc of approximately 60V per module input (module-level), but system-level Voc for the Powerwall 3 integrated inverter is 600V. Reviewer should verify from datasheet.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Maximum input DC short circuit current (Isc) of PV inverter",
      "source": "inferred",
      "raw_value": "15",
      "ai_value": "15",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": "Tesla MCI-2 / Powerwall 3 integrated system typical max DC Isc input is approximately 15A per string. Reviewer should verify from datasheet.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Maximum number of modules in a DC series string",
      "source": "bom",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.8,
      "edited": false,
      "reasoning": "Tesla MCI-2 is a microinverter system — each microinverter connects to individual modules, so the maximum series string length is 1 module per inverter.",
      "source_excerpt": "Tesla MCI-2 ... 3 qty ... QCELLS Q.PEAK DUO BLK ML-G10.C+ 410 ... 8 qty",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Maximum OCPD rating allowed on Inverter 1 (Amps)",
      "source": "bom",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "The 60A disconnect in BOM represents the maximum OCPD for the inverter output circuit.",
      "source_excerpt": "23212.1 Switch Not Fusible 240V 60 Amp N3R",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Maximum spacing between adjacent attachment points (inches)",
      "source": "inferred",
      "raw_value": "48",
      "ai_value": "48",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "SnapNrack UR-45 racking system with UltraFoot attachments typically has a maximum 48-inch spacing between attachment points per the racking manufacturer specifications for standard residential loads.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Max microinverters per branch circuit",
      "source": "inferred",
      "raw_value": "6",
      "ai_value": "6",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "Tesla MCI-2 microinverters: 3 units listed in BOM with 8 modules. Typical branch circuit limit for 20A OCPD with ~250W AC output microinverters is ~6 units. Reviewer should verify from plans.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Microinverter module capacity (W)",
      "source": "bom",
      "raw_value": "410",
      "ai_value": "410",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Module wattage is 410W per BOM and Asana. Tesla MCI-2 microinverters are paired with 410W modules.",
      "source_excerpt": "QCELLS Q.PEAK DUO BLK ML-G10.C+ 410",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Microinverters protected by 20A OCPD",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "Tesla MCI-2 microinverters are standard NEC-compliant microinverters protected by 20A OCPD per branch circuit as required by NEC 705 for microinverter systems.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Microinverter total quantity",
      "source": "bom",
      "raw_value": "3",
      "ai_value": "3",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "BOM explicitly lists 3 Tesla MCI-2 microinverters.",
      "source_excerpt": "13113 | 3 | LIS56635 | Tesla MCI-2",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Module 1 Quantity",
      "source": "bom",
      "raw_value": "8",
      "ai_value": "8",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "BOM shows qty 8.",
      "source_excerpt": "8 | LIS56635 | QCELLS Q.PEAK DUO BLK ML-G10.C+ 410",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Module fire rating type",
      "source": "inferred",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.8,
      "edited": false,
      "reasoning": "Hanwha Q-Cells Q.PEAK DUO BLK ML-G10.C+ modules are rated Class A (fire rating type 1) per standard UL 61730 certification for residential PV modules on composition shingle roofs.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Module is bifacial",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Q.PEAK DUO BLK ML-G10.C+ is a monofacial all-black module.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Module Manufacturer",
      "source": "bom",
      "raw_value": "Hanwha Q CELLS",
      "ai_value": "Hanwha Q CELLS",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Module manufacturer is Hanwha Q CELLS.",
      "source_excerpt": "QCELLS Q.PEAK DUO BLK ML-G10.C+ 410",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Module Model Number",
      "source": "bom",
      "raw_value": "Q.PEAK DUO BLK ML-G10.C+ 410",
      "ai_value": "Q.PEAK DUO BLK ML-G10.C+ 410",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Module model from BOM.",
      "source_excerpt": "QCELLS Q.PEAK DUO BLK ML-G10.C+ 410",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Number of composite shingle layers",
      "source": "inferred",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Single layer of composition shingles is standard for residential roofs in Oakland CA. No indication of re-roofing or multiple layers in available sources.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "OCPD protecting busbar #1 rating (Amps)",
      "source": "inferred",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": "Standard 200A main breaker protects the main service panel busbar in typical California residential installations.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Project Address",
      "source": "asana",
      "raw_value": "2355 Pelham Pl, Oakland, CA",
      "ai_value": "2355 Pelham Pl, Oakland, CA",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "Street/City/State present in Asana custom fields; ZIP not provided.",
      "source_excerpt": "\"Street\": \"2355 Pelham Pl\", \"City\": \"Oakland\", \"State.\": \"CA\"",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Project valuation (USD)",
      "source": "asana",
      "raw_value": "24968",
      "ai_value": "24968",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Contract price: $24,968.34",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "PV system weight (lbs/sq ft)",
      "source": "inferred",
      "raw_value": "4.0",
      "ai_value": "4.0",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Typical residential PV system weight with SnapNrack racking and standard crystalline modules is approximately 3.5-4.5 lbs/sq ft. Hanwha Q.PEAK 410W modules weigh ~44 lbs each at approx 71.1 x 45.9 inches = ~22.7 sq ft/module, yielding ~1.9 lbs/sq ft for modules alone; with racking ~3.5-4.0 lbs/sq ft total.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Racking System Manufacturer",
      "source": "bom",
      "raw_value": "SnapNrack",
      "ai_value": "SnapNrack",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Multiple SnapNrack rail/clamp items in BOM.",
      "source_excerpt": "SnapNrack Domestic UR-45 172\" Rail",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Racking System Model Number",
      "source": "bom",
      "raw_value": "Ultra Rail UR-45",
      "ai_value": "Ultra Rail UR-45",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "UR-45 rail family identified in BOM.",
      "source_excerpt": "Domestic UR-45 172\" Rail - Mill, 232-10095-USA",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+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": "Conventional rafter framing in residential construction typically includes ceiling joists. Low confidence without structural plans.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Rafter size (nominal)",
      "source": "inferred",
      "raw_value": "2x6",
      "ai_value": "2x6",
      "user_value": null,
      "confidence": 0.45,
      "edited": false,
      "reasoning": "2x6 rafters are common in Oakland CA residential construction. SnapNrack UltraFoot lag bolt specifications typically target 2x6 or larger rafters. Reviewer must verify.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Rafter spacing (inches)",
      "source": "inferred",
      "raw_value": "24",
      "ai_value": "24",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": "24-inch rafter spacing is common in California residential construction. Reviewer must verify from structural plans.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Rafter type",
      "source": "inferred",
      "raw_value": "Solid sawn lumber",
      "ai_value": "Solid sawn lumber",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "Oakland CA residential construction of typical age uses solid sawn lumber rafters. No truss or engineered lumber indicated in available sources.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Rapid Shutdown compliance method inside array",
      "source": "bom",
      "raw_value": "Module-level power electronics (MLPE)",
      "ai_value": "Module-level power electronics (MLPE)",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Tesla MCI-2 are module-level microinverters which inherently provide rapid shutdown compliance inside the array per NEC 2017/2020 690.12 via MLPE.",
      "source_excerpt": "Tesla MCI-2 ... 3 qty",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Manufacturer",
      "source": "bom",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Tesla MCI-2 (Mid Circuit Interrupter) used for rapid shutdown with Powerwall 3.",
      "source_excerpt": "Tesla MCI-2",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Model Number",
      "source": "bom",
      "raw_value": "MCI-2",
      "ai_value": "MCI-2",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "BOM listed model.",
      "source_excerpt": "Tesla MCI-2",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Quantity",
      "source": "bom",
      "raw_value": "3",
      "ai_value": "3",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "BOM qty 3.",
      "source_excerpt": "3 | LIS56635 | Tesla MCI-2",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Roof framing type",
      "source": "inferred",
      "raw_value": "Conventional rafter",
      "ai_value": "Conventional rafter",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "Typical residential construction in Oakland CA uses conventional rafter framing. SnapNrack UltraFoot attachments are designed for rafter-based roofs.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Roof has flat plane",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Standard residential pitched roof in Oakland CA. No indication of flat roof sections in available sources.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Roof penetration sealant method name and description",
      "source": "inferred",
      "raw_value": "Flashing with butyl sealant",
      "ai_value": "Flashing with butyl sealant",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "SnapNrack UltraFoot attachments use flashing with butyl sealant as the standard roof penetration sealing method for composition shingle roofs.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Roof pitch",
      "source": "inferred",
      "raw_value": "4/12",
      "ai_value": "4/12",
      "user_value": null,
      "confidence": 0.4,
      "edited": false,
      "reasoning": "No pitch explicitly stated (PDF is image-only). 4/12 is a common residential pitch in Oakland CA. Reviewer must verify from plan set images.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Storage architecture",
      "source": "bom",
      "raw_value": "Energy Storage System",
      "ai_value": "Energy Storage System",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "AC-coupled ESS unit.",
      "source_excerpt": "Tesla Powerwall 3",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Supply side connection per NEC 705.12(A)",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "Tesla Backup Switch / Powerwall 3 system uses load-side interconnection, not supply-side, in standard whole-home backup configuration.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Total roof area (sq ft)",
      "source": "inferred",
      "raw_value": "800",
      "ai_value": "800",
      "user_value": null,
      "confidence": 0.35,
      "edited": false,
      "reasoning": "8 modules at ~22.7 sq ft each = ~182 sq ft array area. Total roof area for a small Oakland residential home is estimated at ~800 sq ft. Very low confidence — reviewer must verify.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Utility available fault current greater than 10 kA at service",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "PG&E urban service in Oakland CA typically delivers available fault current well above 10 kA at the service entrance for residential meters.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Utility company name",
      "source": "asana",
      "raw_value": "PG&E",
      "ai_value": "PG&E",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Utility custom field.",
      "source_excerpt": "\"Utility\": \"PG&E\"",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Utility service feed rating (Amps)",
      "source": "inferred",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Standard residential utility service in Oakland CA via PG&E is 200A. No explicit value in available sources (PDF image-only).",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    },
    {
      "payload_key": "Whole home backup",
      "source": "bom",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "BOM ESS Config explicitly Whole Home Backup.",
      "source_excerpt": "ESS Config: Whole Home Backup",
      "in_field_map": true,
      "updated_at": "2026-05-01T15:52:01.568374+00:00"
    }
  ],
  "artifacts": [
    {
      "id": 66,
      "kind": "asana_json",
      "local_path": "/data/runs/01KQJ3Q20WJ5ZQRYBTMK7RF8GV/asana.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 55787,
      "downloaded_at": "2026-05-01T15:50:00.611580+00:00"
    },
    {
      "id": 67,
      "kind": "pdf",
      "local_path": "/data/runs/01KQJ3Q20WJ5ZQRYBTMK7RF8GV/pdf/Shade_Report_-_Alex_Smith_-_LGCY_Design.pdf",
      "drive_file_id": "1HZVk-f1-3qXJzn-iu_IAG9UScYXSQwgK",
      "sha256": "beab15fef1fa491051e1f24dfcbc543d221f5545384a5589b522788ffc8765c2",
      "bytes": 1189415,
      "downloaded_at": "2026-05-01T15:50:02.837059+00:00"
    },
    {
      "id": 68,
      "kind": "bom",
      "local_path": "/data/runs/01KQJ3Q20WJ5ZQRYBTMK7RF8GV/bom/BOM_LIS56635.csv",
      "drive_file_id": "1IVnbDlq-UplZtSaK8nulGvffU5OrFFiL",
      "sha256": "9b27a150e1480a27111f408da672e4c451b345cbaef43dd5f84134a02995860f",
      "bytes": 1939,
      "downloaded_at": "2026-05-01T15:50:03.587648+00:00"
    },
    {
      "id": 69,
      "kind": "extraction",
      "local_path": "/data/runs/01KQJ3Q20WJ5ZQRYBTMK7RF8GV/extraction.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 34557,
      "downloaded_at": "2026-05-01T15:52:01.556799+00:00"
    }
  ],
  "has_final_patch": false,
  "final_patch_field_count": 0,
  "_meta": {
    "collected_at": "2026-05-06T21:21:59.019878+00:00",
    "iteration_count": 0,
    "audit_log_count": 16,
    "field_values_count": 88,
    "artifacts_count": 4,
    "has_final_patch": false
  }
}