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 |