xpms.std_document_library
TableRow level security on
XOS Standard Library: Document & Asset Library (Playbook, provenance imported). Each new org receives an editable copy at creation.
Primary key: record_id
| Column | Type | Nullable | Description |
|---|---|---|---|
| source_row | integer | No | Row of the Playbook Document & Asset Library sheet the entry was imported from; the library's default order. |
| record_id | xpms.canon_text | No | RECORD ID from the Playbook Document & Asset Library sheet. |
| document_name | xpms.canon_text | Yes | DOCUMENT NAME from the Playbook Document & Asset Library sheet. |
| document_type | xpms.canon_text | Yes | DOCUMENT TYPE from the Playbook Document & Asset Library sheet. |
| reference_id | xpms.canon_text | Yes | REFERENCE ID from the Playbook Document & Asset Library sheet. |
| organization | xpms.canon_text | Yes | ORGANIZATION from the Playbook Document & Asset Library sheet. |
| project | xpms.canon_text | Yes | PROJECT from the Playbook Document & Asset Library sheet. |
| department | xpms.canon_text | Yes | DEPARTMENT from the Playbook Document & Asset Library sheet. |
| category | xpms.canon_text | Yes | CATEGORY from the Playbook Document & Asset Library sheet. |
| sub_category | xpms.canon_text | Yes | SUB CATEGORY from the Playbook Document & Asset Library sheet. |
| file_format | xpms.canon_text | Yes | FILE FORMAT from the Playbook Document & Asset Library sheet. |
| file_size | xpms.canon_text | Yes | FILE SIZE from the Playbook Document & Asset Library sheet. |
| storage_url | xpms.canon_text | Yes | STORAGE URL from the Playbook Document & Asset Library sheet. |
| version | xpms.canon_text | Yes | VERSION from the Playbook Document & Asset Library sheet. |
| issue_date | date | Yes | ISSUE DATE from the Playbook Document & Asset Library sheet. |
| expiration_date | date | Yes | EXPIRATION DATE from the Playbook Document & Asset Library sheet. |
| status | xpms.canon_text | Yes | STATUS from the Playbook Document & Asset Library sheet. |
| flag | boolean | Yes | FLAG from the Playbook Document & Asset Library sheet. |
| notes | xpms.canon_text | Yes | NOTES from the Playbook Document & Asset Library sheet. |
| created_by | xpms.canon_text | Yes | CREATED BY from the Playbook Document & Asset Library sheet. |
| created_at | timestamp without time zone | Yes | CREATED AT from the Playbook Document & Asset Library sheet. |
| updated_at | timestamp without time zone | Yes | UPDATED AT from the Playbook Document & Asset Library sheet. |