ODBC Driver for Oracle Fusion Cloud HCM

Build 24.0.9060

LearnerLearningRecordscompletionDetailsselectedCourseOfferings

LearnerLearningRecordscompletionDetailsselectedCourseOfferings

Columns

Name Type Description
LearnerLearningRecordsassignmentRecordId [KEY] Long LearnerLearningRecordsassignmentRecordId of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
CompletiondetailsactivityId [KEY] Long CompletiondetailsactivityId of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignmentRecordId [KEY] Long Application-generated primary key.
AssignmentRecordNumber String AssignmentRecordNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignmentCreatedDate Datetime AssignmentCreatedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignmentLastModifiedDate Datetime AssignmentLastModifiedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
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 LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignedToId Long Unique identifier of the person to whom the learning item was assigned.
AssignerId Long AssignerId of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignerNumber String AssignerNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignerAttributionType String Entity type that created the learning record, such as person, specialist or community.
AssignerDisplayName String AssignerDisplayName of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignerPersonPrimaryEmailAddress String AssignerPersonPrimaryEmailAddress of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignerPersonPrimaryPhoneNumber String AssignerPersonPrimaryPhoneNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
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 LearnerLearningRecordscompletionDetailsselectedCourseOfferings
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 LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LiShortDescription String LiShortDescription of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LearningItemEffectiveAsOf Datetime LearningItemEffectiveAsOf of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingDeliveryMode String OfferingDeliveryMode of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingLanguage String OfferingLanguage of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingLanguageMeaning String OfferingLanguageMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LiTotalExpectedEffort Decimal LiTotalExpectedEffort of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LiTotalExpectedEffortUOM String LiTotalExpectedEffortUOM of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingStartDate Datetime OfferingStartDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingEndDate Datetime OfferingEndDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
RequestedDate Datetime RequestedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
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 LearnerLearningRecordscompletionDetailsselectedCourseOfferings
RequestRejectedDate Date RequestRejectedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
EnteredWaitlistDate Date EnteredWaitlistDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
CurrentWaitlistPosition Int CurrentWaitlistPosition of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
ExitedWaitlistDate Date ExitedWaitlistDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
DeletedDate Datetime DeletedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
PurchasedDate Date PurchasedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
EnteredPendingPaymentDate Date EnteredPendingPaymentDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignedDate Datetime AssignedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
StartedDate Date StartedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
ContentCompletedDate Date ContentCompletedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
EvaluationSubmittedDate String EvaluationSubmittedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
CompletedDate Datetime CompletedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
WithdrawnDate Datetime WithdrawnDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
WithdrawnRequestedDate Datetime WithdrawnRequestedDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
PurchaseAmount Decimal PurchaseAmount of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
PurchaseCurrency String PurchaseCurrency of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
IsPrimaryOffering String IsPrimaryOffering of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
PrimaryClassroomType String Primary classroom-type, such as Physical Classroom, Virtual Classroom, or No Location Defined.
MaximumCapacity Int MaximumCapacity of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingAvailableCapacity Int OfferingAvailableCapacity of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingCoordinatorDisplayName String OfferingCoordinatorDisplayName of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingCoordinatorPersonNumber String OfferingCoordinatorPersonNumber of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingCoordinatorEmailAddress String OfferingCoordinatorEmailAddress of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
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 LearnerLearningRecordscompletionDetailsselectedCourseOfferings
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 LearnerLearningRecordscompletionDetailsselectedCourseOfferings
ExitedPendingPrerequisitesDate Date ExitedPendingPrerequisitesDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
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 LearnerLearningRecordscompletionDetailsselectedCourseOfferings
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 LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LearningItemEffectiveDate Datetime LearningItemEffectiveDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LearningItemLatestChangeEventDate Datetime LearningItemLatestChangeEventDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
IsLearnerOnLatestLIVersion String IsLearnerOnLatestLIVersion of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
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 LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LearningItemEmbedLink String LearningItemEmbedLink of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LearningItemDataLink String LearningItemDataLink of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingSelfServiceCatalogPrice Decimal OfferingSelfServiceCatalogPrice of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingSelfServiceCatalogPriceCurrency String OfferingSelfServiceCatalogPriceCurrency of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
RefundRule String RefundRule of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LiTotalExpectedEffortUOMMeaning String LiTotalExpectedEffortUOMMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignmentStatusMeaning String AssignmentStatusMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignmentSubStatusMeaning String AssignmentSubStatusMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LearningItemTypeMeaning String LearningItemTypeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
AssignerAttributionTypeMeaning String AssignerAttributionTypeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
DataSecurityPrivilegeMeaning String DataSecurityPrivilegeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
ReasonCodeMeaning String ReasonCodeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
CanEditAssignmentHintMeaning String CanEditAssignmentHintMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LiLongDescription String LiLongDescription of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
PrimaryClassroomTypeMeaning String PrimaryClassroomTypeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
OfferingDeliveryModeMeaning String OfferingDeliveryModeMeaning of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
Finder String Finder of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
LearnerId Long LearnerId of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
ManagerId Long ManagerId of LearnerLearningRecordscompletionDetailsselectedCourseOfferings
SysEffectiveDate String SysEffectiveDate of LearnerLearningRecordscompletionDetailsselectedCourseOfferings

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