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