WorkerJourneystasksquestionnaireResponses
WorkerJourneystasksquestionnaireResponses
Columns
| Name | Type | Description |
| WorkerJourneysWorkerJourneyId [KEY] | Long | Unique identifier of the journey. |
| TasksWorkerJourneyTaskId [KEY] | Long | Unique identifier of the journey task. |
| QuestionnaireResponseId [KEY] | Long | Surrogate identifier for the questionnaire response. |
| QuestionnaireVersionNumber | Long | Version number of the questionnaire that the participant responds to. |
| AttemptNumber | Long | The attempt number of a participant when responding to a questionnaire. |
| Status | String | Status of the questionnaire response. I denotes the response is in progress and not submitted yet, while S denotes a submitted response. |
| StatusMeaning | String | Meaning of the status code. |
| SubmittedDateTime | Date | Date on which the questionnaire response was submitted. |
| TotalScore | Double | Total score for the responses submitted by a participant for a questionnaire. |
| LatestAttemptFlag | Bool | Indicates if the response is the latest attempt by a participant to the questionnaire. This is a read-only attribute. |
| CreatedBy | String | User who created the questionnaire response. |
| CreationDate | Datetime | Date on which the questionnaire response was created. |
| LastUpdatedBy | String | User who last updated the questionnaire response. |
| LastUpdateDate | Datetime | Date on which the questionnaire response was updated. |
| QuestionnaireParticipantId | Long | Surrogate identifier for the questionnaire participant. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| AllocatedAfterDate | Date | AllocatedAfterDate |
| AssignmentId | Long | AssignmentId |
| CategoryFilter | String | CategoryFilter |
| CodeFilter | String | CodeFilter |
| Context | String | Context |
| ContextualAction | String | ContextualAction |
| Facets | String | Facets |
| JourneyId | Long | JourneyId |
| Overdue | String | Overdue |
| PersonId | Long | PersonId |
| SearchTerms | String | SearchTerms |
| StatusCategory | String | StatusCategory |
| StatusFilter | String | StatusFilter |
| SubCategoryFilter | String | SubCategoryFilter |
| WorkerJourneyId | Long | WorkerJourneyId |
| Finder | String | finder |