LearnerLearningRecordscompletionDetails
LearnerLearningRecordscompletionDetails
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetails |
| ActivityId [KEY] | Long | ActivityId of LearnerLearningRecordscompletionDetails |
| ActivityNumber | String | ActivityNumber of LearnerLearningRecordscompletionDetails |
| ActivityType | String | ActivityType of LearnerLearningRecordscompletionDetails |
| ActivityTitle | String | ActivityTitle of LearnerLearningRecordscompletionDetails |
| ActivityDescription | String | ActivityDescription of LearnerLearningRecordscompletionDetails |
| ActivityShortDescription | String | ActivityShortDescription of LearnerLearningRecordscompletionDetails |
| ActivityDisplayOrder | Double | ActivityDisplayOrder of LearnerLearningRecordscompletionDetails |
| ActivitySectionId | Double | ActivitySectionId of LearnerLearningRecordscompletionDetails |
| ActivitySectionNumber | String | ActivitySectionNumber of LearnerLearningRecordscompletionDetails |
| ActivitySectionTitle | String | ActivitySectionTitle of LearnerLearningRecordscompletionDetails |
| ActivitySectionDescription | String | ActivitySectionDescription of LearnerLearningRecordscompletionDetails |
| ActivitySectionDisplayOrder | Double | ActivitySectionDisplayOrder of LearnerLearningRecordscompletionDetails |
| ActivitySecComplRequired | Double | ActivitySecComplRequired of LearnerLearningRecordscompletionDetails |
| ActivitySectionTotalActivities | Double | ActivitySectionTotalActivities of LearnerLearningRecordscompletionDetails |
| ActivitySectionAttemptStatus | String | ActivitySectionAttemptStatus of LearnerLearningRecordscompletionDetails |
| ActivitySectionAttemptStatusMeaning | String | ActivitySectionAttemptStatusMeaning of LearnerLearningRecordscompletionDetails |
| ActivitySectionAttemptCompletionProgress | Double | ActivitySectionAttemptCompletionProgress of LearnerLearningRecordscompletionDetails |
| ActivityPassingScore | Double | ActivityPassingScore of LearnerLearningRecordscompletionDetails |
| ActivityExpectedEffort | String | ActivityExpectedEffort of LearnerLearningRecordscompletionDetails |
| ActivityEffortUnits | String | ActivityEffortUnits of LearnerLearningRecordscompletionDetails |
| ActivityComplRequirement | String | ActivityComplRequirement of LearnerLearningRecordscompletionDetails |
| ActivityLearnerMarkCompl | String | ActivityLearnerMarkCompl of LearnerLearningRecordscompletionDetails |
| ActivityDate | Date | ActivityDate of LearnerLearningRecordscompletionDetails |
| ActivityStartTime | String | ActivityStartTime of LearnerLearningRecordscompletionDetails |
| ActivityEndTime | String | ActivityEndTime of LearnerLearningRecordscompletionDetails |
| ActivityTimeZone | String | ActivityTimeZone of LearnerLearningRecordscompletionDetails |
| VirtualClassroomJoinLink | String | VirtualClassroomJoinLink of LearnerLearningRecordscompletionDetails |
| VirtualClassroomInformation | String | VirtualClassroomInformation of LearnerLearningRecordscompletionDetails |
| AddToCalendarLink | String | AddToCalendarLink of LearnerLearningRecordscompletionDetails |
| ElearnId | Double | ElearnId of LearnerLearningRecordscompletionDetails |
| ElearnNumber | String | ElearnNumber of LearnerLearningRecordscompletionDetails |
| ElearnType | String | ElearnType of LearnerLearningRecordscompletionDetails |
| ElearnTitle | String | ElearnTitle of LearnerLearningRecordscompletionDetails |
| ElearnShortDescription | String | ElearnShortDescription of LearnerLearningRecordscompletionDetails |
| ElearnRichMediaLink | String | ElearnRichMediaLink of LearnerLearningRecordscompletionDetails |
| ElearnQuestionnaireId | Long | ElearnQuestionnaireId of LearnerLearningRecordscompletionDetails |
| ElearnQuestionnaireNumber | String | ElearnQuestionnaireNumber of LearnerLearningRecordscompletionDetails |
| ElearnAttemptsAllowed | Double | ElearnAttemptsAllowed of LearnerLearningRecordscompletionDetails |
| ElearnTimePERAttempt | Double | ElearnTimePERAttempt of LearnerLearningRecordscompletionDetails |
| ElearnTimePERAttemptUnits | String | ElearnTimePERAttemptUnits of LearnerLearningRecordscompletionDetails |
| ElearnDisableReview | String | ElearnDisableReview of LearnerLearningRecordscompletionDetails |
| ElearnHideActualScore | String | ElearnHideActualScore of LearnerLearningRecordscompletionDetails |
| ElearnShowResponseFeedback | String | ElearnShowResponseFeedback of LearnerLearningRecordscompletionDetails |
| ELearnMarkCompletionOnOpen | String | ELearnMarkCompletionOnOpen of LearnerLearningRecordscompletionDetails |
| ActivityAttemptId | Double | ActivityAttemptId of LearnerLearningRecordscompletionDetails |
| ActivityAttemptNumber | String | ActivityAttemptNumber of LearnerLearningRecordscompletionDetails |
| ActivityAttemptStatus | String | Status of the activity when a learner does the activity. Valid values are ORA_ASSN_TASK_COMPLETED, ORA_ASSN_TASK_EXEMPTED, ORA_ASSN_TASK_INCOMPLETE, ORA_ASSN_TASK_NOT_STARTED, ORA_ASSN_TASK_IN_PROGRESS and are defined in the list ActivityAttemptStatusLOV. |
| ActivityAttemptNextAction | String | ActivityAttemptNextAction of LearnerLearningRecordscompletionDetails |
| ActivityAttemptDeepLink | String | ActivityAttemptDeepLink of LearnerLearningRecordscompletionDetails |
| ActivityAttemptEmbedLink | String | ActivityAttemptEmbedLink of LearnerLearningRecordscompletionDetails |
| ActivityAttemptStartedDate | Datetime | ActivityAttemptStartedDate of LearnerLearningRecordscompletionDetails |
| ActivityAttemptComplDate | Datetime | ActivityAttemptComplDate of LearnerLearningRecordscompletionDetails |
| ActivityAttemptExemptedDate | Datetime | ActivityAttemptExemptedDate of LearnerLearningRecordscompletionDetails |
| ActivityAttemptExemptedRC | String | ActivityAttemptExemptedRC of LearnerLearningRecordscompletionDetails |
| ActivityAttemptActualEffort | Double | ActivityAttemptActualEffort of LearnerLearningRecordscompletionDetails |
| ActivityAttemptAEUnits | String | ActivityAttemptAEUnits of LearnerLearningRecordscompletionDetails |
| ActivityAttemptActualScore | Double | ActivityAttemptActualScore of LearnerLearningRecordscompletionDetails |
| ActivityTotalAttempts | Double | ActivityTotalAttempts of LearnerLearningRecordscompletionDetails |
| ActivityAssignmentRecordId | Long | ActivityAssignmentRecordId of LearnerLearningRecordscompletionDetails |
| DataSecurityPrivilege | String | DataSecurityPrivilege of LearnerLearningRecordscompletionDetails |
| ParentLearningItemSubType | String | ParentLearningItemSubType of LearnerLearningRecordscompletionDetails |
| ParentLearningItemSubTypeMeaning | String | ParentLearningItemSubTypeMeaning of LearnerLearningRecordscompletionDetails |
| ActivitySectionAttemptLocked | String | ActivitySectionAttemptLocked of LearnerLearningRecordscompletionDetails |
| ActivityAttemptLocked | String | ActivityAttemptLocked of LearnerLearningRecordscompletionDetails |
| ElearnRecordedAttemptsRule | String | ElearnRecordedAttemptsRule of LearnerLearningRecordscompletionDetails |
| ElearnAttemptReview | String | ElearnAttemptReview of LearnerLearningRecordscompletionDetails |
| ElearnDisableReviewForPassedAttempts | String | ElearnDisableReviewForPassedAttempts of LearnerLearningRecordscompletionDetails |
| ElearnDisableContentReview | String | ElearnDisableContentReview of LearnerLearningRecordscompletionDetails |
| CompletionItemId | Long | CompletionItemId of LearnerLearningRecordscompletionDetails |
| CompletionItemNumber | String | CompletionItemNumber of LearnerLearningRecordscompletionDetails |
| ActivityAttemptAssignedToId | Long | ActivityAttemptAssignedToId of LearnerLearningRecordscompletionDetails |
| ActivityAttemptAssignedToNumber | String | ActivityAttemptAssignedToNumber of LearnerLearningRecordscompletionDetails |
| ActivityAttemptAssignedToDisplayName | String | ActivityAttemptAssignedToDisplayName of LearnerLearningRecordscompletionDetails |
| ActivityAttemptAssignedToType | String | ActivityAttemptAssignedToType of LearnerLearningRecordscompletionDetails |
| ActivityAttemptAssignedToTypeMeaning | String | ActivityAttemptAssignedToTypeMeaning of LearnerLearningRecordscompletionDetails |
| VirtualClassroomType | String | VirtualClassroomType of LearnerLearningRecordscompletionDetails |
| VirtualClassroomTypeMeaning | String | VirtualClassroomTypeMeaning of LearnerLearningRecordscompletionDetails |
| SectionAttemptComplDate | Datetime | SectionAttemptComplDate of LearnerLearningRecordscompletionDetails |
| ActivityCoverArtLink | String | ActivityCoverArtLink of LearnerLearningRecordscompletionDetails |
| ElearnCoverArtLink | String | ElearnCoverArtLink of LearnerLearningRecordscompletionDetails |
| ActivityDescriptionLong | String | ActivityDescriptionLong of LearnerLearningRecordscompletionDetails |
| ActivityTypeMeaning | String | ActivityTypeMeaning of LearnerLearningRecordscompletionDetails |
| ActivityEffortUnitsMeaning | String | ActivityEffortUnitsMeaning of LearnerLearningRecordscompletionDetails |
| ElearnTypeMeaning | String | ElearnTypeMeaning of LearnerLearningRecordscompletionDetails |
| ElearnTimePERAttemptUnitsMeaning | String | ElearnTimePERAttemptUnitsMeaning of LearnerLearningRecordscompletionDetails |
| ActivityAttemptStatusMeaning | String | ActivityAttemptStatusMeaning of LearnerLearningRecordscompletionDetails |
| ActivityAttemptExemptedRCMeaning | String | ActivityAttemptExemptedRCMeaning of LearnerLearningRecordscompletionDetails |
| ActivityAttemptAEUnitsMeaning | String | ActivityAttemptAEUnitsMeaning of LearnerLearningRecordscompletionDetails |
| ActivityComplRequirementMeaning | String | ActivityComplRequirementMeaning of LearnerLearningRecordscompletionDetails |
| DataSecurityPrivilegeMeaning | String | DataSecurityPrivilegeMeaning of LearnerLearningRecordscompletionDetails |
| ElearnRecordedAttemptsRuleMeaning | String | ElearnRecordedAttemptsRuleMeaning of LearnerLearningRecordscompletionDetails |
| ElearnAttemptReviewMeaning | String | ElearnAttemptReviewMeaning of LearnerLearningRecordscompletionDetails |
| ActivitySectionLongDescription | String | ActivitySectionLongDescription of LearnerLearningRecordscompletionDetails |
| ElearnRichMediaSrcLink | String | ElearnRichMediaSrcLink of LearnerLearningRecordscompletionDetails |
| ActivityStartDatetimeUTC | Datetime | ActivityStartDatetimeUTC of LearnerLearningRecordscompletionDetails |
| ActivityEndDatetimeUTC | Datetime | ActivityEndDatetimeUTC of LearnerLearningRecordscompletionDetails |
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 |