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