Create SCC Eligibility download covering 3 annexes for legal exercises

nickaddy commented 4 months ago

Background

This ticket is connected with #2387, in which the Eligibility report display has been reconfigured to focus on specific areas of eligibility for legal exercises only, due to the fact that non-legal exercises are problematic thanks to the lack of distinction between statutory and ASC criteria, and reviews that are currently taking place. Hence, we aim to automate production of the following annexes for legal exercises only: Statutory eligibility criteria (Professional qualification and PQE), PJE and RLoS.

User Story

As an Admin, I would like to be able to download SCC Annex-ready eligibility annexes so that I can expedite production of the SCC paper.

Benefit(s) to user (if not already clear from User story)

Admins will be able to produce a Word download from the platform that covers some of the eligibility annexes required for the SCC report.

Feature(s) Description

[ ] The annexes described below should be produced as a single Word document download which is downloaded to user's desktop when you click the Download SCC Annex report button
[ ] Each section of the report should be preceded by a page break
[ ] The first section of the annex 'Candidates who do not meet the Statutory Eligibility Criteria' includes candidates who are 'Not met' for Professional qualification and/or Post-qualification experience sorted alphabetically by candidate surname
[ ] The content for the 'Reasons Statutory Eligibility Criteria is not satisfied' column is drawn from the 'Reasons not satisfied' field for Statutory eligibility criteria
[ ] The content for the next two sections is Candidate Previous Judicial Experience and plays back this section of the Eligibility report

[ ] It is split into 3 sections 'Recommended to proceed', 'Recommended to discuss', and 'Recommended to reject' according to the Recommendation selected from the dropdown in that section

[ ] The final section relates to Reasonable Length of Service and includes all candidates with a Not Met flag under RLoS ordered alphabetically by their surname
[ ] It is formatted as below

[ ] Column C returns candidates' ages at date that SCC is scheduled for (this has already been calculated by the platform to determine whether they meet the RLoS criteria or not)

Acceptance Criteria

It's done when for legal exercises only:

[ ] Users can trigger a download to their desktop based on the criteria described above
[ ] Each section starts on a fresh page
[ ] Each section is ordered alphabetically by candidates' surnames
[ ] Each section is formatted according to the images presented
[ ] Each section included the content as described
[ ] The PJE section is split into Proceed, Discuss and Reject sub-sections

Definition of Done

[ ] User stories/acceptance criteria met
[ ] Internal reviews passed (feedback actioned)
[ ] User testing passed
[ ] Relevant technical documentation updated
[ ] User guidance updated
[ ] Deployed and merged without errors

User Testing Steps

This feature is designed to automate as much of the production and formatting of the eligibility report as possible for legal exercises. Does the functionality deliver what is required to produce the annexes covering: 1) statutory eligibility criteria, 2) PJE and 3) Reasonable length of service?

Feature Champion

Nick

nickaddy commented 4 months ago

Hey team! Please add your planning poker estimate with Zenhub @drieJAC @HalcyonJAC @KoWeiJAC @tomlovesgithub @warrensearle

KoWeiJAC commented 4 months ago

@nickaddy I'm not very sure about these 2 places, could you help me to confirm them ? Thanks

Is ok that we use number (1, 2, 3 ...) for represent years in this place? Currently, it seems that we don't have functions for convert numbers to words (1 -> one, 2 -> two). And if we use same format for the same field, it may be more consistent.
Is this field the age of candidate at Character and selection SCC date? I've found a logic in our existing code, but not sure if it is the right one.

nickaddy commented 4 months ago

@KoWeiJAC 1) Let's go with the digits (3,4,5) initially and hope that is acceptable, 2) Yes, that's correct :-)

nickaddy commented 4 months ago

Thx @HalcyonJAC - this appears to work well. Can you pls set up say 5 exercises that can be used independently at UT tomorrow (this has not been UT'd yet?) Unless we can use those exercises that you set up previously for the character annex download?

nickaddy commented 4 months ago

@HalcyonJAC This failed UT yesterday with the following responses from users: 'Couldn't download - network issue.' See screenshot. It worked fine for me, but multiple users experienced the issue. Can you pls test with @Franceswog who also experienced the issue above?

jac-uk / admin