Evaluation Details

Column Name	Data Type	Description
Evaluation_Detail_ID ^*1	uniqueidentifier	The unique identifier of the Evaluation_Detail record.
Question_Score_ID	uniqueidentifier	The unique identifier of the question score this record is based on in QMS.
Question_ID	uniqueidentifier	The unique identifier of the question associated with the score this record is based on in QMS.
Answer_ID	uniqueidentifier	The unique identifier of the answer associated to the question score this record is based on in QMS.
Notes	ntext	Notes attached to the question score this record is based on in QMS.
Answer_Label	nvarchar-255	Name of the answer where predefined in the evaluation definition.
Answer_Numeric	decimal nn.n	Numeric value of the answer where the question has a numerical answer.
Failure_Reason	nvarchar-255	Reason given for question failure where defined.
Question_Title	nvarchar-255	Title of the question a score is associated with.
Question_Description	ntext	Description of the question a score is associated with.
Scorecard_Title	nvarchar-255	Title of the score card a score is associated with.
Scorecard_Description	ntext	Description of the score card a score is associated with.
Scorecard_Category_Name ^*2	nvarchar-255	Category of the score card a score is associated with.
Recording_ID ^3, 5^	uniqueidentifier	Unique identifier of QMS media attached to the evaluation.
Evaluation_ID	uniqueidentifier	Unique identifier of the evaluation in QMS this score is associcated with.
Draft	tinyint	Is the evaluation this score is associated with in draft mode.
Progress_Percent	int	Percent complete for the evaluation this score is associated with.
Score_Percent	decimal nn.nnnnnnn	Assigned question score represented as a percent attained.
Created_Date	date	Date the evaluation was create.
Created_Time	time	Time the evaluation was created.
Modified_Date	date	Date the evaluation was last modified.
Modified_Time	time	Time the evaluation was last modified.
Scorecard_ID	uniqueidentifier	Unique identifier of the score card this score is associcated with in QMS.
User_ID ^*4	uniqueidentifier	Unique identifier this evaluation is associated with in QMS.
Evaluator_User_ID	uniqueidentifier	Unique identifier of the evaluating user associated with this evaluation in QMS.
Workflow_Job_ID	uniqueidentifier	Unique identifier of the workflow job for the evaluation where workflow based.
Workflow_Name ^*2	nvarchar-255	Name of the workflow for the evaluation where workflow based.
Workflow_Stage_Name ^*2	nvarchar-255	Name of the current stage the workflow is in where an evaluation is workflow based.
Evaluation_Assigned_User_ID	uniqueidentifier	Unique identifier of the user a currently assigned to operate on an evaluation where workflow based.
Question_TypeID	uniqueidentifier	Unique identifier of the question format.
Question_Type_Name ^*2	nvarchar-50	Name of the question format.
Question_AIGenerated	bit	Is the answer generated by Enghouse AI.

Column Name

Data Type

Description

Evaluation_Detail_ID ^*1

uniqueidentifier

The unique identifier of the Evaluation_Detail record.

Question_Score_ID

uniqueidentifier

The unique identifier of the question score this record is based on in QMS.

Question_ID

uniqueidentifier

The unique identifier of the question associated with the score this record is based on in QMS.

Answer_ID

uniqueidentifier

The unique identifier of the answer associated to the question score this record is based on in QMS.

Notes

ntext

Notes attached to the question score this record is based on in QMS.

Answer_Label

nvarchar-255

Name of the answer where predefined in the evaluation definition.

Answer_Numeric

decimal nn.n

Numeric value of the answer where the question has a numerical answer.

Failure_Reason

nvarchar-255

Reason given for question failure where defined.

Question_Title

nvarchar-255

Title of the question a score is associated with.

Question_Description

ntext

Description of the question a score is associated with.

Scorecard_Title

nvarchar-255

Title of the score card a score is associated with.

Scorecard_Description

ntext

Description of the score card a score is associated with.

Scorecard_Category_Name ^*2

nvarchar-255

Category of the score card a score is associated with.

Recording_ID ^*3, *5^

uniqueidentifier

Unique identifier of QMS media attached to the evaluation.

Evaluation_ID

uniqueidentifier

Unique identifier of the evaluation in QMS this score is associcated with.

Draft

tinyint

Is the evaluation this score is associated with in draft mode.

Progress_Percent

int

Percent complete for the evaluation this score is associated with.

Score_Percent

decimal nn.nnnnnnn

Assigned question score represented as a percent attained.

Created_Date

date

Date the evaluation was create.

Created_Time

time

Time the evaluation was created.

Modified_Date

date

Date the evaluation was last modified.

Modified_Time

time

Time the evaluation was last modified.

Scorecard_ID

uniqueidentifier

Unique identifier of the score card this score is associcated with in QMS.

User_ID ^*4

uniqueidentifier

Unique identifier this evaluation is associated with in QMS.

Evaluator_User_ID

uniqueidentifier

Unique identifier of the evaluating user associated with this evaluation in QMS.

Workflow_Job_ID

uniqueidentifier

Unique identifier of the workflow job for the evaluation where workflow based.

Workflow_Name ^*2

nvarchar-255

Name of the workflow for the evaluation where workflow based.

Workflow_Stage_Name ^*2

nvarchar-255

Name of the current stage the workflow is in where an evaluation is workflow based.

Evaluation_Assigned_User_ID

uniqueidentifier

Unique identifier of the user a currently assigned to operate on an evaluation where workflow based.

Question_TypeID

uniqueidentifier

Unique identifier of the question format.

Question_Type_Name ^*2

nvarchar-50

Name of the question format.

Question_AIGenerated

bit

Is the answer generated by Enghouse AI.

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

This member is a foreign key linking a record in the Recording_Details table.

This member is a foreign key linking a record in the User_Details table.

In QMS many medias can be attached to an evaluation. This relationship is simplified in Custom Reporting to include only the "first in time" attached media.