adm_report_documents_v

Document reporting view showing metadata, ownership, status and file information.

Access scope — Administrative reporting

Applies NO ADM user-access filter. Every matching row in the instance is returned, whoever is querying, and establishing an ADM context does not narrow it. Treat it as an administrative interface: anything built on it carries the whole authorization decision itself.

Overview

Group: Administrative reporting

Category: Documents - Core document analysis and reporting

Use Cases

• Document analysis
• Ownership tracking
• Status monitoring

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, which makes the delete APIs refuse it. Independent of archived_flag and deleted_flag: a document on legal hold is otherwise an ordinary, readable document.
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	A single label derived from three INDEPENDENT flags, in priority order: DELETED, then ARCHIVED, then LEGAL_HOLD, else ACTIVE. Only the highest-priority condition shows, so a document that is archived AND on legal hold reads as ARCHIVED. Read deleted_flag, archived_flag and legal_hold_flag directly whenever more than one condition matters.
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. ADMINISTRATIVE SCOPE: no ADM user-access filter is applied - every row in the instance is returned regardless of who is querying. For a session-scoped interface use adm_my_documents_v.

Key Features

• File size calculations (bytes/KB/MB)
• Document status categorization
• Retention status
• Owner type classification

Related Views

Other views in the Documents category:

• adm_my_documents_v