dbo.ethKpiJobInstance

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Surrogate primary key identifying this KPI job status instance record.
2	JobID	uniqueidentifier	no		Foreign key to the Prime Ecosystem job this KPI status instance belongs to.
3	StatusName	varchar(100)	no		The job status the job occupied during this time span, used to accumulate total time-in-status across repeat visits for KPI calculations.
4	FromDate	datetime	no		The date and time the job entered this status for this instance/span.
5	ToDate	datetime	yes		The date and time the job left this status for this instance/span, or null if the job is still in this status.
6	DateModified	datetime	no		The date and time this KPI job instance record was last modified.

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
nci_msft_1_ethKpiJobInstance_9915D5E8834DDA78896E8E8DBB07B87C	NONCLUSTERED			JobID
IX_ethKpiJobInstance_ID	NONCLUSTERED			ID	FromDate, JobID, StatusName
IX_ethKpiJobInstance_Job_Status_InclDates	NONCLUSTERED			JobID, StatusName	FromDate, ToDate
nci_msft_1_ethKpiJobInstance_18CAAF51F02DB22A88255D48E489C6C1	NONCLUSTERED			StatusName	FromDate, JobID

Relationships (inferred)

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

Referenced by

Views: dbo.vEthKpiActiveJobs, dbo.vEthKpiClosedJobs, dbo.vEthKpiResultsActive_Deprecated, dbo.vEthKpiResultsClosed_Deprecated

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