The Learner Contact and Learning Hours Report produces a list of Contact and Learning Hours recorded for Learner Records that meet the specified criteria.

Open

Report Options

The following customisation options are available:

• Contact Report Type – This controls which date is used in the contact hours record to determine whether the record is included in the report or not.

  • Choosing Dated between dates will use the contact date.

  • Choosing All will include records for all learners in the report.

• Contact From and To – Here you can specify the date range that will determine which contact hours are included in the report. You can either choose a Fixed Date and choose the relevant dates from the calendar date selector, or choose one of the relative values such as Today, Start of Week, Start of Month or others. If you choose a relative value, it is possible to add a positive or negative Offset value, which will adjust the date by the specified number of weeks. For example, choosing End of Week with a +1 Weeks Offset value will run the report from the end of the next week.

• Contact Types – Here you can restrict the report to certain contact types. You can add multiple types to the field and remove any added ones by selecting the X icon.

• On/Off the Job – Here you can restrict the report to either On the Job or Off the Job contact.

• Has Hours – Here you can restrict the report to records with either Planned or Actual hours. You can also choose Any Hours to include both types.

• Recorded By – Here you can choose whether to include contact hours recorded by Officers, Learners and Employers, as well as choosing whether these records need to be Approved or Trusted to be included. You can add multiple roles to the field and remove any added ones by selecting the X icon.

• Learners Report Type – This controls which date is used in the learner record to determine whether contact hours for that learner are included in the report or not. Four types are available:

  • In learning between dates will include any learners that are in learning for any time within the date range.

  • Starters between dates will include any learners whose Start Date falls within the date range.

  • Leavers between dates will include any learners whose Actual End Date falls within the date range.

  • Created between dates will include any learners whose Created date (indicating when they were entered into PICSWeb) falls within the date range.

  • Expected End between dates will include any learners whose Expected End Date falls within the date range.

  • Leavers or Expected End between dates will include any learners whose Expected End Date or Actual End Date falls within the date range.

  • All will include all learners.

• Learners From and To – Here you can specify the date range that will determine which learners will have their contact hours included in the report. You can either choose a Fixed Date and choose the relevant dates from the calendar date selector, or choose one of the relative values such as Today, Start of Week, Start of Month or others. If you choose a relative value, it is possible to add a positive or negative Offset value, which will adjust the date by the specified number of weeks. For example, choosing End of Week with a +1 Weeks Offset value will run the report from the end of the next week.

• Episode Status – Here you can restrict the report to learners whose episodes are on a specific status at the time the report is run.

• Learner Status – Here you can restrict the report to contact hours for learners with specific statuses. Choosing a status from the drop-down menu will add it to the field. You can add multiple statuses to the field and remove any added ones by selecting the X icon.

• Learner Tags – Here you can restrict the report to contact hours for learners with specific Tags. Choosing a tag from the drop-down menu will add it to the field. You can add multiple tags to the field and remove any added ones by selecting the X icon. The following tag options are available:

  • Any – This will restrict the report to learners that have at least one of the specified tags.

  • All – This will restrict the report to learners that have every specified tag.

  • None – This will restrict the report to learners that do not have any of the specified tags.

• Sites – Here you can restrict the report to contact hours for learners linked to specific Sites. Choosing a site from the drop-down menu will add it to the field. You can add multiple sites to the field and remove any added ones by selecting the X icon.

• Qualification Plans – Here you can restrict the report to contact hours for learners with specific Qualification Plans linked. Choosing a plan from the drop-down menu will add it to the field. You can add multiple plans to the field and remove any added ones by selecting the X icon. The following plan options are available:

  • Any Of – This will restrict the report to learners that have at least one of the specified plans linked.

  • None Of – This will restrict the report to learners that do not have any of the specified plans linked.

  • Is Blank – This will restrict the report to learners with no plans linked.

  • Not Blank – This will restrict the report to learners with at least one plan linked.

• Contracts – Here you can restrict the report to contact hours for learners linked to specific Contracts. Choosing a contract from the drop-down menu will add it to the field. You can add multiple contracts to the field and remove any added ones by selecting the X icon. The following contract options are available:

  • Any Of – This will restrict the report to learners that have at least one of the specified contracts linked.

  • None Of – This will restrict the report to learners that do not have any of the specified contracts linked.

  • Is Blank – This will restrict the report to learners with no contracts linked.

  • Not Blank – This will restrict the report to learners with at least one contract linked.

• Programme – Here you can restrict the report to contact hours for learners enrolled on specific programmes. You can add multiple programmes to the field and remove any added ones by selecting the X icon.

• Funding Organisation – Here you can restrict the report to contact hours for learners funded by specific funding organisations. You can add multiple funding organisations to the field and remove any added ones by selecting the X icon.

• Officer – Here you can restrict the report to learners linked to a specific Officer via a specific Relationship.

• Officer Tags – Here you can restrict the report to learners linked to Officers with specific Tags.

• Organisation – Here you can restrict the report to learners linked to a specific Organisation via a specific Relationship.

• Past Expected End – If this is ticked, contact hours for learners that have passed their Expected End Date will be included.

Report Output

The learner contact and learning hours report consists of a single sheet listing all matching contact hour records. Along with the core learner details, any Optional Fields chosen when building the report will be included as additional columns.