WorkerJourneyTasksquestionnaireResponses
WorkerJourneyTasksquestionnaireResponses
Columns
Name | Type | Description |
WorkerJourneyTasksWorkerJourneyTaskId [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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
CategoryFilter | String | CategoryFilter |
Facets | String | Facets |
RequiredFilter | String | RequiredFilter |
SearchTerms | String | SearchTerms |
StatusFilter | String | StatusFilter |
WorkerJourneyTaskId | Long | WorkerJourneyTaskId |
Finder | String | finder |