ODBC Driver for Oracle Fusion Cloud HCM

Build 23.0.8839

LearnerLearningRecordspastRenewalsrelatedLearningRecords

LearnerLearningRecordspastRenewalsrelatedLearningRecords

Columns

Name Type Description
LearnerLearningRecordsassignmentRecordId [KEY] Long LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordspastRenewalsrelatedLearningRecords
PastrenewalsassignmentRecordId [KEY] Long PastrenewalsassignmentRecordId of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentRecordId Long AssignmentRecordId of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentRecordNumber String AssignmentRecordNumber of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentCreatedDate Datetime AssignmentCreatedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentLastModifiedDate Datetime AssignmentLastModifiedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentType String AssignmentType of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentTypeMeaning String AssignmentTypeMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentJustification String AssignmentJustification of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentDueDate Datetime AssignmentDueDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentStatus String AssignmentStatus of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentStatusMeaning String AssignmentStatusMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentSubStatus String AssignmentSubStatus of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentSubStatusMeaning String AssignmentSubStatusMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentDetailsDeepLink String AssignmentDetailsDeepLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentDetailsEmbedLink String AssignmentDetailsEmbedLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentAttributionId Long AssignmentAttributionId of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignedToId Long AssignedToId of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignedToNumber String AssignedToNumber of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignedToType String AssignedToType of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignedToTypeMeaning String AssignedToTypeMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignedToPersonPrimaryEmailAddress String AssignedToPersonPrimaryEmailAddress of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignedToPersonPrimaryPhoneNumber String AssignedToPersonPrimaryPhoneNumber of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignedToPersonImageURL String AssignedToPersonImageURL of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignedToDisplayName String AssignedToDisplayName of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignerId Long AssignerId of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignerNumber String AssignerNumber of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignerAttributionType String AssignerAttributionType of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignerAttributionTypeMeaning String AssignerAttributionTypeMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignerDisplayName String AssignerDisplayName of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignerPersonPrimaryEmailAddress String AssignerPersonPrimaryEmailAddress of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignerPersonPrimaryPhoneNumber String AssignerPersonPrimaryPhoneNumber of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignerCommentsToLearner String AssignerCommentsToLearner of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignerPersonImageURL String AssignerPersonImageURL of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemId Long LearningItemId of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemNumber String LearningItemNumber of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemType String LearningItemType of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemTypeMeaning String LearningItemTypeMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemTitle String LearningItemTitle of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LiShortDescription String LiShortDescription of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemEffectiveAsOf Date LearningItemEffectiveAsOf of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemDeepLink String LearningItemDeepLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemEmbedLink String LearningItemEmbedLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemDataLink String LearningItemDataLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemPublisherDisplayName String LearningItemPublisherDisplayName of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ExpectedEffortInHours String ExpectedEffortInHours of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ActualEffortInHours Double ActualEffortInHours of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LiTotalExpectedEffort Double LiTotalExpectedEffort of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LiTotalExpectedEffortUOM String LiTotalExpectedEffortUOM of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LiTotalExpectedEffortUOMMeaning String LiTotalExpectedEffortUOMMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemMaximumPrice Double LearningItemMaximumPrice of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemMinimumPrice Double LearningItemMinimumPrice of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemPriceCurrency String LearningItemPriceCurrency of LearnerLearningRecordspastRenewalsrelatedLearningRecords
RequestedDate Datetime RequestedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
RequestedStartDate Datetime RequestedStartDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
RequestedCompleteByDate Date RequestedCompleteByDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
RequestApprovedDate Date RequestApprovedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
RequestRejectedDate Date RequestRejectedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
EnteredWaitlistDate Date EnteredWaitlistDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
CurrentWaitlistPosition Int CurrentWaitlistPosition of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ExitedWaitlistDate Date ExitedWaitlistDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
DeletedDate Date DeletedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
EnteredPendingPrerequisitesDate Date EnteredPendingPrerequisitesDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ExitedPendingPrerequisitesDate Date ExitedPendingPrerequisitesDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
EnteredPendingPaymentDate Datetime EnteredPendingPaymentDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
PurchaseAmount Double PurchaseAmount of LearnerLearningRecordspastRenewalsrelatedLearningRecords
PurchaseCurrency String PurchaseCurrency of LearnerLearningRecordspastRenewalsrelatedLearningRecords
PurchasedDate Date PurchasedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignedDate Datetime AssignedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
StartedDate Date StartedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ContentCompletedDate Date ContentCompletedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
EvaluationSubmittedDate Date EvaluationSubmittedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
WithdrawnDate Datetime WithdrawnDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
CompletedDate Datetime CompletedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ExpirationDate Date ExpirationDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ExpirationInDaysSystemDate Double ExpirationInDaysSystemDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ValidityPeriodRule String ValidityPeriodRule of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ValidityPeriodRuleMeaning String ValidityPeriodRuleMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
RenewalPeriod Double RenewalPeriod of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ExpirationRule String ExpirationRule of LearnerLearningRecordspastRenewalsrelatedLearningRecords
HasFutureRenewal String HasFutureRenewal of LearnerLearningRecordspastRenewalsrelatedLearningRecords
NextRenewalAssignmentId Long NextRenewalAssignmentId of LearnerLearningRecordspastRenewalsrelatedLearningRecords
NextRenewalAssignmentNumber String NextRenewalAssignmentNumber of LearnerLearningRecordspastRenewalsrelatedLearningRecords
NextRenewalAssignmentDeepLink String NextRenewalAssignmentDeepLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
NextRenewalAssignmentEmbedLink String NextRenewalAssignmentEmbedLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
WithdrawnRequestedDate Datetime WithdrawnRequestedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
StatusChangeComment String StatusChangeComment of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ReasonCode String ReasonCode of LearnerLearningRecordspastRenewalsrelatedLearningRecords
DataSecurityPrivilege String DataSecurityPrivilege of LearnerLearningRecordspastRenewalsrelatedLearningRecords
DataSecurityPrivilegeMeaning String DataSecurityPrivilegeMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ActualScore Double ActualScore of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemCpeType String LearningItemCpeType of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemCpeTypeMeaning String LearningItemCpeTypeMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ActualCpeUnits Double ActualCpeUnits of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemSubType String LearningItemSubType of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemSubTypeMeaning String LearningItemSubTypeMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
HasPastRenewal String HasPastRenewal of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentRelationType String AssignmentRelationType of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentRelationTypeMeaning String AssignmentRelationTypeMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentRelationId [KEY] Long AssignmentRelationId of LearnerLearningRecordspastRenewalsrelatedLearningRecords
ExemptedDate Datetime ExemptedDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemCoverArtLink String LearningItemCoverArtLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemThumbnailLink String LearningItemThumbnailLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemTrailerLink String LearningItemTrailerLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
AssignmentDueInFromSystemDate Long AssignmentDueInFromSystemDate of LearnerLearningRecordspastRenewalsrelatedLearningRecords
RefundRule String RefundRule of LearnerLearningRecordspastRenewalsrelatedLearningRecords
LearningItemCompletionCertificateLink String LearningItemCompletionCertificateLink of LearnerLearningRecordspastRenewalsrelatedLearningRecords
CanEditAssignmentHint String CanEditAssignmentHint of LearnerLearningRecordspastRenewalsrelatedLearningRecords
CanEditAssignmentHintMeaning String CanEditAssignmentHintMeaning of LearnerLearningRecordspastRenewalsrelatedLearningRecords

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
SysEffectiveDate String SysEffectiveDate
Finder String finder
LearnerId Long learnerId
ManagerId Long managerId

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839