Document
The document table has 3 triggers
+---------------------------------------+---------------+------------+------------------+----------------------------------+
| Trigger Name | Event | Activation |
Condition | Procedure Called |
+---------------------------------------+---------------+------------+------------------+----------------------------------+
| document_action_time_update | INSERT,UPDATE | AFTER |
| document_action_time_update |
| documents_before_insert_generate_code | INSERT | BEFORE |
new.CODE IS NULL | store_documents_code |
| update_audit_timestamp_on_documents | INSERT,UPDATE | AFTER |
| update_audit_timestamp_documents |
+---------------------------------------+---------------+------------+------------------+----------------------------------+
Implements
Fields
String)
Document title displayed in all listings
Boolean!)
Determines if the document will become effective (status) once all approvals are positive
Boolean!)
Determines if training is available on this document
Boolean!)
Determines if training is required on this document
DateTime)
DateTime when the document was approved
DateTime)
DateTime when the document was made effective
Date)
Date when review needs to be performed, what is effective date plus review period
Int)
Number of months after document needs to review
String!)
Document type, based on a selected template
DocumentStatusType!)
Document current status describing its state
String)
Document version in format major.minor
DocumentTemplate)
A user that authored the document (i.e. was the owner at the time of approval)
User)
A user that currently owns the document
ID!)
The ID of the object
List of document related tags
ChangeControl)
Change control associated with the document
List of document related tags
[DocumentSection])
List of document sections where the actual content of the document is stored
String)
Document code identifier
DateTime)
DateTime when the document was created
DateTime)
Last DateTime when the document was modified
[Review])
List of document reviews
[Approval])
List of document approvals
[Training])
List of document trainings
String)
Link (url) to document in Qualio application