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