Table name: PERSON
Key conventions
- The ENROLLMENT_DETAIL table stores multiple records for each person, one for each month they are enrolled in a health plan. However, the CDM will only store one record per person in the PERSON table.
- Only records where the person has prescription benefits (RX=1) are used.
- Start by evaluating all ENROLLMENT_DETAIL records and remove the following persons:
- Individuals with two different, valid sex values (1 or 2) over different ENROLLMENT_DETAIL records
- Individuals with max(DOBYR) > min(DOBYR) +2
- After defining persons to remove, then use the most recent record in ENROLLMENT_DETAIL to define demographic information in the CDM for the remaining persons
- After finding the latest record per person, delete the following:
- Individuals whose DOBYR < 1900 or > the current year.
- Individuals born > 1 year after their first enrollment period.
- For MONTH_OF_BIRTH, the OBSERVATION_PERIOD table will need to be generated first. Then, the value can be derived from using YEAR_OF_BIRTH and OBSERVATION_PERIOD_START_DATE only if the year of birth is equal to the year of the first OBSERVATION_PERIOD_START_DATE.
Reading from ENROLLMENT_DETAIL
| Destination Field | Source field | Logic | Comment field |
|---|---|---|---|
| PERSON_ID | ENROLID | - | - |
| GENDER_CONCEPT_ID | SEX | Map source values to their associated CONCEPT_IDs: 1 - 8507 2 - 8532 If SEX is not 1 or 2 exclude that person. | The exclusion of a person by gender should happen on last enrollment record not just if they had one bad SEX record. CONCEPT_IDs: 8507 = ‘Male’ 8532 = ‘Female’ |
| YEAR_OF_BIRTH | DOBYR | DOBYR needs to be > 1900 and <= current year. If the DOBYR does not meet this criteria, drop the person. | - |
| MONTH_OF_BIRTH | DOBYR | If PERSON.YEAR_OF_BIRTH = MIN(YEAR(OBSERVATION_PERIOD_START_DATE)), then PERSON.MONTH_OF_BIRTH = MONTH(OBSERVATION_PERIOD_START_DATE) ) | Make sure to have Observation Periods generated before coming to this. |
| DAY_OF_BIRTH | - | NULL | - |
| BIRTH_DATETIME | - | NULL | - |
| RACE_CONCEPT_ID | - | 0 | - |
| ETHNICITY_CONCEPT_ID | - | 0 | - |
| LOCATION_ID | EGEOLOC | Map EGEOLOC to LOCATION_SOURCE_VALUE in LOCATION table, then extract its associated LOCATION_ID | |
| PROVIDER_ID | - | NULL | - |
| CARE_SITE_ID | - | NULL | - |
| PERSON_SOURCE_VALUE | ENROLID | - | - |
| GENDER_SOURCE_VALUE | SEX | - | - |
| GENDER_SOURCE_CONCEPT_ID | - | 0 | - |
| RACE_SOURCE_VALUE | - | NULL | - |
| RACE_SOURCE_CONCEPT_ID | - | 0 | - |
| ETHNICITY_SOURCE_VALUE | - | NULL | - |
| ETHNICITY_SOURCE_CONCEPT_ID | - | 0 | - |