Coflyr · Backend model field catalog

EntityAuditState

Audit.EntityAuditStates.

25 former mapped fieldsDeleted6 field groupsGenerated 2026-10-06

Model class: coflyr.models.common.EntityAuditState
Former source: Features/Shared/Audit/Models/EntityAuditState.cs (removed)
Table: Audit.EntityAuditStates
Review: Reviewed decision 2026-10-06: Delete EntityAuditState model and table. Current and historical audit data are read directly from AuditLogEntries.

This page preserves the former fields for review. The EntityAuditState model and table are removed; existing rows were migrated into AuditLogEntries before the table was dropped. The temporary CurrentAuditStates view and AuditCurrentSnapshot projection were subsequently removed. Every former scalar field appears once. Types and nullability reflect the pre-removal EF 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.

← All model classes · AMOS Workpackage example

Identity and naming

1 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.

Relationships and references

4 fields

#	Field	EF type	Storage	Business purpose
1	`DepartmentId`	`Guid?`	Nullable	Selects the related department record.
2	`EntityId`	`Guid`	Required	Selects the related entity record.
3	`SentToDepartmentId`	`Guid?`	Nullable	Selects the related sent to department record.
4	`SentToUserId`	`Guid?`	Nullable	Selects the related sent to user record.

Status and controls

4 fields

#	Field	EF type	Storage	Business purpose
1	`BusinessStatus`	`int`	Required	Tracks the business status of this entity audit state.
2	`DocumentStatus`	`string`	Nullable	Tracks the document status of this entity audit state.
3	`PreApproved`	`bool`	Required	Indicates whether pre approved applies to this entity audit state.
4	`StatusInformation`	`string`	Nullable	Records status information for this entity audit state.

Dates and timing

2 fields

#	Field	EF type	Storage	Business purpose
1	`EffectiveDate`	`DateTime?`	Nullable	Records the effective date for this entity audit state.
2	`ReceivingDate`	`DateTime?`	Nullable	Records the receiving date for this entity audit state.

Audit and revision

8 fields

#	Field	EF type	Storage	Business purpose
1	`AuditActivationDate` DB: ActivationDate	`DateTime?`	Nullable	Records the audit activation date for this entity audit state.
2	`AuditBy`	`string`	Nullable	Records audit by for this entity audit state.
3	`AuditDate`	`DateTime?`	Nullable	Records the audit date for this entity audit state.
4	`AuditRemarks`	`string`	Nullable	Records audit remarks for this entity audit state.
5	`AuditStatus`	`int`	Required	Tracks the audit status of this entity audit state.
6	`AuditUserId`	`Guid?`	Nullable	Selects the related audit user record.
7	`CreatedByApn`	`int?`	Nullable	Records created by apn for this entity audit state.
8	`LatestAuditLogEntryId`	`Guid?`	Nullable	Selects the related latest audit log entry record.

Other fields

6 fields

#	Field	EF type	Storage	Business purpose
1	`EntityType`	`string`	Required	Records entity type for this entity audit state.
2	`LastChangedApn`	`int?`	Nullable	Records last changed apn for this entity audit state.
3	`LastChangedFormCode`	`string`	Nullable	Records last changed form code for this entity audit state.
4	`ReleaseState`	`int`	Required	Records release state for this entity audit state.
5	`ValidFrom`	`DateTime?`	Nullable	Records valid from for this entity audit state.
6	`ValidTo`	`DateTime?`	Nullable	Records valid to for this entity audit state.