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 | |||
| payer_plan_period_end_date | |||
| payer_concept_id | |||
| payer_source_value | |||
| payer_source_concept_id | |||
| 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 |