User Details

Column Name	Data Type	Description
User_ID ^*1	uniqueidentifier	Unique identifier of user in QMS.
Username	nvarchar-20	Assigned username in QMS.
Department_Name ^*2	nvarchar-255	Assigned department name in QMS.
Location_Name ^*2	nvarchar-255	Assigned location name in QMS.
Group_Name ^2, 3^	nvarchar-255	Assigned group name in QMS.
Supervisor_Name ^2, 4^	nvarchar-255	Derived supervisor name from QMS.
First_Name	nvarchar-50	User first name.
Last_Name	nvarchar-50	User surname.
IsActive	tinyint	Is user active in QMS.
User_Type	nvarchar-20	User type in QMS. Standard or Agent.
Call_Recording_License	bit	Is user licensed for call recording in QMS.
On_demand_Recording_License	bit	Is user licensed for demand recording in QMS.
Computer_Recording_License	bit	Is user licensed for screen recording in QMS.
Agent_evaluation_License	bit	Is user licensed for agent evaluation in QMS.
Concurrent_License	bit	Is user licensed for concurrent recording in QMS.
Desktop_utility_License	bit	Is user licensed for desktop utility use in QMS.
Supervisor_License	bit	Is user assigned a supervisor license in QMS.
Realtime_VA_License	bit	Is user licensed for real-time voice analytics in QMS.
Batch_VA_License	bit	Is user licensed for batch voice analytics in QMS.
Text_Recording_License	bit	Is user licensed for text recording in QMS.
Transcription_License	bit	Is user licensed for media transcription in QMS.
Video_Recording_License	bit	Is user licensed for video recording in QMS.

Column Name

Data Type

Description

User_ID ^*1

uniqueidentifier

Unique identifier of user in QMS.

Username

nvarchar-20

Assigned username in QMS.

Department_Name ^*2

nvarchar-255

Assigned department name in QMS.

Location_Name ^*2

nvarchar-255

Assigned location name in QMS.

Group_Name ^*2, *3^

nvarchar-255

Assigned group name in QMS.

Supervisor_Name ^*2, *4^

nvarchar-255

Derived supervisor name from QMS.

First_Name

nvarchar-50

User first name.

Last_Name

nvarchar-50

User surname.

IsActive

tinyint

Is user active in QMS.

User_Type

nvarchar-20

User type in QMS. Standard or Agent.

Call_Recording_License

bit

Is user licensed for call recording in QMS.

On_demand_Recording_License

bit

Is user licensed for demand recording in QMS.

Computer_Recording_License

bit

Is user licensed for screen recording in QMS.

Agent_evaluation_License

bit

Is user licensed for agent evaluation in QMS.

Concurrent_License

bit

Is user licensed for concurrent recording in QMS.

Desktop_utility_License

bit

Is user licensed for desktop utility use in QMS.

Supervisor_License

bit

Is user assigned a supervisor license in QMS.

Realtime_VA_License

bit

Is user licensed for real-time voice analytics in QMS.

Batch_VA_License

bit

Is user licensed for batch voice analytics in QMS.

Text_Recording_License

bit

Is user licensed for text recording in QMS.

Transcription_License

bit

Is user licensed for media transcription in QMS.

Video_Recording_License

bit

Is user licensed for video recording in QMS.

Member is the table’s primary key.

Member has an accompanying, like-named member that serves as a unique identifier. Where the identifier is named member_Id

In QMS a user can be a member of many groups. This relationship is simplified in Custom Reporting to a single group where the group named for a user is the alphabetically first of many.

The named supervisor for a user is derived from the alphabetically first direct manager. If no direct manager, the supervisor is derived from the alphabetically first department manager. If no department or department manager, the supervisor is derived from the alphabetically first location manager if any.