dbo.ethKpiJobSummary

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Surrogate primary key identifying this KPI job status summary record.
2	JobID	uniqueidentifier	no		Foreign key to the Prime Ecosystem job this KPI status summary belongs to.
3	StatusName	varchar(100)	no		The current (or most recent) job status this KPI summary tracks time against.
4	FromDate	datetime	no		The date and time the job most recently entered this status, used as the KPI clock start.
5	ToDate	datetime	yes		The date and time the job left this status, or null while the job is still active in this status.
6	ChurnCount	int	no		The number of times the job has re-entered/churned back into this status.
7	DateModified	datetime	no		The date and time this KPI job summary record was last modified.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
nci_msft_1_ethKpiJobSummary_9915D5E8834DDA78896E8E8DBB07B87C	NONCLUSTERED			JobID

Relationships (inferred)

From	To	Confidence
dbo.ethKpiJobInstance.JobID	dbo.ethKpiJobSummary.JobID	medium
dbo.ethKpiJobInstance.StatusName	dbo.ethKpiJobSummary.StatusName	medium
dbo.ethKpiJobSummary.JobID	dbo.primeJobs.Id	high
dbo.ethKpiMeasures.StatusName	dbo.ethKpiJobSummary.StatusName	high
dbo.ethKpiRole.StatusName	dbo.ethKpiJobSummary.StatusName	high

Referenced by

Views: dbo.vEthKpiResults_Deprecated, dbo.vEthKpiResultsClosed_Deprecated

Procedures: dbo.spEthKpiResultsActive, dbo.spEthKpiResultsActiveAll, dbo.spEthKpiResultsbyJobId, dbo.spEthKpiSummarybyJobId, dbo.spEthQueueMissingKpis