dbo.ethKpiSupervisorType

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

Columns

#	Column	Type	Nullable	Flags	Description
1	id	int	no	identity	Surrogate primary key identifying this supervisor type mapping row.
2	supervisorId	uniqueidentifier	no		ID of the supervisor (Prime user) this mapping applies to.
3	supervisorType	nvarchar(50)	no		Type/category assigned to this supervisor for KPI reporting purposes (e.g. State Manager, Case Manager).

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
PK_ethKpiSupervisorType	CLUSTERED	yes	yes	id
IX_ethKpiSupervisorType_supervisor_supervisorType	NONCLUSTERED			supervisorId, supervisorType

Relationships (inferred)

From	To	Confidence
dbo.ethKpiSupervisorType.supervisorId	dbo.primeUsers.id	medium
dbo.primeJobs.SupervisorId	dbo.ethKpiSupervisorType.supervisorId	high

Referenced by

Views: dbo.vEthKpiResults_Deprecated, dbo.vEthKpiResultsActive_Deprecated, dbo.vEthKpiResultsClosed_Deprecated

Procedures: dbo.spMakesafeGetAllKpiSupervisorTypes