ScoringDetail_viw View

  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
RecordingId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
RecordingDate datetime True Unknown

4.0.106.453 4.0 Release
MediaType varchar (7) True Unknown

4.0.106.453 4.0 Release
InteractionIdKey varchar (36) True Unknown

4.0.106.453 4.0 Release
RecordingLength int True Unknown

4.0.106.453 4.0 Release
InitiationPolicyName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
Direction tinyint True Unknown

4.0.106.453 4.0 Release
RecordedUserIndivId char (22) True Unknown

4.0.106.453 4.0 Release
RecordedUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
RecordedUserDisplayName nvarchar (255) True Unknown

4.0.106.453 4.0 Release
RecordedUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
WorkgroupQueue nvarchar (255) True Unknown

4.0.106.453 4.0 Release
QuestionnaireId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
QuestionnaireName nvarchar (255) False Unknown

4.0.106.453 4.0 Release
QuestionnaireNote nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
QuestionnaireMinScore numeric True Unknown

4.0.106.453 4.0 Release
QuestionnaireMaxScore numeric True Unknown

4.0.106.453 4.0 Release
QDirectoryName nvarchar (255) True Unknown

4.0.106.453 4.0 Release
QGroupId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
QGroupSequence int False Unknown

4.0.106.453 4.0 Release
QGroupName nvarchar (255) False Unknown

4.0.106.453 4.0 Release
QGroupNote nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
IsOptional tinyint False Unknown

4.0.106.453 4.0 Release
QuestionId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
QuestionSequence int False Unknown

4.0.106.453 4.0 Release
QuestionText nvarchar (1024) False Unknown

4.0.106.453 4.0 Release
QuestionType smallint False Unknown

4.0.106.453 4.0 Release
QuestionPromptType smallint False Unknown

4.0.106.453 4.0 Release
QuestionWeight numeric False Unknown

4.0.106.453 4.0 Release
QuestionMin numeric False Unknown

4.0.106.453 4.0 Release
QuestionMax numeric False Unknown

4.0.106.453 4.0 Release
QuestionMinAcceptableScore numeric False Unknown

4.0.106.453 4.0 Release
QuestionCanMarkNA tinyint False Unknown

4.0.106.453 4.0 Release
FormId uniqueidentifier False Unknown

4.0.106.453 4.0 Release
ScoredUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoredUserIndivID char (22) True Unknown

4.0.106.453 4.0 Release
ScoringUserLastName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserFirstName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserMiddleName nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserICUserId nvarchar (50) True Unknown

4.0.106.453 4.0 Release
ScoringUserIndivId char (22) True Unknown

4.0.106.453 4.0 Release
CombinedMaxScore numeric True Unknown

4.0.106.453 4.0 Release
CombinedMinScore numeric True Unknown

4.0.106.453 4.0 Release
CombinedScore numeric False Unknown

4.0.106.453 4.0 Release
CombinedPercentileScore numeric True Unknown

4.0.106.453 4.0 Release
RankName nvarchar (40) True Unknown

4.0.106.453 4.0 Release
NonCriticalMaxScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalMinScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalScore numeric True Unknown

4.0.106.453 4.0 Release
NonCriticalPercentileScore numeric True Unknown

4.0.106.453 4.0 Release
TotalNumCriticalQuestions int False Unknown

4.0.106.453 4.0 Release
NumAnsweredCriticalQstns int True Unknown

4.0.106.453 4.0 Release
NumPosAnsweredCriticalQstns int True Unknown

4.0.106.453 4.0 Release
CriticalScore numeric True Unknown

4.0.106.453 4.0 Release
IsFailed tinyint True Unknown

4.0.106.453 4.0 Release
UsingForCalibration tinyint False Unknown

4.0.106.453 4.0 Release
AnswerScore numeric True Unknown

4.0.106.453 4.0 Release
RawAnswer nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
DisplayAnswer nvarchar (255) True Unknown

4.0.106.453 4.0 Release
UserComments nvarchar (1024) True Unknown

4.0.106.453 4.0 Release
IsMarkedNA tinyint False Unknown

4.0.106.453 4.0 Release