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