LearnerLearningRecordscompletionDetailsselectedCourseOfferingsenrollmentRelatedMaterials
LearnerLearningRecordscompletionDetailsselectedCourseOfferingsenrollmentRelatedMaterials
Columns
Name | Type | Description |
LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingsenrollmentRelatedMaterials |
CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingsenrollmentRelatedMaterials |
SelectedcourseofferingsassignmentRecordId [KEY] | Long | SelectedcourseofferingsassignmentRecordId of LearnerLearningRecordscompletionDetailsselectedCourseOfferingsenrollmentRelatedMaterials |
AttachedDocumentId [KEY] | Long | Unique identifier of the attached document. |
LastUpdateDate | Datetime | Date when attachment record was last updated. |
LastUpdatedBy | String | Name of the user who last updated the attachment record. |
DatatypeCode | String | Attachment Type such as FILE or TEXT, or WEB_PAGE. |
FileName | String | Name of the attachment file. |
DmFolderPath | String | The folder path from which the attachment is created. |
DmDocumentId | String | Surrogate identifier of the document attached. |
DmVersionNumber | String | Version number of the attachment. |
Url | String | URL of a web page type attachment. |
CategoryName | String | Category name of the attachment. This is a read-only attribute. |
UserName | String | URL of a web page type attachment. |
Uri | String | URI of the attachment. This is a read-only attribute. |
FileUrl | String | File URL of the attachment. |
UploadedText | String | Text uploaded in the attachment. |
UploadedFileContentType | String | Content type of the uploaded file. This is a read-only attribute. |
UploadedFileLength | Long | Size of the uploaded file. This is a read-only attribute. |
UploadedFileName | String | Name of the uploaded file. This is a read-only attribute. |
ContentRepositoryFileShared | Bool | Indicates whether the file can be shared. The default value is false and it's the only supported value. |
Title | String | Title of the attachment. |
Description | String | Description of the attachment. |
ErrorStatusCode | String | The error status code, if any, for the attachment. |
ErrorStatusMessage | String | The error message, if any, for the attachment. |
CreatedBy | String | User who created the attachment. |
CreationDate | Datetime | Date when the attachment was created. |
FileContents | String | Actual content of the attachment. |
ExpirationDate | Datetime | Expiration date of the attachment. This is a read-only attribute. |
LastUpdatedByUserName | String | User name of the user who last updated the attachment. |
CreatedByUserName | String | User name of the user who created the attachment. |
AsyncTrackerId | String | Attribute provided by the Attachment UI components to support the upload of files. |
FileWebImage | String | Base64 encoded image file displayed in .png format when the source is a convertible image. |
DownloadInfo | String | JSON object represented as a string that contains information used to programmatically retrieve a file attachment. |
AttachmentId | Long | ID of the attachment. |
AttachmentNumber | String | User-friendly number for identifying the attachment. |
AttachmentName | String | Name of the attachment. |
AttachmentType | String | Type of the attachment. |
AttachmentLink | String | Link to the attachment. |
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 |