LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts
LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts
Columns
Name | Type | Description |
LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
SelectedcourseofferingsassignmentRecordId [KEY] | Long | SelectedcourseofferingsassignmentRecordId of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentId | Long | ContentId of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentType | String | ContentType of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentTypeMeaning | String | ContentTypeMeaning of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentNumber | String | ContentNumber of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentTitle | String | ContentTitle of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentShortDescription | String | ContentShortDescription of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentURL | String | URL to open the e-learning content directly from the browser. |
ContentCatalogLearningItemId | Long | ContentCatalogLearningItemId of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ChapterLevel | Double | ChapterLevel of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ExpectedEffort | String | ExpectedEffort of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
EffortUnits | String | EffortUnits of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptId [KEY] | Long | AttemptId of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
PassingScore | Double | PassingScore of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptStatus | String | AttemptStatus of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptStatusMeaning | String | AttemptStatusMeaning of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ActualScore | Double | ActualScore of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptStartDate | Datetime | AttemptStartDate of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptEndDate | Datetime | AttemptEndDate of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
HideActualScore | String | HideActualScore of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
DisableReview | String | DisableReview of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptedById | Long | AttemptedById of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptRelationNumber | String | AttemptRelationNumber of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptedByNumber | String | AttemptedByNumber of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptedByDisplayName | String | AttemptedByDisplayName of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ActivityContentAttemptStatus | String | ActivityContentAttemptStatus of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentCoverArtLink | String | ContentCoverArtLink of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ActualEffort | Double | Actual effort that the learner spent in the attempt. |
ChapterPosition | String | ChapterPosition of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ActualEffortUnits | String | ActualEffortUnits of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ActualEffortUnitsMeaning | String | ActualEffortUnitsMeaning of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentCatalogLearningItemNumber | String | User-friendly number identifying the catalog learning item added to the activity. It is a surrogate key which is shown in the UI. |
ContentCatalogLearningItemType | String | ContentCatalogLearningItemType of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentCatalogLearningItemSubType | String | ContentCatalogLearningItemSubType of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ContentCatalogLearningItemDataLink | String | Data link to the catalog learning item added to the activity. |
ContentLongDescription | String | ContentLongDescription of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
AttemptPosition | String | AttemptPosition of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
ElearnRichMediaSrcLink | String | ElearnRichMediaSrcLink of LearnerLearningRecordsselectedCourseOfferingscompletionDetailsactivityContentAttempts |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
SysEffectiveDate | String | SysEffectiveDate |
AssignedToId | Long | assignedToId |
AssignerAttributionType | String | assignerAttributionType |
AssignerId | Long | assignerId |
AssignmentRecordId | Long | assignmentRecordId |
DataSecurityPrivilege | String | dataSecurityPrivilege |
Finder | String | finder |
LearnerId | Long | learnerId |
LearningItemId | Long | learningItemId |
LearningItemTitle | String | learningItemTitle |
ManagerId | Long | managerId |