xpms.v_sheet_inspection_compliance
View
The Playbook Inspection Compliance sheet as the database holds it: one row per source row, computed columns reproduced in SQL.
| Column | Type | Nullable | Description |
|---|---|---|---|
| source_row | integer | Yes | Row number in the source sheet. |
| record_id | text | Yes | RECORD ID (column A), field. |
| department | text | Yes | DEPARTMENT (column D), field. |
| category | text | Yes | CATEGORY (column E), field. |
| sub_category | text | Yes | SUB CATEGORY (column F), field. |
| inspection_type | text | Yes | INSPECTION TYPE (column G), field. |
| agency | text | Yes | AGENCY (column H), field. |
| ahj_jurisdiction_code | text | Yes | AHJ JURISDICTION CODE (column I), field. |
| permit_number | text | Yes | PERMIT NUMBER (column J), field. |
| permit_doc_id | text | Yes | PERMIT DOC ID (column K), field. |
| location_id | text | Yes | LOCATION ID (column L), field. |
| vendor_id | text | Yes | VENDOR ID (column M), field. |
| inspector_name | text | Yes | INSPECTOR NAME (column N), field. |
| scheduled_date | text | Yes | SCHEDULED DATE (column O), field. |
| completed_date | text | Yes | COMPLETED DATE (column P), field. |
| result | text | Yes | RESULT (column Q), field. |
| deficiency_summary | text | Yes | DEFICIENCY SUMMARY (column R), field. |
| sign_off_date | text | Yes | SIGN-OFF DATE (column S), field. |
| sign_off_url | text | Yes | SIGN-OFF URL (column T), field. |
| status | text | Yes | STATUS (column U), field. |
| flag | text | Yes | FLAG (column V), field. |
| notes | text | Yes | NOTES (column W), field. |
| created_by | text | Yes | CREATED BY (column X), field. |
| created_at | text | Yes | CREATED AT (column Y), field. |
| updated_at | text | Yes | UPDATED AT (column Z), field. |
| organization | text | Yes | ORGANIZATION (column B), computed. |
| project_id | text | Yes | PROJECT ID (column C), computed. |