LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings
LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| CompletiondetailsactivityId [KEY] | Long | CompletiondetailsactivityId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentRecordId [KEY] | Long | AssignmentRecordId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentRecordNumber | String | AssignmentRecordNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentCreatedDate | Datetime | AssignmentCreatedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentLastModifiedDate | Datetime | AssignmentLastModifiedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentJustification | String | AssignmentJustification of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentStatus | String | AssignmentStatus of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentSubStatus | String | AssignmentSubStatus of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignedToId | Long | AssignedToId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignerId | Long | AssignerId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignerNumber | String | AssignerNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignerAttributionType | String | AssignerAttributionType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignerDisplayName | String | AssignerDisplayName of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignerPersonPrimaryEmailAddress | String | AssignerPersonPrimaryEmailAddress of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignerPersonPrimaryPhoneNumber | String | AssignerPersonPrimaryPhoneNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignerCommentsToLearner | String | AssignerCommentsToLearner of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignerPersonImageURL | String | AssignerPersonImageURL of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemId | Long | LearningItemId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemNumber | String | LearningItemNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemType | String | LearningItemType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemTitle | String | LearningItemTitle of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LiShortDescription | String | LiShortDescription of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemEffectiveAsOf | Datetime | LearningItemEffectiveAsOf of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingDeliveryMode | String | OfferingDeliveryMode of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingLanguage | String | OfferingLanguage of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingLanguageMeaning | String | OfferingLanguageMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LiTotalExpectedEffort | Double | LiTotalExpectedEffort of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LiTotalExpectedEffortUOM | String | LiTotalExpectedEffortUOM of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingStartDate | Datetime | OfferingStartDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingEndDate | Datetime | OfferingEndDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| RequestedDate | Datetime | RequestedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| RequestedStartDate | Datetime | RequestedStartDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| RequestedCompleteByDate | Date | RequestedCompleteByDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| RequestApprovedDate | Datetime | RequestApprovedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| RequestRejectedDate | Date | RequestRejectedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| EnteredWaitlistDate | Date | EnteredWaitlistDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| CurrentWaitlistPosition | Int | CurrentWaitlistPosition of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| ExitedWaitlistDate | Date | ExitedWaitlistDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| DeletedDate | Datetime | DeletedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| PurchasedDate | Date | PurchasedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| EnteredPendingPaymentDate | Date | EnteredPendingPaymentDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignedDate | Datetime | AssignedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| StartedDate | Date | StartedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| ContentCompletedDate | Date | ContentCompletedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| EvaluationSubmittedDate | String | EvaluationSubmittedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| CompletedDate | Datetime | CompletedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| WithdrawnDate | Datetime | WithdrawnDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| WithdrawnRequestedDate | Datetime | WithdrawnRequestedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| PurchaseAmount | Double | PurchaseAmount of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| PurchaseCurrency | String | PurchaseCurrency of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| IsPrimaryOffering | String | IsPrimaryOffering of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| PrimaryClassroomType | String | PrimaryClassroomType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| MaximumCapacity | Int | MaximumCapacity of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingCoordinatorDisplayName | String | OfferingCoordinatorDisplayName of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingCoordinatorPersonNumber | String | OfferingCoordinatorPersonNumber of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingCoordinatorEmailAddress | String | OfferingCoordinatorEmailAddress of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentType | String | AssignmentType of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentTypeMeaning | String | AssignmentTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| StatusChangeComment | String | StatusChangeComment of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| ReasonCode | String | ReasonCode of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentDueDate | Datetime | AssignmentDueDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| EnteredPendingPrerequisitesDate | Date | EnteredPendingPrerequisitesDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| ExitedPendingPrerequisitesDate | Date | ExitedPendingPrerequisitesDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| DataSecurityPrivilege | String | DataSecurityPrivilege of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| ExemptedDate | Datetime | ExemptedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| EnteredPendingSeatAcceptanceDate | Datetime | EnteredPendingSeatAcceptanceDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| ExitedPendingSeatAcceptanceDate | Datetime | ExitedPendingSeatAcceptanceDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| ActiveDate | Datetime | ActiveDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemDefinitionUsedDate | Datetime | LearningItemDefinitionUsedDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemEffectiveDate | Datetime | LearningItemEffectiveDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemLatestChangeEventDate | Datetime | LearningItemLatestChangeEventDate of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| IsLearnerOnLatestLIVersion | String | IsLearnerOnLatestLIVersion of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| EnrollmentQuestionnaireId | Long | EnrollmentQuestionnaireId of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| CanEditAssignmentHint | String | CanEditAssignmentHint of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemDeepLink | String | LearningItemDeepLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemEmbedLink | String | LearningItemEmbedLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemDataLink | String | LearningItemDataLink of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingSelfServiceCatalogPrice | Double | OfferingSelfServiceCatalogPrice of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingSelfServiceCatalogPriceCurrency | String | OfferingSelfServiceCatalogPriceCurrency of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| RefundRule | String | RefundRule of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LiTotalExpectedEffortUOMMeaning | String | LiTotalExpectedEffortUOMMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentStatusMeaning | String | AssignmentStatusMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignmentSubStatusMeaning | String | AssignmentSubStatusMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LearningItemTypeMeaning | String | LearningItemTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| AssignerAttributionTypeMeaning | String | AssignerAttributionTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| DataSecurityPrivilegeMeaning | String | DataSecurityPrivilegeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| ReasonCodeMeaning | String | ReasonCodeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| CanEditAssignmentHintMeaning | String | CanEditAssignmentHintMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| LiLongDescription | String | LiLongDescription of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| PrimaryClassroomTypeMeaning | String | PrimaryClassroomTypeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
| OfferingDeliveryModeMeaning | String | OfferingDeliveryModeMeaning of LearnerLearningRecordscompletionDetailsotherSelectedCourseOfferings |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |
| LearnerId | Long | learnerId |
| ManagerId | Long | managerId |