Complex File Structure with Examples. The PRPL file is designed to reflect the sometimes complex and dynamic relationships between people and their private insurance. It allows maximum flexibility for researchers, but it also requires that they make analytical decisions in their research. The PRPL file is a person-round-policyholder-establishment-level file. There is one unique record for each unique combination of establishment (source of private insurance), policyholder, interview round, and covered person (policyholder or dependent). Thus, the PRPL file contains at least one record for each person in each round with private health insurance, or 63,494 total records. The PRPL file contains records for persons insured through establishments providing hospital/physician, Medigap, dental, vision, or prescription medication coverage. In most cases in this file, one person in the family has insurance from his or her employer, and this insurance covers everyone in the family. In this case, there is one record for each family member in each round, and each record flags the policyholder’s current main job and links to one job record in HC-124. However, other cases are more complex, and some hypothetical examples follow. • Xxxx and Xxxxx are both employed parents, both have health insurance through their employers, and both parents choose family coverage. In this case, there are two PRPL records for each family member in each round. • Xxxx and Xxxx are both employed parents. Xxxx has single coverage from his employer. Xxxx has family coverage from her employer. In this case, Xxxx and the children each have one PRPL record for each round. Xxxx has two records for each round. • Xxxxx has Medicare and Medicare supplemental insurance. In this case, Xxxxx has one PRPL record in each round for the Medicare supplemental insurance. There is no record for Medicare, because it is public insurance. • Xxxxxx is a child living with her mother. Both have Medicaid. Xxxxxx’s father, who does not live with them, has private insurance that covers Xxxxxx. Xxxxxx has one PRPL record in each round for the private insurance. There is no record for Medicaid, because it is public insurance. • Xxxx is uninsured. In this case, Xxxx does not have any PRPL records. • Xxxx has Medicaid instead of private coverage. In this xxxx, Xxxx does not have any PRPL records. • Xxxxxx is an employed parent with family coverage through his current main job. In this case, each family member’s PRPL record flags Xxxxxx’s current main job as the...
