R_AU_DOCUMENT_STEP
This table displays audit information for the status of an object, such as version-controlled or checked out.
Note: Except where otherwise noted, the term Document is used in this topic to refer to any object in Loftware Enterprise SP that is managed by using Documents permissions. This includes the following types of objects: label templates, applications, business rules, forms, images, layer objects, layouts, reusable objects, or workflow templates.
Note: A user account named LOFTUSER (Oracle) or loftuser (PostgreSQL) exists in the Loftware database (LoftStore). This user account has the permissions necessary to see views and run reports using the Loftware Enterprise SP Reporting Schema. If you are using Loftware Cloud Enterprise SP, Loftware Cloud Operations may have assigned a unique username for your reporting user account. Contact Loftware Cloud Operations for details.
Note: All timestamps are relative to the time on the database server.
| Column Name | Type | Description |
|---|---|---|
|
STEP_ID |
Number |
The ID of the Document Step. |
|
WORKFLOW_NAME |
String |
Whether the document is version controlled. document: The document is version controlled. document_nonversioning: The document is not version controlled. |
|
STATE |
String |
The current state of the Document Step. ACTIVATED COMPLETED |
|
STEP_ID |
Number |
The internal identification number of a Document Step. Key: Primary Key |
|
MODIFIED |
Timestamp |
The time when this Document Step was last modified. |
|
CREATED |
Timestamp |
The time when this Document Step was created. |
|
CREATED_ISSUER |
Number |
The ID of the User that created this audit entry. |
|
LAST_UPDATED_ISSUER |
Number |
The ID of the User that last modified this audit entry. |
|
CURRENT_CREATED_ISSUER |
String |
The name of the User that created this audit entry. |
|
CURRENT_LAST_UPDATED_ISSUER |
String |
The name of the User that last modified this audit entry. |
|
AUDIT_ACTION |
String |
The type of audit action performed on this Document Step. CREATE INSERT UPDATE DELETE |
|
AUDIT_DATE |
Timestamp |
The date and time when the audit action was performed on this Document Step. |
|
OBJECT_ID |
Number |
Loftware use only. |
|
ACTION_ID |
Number |
The ID of the action performed on this Document Step. |
|
DUE_DATE |
Timestamp |
Not used. |
|
ENTRY_ID |
Number |
The ID of a document. |
|
OWNER_ID |
Number |
The ID of the User that started the workflow. |
|
SPLIT_ID |
Number |
Not used. |
|
START_DATE |
Timestamp |
The date and time when the Document Step was started. |
|
STATUS |
String |
The current status of this document, which is one of the following values: Checked In Checked Out Editing Saved Finished In Review Approved |
more