dbo.primeUsers

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

Columns

#	Column	Type	Nullable	Flags	Description
1	type	nvarchar(20)	no		Category/type classification of this record
2	id	uniqueidentifier	no		Primary key / unique identifier for this record
3	firstName	nvarchar(100)	no		Contact's first name
4	lastName	nvarchar(100)	no		Contact's last name
5	fullName	nvarchar(200)	no		Contact's full name
6	status	nvarchar(50)	no		Current status of this record
7	email	nvarchar(200)	no		Contact email address
8	timezone	nvarchar(100)	no		Time zone associated with this record
9	contactId	uniqueidentifier	yes		Foreign key to primeContacts
10	levesysRef	nvarchar(100)	yes		Levesys accounting system reference for this record
11	roles	nvarchar(500)	yes		Roles assigned to the user
12	version	bigint	yes		Optimistic-concurrency row version number

Indexes

Name	Type	Unique	PK	Key columns	Included	Filter
IX_primeusers_FullName	NONCLUSTERED			fullName	id, status
IX_primeUsers_ActiveOnly	NONCLUSTERED			id	fullName	([Status]='Active')

Relationships (inferred)

From	To	Confidence
dbo.ethAppointmentDefinitionUser.PrimeUserId	dbo.primeUsers.id	low
dbo.ethAppointmentInstance.PrimeUserId	dbo.primeUsers.id	low
dbo.ethBookingEstimatorSkill.primeEstimatorID	dbo.primeUsers.id	high
dbo.ethBooking.primeUserID	dbo.primeUsers.id	high
dbo.ethKpiSupervisorType.supervisorId	dbo.primeUsers.id	medium
dbo.ethPrimeInvoiceUser.primeUserId	dbo.primeUsers.id	low
dbo.ethWIPJobHistory.SupervisorUserId	dbo.primeUsers.id	high
dbo.optimoRouteDriverDay.EstimatorID	dbo.primeUsers.id	high
dbo.OptimoRouteLog.UserID	dbo.primeUsers.id	high
dbo.optimoRouteOrder.ScheduledEstimatorID	dbo.primeUsers.id	high
dbo.primeAllocations.AssignedId	dbo.primeUsers.id	high
dbo.primeAppointments.createdBy	dbo.primeUsers.fullName	high
dbo.primeAppointments.primaryUserId	dbo.primeUsers.id	high
dbo.primeContactLocation.primecontactID	dbo.primeUsers.contactId	medium
dbo.primeJobs.AssignedId	dbo.primeUsers.id	high
dbo.primeJobs.CaseManagerId	dbo.primeUsers.id	high
dbo.primeJobs.EstimatorId	dbo.primeUsers.id	high
dbo.primeJobs.SupervisorId	dbo.primeUsers.id	high
dbo.primeUsers.contactId	dbo.primeContacts.id	high
dbo.primeWorkOrders.created_by	dbo.primeUsers.fullName	high

Referenced by

Views: dbo.vEthKpiResults_Deprecated, dbo.vEthKpiResultsActive_Deprecated, dbo.vEthKpiResultsClosed_Deprecated, dbo.VPrimeEstimatorstagesEstimatorworkflowdb, dbo.vPrimeJobinvoicesObjectivedb, dbo.vPrimeSalesinvoicesObjectivedb, dbo.VPrimeSwmshrdatesconstructiondbHighriskjobs, dbo.vWIPSkippedJobReasons, dbo.vwWIPSkippedJobReasons

Procedures: dbo.primeGetUsers, dbo.primeSearchUsers, dbo.spEthBookingEstimatorJobDistanceQueue, dbo.spEthBookingGet, dbo.spEthBookingGetAvailabilityDetails, dbo.spEthBookingGetByCode, dbo.spEthBookingGetByID, dbo.spEthBookingGetByJobID, dbo.spEthBookingGetEstimators, dbo.spEthBookingGetEstimatorsSkills, dbo.spEthBookingGetMissingEstimatorLocations, dbo.spEthGetBookingEstimatorLocations, dbo.spEthKpiResultsActive, dbo.spEthKpiResultsActiveAll, dbo.spEthKpiResultsbyJobId, dbo.spEthPopulatePeerReviewStatus, dbo.spEthResolveAppointmentContext, dbo.spEthWIPCaptureJobWeeklySnapshot, dbo.spEthWIPJobClientNoteQueue, dbo.spEthWIPJobEmailGet, dbo.spEthWIPJobEmailQueue, dbo.spEthWIPJobEmailQueueAggregated, dbo.spMakesafeGetAllKpiSupervisorTypes, dbo.spOptimoRouteDriverDayUpsert, dbo.spOptimoRouteGetAppointmentQueue, dbo.spOptimoRouteGetLogs, dbo.spOptimoRouteGetLogsPaged, dbo.spOptimoRouteGetNearbyJobs, dbo.spOptimoRouteGetNotScheduledOrders, dbo.spOptimoRouteGetNotScheduledOrdersEmailQueue, dbo.spOptimoRouteGetScheduledOrders, dbo.spOptimoRouteGetWorkOrderQueue, dbo.spOptimoRouteUpsertStop, dbo.spPrimeBuildLockedEstimatesThisYear, dbo.spPrimeGetContactLocationQueue, dbo.spPrimeGetEstimatorIDFromName, dbo.spPrimeGetJobSummary, dbo.spPrimeGetSupervisors, dbo.spPrimeGetUserFullname, dbo.spPrimeGetUserIDByEmail, dbo.spPrimeGetUsers, dbo.spPrimeGetWIPUpdatesApproved, dbo.spPrimeGetWIPUpdatesClients, dbo.spPrimeGetWIPUpdatesQueue, dbo.spPrimeUpsertUser, dbo.spRefreshEstimatorStageSummary