LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails
LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| OtherselectedcourseofferingsassignmentRecordId [KEY] | Long | OtherselectedcourseofferingsassignmentRecordId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityId [KEY] | Long | ActivityId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityNumber | String | ActivityNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityType | String | ActivityType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityTitle | String | ActivityTitle of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityDescription | String | ActivityDescription of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityShortDescription | String | ActivityShortDescription of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityDisplayOrder | Double | ActivityDisplayOrder of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionId | Double | ActivitySectionId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionNumber | String | ActivitySectionNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionTitle | String | ActivitySectionTitle of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionDescription | String | ActivitySectionDescription of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionDisplayOrder | Double | ActivitySectionDisplayOrder of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySecComplRequired | Double | ActivitySecComplRequired of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionTotalActivities | Double | ActivitySectionTotalActivities of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionAttemptStatus | String | ActivitySectionAttemptStatus of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionAttemptStatusMeaning | String | ActivitySectionAttemptStatusMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionAttemptCompletionProgress | Double | ActivitySectionAttemptCompletionProgress of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityPassingScore | Double | ActivityPassingScore of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityExpectedEffort | String | ActivityExpectedEffort of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityEffortUnits | String | ActivityEffortUnits of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityComplRequirement | String | ActivityComplRequirement of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityLearnerMarkCompl | String | ActivityLearnerMarkCompl of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityDate | Date | ActivityDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityStartTime | String | ActivityStartTime of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityEndTime | String | ActivityEndTime of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityTimeZone | String | ActivityTimeZone of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| VirtualClassroomJoinLink | String | VirtualClassroomJoinLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| VirtualClassroomInformation | String | VirtualClassroomInformation of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| AddToCalendarLink | String | AddToCalendarLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnId | Double | ElearnId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnNumber | String | ElearnNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnType | String | ElearnType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnTitle | String | ElearnTitle of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnShortDescription | String | ElearnShortDescription of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnRichMediaLink | String | ElearnRichMediaLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnQuestionnaireId | Long | ElearnQuestionnaireId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnQuestionnaireNumber | String | ElearnQuestionnaireNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnAttemptsAllowed | Double | ElearnAttemptsAllowed of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnTimePERAttempt | Double | ElearnTimePERAttempt of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnTimePERAttemptUnits | String | ElearnTimePERAttemptUnits of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnDisableReview | String | ElearnDisableReview of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnHideActualScore | String | ElearnHideActualScore of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnShowResponseFeedback | String | ElearnShowResponseFeedback of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ELearnMarkCompletionOnOpen | String | ELearnMarkCompletionOnOpen of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptId | Double | ActivityAttemptId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptNumber | String | ActivityAttemptNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptStatus | String | ActivityAttemptStatus of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptNextAction | String | ActivityAttemptNextAction of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptDeepLink | String | ActivityAttemptDeepLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptEmbedLink | String | ActivityAttemptEmbedLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptStartedDate | Datetime | ActivityAttemptStartedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptComplDate | Datetime | ActivityAttemptComplDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptExemptedDate | Datetime | ActivityAttemptExemptedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptExemptedRC | String | ActivityAttemptExemptedRC of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptActualEffort | Double | ActivityAttemptActualEffort of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptAEUnits | String | ActivityAttemptAEUnits of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptActualScore | Double | ActivityAttemptActualScore of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityTotalAttempts | Double | ActivityTotalAttempts of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAssignmentRecordId | Long | ActivityAssignmentRecordId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| DataSecurityPrivilege | String | DataSecurityPrivilege of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ParentLearningItemSubType | String | ParentLearningItemSubType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ParentLearningItemSubTypeMeaning | String | ParentLearningItemSubTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionAttemptLocked | String | ActivitySectionAttemptLocked of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptLocked | String | ActivityAttemptLocked of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnRecordedAttemptsRule | String | ElearnRecordedAttemptsRule of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnAttemptReview | String | ElearnAttemptReview of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnDisableReviewForPassedAttempts | String | ElearnDisableReviewForPassedAttempts of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnDisableContentReview | String | ElearnDisableContentReview of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| CompletionItemId | Long | CompletionItemId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| CompletionItemNumber | String | CompletionItemNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptAssignedToId | Long | ActivityAttemptAssignedToId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptAssignedToNumber | String | ActivityAttemptAssignedToNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptAssignedToDisplayName | String | ActivityAttemptAssignedToDisplayName of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptAssignedToType | String | ActivityAttemptAssignedToType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptAssignedToTypeMeaning | String | ActivityAttemptAssignedToTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| VirtualClassroomType | String | VirtualClassroomType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| VirtualClassroomTypeMeaning | String | VirtualClassroomTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| SectionAttemptComplDate | Datetime | SectionAttemptComplDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityCoverArtLink | String | ActivityCoverArtLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnCoverArtLink | String | ElearnCoverArtLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityDescriptionLong | String | ActivityDescriptionLong of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityTypeMeaning | String | ActivityTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityEffortUnitsMeaning | String | ActivityEffortUnitsMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnTypeMeaning | String | ElearnTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnTimePERAttemptUnitsMeaning | String | ElearnTimePERAttemptUnitsMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptStatusMeaning | String | ActivityAttemptStatusMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptExemptedRCMeaning | String | ActivityAttemptExemptedRCMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityAttemptAEUnitsMeaning | String | ActivityAttemptAEUnitsMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityComplRequirementMeaning | String | ActivityComplRequirementMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| DataSecurityPrivilegeMeaning | String | DataSecurityPrivilegeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnRecordedAttemptsRuleMeaning | String | ElearnRecordedAttemptsRuleMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnAttemptReviewMeaning | String | ElearnAttemptReviewMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivitySectionLongDescription | String | ActivitySectionLongDescription of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ElearnRichMediaSrcLink | String | ElearnRichMediaSrcLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityStartDatetimeUTC | Datetime | ActivityStartDatetimeUTC of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityEndDatetimeUTC | Datetime | ActivityEndDatetimeUTC of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferingscompletionDetails |
| ActivityContentAttempts | String | activityContentAttempts |
| Classrooms | String | classrooms |
| Instructors | String | instructors |
| OfferedLanguages | String | offeredLanguages |
| RelatedMaterials | String | relatedMaterials |
| OfferedLocations | String | offeredLocations |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SysEffectiveDate | String | SysEffectiveDate |
| AssignedToId | Long | assignedToId |
| AssignerAttributionType | String | assignerAttributionType |
| AssignerId | Long | assignerId |
| AssignmentRecordId | Long | assignmentRecordId |
| Finder | String | finder |
| LearnerId | Long | learnerId |
| LearningItemId | Long | learningItemId |
| LearningItemTitle | String | learningItemTitle |
| ManagerId | Long | managerId |