Cleaning Logs and Query Outputs
Table 1
Table
6 / 9
Table 1
Table
Table 1
| Field | Purpose |
|---|---|
| `rule_id` | Unique identifier for the check |
| `participant_id` | Record requiring review |
| `site` | Site responsible for follow-up |
| `variable` | Field or derived variable involved |
| `issue_description` | Plain-language explanation of the issue |
| `query_text` | Suggested message to site |
| `priority` | Operational importance |
| `status` | Open, answered, resolved, closed, not a query |
| `date_identified` | Date the issue was found |
| `date_resolved` | Date the issue was resolved |
| `resolution_notes` | Human-readable decision or explanation |