This query will flag up for any ongoing absence that is not registered as maternity.
The census does not pick up end dates in the future so this will still flag up even if you have entered an end date from a doctor's note, for example.
Just annotate the query when you upload your census to COLLECT to explain that the absence is ongoing.