Client: Date of birth, Month V1

Null where BirthDateEstimated = 1. Where BirthDateEstimated = 1 (TRUE), Service Providers have entered the year of month only - and date of birth is recorded as 1 January within the DEX database. Where providers record full date of birth rather than choosing to record an estimated date of birth, we still do observe large counts of values such as 1 Jan 1900 recorded for example – although full date has been recorded, further judgement to determine data quality of such records might be considered. This practice varies by service provider, service delivery method and by activity

BirthMonth = CASE when client.BirthDateEstimated = 0 then DATEPART(MONTH, client.BirthDate) else NULL END