LearnerLearningRecordsrelatedLearningRecords
LearnerLearningRecordsrelatedLearningRecords
Columns
| Name | Type | Description |
| LearnerLearningRecordsassignmentRecordId [KEY] | Long | LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentRecordId | Long | AssignmentRecordId of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentRecordNumber | String | AssignmentRecordNumber of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentCreatedDate | Datetime | AssignmentCreatedDate of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentLastModifiedDate | Datetime | AssignmentLastModifiedDate of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentType | String | AssignmentType of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentTypeMeaning | String | AssignmentTypeMeaning of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentJustification | String | AssignmentJustification of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentDueDate | Datetime | AssignmentDueDate of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentStatus | String | AssignmentStatus of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentStatusMeaning | String | AssignmentStatusMeaning of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentSubStatus | String | AssignmentSubStatus of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentSubStatusMeaning | String | AssignmentSubStatusMeaning of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentDetailsDeepLink | String | AssignmentDetailsDeepLink of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentDetailsEmbedLink | String | AssignmentDetailsEmbedLink of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentAttributionId | Long | AssignmentAttributionId of LearnerLearningRecordsrelatedLearningRecords |
| AssignedToId | Long | AssignedToId of LearnerLearningRecordsrelatedLearningRecords |
| AssignedToNumber | String | AssignedToNumber of LearnerLearningRecordsrelatedLearningRecords |
| AssignedToType | String | AssignedToType of LearnerLearningRecordsrelatedLearningRecords |
| AssignedToTypeMeaning | String | AssignedToTypeMeaning of LearnerLearningRecordsrelatedLearningRecords |
| AssignedToPersonPrimaryEmailAddress | String | AssignedToPersonPrimaryEmailAddress of LearnerLearningRecordsrelatedLearningRecords |
| AssignedToPersonPrimaryPhoneNumber | String | AssignedToPersonPrimaryPhoneNumber of LearnerLearningRecordsrelatedLearningRecords |
| AssignedToPersonImageURL | String | AssignedToPersonImageURL of LearnerLearningRecordsrelatedLearningRecords |
| AssignedToDisplayName | String | AssignedToDisplayName of LearnerLearningRecordsrelatedLearningRecords |
| AssignerId | Long | AssignerId of LearnerLearningRecordsrelatedLearningRecords |
| AssignerNumber | String | AssignerNumber of LearnerLearningRecordsrelatedLearningRecords |
| AssignerAttributionType | String | AssignerAttributionType of LearnerLearningRecordsrelatedLearningRecords |
| AssignerAttributionTypeMeaning | String | AssignerAttributionTypeMeaning of LearnerLearningRecordsrelatedLearningRecords |
| AssignerDisplayName | String | AssignerDisplayName of LearnerLearningRecordsrelatedLearningRecords |
| AssignerPersonPrimaryEmailAddress | String | AssignerPersonPrimaryEmailAddress of LearnerLearningRecordsrelatedLearningRecords |
| AssignerPersonPrimaryPhoneNumber | String | AssignerPersonPrimaryPhoneNumber of LearnerLearningRecordsrelatedLearningRecords |
| AssignerCommentsToLearner | String | AssignerCommentsToLearner of LearnerLearningRecordsrelatedLearningRecords |
| AssignerPersonImageURL | String | AssignerPersonImageURL of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemId | Long | LearningItemId of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemNumber | String | LearningItemNumber of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemType | String | LearningItemType of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemTypeMeaning | String | LearningItemTypeMeaning of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemTitle | String | LearningItemTitle of LearnerLearningRecordsrelatedLearningRecords |
| LiShortDescription | String | LiShortDescription of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemEffectiveAsOf | Date | LearningItemEffectiveAsOf of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemDeepLink | String | LearningItemDeepLink of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemEmbedLink | String | LearningItemEmbedLink of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemDataLink | String | LearningItemDataLink of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemPublisherDisplayName | String | LearningItemPublisherDisplayName of LearnerLearningRecordsrelatedLearningRecords |
| ExpectedEffortInHours | String | ExpectedEffortInHours of LearnerLearningRecordsrelatedLearningRecords |
| ActualEffortInHours | Double | ActualEffortInHours of LearnerLearningRecordsrelatedLearningRecords |
| LiTotalExpectedEffort | Double | LiTotalExpectedEffort of LearnerLearningRecordsrelatedLearningRecords |
| LiTotalExpectedEffortUOM | String | LiTotalExpectedEffortUOM of LearnerLearningRecordsrelatedLearningRecords |
| LiTotalExpectedEffortUOMMeaning | String | LiTotalExpectedEffortUOMMeaning of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemMaximumPrice | Double | LearningItemMaximumPrice of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemMinimumPrice | Double | LearningItemMinimumPrice of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemPriceCurrency | String | LearningItemPriceCurrency of LearnerLearningRecordsrelatedLearningRecords |
| RequestedDate | Datetime | RequestedDate of LearnerLearningRecordsrelatedLearningRecords |
| RequestedStartDate | Datetime | RequestedStartDate of LearnerLearningRecordsrelatedLearningRecords |
| RequestedCompleteByDate | Date | RequestedCompleteByDate of LearnerLearningRecordsrelatedLearningRecords |
| RequestApprovedDate | Date | RequestApprovedDate of LearnerLearningRecordsrelatedLearningRecords |
| RequestRejectedDate | Date | RequestRejectedDate of LearnerLearningRecordsrelatedLearningRecords |
| EnteredWaitlistDate | Date | EnteredWaitlistDate of LearnerLearningRecordsrelatedLearningRecords |
| CurrentWaitlistPosition | Int | CurrentWaitlistPosition of LearnerLearningRecordsrelatedLearningRecords |
| ExitedWaitlistDate | Date | ExitedWaitlistDate of LearnerLearningRecordsrelatedLearningRecords |
| DeletedDate | Date | DeletedDate of LearnerLearningRecordsrelatedLearningRecords |
| EnteredPendingPrerequisitesDate | Date | EnteredPendingPrerequisitesDate of LearnerLearningRecordsrelatedLearningRecords |
| ExitedPendingPrerequisitesDate | Date | ExitedPendingPrerequisitesDate of LearnerLearningRecordsrelatedLearningRecords |
| EnteredPendingPaymentDate | Datetime | EnteredPendingPaymentDate of LearnerLearningRecordsrelatedLearningRecords |
| PurchaseAmount | Double | PurchaseAmount of LearnerLearningRecordsrelatedLearningRecords |
| PurchaseCurrency | String | PurchaseCurrency of LearnerLearningRecordsrelatedLearningRecords |
| PurchasedDate | Date | PurchasedDate of LearnerLearningRecordsrelatedLearningRecords |
| AssignedDate | Datetime | AssignedDate of LearnerLearningRecordsrelatedLearningRecords |
| StartedDate | Date | StartedDate of LearnerLearningRecordsrelatedLearningRecords |
| ContentCompletedDate | Date | ContentCompletedDate of LearnerLearningRecordsrelatedLearningRecords |
| EvaluationSubmittedDate | Date | EvaluationSubmittedDate of LearnerLearningRecordsrelatedLearningRecords |
| WithdrawnDate | Datetime | WithdrawnDate of LearnerLearningRecordsrelatedLearningRecords |
| CompletedDate | Datetime | CompletedDate of LearnerLearningRecordsrelatedLearningRecords |
| ExpirationDate | Date | ExpirationDate of LearnerLearningRecordsrelatedLearningRecords |
| ExpirationInDaysSystemDate | Double | ExpirationInDaysSystemDate of LearnerLearningRecordsrelatedLearningRecords |
| ValidityPeriodRule | String | ValidityPeriodRule of LearnerLearningRecordsrelatedLearningRecords |
| ValidityPeriodRuleMeaning | String | ValidityPeriodRuleMeaning of LearnerLearningRecordsrelatedLearningRecords |
| RenewalPeriod | Double | RenewalPeriod of LearnerLearningRecordsrelatedLearningRecords |
| ExpirationRule | String | ExpirationRule of LearnerLearningRecordsrelatedLearningRecords |
| HasFutureRenewal | String | HasFutureRenewal of LearnerLearningRecordsrelatedLearningRecords |
| NextRenewalAssignmentId | Long | NextRenewalAssignmentId of LearnerLearningRecordsrelatedLearningRecords |
| NextRenewalAssignmentNumber | String | NextRenewalAssignmentNumber of LearnerLearningRecordsrelatedLearningRecords |
| NextRenewalAssignmentDeepLink | String | NextRenewalAssignmentDeepLink of LearnerLearningRecordsrelatedLearningRecords |
| NextRenewalAssignmentEmbedLink | String | NextRenewalAssignmentEmbedLink of LearnerLearningRecordsrelatedLearningRecords |
| WithdrawnRequestedDate | Datetime | WithdrawnRequestedDate of LearnerLearningRecordsrelatedLearningRecords |
| StatusChangeComment | String | StatusChangeComment of LearnerLearningRecordsrelatedLearningRecords |
| ReasonCode | String | ReasonCode of LearnerLearningRecordsrelatedLearningRecords |
| DataSecurityPrivilege | String | DataSecurityPrivilege of LearnerLearningRecordsrelatedLearningRecords |
| DataSecurityPrivilegeMeaning | String | DataSecurityPrivilegeMeaning of LearnerLearningRecordsrelatedLearningRecords |
| ActualScore | Double | ActualScore of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemCpeType | String | LearningItemCpeType of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemCpeTypeMeaning | String | LearningItemCpeTypeMeaning of LearnerLearningRecordsrelatedLearningRecords |
| ActualCpeUnits | Double | ActualCpeUnits of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemSubType | String | LearningItemSubType of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemSubTypeMeaning | String | LearningItemSubTypeMeaning of LearnerLearningRecordsrelatedLearningRecords |
| HasPastRenewal | String | HasPastRenewal of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentRelationType | String | AssignmentRelationType of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentRelationTypeMeaning | String | AssignmentRelationTypeMeaning of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentRelationId [KEY] | Long | AssignmentRelationId of LearnerLearningRecordsrelatedLearningRecords |
| ExemptedDate | Datetime | ExemptedDate of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemCoverArtLink | String | LearningItemCoverArtLink of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemThumbnailLink | String | LearningItemThumbnailLink of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemTrailerLink | String | LearningItemTrailerLink of LearnerLearningRecordsrelatedLearningRecords |
| AssignmentDueInFromSystemDate | Long | AssignmentDueInFromSystemDate of LearnerLearningRecordsrelatedLearningRecords |
| RefundRule | String | RefundRule of LearnerLearningRecordsrelatedLearningRecords |
| LearningItemCompletionCertificateLink | String | LearningItemCompletionCertificateLink of LearnerLearningRecordsrelatedLearningRecords |
| CanEditAssignmentHint | String | CanEditAssignmentHint of LearnerLearningRecordsrelatedLearningRecords |
| CanEditAssignmentHintMeaning | String | CanEditAssignmentHintMeaning of LearnerLearningRecordsrelatedLearningRecords |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |
| LearnerId | Long | learnerId |
| ManagerId | Long | managerId |