adm_report_documents_v
Document reporting view showing key metadata, ownership, status, and file information in a user-friendly format.
Overview
Section titled “Overview”Category: Documents - Core document analysis and reporting
Use Cases
Section titled “Use Cases”- Document analysis
- Ownership tracking
- Status monitoring
Columns
Section titled “Columns”The view contains 30 columns providing comprehensive information:
| Column Name | Description |
|---|---|
document_id | Primary key of the document. |
document_name | Name of the document file. |
folder_id | Foreign key to the folder containing the document. |
folder_path | Full hierarchical path of the containing folder. |
document_path | Full path of the document including folder structure. |
current_folder_name | Name of the current folder containing the document. |
file_mime_type | MIME type of the document file. |
latest_version_id | Foreign key to the latest version of the document. |
latest_version_number | Version number of the latest document version. |
latest_file_size | File size of the latest version in bytes. |
latest_file_size_kb | File size of the latest version in kilobytes (rounded to 2 decimal places). |
latest_file_size_mb | File size of the latest version in megabytes (rounded to 2 decimal places). |
legal_hold_flag | Y if the document is on legal hold and cannot be deleted. |
archived_flag | Y if the document has been archived. |
archived_date | Timestamp when the document was archived. |
archived_by | User who archived the document. |
deleted_flag | Y if the document has been soft-deleted. |
deleted_date | Timestamp when the document was soft-deleted. |
deleted_by | User who soft-deleted the document. |
retention_delete_date | Date when the document should be deleted per retention policy. |
retention_category | Retention category assigned to the document. |
user_owner | Username of the user owner if stored in /users/ folder. |
group_owner | Group name of the group owner if stored in /groups/ folder. |
owner_type | Type of owner: USER, GROUP, or NONE. |
created_date | Timestamp when the document was created. |
created_by | User who created the document. |
updated_date | Timestamp when the document metadata was last updated. |
updated_by | User who last updated the document metadata. |
document_status | Current status: ACTIVE, ARCHIVED, DELETED, or LEGAL_HOLD. |
retention_status | Retention policy status: NO_RETENTION, RETENTION_PENDING, or RETENTION_EXPIRED. |
Description: Comprehensive reporting view for documents showing all key metadata, ownership, status, and file information in a user-friendly format.
Key Features
Section titled “Key Features”- File size calculations (bytes/KB/MB)
- Document status categorization
- Retention status
- Owner type classification