data-to-insight / csc-validator-be-903

Python-side code for the Quality LAC Data Beta frontend
https://903.datatoinsight.org
MIT License
8 stars 4 forks source link

Error code SW11aSTG2 [Added 2023 v1.2] #781

Open SLornieCYC opened 5 months ago

SLornieCYC commented 5 months ago

Note: This rule was added by DFE in the 2023/24 v1.2 validation check document. It replaces rule SW11STG2 (#679)

Error information

Error code

SW11aSTG2

Description to display

Social worker episode has ended and no subsequent social worker episode has been provided.

DfE Long-form description of error

The social worker episode has ended. All social worker episodes should be provided for the time period 1 April previous year to 31 March of the current year for a child looked after on 31 March, including periods when the child was no longer looked after if they still had a social worker, Missing social worker episodes should be added.

DfE suggested coding

If <SW_DEC> < (<COLLECTION_END_DATE> - 5 days) then next social worker episode <SW_DECOM> must be present and must be = (previous <SW_DEC> +/- 5 days)

For further info, refer to the DfE validation document here