LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials
LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| SelectedcourseofferingsassignmentRecordId [KEY] | Long | SelectedcourseofferingsassignmentRecordId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| AttachedDocumentId [KEY] | Long | AttachedDocumentId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| LastUpdateDate | Datetime | LastUpdateDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| LastUpdatedBy | String | LastUpdatedBy of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| DatatypeCode | String | DatatypeCode of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| FileName | String | FileName of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| DmFolderPath | String | DmFolderPath of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| DmDocumentId | String | DmDocumentId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| DmVersionNumber | String | DmVersionNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| Url | String | Url of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| CategoryName | String | CategoryName of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| UserName | String | UserName of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| Uri | String | Uri of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| FileUrl | String | FileUrl of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| UploadedText | String | UploadedText of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| UploadedFileContentType | String | UploadedFileContentType of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| UploadedFileLength | Long | UploadedFileLength of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| UploadedFileName | String | UploadedFileName of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| ContentRepositoryFileShared | Bool | ContentRepositoryFileShared of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| Title | String | Title of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| Description | String | Description of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| ErrorStatusCode | String | ErrorStatusCode of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| ErrorStatusMessage | String | ErrorStatusMessage of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| CreatedBy | String | CreatedBy of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| CreationDate | Datetime | CreationDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| FileContents | String | FileContents of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| ExpirationDate | Datetime | ExpirationDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| LastUpdatedByUserName | String | LastUpdatedByUserName of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| CreatedByUserName | String | CreatedByUserName of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| AsyncTrackerId | String | AsyncTrackerId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| FileWebImage | String | FileWebImage of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| DownloadInfo | String | DownloadInfo of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| SourceId | Long | SourceId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| AttachmentId | Long | AttachmentId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| AttachmentNumber | String | AttachmentNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| AttachmentName | String | AttachmentName of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| AttachmentType | String | AttachmentType of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
| AttachmentLink | String | AttachmentLink of LearnerLearningRecordscompletionDetailsselectedCourseOfferingslearningItemRelatedMaterials |
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 |