LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts
LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts
Columns
Name | Type | Description |
LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
PrimaryselectedcourseofferingassignmentRecordId [KEY] | Long | PrimaryselectedcourseofferingassignmentRecordId of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentId | Long | ContentId of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentType | String | ContentType of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentTypeMeaning | String | ContentTypeMeaning of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentNumber | String | ContentNumber of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentTitle | String | ContentTitle of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentShortDescription | String | ContentShortDescription of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentURL | String | URL to open the e-learning content directly from the browser. |
ContentCatalogLearningItemId | Long | ContentCatalogLearningItemId of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ChapterLevel | Double | ChapterLevel of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ExpectedEffort | String | ExpectedEffort of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
EffortUnits | String | EffortUnits of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptId [KEY] | Long | AttemptId of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
PassingScore | Double | PassingScore of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptStatus | String | AttemptStatus of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptStatusMeaning | String | AttemptStatusMeaning of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ActualScore | Double | ActualScore of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptStartDate | Datetime | AttemptStartDate of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptEndDate | Datetime | AttemptEndDate of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
HideActualScore | String | HideActualScore of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
DisableReview | String | DisableReview of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptedById | Long | AttemptedById of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptRelationNumber | String | AttemptRelationNumber of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptedByNumber | String | AttemptedByNumber of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptedByDisplayName | String | AttemptedByDisplayName of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ActivityContentAttemptStatus | String | ActivityContentAttemptStatus of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentCoverArtLink | String | ContentCoverArtLink of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ActualEffort | Double | Actual effort that the learner spent in the attempt. |
ChapterPosition | String | ChapterPosition of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ActualEffortUnits | String | ActualEffortUnits of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ActualEffortUnitsMeaning | String | ActualEffortUnitsMeaning of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
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 LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentCatalogLearningItemSubType | String | ContentCatalogLearningItemSubType of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ContentCatalogLearningItemDataLink | String | Data link to the catalog learning item added to the activity. |
ContentLongDescription | String | ContentLongDescription of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
AttemptPosition | String | AttemptPosition of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
ElearnRichMediaSrcLink | String | ElearnRichMediaSrcLink of LearnerLearningRecordsprimarySelectedCourseOfferingcompletionDetailsactivityContentAttempts |
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 |