Coflyr · Backend model field catalog

ExternalIntegrationJob

public.ExternalIntegrationJobs.

22 mapped fields5 field groupsGenerated 2026-10-06

Model class: coflyr.features.shared.integrations.models.ExternalIntegrationJob
Source: Features/Shared/Integrations/Models/ExternalIntegrationJob.cs
Table: public.ExternalIntegrationJobs
Review: Not marked

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.

← All model classes · AMOS Workpackage example

Identity and naming

2 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`SubjectNumber`	`string`	Nullable	Records subject number for this external integration job.

Status and controls

3 fields

#	Field	EF type	Storage	Business purpose
1	`IncludeSingleRunningTaskcards`	`bool`	Required	Indicates whether include single running taskcards applies to this external integration job.
2	`JobStatus`	`int`	Required	Tracks the job status of this external integration job.
3	`StatusReportRequestedAt`	`DateTime?`	Nullable	Records the status report requested at for this external integration job.

Dates and timing

1 fields

#	Field	EF type	Storage	Business purpose
1	`StartedAt`	`DateTime?`	Nullable	Records the started at for this external integration job.

Audit and revision

2 fields

#	Field	EF type	Storage	Business purpose
1	`SystemAuditId`	`Guid?`	Nullable	Links to system audit history when this model stores the reference.
2	`UpdateId`	`Guid?`	Nullable	Links to the preceding revision or update record.

Other fields

14 fields

#	Field	EF type	Storage	Business purpose
1	`AircraftTypeCode`	`string`	Nullable	Records aircraft type code for this external integration job.
2	`AttemptCount`	`int`	Required	Records the attempt count for this external integration job.
3	`CancelledAt`	`DateTime?`	Nullable	Records the cancelled at for this external integration job.
4	`CompletedAt`	`DateTime?`	Nullable	Records the completed at for this external integration job.
5	`ExternalState`	`string`	Nullable	Records external state for this external integration job.
6	`LastError`	`string`	Nullable	Records last error for this external integration job.
7	`Operation`	`string`	Required	Records operation for this external integration job.
8	`PayloadJson`	`string`	Nullable	Records payload json for this external integration job.
9	`PayloadSha256`	`string`	Nullable	Records payload sha256 for this external integration job.
10	`Provider`	`int`	Required	Records provider for this external integration job.
11	`QueuedAt`	`DateTime`	Required	Records the queued at for this external integration job.
12	`RemovedAt`	`DateTime?`	Nullable	Records the removed at for this external integration job.
13	`ResultJson`	`string`	Nullable	Records result json for this external integration job.
14	`SubjectType`	`string`	Nullable	Records subject type for this external integration job.