← back to audit · 01KQQNBCXMJBEC32BYJB1SCHS9

Teresa Ramirez

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

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
331	info	asana_fetched	Resolving Asana task reference 'https://app.asana.com/1/1203754389657527/project/1211039529104749/task/1211709017140700'	2026-05-03T19:34:24
332	info	asana_fetched	Loaded Asana task: Teresa Ramirez payload { "customer": "Teresa Ramirez", "gid": "1211709017140700", "title": "Teresa Ramirez" }	2026-05-03T19:34:25
333	info	drive_resolved	Searching Asana fields for Google Drive URL	2026-05-03T19:34:25
334	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:34:26
335	info	pdf_downloaded	Picking the latest-dated plan-set PDF	2026-05-03T19:34:26
336	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:34:29
337	info	bom_downloaded	Looking for the BOM CSV in the same folder	2026-05-03T19:34:29
338	warn	bom_downloaded	No BOM CSV in folder — modules section will rely on PDF + Asana only	2026-05-03T19:34:29
339	info	ai_extracted	Extracting text from the plan-set PDF	2026-05-03T19:34:29
340	info	ai_extracted	Pass 1/3: Claude Opus 4.7 (full extraction)	2026-05-03T19:34:36
341	info	ai_extracted	Pass 1: Opus filled 65 fields (avg 85%)	2026-05-03T19:35:43
342	info	ai_extracted	Pass 2/3: Claude Sonnet 4.6 retrying 32 missing fields	2026-05-03T19:35:43
353	info	ai_extracted	Pass 2: Sonnet added 25 more fields	2026-05-03T19:36:57
354	info	ai_extracted	Pass 3/3: Claude Opus 4.7 final retry on 7 stubborn fields	2026-05-03T19:36:57
355	info	ai_extracted	Extracted 90 fields, avg confidence 82% (Opus: 65, Sonnet retry: +25, 7 still unfilled) payload { "avg_confidence": 0.823, "extra_fields": 0, "fields": 90, "missing": 7, "passes": { "opus_full": 65, "opus_retry": 0, "sonnet_retry": 25 }, "usage": { "cache_creation_input_tokens": 9992, "cache_read_input_tokens": 0, "input_tokens": 77980, "output_tokens": 9409 } }	2026-05-03T19:37:04
356	info	awaiting_review	Pipeline complete — review the extracted fields and submit when ready	2026-05-03T19:37:04

Field values (90)

▸ 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.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)	200	—	0.70	no	yes
Backup feeder conductor material	Copper	—	0.90	no	yes
Busbar #1 already present on site	Yes	—	0.90	no	yes
Busbar #1 interconnection compliance method	120% rule	—	0.90	no	yes
Busbar #1 main-lug-only solo main breaker present	No	—	0.70	no	yes
Busbar #1 main panel upgrade	No	—	0.95	no	yes
Busbar #1 number of branch circuit breakers	2	—	0.60	no	yes
Busbar #1 on line side of main service panel	No	—	0.85	no	yes
Busbar #1 panel type	Main Service Panel	—	0.85	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	705.12(B)(2)	—	0.85	no	yes
Busbar feeder max THWN-2 conductors in raceway	3	—	0.90	no	yes
Busbar feeder OCPD rating (Amps)	70	—	0.85	no	yes
Busbar feeder wire gauge (AWG)	4	—	0.90	no	yes
Calculated backup load (Watts)	11500	—	0.55	no	yes
Combiner panel contains ESS	No	—	0.75	no	yes
Combiner panel has dedicated OCPD	Yes	—	0.90	no	yes
Combiner panel interconnection location	New Subpanel	—	0.85	no	yes
Current roof covering material	Asphalt or composition shingles	—	0.95	no	yes
ESS assembly weight (lbs)	291	—	0.90	no	yes
ESS subject to vehicle damage (alternate)	No	—	0.75	no	yes
ESS unit charging from grid	Yes	—	0.60	no	yes
ESS unit has dedicated OCPD	Yes	—	0.80	no	yes
ESS unit installation location (architecture: Energy Storage System)	Outdoor walls	—	0.85	no	yes
ESS unit interconnection location	New Subpanel	—	0.75	no	yes
ESS unit is single unit with inverter	Yes	—	0.90	no	yes
ESS unit manufacturer (architecture: Energy Storage System)	Tesla	—	0.97	no	yes
ESS unit model (architecture: Energy Storage System)	Powerwall 3 (1707000-11-J-DOM)	—	0.92	no	yes
ESS unit OCPD rating (Amps)	60	—	0.90	no	yes
ESS unit quantity (architecture: Energy Storage System)	1	—	0.97	no	yes
ESS units have separation less than 3 feet (alternate)	No	—	0.85	no	yes
Flush mount or tilt-up	Flush mount	—	0.92	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.85	no	yes
Inverter 1 Manufacturer	Tesla	—	0.97	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 without DC-DC Converters	—	0.60	no	yes
Inverter output uses NM cable	No	—	0.85	no	yes
Main breaker derate applied	No	—	0.75	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.80	no	yes
Maximum distance from module to roof (inches)	7	—	0.60	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.85	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	7	—	0.55	no	yes
Microinverter module capacity (W)	450	—	0.70	no	yes
Microinverters protected by 20A OCPD	Yes	—	0.60	no	yes
Microinverter total quantity	18	—	0.90	no	yes
Module 1 Quantity	13	—	0.98	no	yes
Module fire rating type	2	—	0.40	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.60	no	yes
OCPD protecting busbar #1 rating (Amps)	70	—	0.95	no	yes
Project Address	248 Mount Arbor Street, McFarland, CA 93250	—	0.95	no	yes
Project valuation (USD)	43296	—	0.85	no	yes
PV system weight (lbs/sq ft)	4.0	—	0.45	no	yes
Racking System Manufacturer	Unirac	—	0.97	no	yes
Racking System Model Number	NXT UMOUNT	—	0.95	no	yes
Rafter has ceiling joists	No	—	0.65	no	yes
Rafter largest span (feet)	24.0	—	0.35	no	yes
Rafter size (nominal)	2x4	—	0.92	no	yes
Rafter spacing (inches)	24	—	0.95	no	yes
Rafter type	Engineered truss	—	0.90	no	yes
Rapid Shutdown compliance method inside array	PV Hazard Control System (UL 3741)	—	0.70	no	yes
Rapid Shutdown Device Manufacturer	Tesla	—	0.97	no	yes
Rapid Shutdown Device Model Number	MCI-2S	—	0.95	no	yes
Rapid Shutdown Device Quantity	5	—	0.97	no	yes
Roof framing type	Truss	—	0.90	no	yes
Roof has flat plane	No	—	0.60	no	yes
Roof penetration sealant method name and description	Unirac Stronghold Butyl attachment with pre-applied butyl pad	—	0.90	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/01KQQNBCXMJBEC32BYJB1SCHS9/asana.json	39325 B
`pdf`	/data/runs/01KQQNBCXMJBEC32BYJB1SCHS9/pdf/Teresa_Ramirez_V0_12-16-2025.pdf	8555492 B	41acb4f7fafc1047
`extraction`	/data/runs/01KQQNBCXMJBEC32BYJB1SCHS9/extraction.json	39964 B

{
  "run": {
    "id": "01KQQNBCXMJBEC32BYJB1SCHS9",
    "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": 77980,
      "output_tokens": 9409,
      "cache_read_input_tokens": 0,
      "cache_creation_input_tokens": 9992
    },
    "avg_confidence": 0.823,
    "warnings": [
      "Roof pitch derived from 18° tilt (~4/12); plan set states tilt only.",
      "Module fire rating not stated in plan set; guessed.",
      "Backup device OCPD rating uses Backup Switch continuous load rating (200A); verify.",
      "ESS interconnection location inferred from layout (new sub panel); verify.",
      "Inverter architecture: Powerwall 3 has integrated MPPTs but no separate DC-DC optimizers — chose 'String Inverter without DC-DC Converters'.",
      "The new PV system uses Tesla Powerwall 3 with integrated inverter (string inverter architecture with Tesla MCI-2S rapid shutdown devices), NOT microinverters. The microinverter fields (Max microinverters per branch circuit, Microinverter module capacity, Microinverter total quantity, Microinverters protected by 20A OCPD) refer to the EXISTING system (18x Enphase IQ8PLUS-72-2-US on Znshine Solar 450W modules) tied to a separate utility meter. Reviewer should confirm whether these fields apply to the existing or new system.",
      "Rafter largest span could not be determined from available documents — only '2X4 TRUSS @ 24\" O.C.' is specified. Reviewer must pull structural drawings or truss engineering.",
      "PV system weight (lbs/sq ft) is inferred from typical values for this racking system; no explicit structural weight calc was found in the extracted PDF text.",
      "Home has sprinkler systems: No mention in any source; inferred No based on typical residential construction in this area. Reviewer must verify.",
      "Busbar #1 number of branch circuit breakers: Only 2 PV string circuits identified in the new system; the sub panel breaker count (existing branches) is not stated.",
      "DC-coupled battery fields skipped — the Tesla Powerwall 3 is an AC-coupled battery system (integrated AC inverter), not DC-coupled.",
      "Supply-side IX fields skipped — interconnection is load-side (PV breaker tie-in at new sub panel), not supply-side.",
      "Busbar feeder OCPD rating interpreted as the feeder breaker from sub panel to main panel (70A) based on conductor schedule raceway 5 maximum current.",
      "No DC-coupled battery: Tesla Powerwall 3 is an AC-coupled BESS per Asana ('TESLA 1707000-21 AC BESS') and the plan set shows AC interconnection. No supply-side interconnection: plan set explicitly states 'INTERCONNECTION: PV BREAKER TIE IN SUB' (load-side breaker), not a supply-side tap."
    ],
    "flow": "v1",
    "iteration_count": 0,
    "iteration_outcome": null,
    "final_diagnosis": null,
    "created_at": "2026-05-03T19:34:24.457939+00:00",
    "updated_at": "2026-05-03T19:37:04.282358+00:00",
    "submitted_at": null,
    "completed_at": null
  },
  "iterations": [],
  "insights": {
    "stuck_rules": [],
    "newly_revealed": [],
    "conditional_triggers": {}
  },
  "audit_log": [
    {
      "id": 331,
      "ts": "2026-05-03T19:34:24.676634+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": 332,
      "ts": "2026-05-03T19:34:25.367169+00:00",
      "stage": "asana_fetched",
      "level": "info",
      "message": "Loaded Asana task: Teresa Ramirez",
      "payload": {
        "gid": "1211709017140700",
        "title": "Teresa Ramirez",
        "customer": "Teresa Ramirez"
      }
    },
    {
      "id": 333,
      "ts": "2026-05-03T19:34:25.373733+00:00",
      "stage": "drive_resolved",
      "level": "info",
      "message": "Searching Asana fields for Google Drive URL",
      "payload": null
    },
    {
      "id": 334,
      "ts": "2026-05-03T19:34:26.959276+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": 335,
      "ts": "2026-05-03T19:34:26.966030+00:00",
      "stage": "pdf_downloaded",
      "level": "info",
      "message": "Picking the latest-dated plan-set PDF",
      "payload": null
    },
    {
      "id": 336,
      "ts": "2026-05-03T19:34:29.516008+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": 337,
      "ts": "2026-05-03T19:34:29.525007+00:00",
      "stage": "bom_downloaded",
      "level": "info",
      "message": "Looking for the BOM CSV in the same folder",
      "payload": null
    },
    {
      "id": 338,
      "ts": "2026-05-03T19:34:29.541751+00:00",
      "stage": "bom_downloaded",
      "level": "warn",
      "message": "No BOM CSV in folder — modules section will rely on PDF + Asana only",
      "payload": null
    },
    {
      "id": 339,
      "ts": "2026-05-03T19:34:29.690968+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracting text from the plan-set PDF",
      "payload": null
    },
    {
      "id": 340,
      "ts": "2026-05-03T19:34:36.532225+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1/3: Claude Opus 4.7 (full extraction)",
      "payload": null
    },
    {
      "id": 341,
      "ts": "2026-05-03T19:35:43.962173+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 1: Opus filled 65 fields (avg 85%)",
      "payload": null
    },
    {
      "id": 342,
      "ts": "2026-05-03T19:35:43.977923+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 2/3: Claude Sonnet 4.6 retrying 32 missing fields",
      "payload": null
    },
    {
      "id": 353,
      "ts": "2026-05-03T19:36:57.421883+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 2: Sonnet added 25 more fields",
      "payload": null
    },
    {
      "id": 354,
      "ts": "2026-05-03T19:36:57.441552+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Pass 3/3: Claude Opus 4.7 final retry on 7 stubborn fields",
      "payload": null
    },
    {
      "id": 355,
      "ts": "2026-05-03T19:37:04.274968+00:00",
      "stage": "ai_extracted",
      "level": "info",
      "message": "Extracted 90 fields, avg confidence 82% (Opus: 65, Sonnet retry: +25, 7 still unfilled)",
      "payload": {
        "usage": {
          "input_tokens": 77980,
          "output_tokens": 9409,
          "cache_read_input_tokens": 0,
          "cache_creation_input_tokens": 9992
        },
        "fields": 90,
        "passes": {
          "opus_full": 65,
          "opus_retry": 0,
          "sonnet_retry": 25
        },
        "missing": 7,
        "extra_fields": 0,
        "avg_confidence": 0.823
      }
    },
    {
      "id": 356,
      "ts": "2026-05-03T19:37:04.289177+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:37:04.048938+00:00"
    },
    {
      "payload_key": "Backup contains service disconnect",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.8,
      "edited": false,
      "reasoning": "The Tesla Backup Switch serves as the service disconnect/grid isolation device in the backup system architecture, controlling connection to grid during outages.",
      "source_excerpt": "TESLA BACKUP SWITCH (MICROGRID INTERCONNECTION DEVICE) ... The Tesla Backup Switch controls connection to the grid in a Powerwall system",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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": "(N) TESLA BACKUP SWITCH (MICROGRID INTERCONNECTION DEVICE)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Backup device model",
      "source": "pdf",
      "raw_value": "Backup Switch",
      "ai_value": "Backup Switch",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "TESLA BACKUP SWITCH",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Backup device OCPD rating (Amps)",
      "source": "pdf",
      "raw_value": "200",
      "ai_value": "200",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Continuous Load Rating 200 A, 120/240 V split phase",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Busbar #1 already present on site",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Busbar #1 interconnection compliance method",
      "source": "pdf",
      "raw_value": "120% rule",
      "ai_value": "120% rule",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "BUS RATING x 120% 240-70=170A ALLOWABLE BACKFEED",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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.7,
      "edited": false,
      "reasoning": "The existing main service panel has a 70A main breaker, indicating it is not a main-lug-only panel.",
      "source_excerpt": "(E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "Busbar #1 number of branch circuit breakers",
      "source": "pdf",
      "raw_value": "2",
      "ai_value": "2",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "The system has two DC branch circuits (circuit #1 with 6 modules, circuit #2 with 7 modules). These feed into the integrated inverter, not separate breakers in a busbar, but this represents the number of PV input circuits.",
      "source_excerpt": "(01) CIRCUIT OF 6 MODULES (01) CIRCUIT OF 7 MODULES",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Busbar #1 on line side of main service panel",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "The interconnection is at the new sub panel (load side of the main service panel), not on the line side.",
      "source_excerpt": "INTERCONNECTION: PV BREAKER TIE IN SUB ... (E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER ... (N) 200A SUB PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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.85,
      "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:37:04.048938+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:37:04.048938+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 ... BUS RATING x 120%",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Busbar feeder interconnection compliance method",
      "source": "pdf",
      "raw_value": "705.12(B)(2)",
      "ai_value": "705.12(B)(2)",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "The plan set explicitly cites NEC 705.12(B)(2) as the compliance method for backfeed breaker sizing.",
      "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:37:04.048938+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": "The conductor quantity column for raceway 5 shows 3 conductors (2 hots + 1 neutral/ground) in the 1\" EMT conduit.",
      "source_excerpt": "RACEWAY 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:37:04.048938+00:00"
    },
    {
      "payload_key": "Busbar feeder OCPD rating (Amps)",
      "source": "pdf",
      "raw_value": "70",
      "ai_value": "70",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "The feeder from sub panel to main panel has a maximum current of 70A applied, and the main breaker is 70A. The sub panel feeder OCPD is 70A.",
      "source_excerpt": "(E) 200A MAIN SERVICE PANEL WITH (E) 70A MAIN BREAKER ... RACEWAY 5: SUB PANEL TO MAIN PANEL ... 4 AWG THWN-2 COPPER ... 70.00",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Busbar feeder wire gauge (AWG)",
      "source": "pdf",
      "raw_value": "4",
      "ai_value": "4",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Raceway 5 (sub panel to main panel) uses 4 AWG THWN-2 copper conductors, as stated in the conductor schedule.",
      "source_excerpt": "RACEWAY 5 AC SUB PANEL TO MAIN PANEL 3 1\" EMT CONDUIT ... 4 AWG THWN-2 COPPER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Calculated backup load (Watts)",
      "source": "pdf",
      "raw_value": "11500",
      "ai_value": "11500",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "The system is configured for whole home backup. The Powerwall 3 provides 11.5 kW AC continuous output, which represents the maximum backup load capacity. No explicit calculated backup load value is stated; using inverter rated output as proxy.",
      "source_excerpt": "BATTERY CONFIGURATION: WHOLE HOME BACKUP ... TESLA POWERWALL 3 11.5 KW / 13.5 KWH",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Combiner panel contains ESS",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.75,
      "edited": false,
      "reasoning": "The Powerwall 3 is a standalone integrated inverter/ESS unit connected to the sub panel via AC disconnect; the sub panel itself does not contain the ESS.",
      "source_excerpt": "(N) TESLA POWERWALL 3 11.5 KW / 13.5 KWH (1707000-11-J-DOM) INVERTER / ENERGY STORAGE SYSTEM ... (N) 200A SUB PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Combiner panel has dedicated OCPD",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "The electrical diagram shows a dedicated 60A breaker in the new sub panel for the PV/inverter interconnection.",
      "source_excerpt": "(N) 60A BREAKER ... (N) 200A SUB PANEL ... BACKFEED BREAKER SIZING ... 60A PV BREAKER - OK",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Combiner panel interconnection location",
      "source": "pdf",
      "raw_value": "New Subpanel",
      "ai_value": "New Subpanel",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "The plan set and Asana both state interconnection is via PV breaker tie-in at a new sub panel. The 60A PV breaker is installed in the new 200A sub panel.",
      "source_excerpt": "INTERCONNECTION: PV BREAKER TIE IN SUB ... (N) 200A SUB PANEL ... (N) 60A BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "ESS assembly weight (lbs)",
      "source": "pdf",
      "raw_value": "291",
      "ai_value": "291",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "Tesla Powerwall 3 datasheet in the plan set explicitly states total installed unit weight of 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:37:04.048938+00:00"
    },
    {
      "payload_key": "ESS subject to vehicle damage (alternate)",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.75,
      "edited": false,
      "reasoning": "The Powerwall 3 is wall-mounted on the east outside wall of the structure, not in a location subject to vehicle traffic (no garage or driveway proximity indicated).",
      "source_excerpt": "TESLA POWERWALL (E) 2\" X 4\" WALL STUDS TESLA POWERWALL MOUNTING BRACKET (4) 1/4\" X 3\" LAG BOLTS... EAST OUTSIDE WALL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "ESS unit has dedicated OCPD",
      "source": "pdf",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.8,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 60A NON-FUSED AC DISCONNECT ... (N) 60A BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "EAST OUTSIDE WALL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "ESS unit interconnection location",
      "source": "pdf",
      "raw_value": "New Subpanel",
      "ai_value": "New Subpanel",
      "user_value": null,
      "confidence": 0.75,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 200A SUB PANEL",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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": "TESLA POWERWALL 3 ... INVERTER / ENERGY STORAGE SYSTEM",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "ESS unit manufacturer (architecture: Energy Storage System)",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.97,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "TESLA POWERWALL 3",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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.92,
      "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:37:04.048938+00:00"
    },
    {
      "payload_key": "ESS unit OCPD rating (Amps)",
      "source": "pdf",
      "raw_value": "60",
      "ai_value": "60",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Overcurrent Protection Device 60 A",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "ESS unit quantity (architecture: Energy Storage System)",
      "source": "pdf",
      "raw_value": "1",
      "ai_value": "1",
      "user_value": null,
      "confidence": 0.97,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 01- TESLA POWERWALL 3",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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.85,
      "edited": false,
      "reasoning": "Plan set explicitly calls out the 3-foot separation requirement for multiple ESS systems and notes compliance with it. Only one Powerwall 3 unit is installed.",
      "source_excerpt": "MULTIPLE ESS SYSTEMS SHALL BE SEPARATED FROM EACH OTHER BY AT LEAST 3'",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Flush mount or tilt-up",
      "source": "pdf",
      "raw_value": "Flush mount",
      "ai_value": "Flush mount",
      "user_value": null,
      "confidence": 0.92,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "PHOTOVOLTAIC ROOF MOUNT SYSTEM",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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 residential in McFarland, CA at this contract value is unlikely to have sprinklers. Reviewer should verify.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "Inverter 1 interconnection location",
      "source": "pdf",
      "raw_value": "New Subpanel",
      "ai_value": "New Subpanel",
      "user_value": null,
      "confidence": 0.85,
      "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:37:04.048938+00:00"
    },
    {
      "payload_key": "Inverter 1 Manufacturer",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.97,
      "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:37:04.048938+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:37:04.048938+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",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Inverter architecture type",
      "source": "inferred",
      "raw_value": "String Inverter without DC-DC Converters",
      "ai_value": "String Inverter without DC-DC Converters",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Inverter output uses NM cable",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.85,
      "edited": false,
      "reasoning": "The plan set specifies EMT conduit for all AC runs (raceways 3, 4, 5) and prohibits NM-B on exterior. The inverter output conductors are in 3/4\" EMT conduit.",
      "source_excerpt": "NO PVC ALLOWED ON ROOF OR IN ATTIC ... 3/4\" EMT CONDUIT RUN ... (G) NO PVC ALLOWED ON ROOF OR IN ATTIC. (N) NM-B OR PAPER INSULATED CONDUCTORS MAY NOT BE USED ON EXTERIOR.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Main breaker derate applied",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.75,
      "edited": false,
      "reasoning": "The compliance method used is 705.12(B)(2) sum rule (120% bus rating minus main breaker), not the main breaker derate method under 705.12(B)(2)(3)(c). No derate attestation label is indicated.",
      "source_excerpt": "SEE NEC 705.12(B)(2) OF 2026 NEC 200X1.20=240 BUS RATING x 120% 240-70=170A ALLOWABLE BACKFEED ((BUS RATING x 1.2) - MAIN BREAKER)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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": "MCI TO JUNCTION BOX 4- 10 AWG PV WIRE",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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.8,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "JUNCTION BOX TO INVERTER 4 ... 10 AWG THWN-2",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Maximum distance from module to roof (inches)",
      "source": "pdf",
      "raw_value": "7",
      "ai_value": "7",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "3\" MIN. 6\" MAX.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+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:37:04.048938+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.85,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 7 MODULES IN BRANCH CIRCUIT #2",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "Max microinverters per branch circuit",
      "source": "pdf",
      "raw_value": "7",
      "ai_value": "7",
      "user_value": null,
      "confidence": 0.55,
      "edited": false,
      "reasoning": "The existing system uses Enphase IQ8PLUS microinverters (18 units). The new system uses Tesla MCI-2S rapid shutdown devices, not microinverters. The 6 and 7 module circuits refer to the new Tesla Powerwall 3 string inputs, not microinverter branch circuits. This field may not apply to the new system.",
      "source_excerpt": "(01) CIRCUIT OF 6 MODULES (01) CIRCUIT OF 7 MODULES",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Microinverter module capacity (W)",
      "source": "pdf",
      "raw_value": "450",
      "ai_value": "450",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": "The existing system has 18 Enphase IQ8PLUS microinverters paired with 450W Znshine Solar modules. The IQ8PLUS handles up to 440-550W modules; the module capacity is 450W.",
      "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:37:04.048938+00:00"
    },
    {
      "payload_key": "Microinverters protected by 20A OCPD",
      "source": "inferred",
      "raw_value": "Yes",
      "ai_value": "Yes",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": "Enphase IQ8PLUS microinverters are standard residential microinverters typically protected by 20A OCPD per NEC 705.12 and Enphase installation guidelines. No explicit OCPD value for the existing microinverter system is stated in the plan set.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Microinverter total quantity",
      "source": "pdf",
      "raw_value": "18",
      "ai_value": "18",
      "user_value": null,
      "confidence": 0.9,
      "edited": false,
      "reasoning": "The existing system has 18 Enphase IQ8PLUS-72-2-US microinverters, explicitly stated in the plan set.",
      "source_excerpt": "18 - ENPHASE IQ8PLUS-72-2-US MICROINVERTERS",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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": "13 MODULES - ROOF MOUNT - 5.330 kWDC",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Module fire rating type",
      "source": "inferred",
      "raw_value": "2",
      "ai_value": "2",
      "user_value": null,
      "confidence": 0.4,
      "edited": false,
      "reasoning": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "Module Manufacturer",
      "source": "pdf",
      "raw_value": "Q CELLS",
      "ai_value": "Q CELLS",
      "user_value": null,
      "confidence": 0.95,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "13 - QCELLS: Q.PEAK DUO BLK ML-G10.C+ 410 (410W) MODULES",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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) 70A MAIN BREAKER",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Project Address",
      "source": "asana",
      "raw_value": "248 Mount Arbor Street, McFarland, CA 93250",
      "ai_value": "248 Mount Arbor Street, 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:37:04.048938+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:37:04.048938+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.45,
      "edited": false,
      "reasoning": "No explicit lbs/sq ft value stated. Unirac NXT Umount system with Stronghold Butyl attachments is a lightweight system. Typical installed weight for this racking + QCELLS 410W modules is approximately 3.5-4.5 lbs/sq ft. Using 4.0 as a standard estimate; reviewer should verify from structural calcs.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Racking System Manufacturer",
      "source": "pdf",
      "raw_value": "Unirac",
      "ai_value": "Unirac",
      "user_value": null,
      "confidence": 0.97,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "UNIRAC NXT UMOUNT RAIL 168\"",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "Rafter has ceiling joists",
      "source": "pdf",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.65,
      "edited": false,
      "reasoning": "The roof framing is described as 2x4 truss construction (not stick-frame rafters with ceiling joists). Trusses typically do not have separate ceiling joists in the traditional sense — the bottom chord serves that function.",
      "source_excerpt": "ROOF FRAME: 2X4 TRUSS @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Rafter largest span (feet)",
      "source": "inferred",
      "raw_value": "24.0",
      "ai_value": "24.0",
      "user_value": null,
      "confidence": 0.35,
      "edited": false,
      "reasoning": "No explicit rafter/truss span stated. The roof plan shows modules on a single face. For a typical single-story residential in McFarland, CA with 2x4 truss at 24\" OC, spans of 18-28 ft are common. No direct measurement available; reviewer must verify.",
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Rafter size (nominal)",
      "source": "pdf",
      "raw_value": "2x4",
      "ai_value": "2x4",
      "user_value": null,
      "confidence": 0.92,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "2X4 TRUSS @ 24\" O.C.",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "Rapid Shutdown compliance method inside array",
      "source": "pdf",
      "raw_value": "PV Hazard Control System (UL 3741)",
      "ai_value": "PV Hazard Control System (UL 3741)",
      "user_value": null,
      "confidence": 0.7,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "Certifications UL 1741 PVRSE, UL 3741, PVRSA",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Manufacturer",
      "source": "pdf",
      "raw_value": "Tesla",
      "ai_value": "Tesla",
      "user_value": null,
      "confidence": 0.97,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "05 - TESLA MCI-2S (RAPID SHUTDOWN DEVICE)",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "Rapid Shutdown Device Quantity",
      "source": "pdf",
      "raw_value": "5",
      "ai_value": "5",
      "user_value": null,
      "confidence": 0.97,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "(N) 05- TESLA MCI-2S",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+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": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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.9,
      "edited": false,
      "reasoning": null,
      "source_excerpt": "UNIRAC STRONGHOLD BUTYL ATTACHMENTS",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+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:37:04.048938+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:37:04.048938+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:37:04.048938+00:00"
    },
    {
      "payload_key": "Utility available fault current greater than 10 kA at service",
      "source": "inferred",
      "raw_value": "No",
      "ai_value": "No",
      "user_value": null,
      "confidence": 0.6,
      "edited": false,
      "reasoning": null,
      "source_excerpt": null,
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+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",
      "in_field_map": true,
      "updated_at": "2026-05-03T19:37:04.048938+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:37:04.048938+00:00"
    }
  ],
  "artifacts": [
    {
      "id": 70,
      "kind": "asana_json",
      "local_path": "/data/runs/01KQQNBCXMJBEC32BYJB1SCHS9/asana.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 39325,
      "downloaded_at": "2026-05-03T19:34:25.352123+00:00"
    },
    {
      "id": 71,
      "kind": "pdf",
      "local_path": "/data/runs/01KQQNBCXMJBEC32BYJB1SCHS9/pdf/Teresa_Ramirez_V0_12-16-2025.pdf",
      "drive_file_id": "1p3daAjfHODTGPqqvHtAIAmWQWNu83s9U",
      "sha256": "41acb4f7fafc1047d3c43daf7d286d6f6f49b9f0cfa950d693b252711d0faac4",
      "bytes": 8555492,
      "downloaded_at": "2026-05-03T19:34:29.500475+00:00"
    },
    {
      "id": 74,
      "kind": "extraction",
      "local_path": "/data/runs/01KQQNBCXMJBEC32BYJB1SCHS9/extraction.json",
      "drive_file_id": null,
      "sha256": null,
      "bytes": 39964,
      "downloaded_at": "2026-05-03T19:37:04.039393+00:00"
    }
  ],
  "has_final_patch": false,
  "final_patch_field_count": 0,
  "_meta": {
    "collected_at": "2026-05-06T21:21:57.316160+00:00",
    "iteration_count": 0,
    "audit_log_count": 16,
    "field_values_count": 90,
    "artifacts_count": 3,
    "has_final_patch": false
  }
}