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