| Database Table RecordAuditParticipant |
[This is preliminary documentation and is subject to change.]
Relation between RecordAudit and Employee - which participants take part in record audit.
Note that only some records will have relation to Employee - in the cases where the participant is created as an employee/user in the system. In other cases, the participant's name (and organizational association) is specified directly in this table.
In both cases, the participant's role in the current record audit may be specified (in text).
FieldsField Name | Type | Note | Description |
|---|---|---|---|
Id | INT | Primary Key | internal unique id |
CreatedDateTime | DATETIME | Date and time for creation of participant | |
CreatedBy | INT | Employee id of user who created the paticipant | |
UpdatedDateTime | DATETIME | Date and time for latest update of participant | |
UpdatedBy | INT | Employee if of user who last updated the paticipant | |
DeletedDateTime | DATETIME | Date and time for (logical) deletion of participant | |
DeletedBy | INT | Employee id of user who (logically) deleted the paticipant | |
RecordAuditId | INT | Reference to RecordAudit | |
SequenceNumber | INT | Sequence of creation - used for sorting | |
EmployeeId | INT | Reference to Employee (NULL if this participant is not created as employee beforehand) | |
FirstName | VARCHAR(50) | First name of participant (only used if EmployeeId is NULL) | |
LastName | VARCHAR(50) | Last name of participant (only used if EmployeeId is NULL) | |
RoleDescription | VARCHAR(50) | Description of the participant's role in the record audit | |
RecordAuditLead | BIT | Whether this employee is "lead" in the record audit | |
OrgUnitType | VARCHAR(20) | Reference to OrgUnit (only used if EmployeeId is NULL) | |
OrgUnitCode | VARCHAR(20) | Reference to OrgUnit (only used if EmployeeId is NULL) |