IR Q Form View
The IR_QForm view contains saved and completed forms for a questionnaire.
| 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.
|
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.
|
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.
|
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.
|
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.
|
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.
|
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. |