OPSDocuments
Name: OPS Documents
Type: Application
Modules: OPS-Bidding, OPS-Employee Profile, OPS-Workforce Management, OPS-Web, Employee Self-Service
Description: Contains information about documents and their employee acknowledgement status.
| Field | Documentation |
|---|---|
| FileGroupId | Unique identifier of a group of documents. For example, three documents attached to an absence record would have the same FileGroupId. |
| ContentId | Content identifier (from BinaryContents.ContentId). This field link to BinaryContents table where the attachment is stored as binary data. |
| EmployeeId | Employee associated with the document (from Employees.EmployeeId). |
| DocTypeId | Unique identifier of the associated document type. |
| ViewFromDate | Start date from which the document can be viewed. |
| ViewToDate | End date to which the document can be viewed. |
| AckStatus | Acknowledgement status of the document (0 = Not Acknowledged, 1 = Acknowledged). |
| AckActionDate | Date the document was acknowledged by the associated employee. |
| AckActionTime | Time the document was acknowledged by the associated employee. |
| UserString1 | Client supplementary data. |
| ModTime | Time the record was last modified. |
| ModDate | Date the record was last modified. |
| ModBy | User who last modified the record. |
| ModAction | Last action performed on the record. |
| AcknowledgeRequired | If selected, the document must be acknowledged by the associated employee. |
| DisplayOption | Where the document can be viewed (e.g., Employee Self-Service). |