JDBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9062

LearnerLearningRecordsselectedCourseOfferings

LearnerLearningRecordsselectedCourseOfferings

Columns

Name Type Description
LearnerLearningRecordsassignmentRecordId [KEY] Long LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordsselectedCourseOfferings
AssignmentRecordId [KEY] Long Application-generated primary key.
AssignmentRecordNumber String AssignmentRecordNumber of LearnerLearningRecordsselectedCourseOfferings
AssignmentCreatedDate Datetime AssignmentCreatedDate of LearnerLearningRecordsselectedCourseOfferings
AssignmentLastModifiedDate Datetime AssignmentLastModifiedDate of LearnerLearningRecordsselectedCourseOfferings
AssignmentJustification String Justification provided by the specialist or learner when enrolling for a learning item.
AssignmentStatus String Status of the enrollment record, such as Content Completed, Completed, and Waitlisted. Valid values are defined in the list AssignmentStatusLOV.
AssignmentSubStatus String AssignmentSubStatus of LearnerLearningRecordsselectedCourseOfferings
AssignedToId Long Unique identifier of the person to whom the learning item was assigned.
AssignerId Long AssignerId of LearnerLearningRecordsselectedCourseOfferings
AssignerNumber String AssignerNumber of LearnerLearningRecordsselectedCourseOfferings
AssignerAttributionType String Entity type that created the learning record, such as person, specialist or community.
AssignerDisplayName String AssignerDisplayName of LearnerLearningRecordsselectedCourseOfferings
AssignerPersonPrimaryEmailAddress String AssignerPersonPrimaryEmailAddress of LearnerLearningRecordsselectedCourseOfferings
AssignerPersonPrimaryPhoneNumber String AssignerPersonPrimaryPhoneNumber of LearnerLearningRecordsselectedCourseOfferings
AssignerCommentsToLearner String Comments specified by the assigner for the learner when creating the assignment. It's null when no comment is provided.
AssignerPersonImageURL String AssignerPersonImageURL of LearnerLearningRecordsselectedCourseOfferings
LearningItemId Long Unique identifier for the learning item that's the internal primary key.
LearningItemNumber String Friendly number identifying the learning item. It's a surrogate key that's shown in the UI.
LearningItemType String Learning item type, such as Course, Specialization, Tutorial, and Video. Valid values are defined in the list AssignedLearningItemTypeLOV.
LearningItemTitle String LearningItemTitle of LearnerLearningRecordsselectedCourseOfferings
LiShortDescription String LiShortDescription of LearnerLearningRecordsselectedCourseOfferings
LearningItemEffectiveAsOf Datetime LearningItemEffectiveAsOf of LearnerLearningRecordsselectedCourseOfferings
OfferingDeliveryMode String OfferingDeliveryMode of LearnerLearningRecordsselectedCourseOfferings
OfferingLanguage String OfferingLanguage of LearnerLearningRecordsselectedCourseOfferings
OfferingLanguageMeaning String OfferingLanguageMeaning of LearnerLearningRecordsselectedCourseOfferings
LiTotalExpectedEffort Decimal LiTotalExpectedEffort of LearnerLearningRecordsselectedCourseOfferings
LiTotalExpectedEffortUOM String LiTotalExpectedEffortUOM of LearnerLearningRecordsselectedCourseOfferings
OfferingStartDate Datetime OfferingStartDate of LearnerLearningRecordsselectedCourseOfferings
OfferingEndDate Datetime OfferingEndDate of LearnerLearningRecordsselectedCourseOfferings
RequestedDate Datetime RequestedDate of LearnerLearningRecordsselectedCourseOfferings
RequestedStartDate Datetime Learning request start date specified on the learning record for the selected offering.
RequestedCompleteByDate Date Learning request completion by date specified on the learning record for the selected offering.
RequestApprovedDate Datetime RequestApprovedDate of LearnerLearningRecordsselectedCourseOfferings
RequestRejectedDate Date RequestRejectedDate of LearnerLearningRecordsselectedCourseOfferings
EnteredWaitlistDate Date EnteredWaitlistDate of LearnerLearningRecordsselectedCourseOfferings
CurrentWaitlistPosition Int CurrentWaitlistPosition of LearnerLearningRecordsselectedCourseOfferings
ExitedWaitlistDate Date ExitedWaitlistDate of LearnerLearningRecordsselectedCourseOfferings
DeletedDate Datetime DeletedDate of LearnerLearningRecordsselectedCourseOfferings
PurchasedDate Date PurchasedDate of LearnerLearningRecordsselectedCourseOfferings
EnteredPendingPaymentDate Date EnteredPendingPaymentDate of LearnerLearningRecordsselectedCourseOfferings
AssignedDate Datetime AssignedDate of LearnerLearningRecordsselectedCourseOfferings
StartedDate Date StartedDate of LearnerLearningRecordsselectedCourseOfferings
ContentCompletedDate Date ContentCompletedDate of LearnerLearningRecordsselectedCourseOfferings
EvaluationSubmittedDate String EvaluationSubmittedDate of LearnerLearningRecordsselectedCourseOfferings
CompletedDate Datetime CompletedDate of LearnerLearningRecordsselectedCourseOfferings
WithdrawnDate Datetime WithdrawnDate of LearnerLearningRecordsselectedCourseOfferings
WithdrawnRequestedDate Datetime WithdrawnRequestedDate of LearnerLearningRecordsselectedCourseOfferings
PurchaseAmount Decimal PurchaseAmount of LearnerLearningRecordsselectedCourseOfferings
PurchaseCurrency String PurchaseCurrency of LearnerLearningRecordsselectedCourseOfferings
IsPrimaryOffering String IsPrimaryOffering of LearnerLearningRecordsselectedCourseOfferings
PrimaryClassroomType String Primary classroom-type, such as Physical Classroom, Virtual Classroom, or No Location Defined.
MaximumCapacity Int MaximumCapacity of LearnerLearningRecordsselectedCourseOfferings
OfferingAvailableCapacity Int OfferingAvailableCapacity of LearnerLearningRecordsselectedCourseOfferings
OfferingCoordinatorDisplayName String OfferingCoordinatorDisplayName of LearnerLearningRecordsselectedCourseOfferings
OfferingCoordinatorPersonNumber String OfferingCoordinatorPersonNumber of LearnerLearningRecordsselectedCourseOfferings
OfferingCoordinatorEmailAddress String OfferingCoordinatorEmailAddress of LearnerLearningRecordsselectedCourseOfferings
AssignmentType String Enrollment type on the primary selected course offering, such as required or voluntary. Valid values are defined in the list AssignmentTypeLOV.
AssignmentTypeMeaning String AssignmentTypeMeaning of LearnerLearningRecordsselectedCourseOfferings
StatusChangeComment String Status change comment on the primary selected course offering.
ReasonCode String Reason code on the primary selected course offering. Valid values are defined in the list ReasonCodeLOV.
AssignmentDueDate Datetime Assignment due date on the primary selected course offering.
EnteredPendingPrerequisitesDate Date EnteredPendingPrerequisitesDate of LearnerLearningRecordsselectedCourseOfferings
ExitedPendingPrerequisitesDate Date ExitedPendingPrerequisitesDate of LearnerLearningRecordsselectedCourseOfferings
DataSecurityPrivilege String Data security privilege for the learning item such Learner or Learner Manager. Valid values are defined in the list DataSecurityPrivilegeLOV.
ExemptedDate Datetime ExemptedDate of LearnerLearningRecordsselectedCourseOfferings
EnteredPendingSeatAcceptanceDate Datetime Date when the assignment record entered the pending seat acceptance status.
ExitedPendingSeatAcceptanceDate Datetime Date when the assignment record exited the pending seat acceptance status.
ActiveDate Datetime Date when the assignment record moved to an active status.
LearningItemDefinitionUsedDate Datetime LearningItemDefinitionUsedDate of LearnerLearningRecordsselectedCourseOfferings
LearningItemEffectiveDate Datetime LearningItemEffectiveDate of LearnerLearningRecordsselectedCourseOfferings
LearningItemLatestChangeEventDate Datetime LearningItemLatestChangeEventDate of LearnerLearningRecordsselectedCourseOfferings
IsLearnerOnLatestLIVersion String IsLearnerOnLatestLIVersion of LearnerLearningRecordsselectedCourseOfferings
EnrollmentQuestionnaireId Long Unique identifier of the enrollment questionnaire.
SourceId Long Unique identifier for the source where this assignment was created.
SourceType String Type for the source where this assignment was created, such as Recommendation or Search.
CanEditAssignmentHint String Hint to identify if the user can edit the learning record, such as Can delete, Can withdraw, No edit. Valid values are defined in the list CanEditAssignmentHintLOV.
LearningItemDeepLink String LearningItemDeepLink of LearnerLearningRecordsselectedCourseOfferings
LearningItemEmbedLink String LearningItemEmbedLink of LearnerLearningRecordsselectedCourseOfferings
LearningItemDataLink String LearningItemDataLink of LearnerLearningRecordsselectedCourseOfferings
OfferingSelfServiceCatalogPrice Decimal OfferingSelfServiceCatalogPrice of LearnerLearningRecordsselectedCourseOfferings
OfferingSelfServiceCatalogPriceCurrency String OfferingSelfServiceCatalogPriceCurrency of LearnerLearningRecordsselectedCourseOfferings
RefundRule String RefundRule of LearnerLearningRecordsselectedCourseOfferings
LiTotalExpectedEffortUOMMeaning String LiTotalExpectedEffortUOMMeaning of LearnerLearningRecordsselectedCourseOfferings
AssignmentStatusMeaning String AssignmentStatusMeaning of LearnerLearningRecordsselectedCourseOfferings
AssignmentSubStatusMeaning String AssignmentSubStatusMeaning of LearnerLearningRecordsselectedCourseOfferings
LearningItemTypeMeaning String LearningItemTypeMeaning of LearnerLearningRecordsselectedCourseOfferings
AssignerAttributionTypeMeaning String AssignerAttributionTypeMeaning of LearnerLearningRecordsselectedCourseOfferings
DataSecurityPrivilegeMeaning String DataSecurityPrivilegeMeaning of LearnerLearningRecordsselectedCourseOfferings
ReasonCodeMeaning String ReasonCodeMeaning of LearnerLearningRecordsselectedCourseOfferings
CanEditAssignmentHintMeaning String CanEditAssignmentHintMeaning of LearnerLearningRecordsselectedCourseOfferings
LiLongDescription String LiLongDescription of LearnerLearningRecordsselectedCourseOfferings
PrimaryClassroomTypeMeaning String PrimaryClassroomTypeMeaning of LearnerLearningRecordsselectedCourseOfferings
OfferingDeliveryModeMeaning String OfferingDeliveryModeMeaning of LearnerLearningRecordsselectedCourseOfferings
Finder String Finder of LearnerLearningRecordsselectedCourseOfferings
LearnerId Long LearnerId of LearnerLearningRecordsselectedCourseOfferings
ManagerId Long ManagerId of LearnerLearningRecordsselectedCourseOfferings
SysEffectiveDate String SysEffectiveDate of LearnerLearningRecordsselectedCourseOfferings

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