xpms.v_sheet_activity_log
View
The Playbook Activity Log 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. |
| organization | text | Yes | ORGANIZATION (column B), field. |
| project | text | Yes | PROJECT (column C), field. |
| department | text | Yes | DEPARTMENT (column D), field. |
| category | text | Yes | CATEGORY (column E), field. |
| sub_category | text | Yes | SUB CATEGORY (column F), field. |
| timestamp | text | Yes | TIMESTAMP (column G), field. |
| location_zone | text | Yes | LOCATION / ZONE (column H), field. |
| subject_item | text | Yes | SUBJECT / ITEM (column I), field. |
| description | text | Yes | DESCRIPTION (column J), field. |
| party_involved | text | Yes | PARTY INVOLVED (column K), field. |
| qty_value | text | Yes | QTY / VALUE (column L), field. |
| priority | text | Yes | PRIORITY (column M), field. |
| logged_by | text | Yes | LOGGED BY (column N), field. |
| reference_id | text | Yes | REFERENCE ID (column O), field. |
| status | text | Yes | STATUS (column P), field. |
| flag | text | Yes | FLAG (column Q), field. |
| notes | text | Yes | NOTES (column R), field. |
| created_by | text | Yes | CREATED BY (column S), field. |
| created_at | text | Yes | CREATED AT (column T), field. |
| updated_at | text | Yes | UPDATED AT (column U), field. |