...

The Learner Claim History Report produces a list

...

of funding claim items per learner over a specified period of time.

...

Report Options

...

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

  • In learning between dates

 will

• •  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 claims included in the report. You can either choose a Fixed Date

 and

•  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

•  or others. If you choose a relative value, it is possible to add a positive or negative Offset

 value

•  value, which will adjust the date by the specified number of weeks. For example, choosing End of Week

 with

•  with a +1 Weeks Offset

 value

•  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.

• Claims From and To – This date range controls which claims will be included for the learners included in the report. Setting this date range up works in the same way as the learner date range explained above.

• Show employer earned payments instead of PMR based claims – This setting controls which employer claim items are shown in the report.

   If

   If the option is ticked, the report will show claim items for Employer Earned payments. If it is unticked, the report will show claim items for the Actual Employer payments, based on the PMRs recorded for the relevant learners.

   

• Exclude FM36 Employer Incentives – If this is ticked, any Employer Incentive claims for FM36 programmes will not be included in the report.

• Distribute FM25 Totals by Period – If this is ticked, the annual total for FM25 claims will be divided into different funding periods.

• Learner Status – Here you can restrict the report to claims 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 claims for learners with

  specific 

  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

   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.

• Site –

  Sites – Here you can restrict the report to claims for learners linked to specific Sites. Choosing a

  specific Site.Qualification Plan –

  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 claim items 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

  claims

  claim items for learners linked to

  a specific Qualification Plan.Contract 

  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 claims 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 claims 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

   Contract

  Officer via a specific Relationship.

• Consortium 

  Officer Tags – Here you can restrict the report to

  claims for

  learners linked to

  a

  Officers with specific

   consortium

  Tags.

  Programme 

• Organisation – Here you can restrict the report to

  claims for learners enrolled on

  learners linked to a specific Organisation via a specific

   programme

  Relationship.

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

• On Break-in-Learning – If this is ticked, claims for learners that are marked as on a Break in Learning will be included.

• Learner

  Subcontractor

  Export Status – Here you can restrict the learners included in the report according to their Export Status.

• Learner Subcontracted Status – Here you can restrict the learners included in the report according to their Subcontractor arrangements. The following options are available:

  • All Learners – This will include claims for learners who are both taught directly and through subcontractors.

  • Non-subcontracted Learners – This will only include claims for learners that are taught directly.

  • All Subcontracted Learners – This will only include claims for learners that are taught through subcontractors.

  • Only for Specified Subcontractor – This will only include claims for learners taught through a specific subcontractor organisation. You can specify which organisation using the Subcontractor field below.

• Subcontractor – If you have set the Learner Subcontractor Status to Only for Specified Subcontractor, you can specify the Subcontractor Organisation from the drop-down menu.

• Calculation Basis – Here you can choose whether to use ESFA Rates to calculate claim values or to apply any relevant Subcontractor Rates that you have recorded in

  PICSWeb 

  PICSWeb

Report Output

The claim history report consists of a single sheet listing all included claims. Along with some learner details and claim details, any any Optional Fields chosen  chosen when building the report will be included as additional columns. 

Image Removed

...