Coflyr · Backend model field catalog
QualityAudit
QualitySystem.QualityAudits.
22 mapped fields5 field groupsGenerated 2026-10-06
Every mapped scalar field appears once. Types and nullability come from the current EF model snapshot. Navigation properties and unmapped DTO fields are outside this page. Purpose text is inferred from names and should be checked against the feature workflow.
Identity and naming
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | AuditNumber | string | Required | Records audit number for this quality audit. |
Relationships and references
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ChecklistTemplateId | Guid? | Nullable | Selects the related checklist template record. |
| 2 | ReportReference | string | Nullable | Records report reference for this quality audit. |
Dates and timing
6 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ActualEndDate | DateTime? | Nullable | Records the actual end date for this quality audit. |
| 2 | ActualStartDate | DateTime? | Nullable | Records the actual start date for this quality audit. |
| 3 | ClosureDate | DateTime? | Nullable | Records the closure date for this quality audit. |
| 4 | PlannedEndDate | DateTime? | Nullable | Records the planned end date for this quality audit. |
| 5 | PlannedStartDate | DateTime? | Nullable | Records the planned start date for this quality audit. |
| 6 | ReportIssuedDate | DateTime? | Nullable | Records the report issued date for this quality audit. |
Audit and revision
10 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AuditCategory | int | Required | Records audit category for this quality audit. |
| 2 | AuditResult | int | Required | Records audit result for this quality audit. |
| 3 | AuditScope | int | Required | Records audit scope for this quality audit. |
| 4 | AuditStage | int | Required | Records audit stage for this quality audit. |
| 5 | AuditTitle | string | Required | Records audit title for this quality audit. |
| 6 | AuditeeBusinessPartnerId | Guid? | Nullable | Selects the related auditee business partner record. |
| 7 | AuditeeDepartmentId | Guid? | Nullable | Selects the related auditee department record. |
| 8 | LeadAuditorStaffMemberId | Guid? | Nullable | Selects the related lead auditor staff member record. |
| 9 | SystemAuditId | Guid? | Nullable | Links to system audit history when this model stores the reference. |
| 10 | UpdateId | Guid? | Nullable | Links to the preceding revision or update record. |
Other fields
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ComplianceScore | decimal? | Nullable | Records compliance score for this quality audit. |
| 2 | RegulationBasis | int | Required | Records regulation basis for this quality audit. |