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 |