xpms.v_sheet_document_asset_library
View
The Playbook Document & Asset Library 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 | xpms.canon_text | Yes | RECORD ID (column A), field. |
| document_name | xpms.canon_text | Yes | DOCUMENT NAME (column B), field. |
| document_type | xpms.canon_text | Yes | DOCUMENT TYPE (column C), field. |
| reference_id | xpms.canon_text | Yes | REFERENCE ID (column D), field. |
| organization | xpms.canon_text | Yes | ORGANIZATION (column E), field. |
| project | xpms.canon_text | Yes | PROJECT (column F), field. |
| department | xpms.canon_text | Yes | DEPARTMENT (column G), field. |
| category | xpms.canon_text | Yes | CATEGORY (column H), field. |
| sub_category | xpms.canon_text | Yes | SUB CATEGORY (column I), field. |
| file_format | xpms.canon_text | Yes | FILE FORMAT (column J), field. |
| file_size | xpms.canon_text | Yes | FILE SIZE (column K), field. |
| storage_url | xpms.canon_text | Yes | STORAGE URL (column L), field. |
| version | xpms.canon_text | Yes | VERSION (column M), field. |
| issue_date | date | Yes | ISSUE DATE (column N), field. |
| expiration_date | date | Yes | EXPIRATION DATE (column O), field. |
| status | xpms.canon_text | Yes | STATUS (column P), field. |
| flag | boolean | Yes | FLAG (column Q), field. |
| notes | xpms.canon_text | Yes | NOTES (column R), field. |
| created_by | xpms.canon_text | Yes | CREATED BY (column S), field. |
| created_at | timestamp without time zone | Yes | CREATED AT (column T), field. |
| updated_at | timestamp without time zone | Yes | UPDATED AT (column U), field. |