Expand All Collapse All
IR Q Form View

IR_QForm_viw View

IR Q Form View

The IR_QForm view contains saved and completed forms for a questionnaire.

  • Last Changed Version - 17.4.0.0
  • Last Changed Reason - Added for data extraction from IR_QForm table.

Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
QFormId uniqueidentifier (16) False No

ID of the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
QuestionnaireId uniqueidentifier (16) False No

ID of the questionnaire this form provides answers to.

 17.4.0.0 Added for data extraction from IR_QForm table.
RecordingId uniqueidentifier (16) True No

ID of the recording that this form refers to.

 17.4.0.0 Added for data extraction from IR_QForm table.
ScoringIndivId char (22) True Yes

Individual ID of the user who is scoring the recording.

 17.4.0.0 Added for data extraction from IR_QForm table.
TargetIndivId char (22) True Yes

Individual ID of the user being scored.

 17.4.0.0 Added for data extraction from IR_QForm table.
TargetIntx_Part_Id char (22) True Yes

Participant ID on the interaction of the user being scored.

 17.4.0.0 Added for data extraction from IR_QForm table.
ScoringState int (4) False No

Scoring state of the form.

  • 0 - None. Scoring has not yet started.
  • 1 - Assigned. Questionnaire Scorecard has been assigned but not started.
  • 2 - Incomplete. Questionnaire Scorecard has been saved but not finished.
  • 3 - Finished.
 17.4.0.0 Added for data extraction from IR_QForm table.
Score numeric (9) False No

Total score of the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
RankName nvarchar (40) True Depends on customer usage

Name of the rank given to the form based on it's score.

 17.4.0.0 Added for data extraction from IR_QForm table.
MaxScore numeric (9) True No

Maximum score of all answers scored for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
MinScore numeric (9) True No

Minimum score of all answers scored for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
ScoringDate datetime (8) True No

Time the form was last scored and saved.

 17.4.0.0 Added for data extraction from IR_QForm table.
ScoringDateOffset int (4) True No

UTC offset of the scoring date.

 17.4.0.0 Added for data extraction from IR_QForm table.
AssignedDesc nvarchar (1024) True Depends on customer usage

Name of the Recorder Policy that caused the form to be assigned.

 17.4.0.0 Added for data extraction from IR_QForm table.
NonCriticalMaxScore numeric (9) True No

Total maximum score of all non-critical questions answered for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
NonCriticalMinScore numeric (9) True No

Total minimum score of all non-critical questions answered for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
NonCriticalScore numeric (9) True No

Total score of all non-critical questions answered for the form.

 17.4.0.0 Added for data extraction from IR_QForm table.
CriticalAccuracyScore numeric (9) True No

Stores the critical accuracy percentage (0.00 to 100.00) of positively answered critical questions divided by the total number of critical questions answered within a scorecard.

 17.4.0.0 Added for data extraction from IR_QForm table.
NumAnsweredCriticalQstns int (4) True No

Number of critical questions answered.

 17.4.0.0 Added for data extraction from IR_QForm table.
NumPosAnsweredCriticalQstns int (4) True No

Number of positively answered critical questions.

 17.4.0.0 Added for data extraction from IR_QForm table.
IsFailed tinyint (1) True No

Indicates whether the scorecard has been marked Pass or Fail. NULL for non-pass/fail questionnaires.

  • NULL - Not marked passed or failed. Either the questionnaire is not pass/fail or the scorecard has not been finished.
  • 0 - Scorecard passed.
  • 1 - Scorecard failed.
 17.4.0.0 Added for data extraction from IR_QForm table.
UsingForCalibration tinyint (1) False No

Was this form used for calibration.

 17.4.0.0 Added for data extraction from IR_QForm table.
SignoffState tinyint (1) True No

State of the sign-off process.

  • NULL - Sign-off process has not yet started.
  • 0 - Sign-off process is in progress.
  • 1 - Sign-off process has completed.
 17.4.0.0 Added for data extraction from IR_QForm table.
SignoffComments nvarchar (2000) True Depends on customer usage

Comments about the sign-off.

 17.4.0.0 Added for data extraction from IR_QForm table.
Version int (4) False No

Version of the database row.

 17.4.0.0 Added for data extraction from IR_QForm table.
RecordingDate datetime2 (8) False No

Time the recording was made.

 17.4.0.0 Added for data extraction from IR_QForm table.
Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason
QFORMID raw (16) False No

ID of the form.

 17.4.0.0 Added for data extraction from IR_QFORM table.
QUESTIONNAIREID raw (16) False No

ID of the questionnaire this form provides answers to.

 17.4.0.0 Added for data extraction from IR_QFORM table.
RECORDINGID raw (16) False No

ID of the recording that this form refers to.

 17.4.0.0 Added for data extraction from IR_QFORM table.
SCORINGINDIVID char (22) True Yes

Individual ID of the user who is scoring the recording.

 17.4.0.0 Added for data extraction from IR_QFORM table.
TARGETINDIVID char (22) True Yes

Individual ID of the user being scored.

 17.4.0.0 Added for data extraction from IR_QFORM table.
TARGETINTX_PART_ID char (22) True Yes

Participant ID on the interaction of the user being scored.

 17.4.0.0 Added for data extraction from IR_QFORM table.
SCORINGSTATE number (22) False No

Scoring state of the form.

  • 0 - None. Scoring has not yet started.
  • 1 - Assigned. Questionnaire Scorecard has been assigned but not started.
  • 2 - Incomplete. Questionnaire Scorecard has been saved but not finished.
  • 3 - Finished.
 17.4.0.0 Added for data extraction from IR_QFORM table.
SCORE number (22) False No

Total score of the form.

 17.4.0.0 Added for data extraction from IR_QFORM table.
RANKNAME nvarchar2 (80) True Depends on customer usage

Name of the rank given to the form based on it's score.

 17.4.0.0 Added for data extraction from IR_QFORM table.
MAXSCORE number (22) True No

Maximum score of all answers scored for the form.

 17.4.0.0 Added for data extraction from IR_QFORM table.
MINSCORE number (22) True No

Minimum score of all answers scored for the form.

 17.4.0.0 Added for data extraction from IR_QFORM table.
SCORINGDATE date (7) True No

Time the form was last scored and saved.

 17.4.0.0 Added for data extraction from IR_QFORM table.
SCORINGDATEOFFSET number (22) True No

UTC offset of the scoring date.

 17.4.0.0 Added for data extraction from IR_QFORM table.
ASSIGNEDDESC nvarchar2 (2048) True Depends on customer usage

Name of the Recorder Policy that caused the form to be assigned.

 17.4.0.0 Added for data extraction from IR_QFORM table.
NONCRITICALMAXSCORE number (22) True No

Total maximum score of all non-critical questions answered for the form.

 17.4.0.0 Added for data extraction from IR_QFORM table.
NONCRITICALMINSCORE number (22) True No

Total minimum score of all non-critical questions answered for the form.

 17.4.0.0 Added for data extraction from IR_QFORM table.
NONCRITICALSCORE number (22) True No

Total score of all non-critical questions answered for the form.

 17.4.0.0 Added for data extraction from IR_QFORM table.
CRITICALACCURACYSCORE number (22) True No

Stores the critical accuracy percentage (0.00 to 100.00) of positively answered critical questions divided by the total number of critical questions answered within a scorecard.

 17.4.0.0 Added for data extraction from IR_QFORM table.
NUMANSWEREDCRITICALQSTNS number (22) True No

Number of critical questions answered.

 17.4.0.0 Added for data extraction from IR_QFORM table.
NUMPOSANSWEREDCRITICALQSTNS number (22) True No

Number of positively answered critical questions.

 17.4.0.0 Added for data extraction from IR_QFORM table.
ISFAILED number (22) True No

Indicates whether the scorecard has been marked Pass or Fail. NULL for non-pass/fail questionnaires.

  • NULL - Not marked passed or failed. Either the questionnaire is not pass/fail or the scorecard has not been finished.
  • 0 - Scorecard passed.
  • 1 - Scorecard failed.
 17.4.0.0 Added for data extraction from IR_QFORM table.
USINGFORCALIBRATION number (22) False No

Was this form used for calibration.

 17.4.0.0 Added for data extraction from IR_QFORM table.
SIGNOFFSTATE number (22) True No

State of the sign-off process.

  • NULL - Sign-off process has not yet started.
  • 0 - Sign-off process is in progress.
  • 1 - Sign-off process has completed.
 17.4.0.0 Added for data extraction from IR_QFORM table.
SIGNOFFCOMMENTS nvarchar2 (4000) True Depends on customer usage

Comments about the sign-off.

 17.4.0.0 Added for data extraction from IR_QFORM table.
VERSION number (22) False No

Version of the database row.

 17.4.0.0 Added for data extraction from IR_QFORM table.
RECORDINGDATE timestamp (11) False No

Time the recording was made.

 17.4.0.0 Added for data extraction from IR_QFORM table.