Documentation
Common Data Model (CDM)
Convert Database to CDM (ETL)
Tool Specific Documentation
Common Data Model (CDM)
Convert Database to CDM (ETL)
Tool Specific Documentation
Add the attribute to the payer plan period table to indicate if a person is likely to have prescription drug records for this period of time. Create a new payer plan period record when a person’s drug benefit status changes. Claims data often provides such an indicator, although it is not clear if the lack of drug benefits is because they are not included in a person's health insurance plan or if the plan does not report drug benefit information to the data provider. EMR data also may or may not include prescription drug information. The fact that prescription drug records are not likely to be available is an important piece of information. Possible values are Y/N/NULL.
Note - in V3 we did discuss at length modeling benefits. Complicated but important topic for causal inference
Add this column to Payer Plan Period Table
Column name | Required | Data type | Description |
---|---|---|---|
Rx_benefit | No | char(1) | Y/N/NULL Indicates if person's prescription information likely to be recorded in drug exposure table |