The LearningPlanComponents table in OData provides information on every learning plan component for every learner and programme.
The columns “PlannedHours” and “ActualHours” provide this information for each component.
“PlannedHours” – these are the hours recorded against the component under ‘Planned hours’ field. Returned value is displayed in hours (integer).
“ActualHours” – these are the sum of Off-The-Job Hours Spent across all evidence of the selected component where evidence status is either Accepted or QA Verified. Returned value is displayed in hours (decimal): for instance, ‘2.05’ refers to ‘2 hours and 3 minutes’.
The OData dictionary provides more information on the available data fields.