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