LearnerLearningRecordsselectedCourseOfferings
LearnerLearningRecordsselectedCourseOfferings
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordsselectedCourseOfferings |
| AssignmentRecordId [KEY] | Long | System-generated primary key. |
| AssignmentRecordNumber | String | AssignmentRecordNumber of LearnerLearningRecordsselectedCourseOfferings |
| AssignmentCreatedDate | Datetime | AssignmentCreatedDate of LearnerLearningRecordsselectedCourseOfferings |
| AssignmentLastModifiedDate | Datetime | AssignmentLastModifiedDate of LearnerLearningRecordsselectedCourseOfferings |
| 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 LearnerLearningRecordsselectedCourseOfferings |
| AssignedToId | Long | Unique identifier of the person to whom the learning item was assigned. |
| AssignerId | Long | AssignerId of LearnerLearningRecordsselectedCourseOfferings |
| AssignerNumber | String | AssignerNumber of LearnerLearningRecordsselectedCourseOfferings |
| AssignerAttributionType | String | Entity type that created the learning record such as person, specialist or community. |
| AssignerDisplayName | String | AssignerDisplayName of LearnerLearningRecordsselectedCourseOfferings |
| AssignerPersonPrimaryEmailAddress | String | AssignerPersonPrimaryEmailAddress of LearnerLearningRecordsselectedCourseOfferings |
| AssignerPersonPrimaryPhoneNumber | String | AssignerPersonPrimaryPhoneNumber of LearnerLearningRecordsselectedCourseOfferings |
| 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 LearnerLearningRecordsselectedCourseOfferings |
| 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 LearnerLearningRecordsselectedCourseOfferings |
| LiShortDescription | String | LiShortDescription of LearnerLearningRecordsselectedCourseOfferings |
| LearningItemEffectiveAsOf | Datetime | LearningItemEffectiveAsOf of LearnerLearningRecordsselectedCourseOfferings |
| OfferingDeliveryMode | String | OfferingDeliveryMode of LearnerLearningRecordsselectedCourseOfferings |
| OfferingLanguage | String | OfferingLanguage of LearnerLearningRecordsselectedCourseOfferings |
| OfferingLanguageMeaning | String | OfferingLanguageMeaning of LearnerLearningRecordsselectedCourseOfferings |
| LiTotalExpectedEffort | Double | LiTotalExpectedEffort of LearnerLearningRecordsselectedCourseOfferings |
| LiTotalExpectedEffortUOM | String | LiTotalExpectedEffortUOM of LearnerLearningRecordsselectedCourseOfferings |
| OfferingStartDate | Datetime | OfferingStartDate of LearnerLearningRecordsselectedCourseOfferings |
| OfferingEndDate | Datetime | OfferingEndDate of LearnerLearningRecordsselectedCourseOfferings |
| RequestedDate | Datetime | RequestedDate of LearnerLearningRecordsselectedCourseOfferings |
| 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 LearnerLearningRecordsselectedCourseOfferings |
| RequestRejectedDate | Date | RequestRejectedDate of LearnerLearningRecordsselectedCourseOfferings |
| EnteredWaitlistDate | Date | EnteredWaitlistDate of LearnerLearningRecordsselectedCourseOfferings |
| CurrentWaitlistPosition | Int | CurrentWaitlistPosition of LearnerLearningRecordsselectedCourseOfferings |
| ExitedWaitlistDate | Date | ExitedWaitlistDate of LearnerLearningRecordsselectedCourseOfferings |
| DeletedDate | Datetime | DeletedDate of LearnerLearningRecordsselectedCourseOfferings |
| PurchasedDate | Date | PurchasedDate of LearnerLearningRecordsselectedCourseOfferings |
| EnteredPendingPaymentDate | Date | EnteredPendingPaymentDate of LearnerLearningRecordsselectedCourseOfferings |
| AssignedDate | Datetime | AssignedDate of LearnerLearningRecordsselectedCourseOfferings |
| StartedDate | Date | StartedDate of LearnerLearningRecordsselectedCourseOfferings |
| ContentCompletedDate | Date | ContentCompletedDate of LearnerLearningRecordsselectedCourseOfferings |
| EvaluationSubmittedDate | String | EvaluationSubmittedDate of LearnerLearningRecordsselectedCourseOfferings |
| CompletedDate | Datetime | CompletedDate of LearnerLearningRecordsselectedCourseOfferings |
| WithdrawnDate | Datetime | WithdrawnDate of LearnerLearningRecordsselectedCourseOfferings |
| WithdrawnRequestedDate | Datetime | WithdrawnRequestedDate of LearnerLearningRecordsselectedCourseOfferings |
| PurchaseAmount | Double | PurchaseAmount of LearnerLearningRecordsselectedCourseOfferings |
| PurchaseCurrency | String | PurchaseCurrency of LearnerLearningRecordsselectedCourseOfferings |
| IsPrimaryOffering | String | IsPrimaryOffering of LearnerLearningRecordsselectedCourseOfferings |
| PrimaryClassroomType | String | Primary classroom-type such as Physical Classroom, Virtual Classroom, or No Location Defined. |
| MaximumCapacity | Int | MaximumCapacity of LearnerLearningRecordsselectedCourseOfferings |
| OfferingCoordinatorDisplayName | String | OfferingCoordinatorDisplayName of LearnerLearningRecordsselectedCourseOfferings |
| OfferingCoordinatorPersonNumber | String | OfferingCoordinatorPersonNumber of LearnerLearningRecordsselectedCourseOfferings |
| OfferingCoordinatorEmailAddress | String | OfferingCoordinatorEmailAddress of LearnerLearningRecordsselectedCourseOfferings |
| 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 LearnerLearningRecordsselectedCourseOfferings |
| 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 LearnerLearningRecordsselectedCourseOfferings |
| ExitedPendingPrerequisitesDate | Date | ExitedPendingPrerequisitesDate of LearnerLearningRecordsselectedCourseOfferings |
| 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 LearnerLearningRecordsselectedCourseOfferings |
| 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 LearnerLearningRecordsselectedCourseOfferings |
| LearningItemDefinitionUsedDate | Datetime | LearningItemDefinitionUsedDate of LearnerLearningRecordsselectedCourseOfferings |
| LearningItemEffectiveDate | Datetime | LearningItemEffectiveDate of LearnerLearningRecordsselectedCourseOfferings |
| LearningItemLatestChangeEventDate | Datetime | LearningItemLatestChangeEventDate of LearnerLearningRecordsselectedCourseOfferings |
| IsLearnerOnLatestLIVersion | String | IsLearnerOnLatestLIVersion of LearnerLearningRecordsselectedCourseOfferings |
| 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 LearnerLearningRecordsselectedCourseOfferings |
| LearningItemEmbedLink | String | LearningItemEmbedLink of LearnerLearningRecordsselectedCourseOfferings |
| LearningItemDataLink | String | LearningItemDataLink of LearnerLearningRecordsselectedCourseOfferings |
| OfferingSelfServiceCatalogPrice | Double | OfferingSelfServiceCatalogPrice of LearnerLearningRecordsselectedCourseOfferings |
| OfferingSelfServiceCatalogPriceCurrency | String | OfferingSelfServiceCatalogPriceCurrency of LearnerLearningRecordsselectedCourseOfferings |
| RefundRule | String | RefundRule of LearnerLearningRecordsselectedCourseOfferings |
| LiTotalExpectedEffortUOMMeaning | String | LiTotalExpectedEffortUOMMeaning of LearnerLearningRecordsselectedCourseOfferings |
| AssignmentStatusMeaning | String | AssignmentStatusMeaning of LearnerLearningRecordsselectedCourseOfferings |
| AssignmentSubStatusMeaning | String | AssignmentSubStatusMeaning of LearnerLearningRecordsselectedCourseOfferings |
| LearningItemTypeMeaning | String | LearningItemTypeMeaning of LearnerLearningRecordsselectedCourseOfferings |
| AssignerAttributionTypeMeaning | String | AssignerAttributionTypeMeaning of LearnerLearningRecordsselectedCourseOfferings |
| DataSecurityPrivilegeMeaning | String | DataSecurityPrivilegeMeaning of LearnerLearningRecordsselectedCourseOfferings |
| ReasonCodeMeaning | String | ReasonCodeMeaning of LearnerLearningRecordsselectedCourseOfferings |
| CanEditAssignmentHintMeaning | String | CanEditAssignmentHintMeaning of LearnerLearningRecordsselectedCourseOfferings |
| LiLongDescription | String | LiLongDescription of LearnerLearningRecordsselectedCourseOfferings |
| PrimaryClassroomTypeMeaning | String | PrimaryClassroomTypeMeaning of LearnerLearningRecordsselectedCourseOfferings |
| OfferingDeliveryModeMeaning | String | OfferingDeliveryModeMeaning of LearnerLearningRecordsselectedCourseOfferings |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |
| LearnerId | Long | learnerId |
| ManagerId | Long | managerId |