dbo.primeStatuses

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

Columns

#	Column	Type	Nullable	Flags	Description
1	type	varchar(100)	yes		Category/type classification of this record
2	id	uniqueidentifier	yes		Primary key / unique identifier for this record
3	description	varchar(512)	yes		Free-text description
4	name	varchar(100)	yes		Display name
5	statusType	varchar(100)	yes		Category/type of status (e.g. Open, Closed, Won, Lost)
6	version	int	yes		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
IX_primestatuses_name	NONCLUSTERED			name	statusType

Relationships (inferred)

From	To	Confidence
dbo.ethKpiJobInstance.StatusName	dbo.primeStatuses.name	high
dbo.ethWIPJobWeeklySnapshot.StatusId	dbo.primeStatuses.id	high
dbo.primeExportJobsRegistered.CurrentStatus	dbo.primeStatuses.name	medium
dbo.primeJobs.StatusId	dbo.primeStatuses.id	high
dbo.primeStatusHistories_Job.NewStatusId	dbo.primeStatuses.id	medium

Referenced by

Views: dbo.vEthKpiActiveJobs, dbo.vEthKpiClosedJobs, dbo.VPrimeCompletiontimesObjectivedb, dbo.vprimeEstimatorQuoteConversions, dbo.vprimeFinancialschedule_1_jobandinvoicedetails, dbo.vprimeFinancialschedule_2_estimates, dbo.VPrimeJobcategoriesObjectivedb, dbo.vPrimeJobinvoicesObjectivedb, dbo.vprimejobsthismonthObjectivedb, dbo.vPrimeSalesinvoicesObjectivedb, dbo.VPrimeSalesPipelineObjectivedb, dbo.vWIPSkippedJobReasons, dbo.vWIPUpdateDrilldownByWeek, dbo.vwWIPSkippedJobReasons

Procedures: dbo.spEthPopulatePeerReviewStatus, dbo.spEthQueueAccountsPayableInvoices, dbo.spPopulateInvoiceCheck, dbo.spPrimeUpsertStatus, dbo.spRefreshEstimatorStageSummary