JDBC Driver for Oracle Fusion Cloud HCM

Build 26.0.9770

LearningSelfPacedItemscontent

Returns Content associated with a self-paced learning item.

Columns

Name Type SupportedFinders Description
LearningSelfPacedItemslearningItemId [KEY] Long Unique identifier for the learning item.
Status String Status of the learning content, such as active or processing.
ContentId [KEY] Long The unique identifier for the content.
AddedOnDate Datetime Date when the learning item was added to the learning catalog.
SourceId String Unique identifier for the course in the external application, if available.
AutoCommit String Indicates if automatic commit is enabled.Valid values are Y or N.
PassingScore Decimal Score required to successfully complete the provided learning content.
LearnerMaximumAttempts Long The maximum attempts allowed on for the learning content.
LearnerAttemptReview String What attempts a learner can review.
LearnerAttemptRule String The rule used to configure attempts.
SourceLaunchURL String Source URL for the learning item
Type String Type of learning content, such as Video or SCORM
DurationInSeconds Long Content duration in seconds.
StorageProviderNumber String User-friendly number identifying the learning content storage provider.
DeliveryProviderNumber String User-friendly number identifying the learning content delivery provider.
ChapterLevel Long Chapter level of the learning content.Currently this is always set to 1.
ChapterPosition String Chapter position of the learning content.Currently this is always set to 1.
SourceSupportedLanguages String List of languages the learning content supports.
CoverArtHighRenditionLink String Link to the high rendition version of the learning cover art image.
CoverArtMedRenditionLink String Link to the medium rendition version of the learning cover art image.
CoverArtLowRenditionLink String Link to the low rendition version of the learning cover art image.
Title String Title of the learning content.
DeliveryURL String URL used to deliver the learning item to the learner.
AllowBrowseCondition String When a learner is allowed to browse the content.
ScoredContentCompletionRule String Indicates how to set completions when the learner closes the player window.
LearnerAttemptReviewCondition String When a learner can review attempts.
CompletionRule String Completion rule that determines how the content handles completions. It also determines if manager or learner confirmation is required.
AllowFwdScrub String Indicates if forward scrubbing is enabled.Valid values are Y or N.
ShowFeedbackToLearner String Indicates if feedback should be visible to the learner. Valid values are Y or N
DisplayMode String How the content is displayed to the learner, such as embedded.
TimeLimitInSeconds Long Time limit in seconds that the learner is provided to complete the content.
EnableScoring String Indicates if scoring is enabled or not. Valid values are Y or N.
CompletionThreshold Decimal What percentage of the content a learner needs to complete to be marked successful.
SourceMaximumScore Decimal Maximum score that learners can achieve for the provided learning content.
SourceMinimumScore Decimal Minimum score that learners can achieve for the provided learning content.
SourcePassingScore Decimal Score required to successfully complete the provided learning content. This is a read only attribute.
ScoreViewRule String Determines who can view the score, such as learners, learning administrators, or both.
QuestionnaireVersion Long Version of the questionnaire.
QuestionnaireName String Name of the questionnaire.
QuestionnaireCode String Unique code for the questionnaire.
ObsType String Type of observer, such as Individuals, Management Hierarchy, or Representative.
ObsAllowReassignment String Indicates whether the observer can reassign the observation checklist task. Valid values are Y or N. Default value is N.
ObsRepType String Type of representative, such as Benefits representative, Learning representative, or Payroll representative.
ObsManagerType String Manager type, such as Line Manager, Project Manager, or Regional Manager.
ObsManagerLevel String Manager level, such as first level manager, second level manger, or third level manager.
ObsAttemptRule String Determines how many attempts can be recorded. Valid values are ORA_WLF_ARA_LTD_NUM,ORA_WLF_ARA_SNGL,ORA_WLF_ARA_SNGL_RESUME or ORA_WLF_ARA_UNLTD. The default value is ORA_WLF_ARA_SNGL.
ObsMaximumAttempts Long Maximum number of attempts allowed for an observer.
ObsAttemptReviewByLearner String Determines what observer attempts a learner can review. Valid values are ORA_WLF_ARAR_DONT_ENABLE, ORA_WLF_ARAR_LAST_ATTEMPT, ORA_WLF_ARAR_ANY_PAST_ATTEMPT or ORA_WLF_ARAR_LAST_PASS_ATEMPT. If the content is an observation checklist and null for other content types, the default value is ORA_WLF_ARAR_LAST_ATTEMPT.
ObsLearnerSelfAssessEnable String Indicates whether the observation checklist supports self-assessment. Valid values are Y or N. Default value is N.
ObsAttemptReviewByLearnerMeaning String Description for the obsAttemptReviewByLearner attribute value.
ObsAttemptReviewConditionByLearner String Indicates when learners can review the observer's recorded attempts.
ObsShowFeedbackToLearner String Indicates whether observer's feedback should be visible to the learner. Valid values are Y or N.
ObsAllowBrowseCondition String Indicates when learners can browse the content of an observation checklist.
ObsManagerTypeMeaning String Description for the obsManagerType attribute value.
ObsRepTypeMeaning String Description for the obsRepType attribute value.
AutoLaunchOnPageOpen String Indicates whether the content needs to be automatically launched when the enrollment page opens.
CompleteBeforeExitAU String Indicates how completions are recorded by the AICC player. ORA_YES means completions are recorded without waiting for the ExitAU AICC call. ORA_NO means the player waits for the ExitAU call.
RetryAttemptsBeforeDelay Long Number of times a learner can attempt the learning item without a delay.
RetryDelayInHours Decimal Time of delay, in hours, after which the learner can try the content again.
EffortCalculationRule String Determines how the learner's effort is calculated.
ManifestFile String Metadata file that describes an eLearning content package in terms of it's structure, resources, and configuration.
FileListJson String JSON array describing list of files in the eLearning content package in terms of file path, size, and other file related metadata.
AgentCode String Unique code for identifying the agent.
AgentName String Name of the agent.
Finder String The named finder used to filter the records returned for this resource.
LearningItemId Long PrimaryKey, findByLearningItemId Unique identifier of the self-paced learning item that this record belongs to.
LearningItemNumber String FindByLearningItemNumber User-friendly number identifying the self-paced learning item that this record belongs to.
SysEffectiveDate String FindByLearningItemId, findByLearningItemNumber The effective date used to retrieve records valid as of the specified date.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770