User profile for Richard Phipps

This might be related to the known issues with 23A-216 bringing up learners who have met the 20% OTJ requirement (which I reported to ESFA in January) but are coming up on the report incorrectly as...

Richard Phipps commented, 14 April 2023 09:42

I've just uploaded a new annotation file, and then a return and checked the subsequent return, and for us the 23A-105, 23A-210, and 23A-211 all have data in them. With regards to the annotations it's still a bit broken, it copies them over but it's never copied over any annotations on 23B-002, and on some reports like 23Y-207 it doesn't copy over all annotations. For that reason I use my own tool built in an excel spreadsheet to deal with formatting and copying as I can't reply on the DSATS functionalist currently. If anyone else is struggling with annotations and would like to use it just email me at richard.phipps@loucoll.ac.uk and I can send it over. Here are the details: This DSATS helper tool is used to improve the ease of working on DSAT reports regularly. It can be used to format an existing DSAT report file to make it easier to use, or to both format and copy annotations from an older report file (as was present in version 16 or below). Formatting • In version 17 there is a new 'Contents' sheet which has a list of DSAT reports which are hyperlinked, but the sheet has no details of what the report does or the logic being used. There is also a B-001 sheet which lists all the information about the reports (as was present in version 16 reports), but unfortunately with no hyperlinks. This tool will combine the two by deleting the new Contents page, rename the B-001 page to Contents and turn all of the report titles into hyperlinks. This keeps the very useful hyperlinks with all the information on the reports on one page. • Each report will have a User Annotations column added with cell borders put in place for every line of data if this column is not already present. • A blank count formula will be set up for each report so that the number of blank user annotation rows will be visible from the new Contents page. This is useful if all the rows in the report were previously annotated as once the old annotations are copied into a new report any blank user annotation cells are probably new data. • An old User Annotations column and Old record count are setup on the Contents sheet, and used when copying annotations so that the old annotations for each report can be seen. • Each report tab is coloured according to the fill colour used in the 'User Annotations' column on the Contents page. This helps when using colour coding of report comments. • A 'Back to Contents' link is added on each report to go back to the Contents page Copying • When two ILR/FIS DSAT report files are open, the date stored in the names of the files is used to determine which is the oldest and newest DSAT report files, rather than the date the file was last modified. • The user annotations on the Contents sheet in the old report file are copied to the Old User Annotations column in the new report file, as are the old report counts. In addition the colour formatting is copied for when colour coding has been used. • For each report the comments on the old reports file are copied into the new report file. The colour that was used as the fill in the old user annotations cell is applied to the entire row (which helps make it easier if people use colour coding for DSAT user annotations) It can take a while to complete the formatting and copying with large reports with a lot of data Disclaimer Always use on a copy of the DSATS report files - USE AT YOUR OWN RISK!

PDSAT - R08

I've just uploaded a new annotation file, and then a return and checked the subsequent return, and for us the 23A-105, 23A-210, and 23A-211 all have data in them. With regards to the annotations it...

Richard Phipps commented, 11 April 2023 08:53

If the learner was present in the ILR for the R14 in the previous academic year then we follow this Provider Support Manual Guidance: Learners reported in the previous year as continuing who have now been identified as withdrawn On the learning aim, set the Completion status to code 3 ‘withdrawn’ and complete the Withdrawal reason field with the relevant code. Record the Learning actual end date as the last day the learner was in learning: this will be in the previous ILR year, do not use 1 August of the current year. You must add a Destination and Progression record for this learner if applicable. For learners who never attended we put them in just for one day to close off their record.. I know they are treated as withdrawn in the QaR stats, but otherwise they set these as continuing in one year and nothing in the subsequent years which is confusing.

Removing learning aims with one day from ILR?

If the learner was present in the ILR for the R14 in the previous academic year then we follow this Provider Support Manual Guidance: Learners reported in the previous year as continuing who have n...

Richard Phipps commented, 20 March 2023 11:24

Thanks Ben!

Pdsat dashboard - website down?

Thanks Ben!

Richard Phipps commented, 24 February 2023 12:10

No response yet either. I chased up last week, but no reply.

23A-216 Actual OTJ Training Hours

No response yet either. I chased up last week, but no reply.

Richard Phipps

Last activity

Member since

Votes

Subscriptions

Replies

Becka, You are welcome, glad you sorted it :) Richard

Hi Henry, I can't yet see a FIS 2324 version available on the downloads page. Is it still planned to be available today? Thanks, Richard

Doing this for us too..

But not on Category codes 46 or 49, so you think they have just checked for other category end dates by error?

This might be related to the known issues with 23A-216 bringing up learners who have met the 20% OTJ requirement (which I reported to ESFA in January) but are coming up on the report incorrectly as not meeting it.

Thanks Ben!

No response yet either. I chased up last week, but no reply.