dbo.ethTask

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.ethTask.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Identity primary key of the background task record.
2	TaskName	nvarchar(100)	no		Name identifying the type of background task to run (e.g. which job processor should pick this task up).
3	PrimeObjectID	uniqueidentifier	yes		Prime Ecosystem object identifier (e.g. job id) this task operates on, if applicable.
4	CreatedAt	datetime	no		Date and time the task record was created/queued.
5	QueuedFor	datetime	no		Date and time the task becomes eligible to run; tasks are picked up once this time has passed and they are not yet completed.
6	PrimeJobNumber	nvarchar(50)	yes		Prime Ecosystem job number this task relates to, if applicable.
7	PrimeJobURL	nvarchar(100)	yes		Direct URL to the related job in Prime Ecosystem, if applicable.
8	AttemptCount	int	yes		Number of times processing of this task has been attempted.
9	CompletedAt	datetime	yes		Date and time the task finished processing; null while still pending/in progress.
10	RepeatTask	bit	no		Flag (1 = this task should be re-queued/repeated rather than run once).
11	StatusDescription	nvarchar(512)	yes		Free-text status/result message describing the outcome or state of processing this task.
12	EthObjectID	int	yes		Identifier of a related Ethos-side (non-Prime Ecosystem) record this task operates on, if applicable.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
UX_ethTask_Open_AIPrimeGetJobSummaryQueue	NONCLUSTERED	yes		PrimeObjectID		([CompletedAt] IS NULL AND [TaskName]='AIPrimeGetJobSummaryQueue')

Relationships (inferred)

From	To	Confidence
dbo.ethTask.PrimeObjectID	dbo.primeJobs.Id	high
dbo.ethTask.PrimeObjectID	dbo.ethBooking.primeJobID	high

Referenced by

Procedures: dbo.spEthAIPrimeUpsertJobSummaryQueue, dbo.spEthBookingGet, dbo.spEthNexusECDQueueTasks, dbo.spEthPeerReviewTaskCheck, dbo.spEthRepairlineJobDatesQueueTasks, dbo.spEthSedgwickJobDatesqueueTasks, dbo.spEthTaskComplete, dbo.spEthTaskDelete, dbo.spEthTaskDeleteForObject, dbo.spEthTaskGetCount, dbo.spEthTaskGetNext, dbo.spEthTaskGetNextX, dbo.spEthTaskIncrementAttempt, dbo.spEthTaskInsert, dbo.spEthTaskInsertbyJobNumber, dbo.spEthTaskInsertMakeSafeAllocation