dbo.ethWIPJobHidden

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Identity primary key of the hidden-job record.
2	JobId	uniqueidentifier	no		Prime Ecosystem job (primeJobs.id) that has been marked hidden from WIP dashboards/reports.
3	CreatedAt	datetime	no		Date and time the job was marked hidden.
4	HiddenReasonText	nvarchar(MAX)	yes		Free-text reason explaining why the job was hidden from WIP tracking.
5	HiddenByUserID	uniqueidentifier	yes		Prime Ecosystem user (primeUsers.id) who hid the job.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_ethWIPJobHidden	CLUSTERED	yes	yes	ID

Relationships (inferred)

From	To	Confidence
dbo.ethWIPJobHidden.JobId	dbo.primeJobs.Id	high
dbo.ethWIPJobHidden.JobId	dbo.ethWIPJobWeeklySnapshot.PrimeJobId	high

Referenced by

Views: dbo.vWIPUpdateCurrentWeekSummary, dbo.vWIPUpdateDrilldownByWeek

Procedures: dbo.spEthWIPCaptureJobWeeklySnapshot, dbo.spEthWIPJobMarkHidden