Skip to content Learn about the access keys available for Metadata Registry

Client: Date of birth, Month 0.1

Definition

The client's month of birth.

Components

Data Element (this item)
Client: Date of birth, Month

Representation

This representation is based on the value domain for this data element, more information is available at " Month 0.1 ".
Data Type Date/Time
Format M[M]
Maximum character length 2
Values
Value Meaning Start Date End Date
Permissible Values 1 January
2 February
3 March
4 April
5 May
6 June
7 July
8 August
9 September
10 October
11 November
12 December

Comments

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

Related content

Relation Count
Input in Derivations 0
Output in Derivations 0
Inclusion in Data Set Specifications 0
Inclusion in Data Distributions 3
As a numerator in an Indicator 0
As a denominator in an Indicator 0
As a disaggregation in an Indicator 0