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