LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LearnerLearningRecordscompletionDetailsselectedCourseOfferings
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignmentRecordId [KEY] | Long | System-generated primary key. |
| AssignmentRecordNumber | String | AssignmentRecordNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignmentCreatedDate | Datetime | AssignmentCreatedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignmentLastModifiedDate | Datetime | AssignmentLastModifiedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignmentJustification | String | Justification provided by the specialist or learner when enrolling for a learning item. |
| AssignmentStatus | String | Status of the enrollment record such as Content Completed, Completed, and Waitlisted. Valid values are defined in the list AssignmentStatusLOV. |
| AssignmentSubStatus | String | AssignmentSubStatus of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignedToId | Long | Unique identifier of the person to whom the learning item was assigned. |
| AssignerId | Long | AssignerId of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignerNumber | String | AssignerNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignerAttributionType | String | Entity type that created the learning record such as person, specialist or community. |
| AssignerDisplayName | String | AssignerDisplayName of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignerPersonPrimaryEmailAddress | String | AssignerPersonPrimaryEmailAddress of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignerPersonPrimaryPhoneNumber | String | AssignerPersonPrimaryPhoneNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignerCommentsToLearner | String | Comments specified by the assigner for the learner when creating the assignment. It is null when no comment is provided. |
| AssignerPersonImageURL | String | AssignerPersonImageURL of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LearningItemId | Long | Unique identifier for the learning item which is the internal primary key. |
| LearningItemNumber | String | User-friendly number identifying the learning item. It is a surrogate key which is shown in the UI. |
| LearningItemType | String | Learning item type such as Course, Specialization, Tutorial, and Video. Valid values are defined in the list AssignedLearningItemTypeLOV. |
| LearningItemTitle | String | LearningItemTitle of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LiShortDescription | String | LiShortDescription of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LearningItemEffectiveAsOf | Datetime | LearningItemEffectiveAsOf of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingDeliveryMode | String | OfferingDeliveryMode of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingLanguage | String | OfferingLanguage of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingLanguageMeaning | String | OfferingLanguageMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LiTotalExpectedEffort | Double | LiTotalExpectedEffort of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LiTotalExpectedEffortUOM | String | LiTotalExpectedEffortUOM of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingStartDate | Datetime | OfferingStartDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingEndDate | Datetime | OfferingEndDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| RequestedDate | Datetime | RequestedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| RequestedStartDate | Datetime | Learning request start date specified on the learning record for the selected offering. |
| RequestedCompleteByDate | Date | Learning request completion by date specified on the learning record for the selected offering. |
| RequestApprovedDate | Datetime | RequestApprovedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| RequestRejectedDate | Date | RequestRejectedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| EnteredWaitlistDate | Date | EnteredWaitlistDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| CurrentWaitlistPosition | Int | CurrentWaitlistPosition of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| ExitedWaitlistDate | Date | ExitedWaitlistDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| DeletedDate | Datetime | DeletedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| PurchasedDate | Date | PurchasedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| EnteredPendingPaymentDate | Date | EnteredPendingPaymentDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignedDate | Datetime | AssignedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| StartedDate | Date | StartedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| ContentCompletedDate | Date | ContentCompletedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| EvaluationSubmittedDate | String | EvaluationSubmittedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| CompletedDate | Datetime | CompletedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| WithdrawnDate | Datetime | WithdrawnDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| WithdrawnRequestedDate | Datetime | WithdrawnRequestedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| PurchaseAmount | Double | PurchaseAmount of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| PurchaseCurrency | String | PurchaseCurrency of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| IsPrimaryOffering | String | IsPrimaryOffering of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| PrimaryClassroomType | String | Primary classroom-type such as Physical Classroom, Virtual Classroom, or No Location Defined. |
| MaximumCapacity | Int | MaximumCapacity of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingCoordinatorDisplayName | String | OfferingCoordinatorDisplayName of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingCoordinatorPersonNumber | String | OfferingCoordinatorPersonNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingCoordinatorEmailAddress | String | OfferingCoordinatorEmailAddress of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignmentType | String | Enrollment type on the primary selected course offering such as required or voluntary. Valid values are defined in the list AssignmentTypeLOV. |
| AssignmentTypeMeaning | String | AssignmentTypeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| StatusChangeComment | String | Status change comment on the primary selected course offering. |
| ReasonCode | String | Reason code on the primary selected course offering. Valid values are defined in the list ReasonCodeLOV. |
| AssignmentDueDate | Datetime | Assignment due date on the primary selected course offering. |
| EnteredPendingPrerequisitesDate | Date | EnteredPendingPrerequisitesDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| ExitedPendingPrerequisitesDate | Date | ExitedPendingPrerequisitesDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| DataSecurityPrivilege | String | Data security privilege for the learning item such Learner or Learner Manager. Valid values are defined in the list DataSecurityPrivilegeLOV. |
| ExemptedDate | Datetime | ExemptedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| EnteredPendingSeatAcceptanceDate | Datetime | Date when the assignment record entered the pending seat acceptance status. |
| ExitedPendingSeatAcceptanceDate | Datetime | Date when the assignment record exited the pending seat acceptance status. |
| ActiveDate | Datetime | ActiveDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LearningItemDefinitionUsedDate | Datetime | LearningItemDefinitionUsedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LearningItemEffectiveDate | Datetime | LearningItemEffectiveDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LearningItemLatestChangeEventDate | Datetime | LearningItemLatestChangeEventDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| IsLearnerOnLatestLIVersion | String | IsLearnerOnLatestLIVersion of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| EnrollmentQuestionnaireId | Long | Unique identifier of the enrollment questionnaire. |
| CanEditAssignmentHint | String | Hint to identify if the user can edit the learning record such as Can delete, Can withdraw, No edit. Valid values are defined in the list CanEditAssignmentHintLOV. |
| LearningItemDeepLink | String | LearningItemDeepLink of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LearningItemEmbedLink | String | LearningItemEmbedLink of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LearningItemDataLink | String | LearningItemDataLink of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingSelfServiceCatalogPrice | Double | OfferingSelfServiceCatalogPrice of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingSelfServiceCatalogPriceCurrency | String | OfferingSelfServiceCatalogPriceCurrency of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| RefundRule | String | RefundRule of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LiTotalExpectedEffortUOMMeaning | String | LiTotalExpectedEffortUOMMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignmentStatusMeaning | String | AssignmentStatusMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignmentSubStatusMeaning | String | AssignmentSubStatusMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LearningItemTypeMeaning | String | LearningItemTypeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| AssignerAttributionTypeMeaning | String | AssignerAttributionTypeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| DataSecurityPrivilegeMeaning | String | DataSecurityPrivilegeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| ReasonCodeMeaning | String | ReasonCodeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| CanEditAssignmentHintMeaning | String | CanEditAssignmentHintMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| LiLongDescription | String | LiLongDescription of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| PrimaryClassroomTypeMeaning | String | PrimaryClassroomTypeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
| OfferingDeliveryModeMeaning | String | OfferingDeliveryModeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |
| LearnerId | Long | learnerId |
| ManagerId | Long | managerId |