Tip: DOB/AGE





Number

0006

Submitting Entity (SE)

All

Add Date

Mar 1, 2019

Update Date

 

Update

 

Description

  1. The standard value delivered for data requests is age, calculated from a member’s date of birth. Data quality errors within SE systems can sometimes result in multiple dates of birth for the same carrier specific unique member ID (ME107, MC137, PC107, DC056). This could result in different age values for a member.

  2. The field ME014_ENROL_AGE is calculated using the member date of birth (ME014) and member enrollment date (ME162A). The ME014_ENROL_AGE value has been found to be negative on approximately 15,500 member records (3,987 members). Negative ages result when the member enrollment dates (ME162A) are earlier than the member date of birth. This anomaly is present among 17 submitting entities. This is a result of either data quality issues or children member records having the parent’s enrollment dates.  Less than 100 member records have a calculated age based on enrollment date that is over 125. Approximately half of these problematic records have date of birth data quality issues.

Active/Resolved

Active

Action / Resolution

Category 1

DOB

Category 2

Data Quality

Tip / Issue

Tip