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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。