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

1 stars 1 forks source link

Error code 2886Q [Amended 2024 v1.0] #469

Closed SLornieCYC closed 7 months ago

SLornieCYC commented 9 months ago

Note: Rule previously implemented from issue #3 but rule has been amended in updated guidance. Changes highlighted with bold and strikethrough. Cannot be implemented before #468.

Error information

Error code

2886Q

Module

Return level validation

Message

Please check and either amend data or provide a reason: Percentage of children with no gender sex recorded is more than 2% (excluding unborns)

Validation check

The sum of:

the number of child records where <GenderCurrent> (N00065) <Sex> (N00783), is equal to U or missing, and the (N00098) is equal to missing, divided by the total number of child records should be less than or equal to 0.02. Validation should be triggered at LA level.

For further info, refer to the DfE validation document here