CDM Table name: PAYER_PLAN_PERIOD
The enrollment table has a new field ‘family_id’. This can be used to link persons of the same family together. For every record in the enrollment table, a new record in the payer_plan_period must be created, using the member_id to populate the person_id field (as usual), and the family_id to populate the payer_plan_period_id (after removing the leading “M” to turn the family_id into an integer). The source value of family_id should go into the family_source_value field of the payer_plan_period table.
Reading from JMDC.Enrollment
| Destination Field | Source Field | Logic | Comment |
|---|---|---|---|
| payer_plan_period_id | family_id | use the family_id by removing the “M” and convert into an integer | |
| person_id | member_id | ||
| payer_plan_period_start_date | observation_start | ||
| payer_plan_period_end_date | observation_end | ||
| payer_concept_id | type_of_insurance | Map using the following logic: 4 (National health insurance scheme) = 32725(National Health Insurance Program) </br> 1 (Association/union administered health insurance) = 0 </br> 2 (Mutual aid association insurance) = 0 </br> 5 (Advanced elderly medical service system) = 0 </br> | |
| payer_source_value | type_of_insurance | ||
| payer_source_concept_id | 0 | ||
| plan_concept_id | |||
| plan_source_value | |||
| plan_source_concept_id | |||
| sponsor_concept_id | |||
| sponsor_source_value | |||
| sponsor_source_concept_id | |||
| family_source_value | family_id | ||
| stop_reason_concept_id | |||
| stop_reason_source_value | |||
| stop_reason_source_concept_id |
Change Log
March 7, 2025
- Update logic to map type_of_insurance and add in payer start/end dates