# CSV field dictionary — all data fictional

One row = one service visit. UTF-8 CSV; semicolon within a cell separates reference IDs. `NONE` explicitly means none/not applicable (not missing). Empty cell means unknown/missing and must be reviewed.

| Column | Meaning | Origin / handling |
|---|---|---|
| `job_id` | Unique, filesystem-safe visit key | Internal record identity; required |
| `source_ref` | Approved work order identifier | Link to original source, not proof by itself; required |
| `visit_date` | Recorded ISO date | Copy, never infer |
| `time_zone` | IANA time zone | Label for source date/time; no scheduling calculation |
| `technician_id` | Pseudonymous technician ID | No personal name necessary in sample |
| `site_code` | Fictional site label | No real addresses |
| `asset_code` | Fictional equipment label | No serial number of a real customer |
| `work_request` | Original task description | Compare original request |
| `technician_notes` | Raw note text | Not automatically fact-checked |
| `approved_actions` | Action text marked approved in input | **Unverified assertion** until work-order check |
| `approved_parts` | Part code and quantity, or NONE | Verify with stock log; `FILTER-A:1` = one unit |
| `photo_refs` | Semicolon-separated photo IDs or NONE | References only; sample contains no actual images |
| `photo_status` | REFERENCED, NOT_REQUIRED or PENDING | Never means actual photo evidence checked |
| `job_status` | COMPLETE, PARTIAL or OPEN | Recorded status only; never infer |
| `unresolved_items` | Outstanding issue or NONE | COMPLETE with issue triggers contradiction |
| `follow_up_owner` | Existing role tasked with next action, or NONE | No automatic assignment |
| `customer_ack_status` | RECORDED, NOT_OBTAINED, NOT_REQUIRED | Does not equal customer acceptance |
| `customer_ack_ref` | Source ID for acknowledgment, or NONE | Proof and meaning must be inspected |
| `tech_review` | APPROVED or PENDING field | Self-declared input; script never certifies approval |
| `coordinator_review` | APPROVED or PENDING field | Self-declared input; script never certifies approval |

Test cases: FS-1001 reference-only complete case; FS-1002 partial scope; FS-1003 missing photo reference; FS-1004 COMPLETE versus unresolved conflict; FS-1005 no-part/no-photo case; FS-1006 acknowledgment evidence missing; FS-1007 missing original WO; FS-1008 follow-up owner missing. Dates, asset and parts codes are fabricated for demonstration.
