dbo.makesafeUser

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

Columns

#	Column	Type	Nullable	Flags	Description
1	ID	int	no	identity	Primary key, identity.
2	FullName	varchar(255)	no		Full name of the make-safe system user (staff member).
3	EntraIDUPN	varchar(255)	no		Microsoft Entra ID (Azure AD) user principal name used to authenticate this user.
4	Mobile	varchar(20)	yes		User's mobile phone number, used for SMS notifications/escalations.
5	MakeSafeEscalations	bit	no		True if the user should receive make-safe escalation alerts.
6	MakeSafeExceptions	bit	no		True if the user should be notified of make-safe exception/error conditions.
8	Disabled	bit	no		True if the user account is disabled and should not be used for assignment or login.

Relationships (inferred)

From	To	Confidence
dbo.makesafeEventLog.UserID	dbo.makesafeUser.ID	medium
dbo.makesafePhoneCall.AssignedUserID	dbo.makesafeUser.ID	high
dbo.makesafeSMSMessage.FromUserID	dbo.makesafeUser.ID	high
dbo.makesafeSMSMessage.ToUserID	dbo.makesafeUser.ID	high
dbo.makesafeUserSchedule.UserID	dbo.makesafeUser.ID	high

Referenced by

Views: dbo.vMakeSafePhonecalls, dbo.vMakeSafePhonecallsNoAlerts

Procedures: dbo.spMakesafeGetActiveEscalationMobiles, dbo.spMakesafeGetActiveExceptionMobiles, dbo.spMakesafeGetActivePhoneCalls, dbo.spMakesafeGetActiveUserScheduleMobiles, dbo.spMakesafeGetAllEventLogs, dbo.spMakesafeGetAllPhoneCalls, dbo.spMakesafeGetAllSMSMessages, dbo.spMakesafeGetAllUsers, dbo.spMakesafeGetAllUserSchedules, dbo.spMakesafeGetAllUserSettings, dbo.spMakesafeGetAssignedPhoneCalls, dbo.spMakesafeGetClosedPhoneCalls, dbo.spMakesafeGetGeoLocationPhoneCalls, dbo.spMakesafeGetPhoneCallbyCode, dbo.spMakesafeGetPhoneCallbyID, dbo.spMakesafeGetPhoneCalls, dbo.spMakesafeGetPhoneCallsPaged, dbo.spMakesafeGetPhoneCallStatusbyID, dbo.spMakesafeGetQueuedSMSMessages, dbo.spMakesafeGetQueuedSMSMessagesCount, dbo.spMakesafeGetSMSMessageByID, dbo.spMakesafeGetSMSMessagesbyID, dbo.spMakesafeGetUnassignedPhoneCalls, dbo.spMakesafeGetUserbyUPN, dbo.spMakesafeGetUserPhoneCalls, dbo.spMakesafeGetUserSchedule, dbo.spMakesafeGetUserScheduleByID, dbo.spMakesafeGetUserScheduleCount, dbo.spMakesafeGetUserSettings, dbo.spMakesafeGetUserSettingsByEntraIDUPN, dbo.spMakesafeGetUserSettingsByUserID, dbo.spMakesafeInsertSMSReply, dbo.spMakesafeQueueEscalationSMSMessagesNoSchedules, dbo.spMakesafeQueueOnCallSMSAssignedNotClosed, dbo.spMakesafeUpdateUserSettings, dbo.spMakesafeUpsertUser