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 |