← back to audit · 01KQQNE2XV9BP3XGGQ8ZPSZRSA

Teresa Ramirez

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

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
343	info	asana_fetched	Resolving Asana task reference 'https://app.asana.com/1/1203754389657527/project/1211039529104749/task/1211709017140700'	2026-05-03T19:35:52
344	info	asana_fetched	Loaded Asana task: Teresa Ramirez payload { "customer": "Teresa Ramirez", "gid": "1211709017140700", "title": "Teresa Ramirez" }	2026-05-03T19:35:53
345	info	drive_resolved	Searching Asana fields for Google Drive URL	2026-05-03T19:35:53
346	info	drive_resolved	Resolved Drive folder (8 items, 7 in CAD/) payload { "cad_folder_id": "1QSubAYKQtku-FjHGZL0Y7rTqCilfizul", "folder_id": "1lcO5aA-VkQ3sJlAZh7r_jXH5laQHAcX_" }	2026-05-03T19:35:54
347	info	pdf_downloaded	Picking the latest-dated plan-set PDF	2026-05-03T19:35:54
348	info	pdf_downloaded	Downloaded plan-set: Teresa Ramirez_V0_12-16-2025.pdf (8.2 MB) payload { "bytes": 8555492, "filename": "Teresa Ramirez_V0_12-16-2025.pdf" }	2026-05-03T19:35:57
349	info	bom_downloaded	Looking for the BOM CSV in the same folder	2026-05-03T19:35:57
350	warn	bom_downloaded	No BOM CSV in folder — modules section will rely on PDF + Asana only	2026-05-03T19:35:57
351	info	ai_extracted	Extracting text from the plan-set PDF	2026-05-03T19:35:57
352	info	ai_extracted	Pass 1/3: Claude Opus 4.7 (full extraction)	2026-05-03T19:36:03
357	info	ai_extracted	Pass 1: Opus filled 64 fields (avg 85%)	2026-05-03T19:37:07
358	info	ai_extracted	Pass 2/3: Claude Sonnet 4.6 retrying 33 missing fields	2026-05-03T19:37:07
359	info	ai_extracted	Pass 2: Sonnet added 23 more fields	2026-05-03T19:38:11
360	info	ai_extracted	Pass 3/3: Claude Opus 4.7 final retry on 10 stubborn fields	2026-05-03T19:38:11
361	info	ai_extracted	Extracted 89 fields, avg confidence 83% (Opus: 64, Sonnet retry: +23, Opus retry: +2, 8 still unfilled) payload { "avg_confidence": 0.832, "extra_fields": 0, "fields": 89, "missing": 8, "passes": { "opus_full": 64, "opus_retry": 2, "sonnet_retry": 23 }, "usage": { "cache_creation_input_tokens": 27299, "cache_read_input_tokens": 9992, "input_tokens": 50777, "output_tokens": 9478 } }	2026-05-03T19:38:24
362	info	awaiting_review	Pipeline complete — review the extracted fields and submit when ready	2026-05-03T19:38:25

Field values (89)

▸ 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 device OCPD rating (Amps)	200	—	0.75	no	yes
Backup feeder conductor material	Copper	—	0.90	no	yes
Busbar #1 already present on site	Yes	—	0.95	no	yes
Busbar #1 interconnection compliance method	120% rule	—	0.85	no	yes
Busbar #1 main-lug-only solo main breaker present	No	—	0.72	no	yes
Busbar #1 main panel upgrade	No	—	0.95	no	yes
Busbar #1 number of branch circuit breakers	1	—	0.82	no	yes
Busbar #1 on line side of main service panel	No	—	0.88	no	yes
Busbar #1 panel type	Main Service Panel	—	0.90	no	yes
Busbar #1 rating (Amps)	200	—	0.95	no	yes
Busbar #1 subject to backfeed	Yes	—	0.85	no	yes
Busbar feeder interconnection compliance method	120% rule	—	0.88	no	yes
Busbar feeder max THWN-2 conductors in raceway	3	—	0.90	no	yes
Busbar feeder OCPD rating (Amps)	70	—	0.88	no	yes
Busbar feeder wire gauge (AWG)	4	—	0.92	no	yes
Combiner panel contains ESS	No	—	0.50	no	yes
Combiner panel has dedicated OCPD	Yes	—	0.60	no	yes
Combiner panel interconnection location	New Subpanel	—	0.80	no	yes
Current roof covering material	Asphalt or composition shingles	—	0.95	no	yes
ESS assembly weight (lbs)	291	—	0.92	no	yes
ESS subject to vehicle damage (alternate)	No	—	0.78	no	yes
ESS unit charging from grid	Yes	—	0.60	no	yes
ESS unit has dedicated OCPD	Yes	—	0.70	no	yes
ESS unit installation location (architecture: Energy Storage System)	Outdoor walls	—	0.70	no	yes
ESS unit interconnection location	New Subpanel	—	0.70	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 (1707000-11-J-DOM)	—	0.90	no	yes
ESS unit OCPD rating (Amps)	60	—	0.85	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.88	no	yes
Flush mount or tilt-up	Flush mount	—	0.90	no	yes
Home has sprinkler systems	No	—	0.45	no	yes
Homeowner Full Name	Teresa Ramirez	—	0.98	no	yes
Inverter 1 interconnection location	New Subpanel	—	0.80	no	yes
Inverter 1 Manufacturer	Tesla	—	0.98	no	yes
Inverter 1 Model Number	1707000-11-J-DOM	—	0.95	no	yes
Inverter 1 OCPD rating (Amps)	60	—	0.95	no	yes
Inverter architecture type	String Inverter with DC-DC Converters	—	0.75	no	yes
Inverter output uses NM cable	No	—	0.88	no	yes
Main breaker derate applied	No	—	0.85	no	yes
Max DC PV Wire / USE-2 conductors in raceway (excl. EGC)	4	—	0.85	no	yes
Max DC THWN-2 conductors in raceway (excl. EGC)	4	—	0.85	no	yes
Maximum distance from module to roof (inches)	7	—	0.70	no	yes
Maximum input DC open circuit voltage (Voc) of PV inverter	600	—	0.90	no	yes
Maximum input DC short circuit current (Isc) of PV inverter	19	—	0.90	no	yes
Maximum number of modules in a DC series string	7	—	0.92	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
Max microinverters per branch circuit	18	—	0.55	no	yes
Microinverter module capacity (W)	450	—	0.72	no	yes
Microinverters protected by 20A OCPD	Yes	—	0.72	no	yes
Microinverter total quantity	18	—	0.92	no	yes
Module 1 Quantity	13	—	0.98	no	yes
Module fire rating type	2	—	0.50	no	yes
Module is bifacial	No	—	0.85	no	yes
Module Manufacturer	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.50	no	yes
OCPD protecting busbar #1 rating (Amps)	70	—	0.95	no	yes
Project Address	248 Mount Arbor St, McFarland, CA 93250	—	0.95	no	yes
Project valuation (USD)	43296	—	0.85	no	yes
PV system weight (lbs/sq ft)	4.0	—	0.50	no	yes
Racking System Manufacturer	Unirac	—	0.95	no	yes
Racking System Model Number	NXT UMOUNT	—	0.95	no	yes
Rafter has ceiling joists	No	—	0.72	no	yes
Rafter largest span (feet)	24.0	—	0.40	no	yes
Rafter size (nominal)	2x4	—	0.95	no	yes
Rafter spacing (inches)	24	—	0.95	no	yes
Rafter type	Engineered truss	—	0.90	no	yes
Rapid Shutdown compliance method inside array	Module-level shutdown (MLPE/MCI)	—	0.95	no	yes
Rapid Shutdown Device Manufacturer	Tesla	—	0.98	no	yes
Rapid Shutdown Device Model Number	MCI-2S	—	0.95	no	yes
Rapid Shutdown Device Quantity	5	—	0.95	no	yes
Roof framing type	Truss	—	0.90	no	yes
Roof has flat plane	No	—	0.85	no	yes
Roof penetration sealant method name and description	Unirac Stronghold Butyl attachment with pre-applied butyl pad	—	0.85	no	yes
Roof pitch	4/12	—	0.70	no	yes
Storage architecture	Energy Storage System	—	0.90	no	yes
Supply side connection per NEC 705.12(A)	No	—	0.85	no	yes
Total roof area (sq ft)	1884	—	0.85	no	yes
Utility available fault current greater than 10 kA at service	No	—	0.60	no	yes
Utility company name	Southern California Edison	—	0.90	no	yes
Utility service feed rating (Amps)	200	—	0.95	no	yes
Whole home backup	Yes	—	0.95	no	yes

Artifacts (3)

Kind	Path	Size	SHA
`asana_json`	/data/runs/01KQQNE2XV9BP3XGGQ8ZPSZRSA/asana.json	39325 B
`pdf`	/data/runs/01KQQNE2XV9BP3XGGQ8ZPSZRSA/pdf/Teresa_Ramirez_V0_12-16-2025.pdf	8555492 B	41acb4f7fafc1047
`extraction`	/data/runs/01KQQNE2XV9BP3XGGQ8ZPSZRSA/extraction.json	39709 B

{
  "run": {
    "id": "01KQQNE2XV9BP3XGGQ8ZPSZRSA",
    "asana_task_gid": "1211709017140700",
    "asana_task_url": "https://app.asana.com/1/1203754389657527/project/1211039529104749/task/1211709017140700",
    "asana_task_title": "Teresa Ramirez",
    "customer_name": "Teresa Ramirez",
    "status": "awaiting_review",
    "current_stage": "awaiting_review",
    "drive_folder_id": "1lcO5aA-VkQ3sJlAZh7r_jXH5laQHAcX_",
    "drive_cad_folder_id": "1QSubAYKQtku-FjHGZL0Y7rTqCilfizul",
    "plan_set_filename": "Teresa Ramirez_V0_12-16-2025.pdf",
    "bom_filename": null,
    "solarapp_uuid": null,
    "project_url": null,
    "error_stage": null,
    "error_message": null,
    "error_payload": null,
    "ai_token_usage": {
      "input_tokens": 50777,
      "output_tokens": 9478,
      "cache_read_input_tokens": 9992,
      "cache_creation_input_tokens": 27299
    },
    "avg_confidence": 0.832,
    "warnings": [
      "Roof pitch inferred from 18° tilt (~4/12).",
      "Module fire rating not stated explicitly; defaulted to Class 2.",
      "Busbar feeder details and supply-side IX skipped — interconnection is via 60A breaker tie in subpanel under 120% rule.",
      "Inverter architecture for Powerwall 3 with MCIs treated as string-with-DC-DC; verify against SolarAPP+ canonical.",
      "The new PV system uses Tesla MCI-2S Mid-Circuit Interrupters (RSD devices), NOT microinverters. The microinverter fields (max per branch circuit, module capacity, total quantity, 20A OCPD) refer to the EXISTING Enphase IQ8PLUS system on the structure which is tied to a separate utility meter (322010-467317). Reviewer should confirm whether SolarAPP+ fields apply to new system only or include existing.",
      "No BOM CSV was provided — all equipment data sourced from plan-set PDF and Asana.",
      "Home sprinkler system status not stated anywhere; No was inferred from absence of mention and typical construction type for this area/price point.",
      "PV system weight lbs/sq ft is a typical industry estimate; no explicit calculation found in plan set.",
      "Rafter largest span was not stated; the 24.0 ft value is a rough estimate for a single-story home with 2x4 trusses — must be verified.",
      "Backup fields (Backup contains service disconnect, Backup device OCPD rating, Calculated backup load) were skipped as the plan set does not provide explicit values for these; the system is whole-home backup via Tesla Backup Switch but no load calculation or OCPD rating for the backup circuit is enumerated.",
      "DC-coupled battery fields skipped — system uses AC-coupled Tesla Powerwall 3 (not DC-coupled).",
      "Supply-side IX fields skipped — interconnection is load-side (PV breaker tie-in at sub panel), not supply-side.",
      "Calculated backup load not stated in plan set (whole home backup configuration noted but no calculated watts).",
      "No DC-coupled battery in this design — Powerwall 3 is treated as AC-coupled BESS per Asana ('TESLA 1707000-21 AC BESS'). Skipped DC-coupled battery fields.",
      "No supply-side interconnection — plan set explicitly shows 'PV BREAKER TIE IN SUB' (load-side breaker tie). Skipped supply-side IX fields.",
      "Backup OCPD inferred from Tesla Backup Switch 200A continuous rating; reviewer should verify whether SolarAPP+ wants the backup switch rating vs. a downstream OCPD."
    ],
    "flow": "v1",
    "iteration_count": 0,
    "iteration_outcome": null,
    "final_diagnosis": null,
    "created_at": "2026-05-03T19:35:52.512848+00:00",
    "updated_at": "2026-05-03T19:38:24.992548+00:00",
    "submitted_at": null,
    "completed_at": null
  },
  "iterations": [],
  "insights": {
    "stuck_rules": [],
    "newly_revealed": [],
    "conditional_triggers": {}
  },
  "audit_log": [
    {
      "id": 343,
      "ts": "2026-05-03T19:35:52.520316+00:00",
      "stage": "asana_fetched",
      "level": "info",
      "message": "Resolving Asana task reference 'https://app.asana.com/1/1203754389657527/project/1211039529104749/task/1211709017140700'",
      "payload": null
    },
    {
      "id": 344,
      "ts": "2026-05-03T19:35:53.179336+00:00",
      "stage": "asana_fetched",
      "level": "info",
      "message": "Loaded Asana task: Teresa Ramirez",
      "payload": {
        "gid": "1211709017140700",
        "title": "Teresa Ramirez",
        "customer": "Teresa Ramirez"
      }
    },
    {
      "id": 345,
      "ts": "2026-05-03T19:35:53.186135+00:00",
      "stage": "drive_resolved",
      "level": "info",
      "message": "Searching Asana fields for Google Drive URL",
      "payload": null
    },
    {
      "id": 346,
      "ts": "2026-05-03T19:35:54.465995+00:00",
      "stage": "drive_resolved",
      "level": "info",
      "message": "Resolved Drive folder (8 items, 7 in CAD/)",
      "payload": {
        "folder_id": "1lcO5aA-VkQ3sJlAZh7r_jXH5laQHAcX_",
        "cad_folder_id": "1QSubAYKQtku-FjHGZL0Y7rTqCilfizul"
      }
    },
    {
      "id": 347,
      "ts": "2026-05-03T19:35:54.475127+00:00",
      "stage": "pdf_downloaded",
      "level": "info",
      "message": "Picking the latest-dated plan-set PDF",
      "payload": null
    },
    {
      "id": 348,
      "ts": "2026-05-03T19:35:57.220596+00:00",
      "stage": "pdf_downloaded",
      "level": "info",
      "message": "Downloaded plan-set: Teresa Ramirez_V0_12-16-2025.pdf (8.2 MB)",
      "payload": {
        "bytes": 8555492,
        "filename": "Teresa Ramirez_V0_12-16-2025.pdf"
      }
    },
    {
      "id": 349,
      "ts": "2026-05-03T19:35:57.227597+00:00",
      "stage": "bom_downloaded",
      "level": "info",
      "message": "Looking for the BOM CSV in the same folder",
      "payload": null
    },
    {
      "id": 350,
      "ts": "2026-05-03T19:35:57.243225+00:00",
      "stage": "bom_downloaded",
      "level": "warn",
      "message": "No BOM CSV in folder — modules section will rely on PDF + Asana only",
      "payload": null
    },
    {
      "id": 351,
      "ts": "2026-05-03T19:35:57.250482+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracting text from the plan-set PDF",
      "payload": null
    },
    {
      "id": 352,
      "ts": "2026-05-03T19:36:03.849208+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1/3: Claude Opus 4.7 (full extraction)",
      "payload": null
    },
    {
      "id": 357,
      "ts": "2026-05-03T19:37:07.631977+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1: Opus filled 64 fields (avg 85%)",
      "payload": null
    },
    {
      "id": 358,
      "ts": "2026-05-03T19:37:07.645039+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 2/3: Claude Sonnet 4.6 retrying 33 missing fields",
      "payload": null
    },
    {
      "id": 359,
      "ts": "2026-05-03T19:38:11.507249+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 2: Sonnet added 23 more fields",
      "payload": null
    },
    {
      "id": 360,
      "ts": "2026-05-03T19:38:11.528680+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 3/3: Claude Opus 4.7 final retry on 10 stubborn fields",
      "payload": null
    },
    {
      "id": 361,
      "ts": "2026-05-03T19:38:24.984388+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracted 89 fields, avg confidence 83% (Opus: 64, Sonnet retry: +23, Opus retry: +2, 8 still unfilled)",
      "payload": {
        "usage": {
          "input_tokens": 50777,
          "output_tokens": 9478,
          "cache_read_input_tokens": 9992,
          "cache_creation_input_tokens": 27299
        },
        "fields": 89,
        "passes": {
          "opus_full": 64,
          "opus_retry": 2,
          "sonnet_retry": 23
        },
        "missing": 8,
        "extra_fields": 0,
        "avg_confidence": 0.832
      }
    },
    {
      "id": 362,
      "ts": "2026-05-03T19:38:25.000765+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.5,
      "edited": false,
      "reasoning": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Backup contains service disconnect",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "The Tesla Backup Switch is installed behind the utility meter and acts as the microgrid interconnection device, controlling grid connection. It functions as a service disconnect in the backup configuration.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Backup device manufacturer",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "TESLA BACKUP SWITCH",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "TESLA BACKUP SWITCH (MICROGRID INTERCONNECTION DEVICE)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Backup device OCPD rating (Amps)",
      "source": "pdf",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": null,
      "confidence": 0.75,
      "edited": false,
      "reasoning": "Tesla Backup Switch is rated 200A continuous, matching the existing 200A main service panel rating.",
      "source_excerpt": "Continuous Load Rating 200 A, 120/240 V split phase",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Backup feeder conductor material",
      "source": "pdf",
      "raw_value": "Copper",
      "ai_value": "Copper",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "ALL CONDUCTORS COPPER, UNLESS OTHERWISE NOTED",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Busbar #1 already present on site",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(E) 200A MAIN SERVICE PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "200X1.20=240 BUS RATING x 120% ... 170A ALLOWABLE BACKFEED",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Busbar #1 main-lug-only solo main breaker present",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.72,
      "edited": false,
      "reasoning": "The new 200A sub panel has a 60A PV backfeed breaker installed, indicating it is a breaker-equipped sub panel, not a main-lug-only panel with a solo main breaker.",
      "source_excerpt": "(N) 200A SUB PANEL ... (N) 60A BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "MPU: N",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Busbar #1 number of branch circuit breakers",
      "source": "pdf",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.82,
      "edited": false,
      "reasoning": "The electrical diagram shows the PV interconnection is via a single 60A breaker in the sub panel. The sub panel feeds back to the main panel. One 60A backfeed breaker is shown.",
      "source_excerpt": "(N) 60A BREAKER ... (E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER ... (N) 200A SUB PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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.88,
      "edited": false,
      "reasoning": "The interconnection is a load-side connection via a breaker in the new 200A sub panel, which is downstream of the main service panel. Not on the line side.",
      "source_excerpt": "INTERCONNECTION: PV BREAKER TIE IN SUB ... (N) 200A SUB PANEL ... (E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Busbar #1 rating (Amps)",
      "source": "pdf",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(E) 200A MAIN SERVICE PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Busbar #1 subject to backfeed",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "BACKFEED BREAKER SIZING ... 60A PV BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Busbar feeder interconnection compliance method",
      "source": "pdf",
      "raw_value": "120% rule",
      "ai_value": "120% rule",
      "user_value": null,
      "confidence": 0.88,
      "edited": false,
      "reasoning": "Plan set explicitly applies NEC 705.12(B)(2) 120% bus rating rule for the sub panel interconnection compliance.",
      "source_excerpt": "SEE NEC 705.12(B)(2) OF 2026 NEC 200X1.20=240 BUS RATING x 120% 240-70=170A ALLOWABLE BACKFEED",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Busbar feeder max THWN-2 conductors in raceway",
      "source": "pdf",
      "raw_value": "3",
      "ai_value": "3",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Raceway schedule row 5 shows 3 conductors in the sub panel to main panel run.",
      "source_excerpt": "5 AC SUB PANEL TO MAIN PANEL 3 1\" EMT CONDUIT RUN (TO BE UPSIZED IF NEEDED) 4 AWG THWN-2 COPPER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Busbar feeder OCPD rating (Amps)",
      "source": "pdf",
      "raw_value": "70",
      "ai_value": "70",
      "user_value": null,
      "confidence": 0.88,
      "edited": false,
      "reasoning": "The feeder from sub panel to main panel is protected by the existing 70A main breaker in the main service panel, which serves as the OCPD for the sub panel feeder.",
      "source_excerpt": "(E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER ... SUB PANEL TO MAIN PANEL 3 1\" EMT CONDUIT RUN 4 AWG THWN-2 COPPER 95.00 70.00",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Busbar feeder wire gauge (AWG)",
      "source": "pdf",
      "raw_value": "4",
      "ai_value": "4",
      "user_value": null,
      "confidence": 0.92,
      "edited": false,
      "reasoning": "Raceway row 5 clearly states 4 AWG THWN-2 copper for the sub panel to main panel feeder.",
      "source_excerpt": "5 AC SUB PANEL TO MAIN PANEL 3 1\" EMT CONDUIT RUN 4 AWG THWN-2 COPPER 95.00 70.00",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Combiner panel contains ESS",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Combiner panel has dedicated OCPD",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 60A BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Combiner panel interconnection location",
      "source": "pdf",
      "raw_value": "New Subpanel",
      "ai_value": "New Subpanel",
      "user_value": null,
      "confidence": 0.8,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "PV BREAKER TIE IN SUB ... (N) 200A SUB PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "ROOF TYPE: COMP SHINGLE (MAIN HOME)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "ESS assembly weight (lbs)",
      "source": "pdf",
      "raw_value": "291",
      "ai_value": "291",
      "user_value": null,
      "confidence": 0.92,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 datasheet embedded in plan set states total weight of installed unit is 291.2 lbs, rounded to 291.",
      "source_excerpt": "Total Weight of Installed Unit 132 kg (291.2 lb)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "ESS subject to vehicle damage (alternate)",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.78,
      "edited": false,
      "reasoning": "ESS is wall-mounted on the east outside wall of the structure. No indication it is in a location subject to vehicle damage (e.g., garage or driveway path). Plan note states buried conduits under vehicle traffic areas require 24\" cover — unrelated to ESS placement.",
      "source_excerpt": "EAST OUTSIDE WALL ... TESLA POWERWALL MOUNTING BRACKET (4) 1/4\" X 3\" LAG BOLTS",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "ESS unit charging from grid",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "ESS unit has dedicated OCPD",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 60A NON-FUSED AC DISCONNECT ... (N) 60A BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "EAST OUTSIDE WALL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "ESS unit interconnection location",
      "source": "pdf",
      "raw_value": "New Subpanel",
      "ai_value": "New Subpanel",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 200A SUB PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "POWERWALL 3 ... INVERTER / ENERGY STORAGE SYSTEM",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "TESLA POWERWALL 3",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "ESS unit model (architecture: Energy Storage System)",
      "source": "pdf",
      "raw_value": "Powerwall 3 (1707000-11-J-DOM)",
      "ai_value": "Powerwall 3 (1707000-11-J-DOM)",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "TESLA POWERWALL 3 11.5 KW / 13.5 KWH (1707000-11-J-DOM)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "ESS unit OCPD rating (Amps)",
      "source": "pdf",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Overcurrent Protection Device 60 A",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "(N) 01- TESLA POWERWALL 3",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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.88,
      "edited": false,
      "reasoning": "Plan set explicitly notes ESS units shall be separated by at least 3 feet and references CFC 1207.11.2.1 compliance. Only one Powerwall 3 unit is installed, so separation requirement is met by default.",
      "source_excerpt": "MULTIPLE ESS SYSTEMS SHALL BE SEPARATED FROM EACH OTHER BY AT LEAST 3' ... Per CFC 1207.11.2.1 SPACING - ESS UNITS ARE LISTED AND IN ACCORDANCE WITH UL 9540A.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "PHOTOVOLTAIC ROOF MOUNT SYSTEM",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Home has sprinkler systems",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.45,
      "edited": false,
      "reasoning": "No mention of sprinkler systems anywhere in the plan set, Asana ticket, or BOM. Standard single-family residential in McFarland, CA at this contract price level rarely has sprinkler systems. Inferred No with low confidence — reviewer should verify.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Homeowner Full Name",
      "source": "asana",
      "raw_value": "Teresa Ramirez",
      "ai_value": "Teresa Ramirez",
      "user_value": null,
      "confidence": 0.98,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "task_name: Teresa Ramirez",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Inverter 1 interconnection location",
      "source": "pdf",
      "raw_value": "New Subpanel",
      "ai_value": "New Subpanel",
      "user_value": null,
      "confidence": 0.8,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "INTERCONNECTION: PV BREAKER TIE IN SUB ... (N) 200A SUB PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Inverter 1 Manufacturer",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.98,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "TESLA POWERWALL 3 11.5 KW / 13.5 KWH (1707000-11-J-DOM) INVERTER / ENERGY STORAGE SYSTEM",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Inverter 1 Model Number",
      "source": "pdf",
      "raw_value": "1707000-11-J-DOM",
      "ai_value": "1707000-11-J-DOM",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "TESLA POWERWALL 3 11.5 KW / 13.5 KWH (1707000-11-J-DOM)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "(N) 60A BREAKER ... 60A PV BREAKER - OK",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Inverter architecture type",
      "source": "pdf",
      "raw_value": "String Inverter with DC-DC Converters",
      "ai_value": "String Inverter with DC-DC Converters",
      "user_value": null,
      "confidence": 0.75,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "TESLA MCI-2S (RAPID SHUTDOWN DEVICE) ... PV strings into Powerwall 3 MPPTs",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Inverter output uses NM cable",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.88,
      "edited": false,
      "reasoning": "The primary wiring method from inverter to AC disconnect and sub panel is EMT conduit with THWN-2 conductors per the raceway schedule. NM-B is mentioned only as an alternative attic run option, but the line diagram clearly shows EMT conduit runs for all AC circuits.",
      "source_excerpt": "NOTE (N) NO PVC ALLOWED ON ROOF OR IN ATTIC ... 3/4\" EMT CONDUIT RUN 7/8\" ABOVE ROOF OR (ATTIC RUN WITH FLEX/NM-B CABLE)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Main breaker derate applied",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "The plan set uses the 120% bus rule (NEC 705.12(B)(2)) compliance method for the sub panel backfeed, not the main breaker derate method (NEC 705.12(B)(2)(3)(c)).",
      "source_excerpt": "SEE NEC 705.12(B)(2) OF 2026 NEC 200X1.20=240 BUS RATING x 120% 240-70=170A ALLOWABLE BACKFEED",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Max DC PV Wire / USE-2 conductors in raceway (excl. EGC)",
      "source": "pdf",
      "raw_value": "4",
      "ai_value": "4",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "DC MCI TO JUNCTION BOX 4- 10 AWG PV WIRE",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Max DC THWN-2 conductors in raceway (excl. EGC)",
      "source": "pdf",
      "raw_value": "4",
      "ai_value": "4",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "DC JUNCTION BOX TO INVERTER 4 3/4\" EMT 10 AWG THWN-2",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Maximum distance from module to roof (inches)",
      "source": "pdf",
      "raw_value": "7",
      "ai_value": "7",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "3/4\" EMT CONDUIT RUN 7/8\" ABOVE ROOF",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Maximum input DC open circuit voltage (Voc) of PV inverter",
      "source": "pdf",
      "raw_value": "600",
      "ai_value": "600",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Withstand Voltage 600 V DC",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Maximum Short Circuit Current per MPPT (Isc) 19 A",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Maximum number of modules in a DC series string",
      "source": "pdf",
      "raw_value": "7",
      "ai_value": "7",
      "user_value": null,
      "confidence": 0.92,
      "edited": false,
      "reasoning": "Two strings: one of 6 modules and one of 7 modules. The maximum is 7.",
      "source_excerpt": "(N) 7 MODULES IN BRANCH CIRCUIT #2 ... (N) 6 MODULES IN BRANCH CIRCUIT #1",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "Overcurrent Protection Device 60 A (11.5 kW)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "UNIRAC STRONGHOLD BUTYL ATTACHMENTS @ 48\" O.C MAX",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Max microinverters per branch circuit",
      "source": "pdf",
      "raw_value": "18",
      "ai_value": "18",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "The existing system has 18 Enphase IQ8PLUS microinverters. The new system uses Tesla MCI-2S RSD devices (not microinverters). The 'max microinverters per branch circuit' field applies to the existing microinverter system. Exact branch circuit count for the existing 18 microinverters is not specified; if split into 2 circuits, max would be 9 or similar. Low confidence — reviewer should verify existing system circuit layout.",
      "source_excerpt": "(E) PV ARRAY 18 - ZNSHINE SOLAR ZXM6-NH144-450/M 450W MODULES 18 - ENPHASE IQ8PLUS-72-2-US MICROINVERTERS",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Microinverter module capacity (W)",
      "source": "pdf",
      "raw_value": "450",
      "ai_value": "450",
      "user_value": null,
      "confidence": 0.72,
      "edited": false,
      "reasoning": "The existing microinverter system uses Enphase IQ8PLUS paired with 450W modules.",
      "source_excerpt": "18 - ENPHASE IQ8PLUS-72-2-US MICROINVERTERS ... 18 - ZNSHINE SOLAR ZXM6-NH144-450/M 450W MODULES",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Microinverters protected by 20A OCPD",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.72,
      "edited": false,
      "reasoning": "Enphase IQ8PLUS microinverters on residential installs are standardly protected by 20A OCPD per Enphase installation guidelines and NEC branch circuit sizing for microinverter strings. No explicit OCPD value stated for existing system in the plan set.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Microinverter total quantity",
      "source": "pdf",
      "raw_value": "18",
      "ai_value": "18",
      "user_value": null,
      "confidence": 0.92,
      "edited": false,
      "reasoning": "Plan set clearly states 18 Enphase IQ8PLUS-72-2-US microinverters in the existing PV system.",
      "source_excerpt": "18 - ENPHASE IQ8PLUS-72-2-US MICROINVERTERS",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Module 1 Quantity",
      "source": "pdf",
      "raw_value": "13",
      "ai_value": "13",
      "user_value": null,
      "confidence": 0.98,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 13- QCELLS: Q.PEAK DUO BLK ML-G10.C+ 410",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Module fire rating type",
      "source": "inferred",
      "raw_value": "2",
      "ai_value": "2",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Module is bifacial",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Module Manufacturer",
      "source": "asana",
      "raw_value": "Q Cells",
      "ai_value": "Q Cells",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Module Manufacturer: HANWHA_Q_CELLS",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Module Model Number",
      "source": "pdf",
      "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": null,
      "source_excerpt": "QCELLS: Q.PEAK DUO BLK ML-G10.C+ 410 (410W) MODULES",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Number of composite shingle layers",
      "source": "inferred",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.5,
      "edited": false,
      "reasoning": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "OCPD protecting busbar #1 rating (Amps)",
      "source": "pdf",
      "raw_value": "70",
      "ai_value": "70",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Project Address",
      "source": "asana",
      "raw_value": "248 Mount Arbor St, McFarland, CA 93250",
      "ai_value": "248 Mount Arbor St, McFarland, CA 93250",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Street: 248 Mount Arbor Street; City: McFarland; State: CA",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Project valuation (USD)",
      "source": "asana",
      "raw_value": "43296",
      "ai_value": "43296",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Contract Amount: 43296.17",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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.5,
      "edited": false,
      "reasoning": "Unirac NXT UMOUNT with comp shingle roof. Typical installed weight for rail-based residential PV system on comp shingle is ~3.5–4.5 lbs/sq ft. No explicit value given in plan set. Using 4.0 as midpoint estimate.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Racking System Manufacturer",
      "source": "pdf",
      "raw_value": "Unirac",
      "ai_value": "Unirac",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "UNIRAC NXT UMOUNT RAIL 168\"",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Racking System Model Number",
      "source": "pdf",
      "raw_value": "NXT UMOUNT",
      "ai_value": "NXT UMOUNT",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "UNIRAC NXT UMOUNT RAIL 168\"-MILL (168RLM1-US)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Rafter has ceiling joists",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.72,
      "edited": false,
      "reasoning": "Roof framing is described as 2x4 truss system. Trusses are self-contained structural members that do not rely on ceiling joists for rafter support in the traditional sense.",
      "source_excerpt": "ROOF FRAME: 2X4 TRUSS @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Rafter largest span (feet)",
      "source": "inferred",
      "raw_value": "24.0",
      "ai_value": "24.0",
      "user_value": null,
      "confidence": 0.4,
      "edited": false,
      "reasoning": "Roof frame is 2x4 truss @ 24\" O.C. For a typical single-story residential in McFarland CA, truss span is commonly 20–28 ft. No explicit span stated. Low confidence — reviewer must verify from structural drawings.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Rafter size (nominal)",
      "source": "pdf",
      "raw_value": "2x4",
      "ai_value": "2x4",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "2X4 TRUSS @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Rafter spacing (inches)",
      "source": "pdf",
      "raw_value": "24",
      "ai_value": "24",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "2X4 TRUSS @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Rafter type",
      "source": "pdf",
      "raw_value": "Engineered truss",
      "ai_value": "Engineered truss",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "ROOF FRAME: 2X4 TRUSS @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Rapid Shutdown compliance method inside array",
      "source": "pdf",
      "raw_value": "Module-level shutdown (MLPE/MCI)",
      "ai_value": "Module-level shutdown (MLPE/MCI)",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": "Tesla MCI-2S Mid-Circuit Interrupters are installed every 3rd module on each string, providing module-level rapid shutdown inside the array per NEC 690.12.",
      "source_excerpt": "(N) 05- TESLA MCI-2S (RAPID SHUTDOWN DEVICE) ... TESLA MCI EVERY 3RD MODULE",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Manufacturer",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.98,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "TESLA MCI-2S (RAPID SHUTDOWN DEVICE)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "TESLA MCI-2S (RAPID SHUTDOWN DEVICE)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Quantity",
      "source": "pdf",
      "raw_value": "5",
      "ai_value": "5",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 05- TESLA MCI-2S",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Roof framing type",
      "source": "pdf",
      "raw_value": "Truss",
      "ai_value": "Truss",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "2X4 TRUSS @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Roof has flat plane",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "Roof tilt is listed as 18°, which is a pitched roof, not flat.",
      "source_excerpt": "ROOF TILT #1 13 90° 18°",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Roof penetration sealant method name and description",
      "source": "pdf",
      "raw_value": "Unirac Stronghold Butyl attachment with pre-applied butyl pad",
      "ai_value": "Unirac Stronghold Butyl attachment with pre-applied butyl pad",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "STRONGHOLD BUTYL ATTACHMENTS ... pre-applied, peel and install, butyl design",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Roof pitch",
      "source": "pdf",
      "raw_value": "4/12",
      "ai_value": "4/12",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "ROOF TILT 18°",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Storage architecture",
      "source": "pdf",
      "raw_value": "Energy Storage System",
      "ai_value": "Energy Storage System",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "TESLA POWERWALL 3 ... INVERTER / ENERGY STORAGE SYSTEM",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+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": null,
      "source_excerpt": "INTERCONNECTION: PV BREAKER TIE IN SUB",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Total roof area (sq ft)",
      "source": "pdf",
      "raw_value": "1884",
      "ai_value": "1884",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "AREA OF ROOF (PLAN VIEW) (Sq. Ft.) 1883.98",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Utility available fault current greater than 10 kA at service",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Maximum Short-Circuit Current Rating 10 kA",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Utility company name",
      "source": "asana",
      "raw_value": "Southern California Edison",
      "ai_value": "Southern California Edison",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Utility: SCE (CA)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Utility service feed rating (Amps)",
      "source": "pdf",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    },
    {
      "payload_key": "Whole home backup",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "BATTERY CONFIGURATION: WHOLE HOME BACKUP",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:38:24.781396+00:00"
    }
  ],
  "artifacts": [
    {
      "id": 72,
      "kind": "asana_json",
      "local_path": "/data/runs/01KQQNE2XV9BP3XGGQ8ZPSZRSA/asana.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 39325,
      "downloaded_at": "2026-05-03T19:35:53.164581+00:00"
    },
    {
      "id": 73,
      "kind": "pdf",
      "local_path": "/data/runs/01KQQNE2XV9BP3XGGQ8ZPSZRSA/pdf/Teresa_Ramirez_V0_12-16-2025.pdf",
      "drive_file_id": "1p3daAjfHODTGPqqvHtAIAmWQWNu83s9U",
      "sha256": "41acb4f7fafc1047d3c43daf7d286d6f6f49b9f0cfa950d693b252711d0faac4",
      "bytes": 8555492,
      "downloaded_at": "2026-05-03T19:35:57.205903+00:00"
    },
    {
      "id": 75,
      "kind": "extraction",
      "local_path": "/data/runs/01KQQNE2XV9BP3XGGQ8ZPSZRSA/extraction.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 39709,
      "downloaded_at": "2026-05-03T19:38:24.771111+00:00"
    }
  ],
  "has_final_patch": false,
  "final_patch_field_count": 0,
  "_meta": {
    "collected_at": "2026-05-06T21:23:10.104615+00:00",
    "iteration_count": 0,
    "audit_log_count": 16,
    "field_values_count": 89,
    "artifacts_count": 3,
    "has_final_patch": false
  }
}