adm_report_pdf_provenance_v
PDF provenance reporting view with one row per version of a PDF document, holding the signature status of the version, the status of the version before it, the signing mode of the folder, and a flag for the versions that are no longer the file that ADM signed.
Overview
Section titled “Overview”Group: Administrative reporting
Category: Signing - PDF signatures and where a PDF comes from
Use Cases
Section titled “Use Cases”- Find the PDFs that changed after ADM signed them
- Review the signature status per folder and signing mode
- Follow the status of one document from version to version
Columns
Section titled “Columns”The view contains 14 columns providing comprehensive information:
| Column Name | Description |
|---|---|
document_id |
The PDF document. |
version_id |
The version. |
version_number |
The number of the version, from 1. |
document_name |
The name of the document. |
folder_id |
The folder of the document. |
folder_path |
The path of the folder of the document. |
version_created_by |
The user who stored the version: an upload, a PDF operation, a save in the PDF editor or a restore. |
version_created_date |
When the version was stored. |
version_status |
CURRENT for the latest version of the document, HISTORICAL for an older one. |
deleted_flag |
Y when the document is in the trash. |
pdf_provenance |
The status of the version: NOT_SIGNED, ADM_SIGNED, MODIFIED, FOREIGN_SIGNED or UNKNOWN. A version that ADM did not classify (stored before the column, or in a folder with the signing mode OFF) is UNKNOWN. |
previous_provenance |
The status of the version before it (the next lower version number). Null for the first version. |
signing_mode |
The signing mode of the folder now: OFF, WATCH or SIGN, from the active signing policy with the longest pattern, or from the setting AUTO_SIGN_DEFAULT_MODE. Null when that setting holds a value that is not a mode. A move of the folder changes it. |
no_longer_pure_adm |
Y when the version is MODIFIED, or when the version before it was ADM_SIGNED and this version is not. N otherwise. |
Description: One row per version of a PDF document, with the signature status of the version, the status of the version before it and the signing mode of the folder: the report of the PDFs that are no longer the file that ADM signed. ADMINISTRATIVE SCOPE: no ADM user-access filter is applied - every row in the instance is returned regardless of who is querying. For one document as a user, use adm_pdf_api.get_provenance.
Key Features
Section titled “Key Features”- Status of each version and of the version before it
- Flag no_longer_pure_adm
- Signing mode of the folder, resolved like adm_signing_api.get_effective_policy
- No file read: the status is the stored column