Database Table LogEntry accr

[This is preliminary documentation and is subject to change.]

The table LogEntry is a part of the "core" data model - see LogEntry ("core" version).

When the accreditation data model add-on is installed, the LogEntry table is extended with fields referring to the objects, that are managed in the accreditation sub-system.

The table of fields below list only the fields added as result of accreditation data model add-on - refer to LogEntry ("core" version) to get the original fields.

Fields

Field name	Type	Note	Description
StandardCode	VARCHAR(20)	Foreign key to Standard	Code of standard associated with the event.
VersionNumber	INT	Partial foreign key to StandardVersion	Edition number of standard associated to the event.
IndicatorCode	VARCHAR(20)	Partial foreign key to Indicator	Code of indicator assoicated with the event.
RoundNumber	INT	Partial foreign key to SelfevaluationRound combine with OrgUnitType and OrgUnitKey to get full key	Sequence number of selfevaluation round associated to the event.
RecordAuditId	INT	Foreign key to RecordAudit	Id of the record audit associated to the event.
RecordAuditRecordId	INT	Foreign key to RecordAuditRecord	Id of the record audit record associated to the event.
RecordAuditParticipantId	INT	Foreign key to RecordauditParticipant	Id paticipant of record audit associated to the event.
SurveyId	INT	Foreign key to Survey	Id of the survey associated to the event.
SurveyIteration	INT	Partial foreign key to SurveyIterationBody	Id of the survey iteration body associated to the event.
SurveyAccreditationBody	INT	Foreign key to AccreditationBody. Partial foreign key to SurveyIterationBody, combine with fields SurveyId and SurveyIteration to get the full key.	Accreditationbody of the survey iteration body associated to the event.
StandardGroupCode	VARCHAR(20)	Foreign key to StandardGroup	Code of the standard group associated to the event.
TracerId	INT	Foreign key to Tracer	Id of the tracer associated to the event.
AssessmentId	INT	Foreign key to Assessment	Id of the assessment associated to the event.
FindingId	INT	Foreign key to Finding	Id of the finding associated to the event.

Relations

Table	Key field(s)	Description
Standard	StandardCode	Identifies a standard
StandardVersion	StandardCode, VersionNumber	Identifies standard edition
Indicator	StandardCode, VersionNumber, IndicatorCode	Identifies indicator
SelfEvaluationRound	OrgUnitType, OrgUnitCode, RoundNumber	Identifies self evaluation round
RecordAudit	RecordAuditId	Identifies record audit
RecordAuditRecord	RecordAuditRecordId	Identifies record audit record (= instance of form)
RecordAuditParticipant	RecordAuditParticipantId	Identifies record audit participant
Survey	SurveyId	Identifies survey
SurveyIterationBody	SurveyID, SurveyIteration, SurveyAccreditationBody	Identifies iteration and body specific information in survey
StdGroup	StandardGroupCode	Identifes standard group (theme, category)
Tracer	TracerId	Identifies tracer
Assessment	AssessmentId	Identifes assessment
Finding	FindingId	Identifies finding