Common use of Complex File Structure with Examples Clause in Contracts

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 57,710 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-166. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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. No Private 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. Sources of Insurance: Employers and Other Establishments • 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob changes jobs between January 1st, 2014 and the date of his MEPS interview, and both jobs provide health insurance. In this case, Bob has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob on the interview date. • Xxxxx quits her job in Round 1 (Panel 19) but pays her previous employer to continue her health insurance while she looks for another job in Round 2. In this case, Xxxxx’s Round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166. Xxxxx’s Round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round 1. Thus, the job variables from Round 1 are no longer current in Round 2, but the link exists for users.

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 57,710 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-166HC-124. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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. No Private 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. Sources of Insurance: Employers and Other Establishments • 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-124. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-124. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC-124. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased former husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased former husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Respondent Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob Xxx changes jobs between January 1st, 2014 2009 and the date of his MEPS interview, and both jobs provide health insurance. In this case, Bob Xxx has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob Xxx on the interview date. • Xxxxx quits her job in Round 1 (Panel 1914) but pays her previous employer to continue her health insurance while she looks for another job in Round 2. In this case, Xxxxx’s Round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC-124. Xxxxx’s Round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round 1. Thus, the job jobs variables from Round 1 are no longer current in Round 2, but the link exists for users.

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 57,710 71,790 total records. The PRPL file contains records for persons insured through establishments providing hospital/physician, Medigapmedigap, 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 the one job record in HC-166HC-056. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • ▪ 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. No Private 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. Sources of Insurance: Employers and Other Establishments • ▪ 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-056. • ▪ Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-056. • ▪ Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC-056. Policyholders Not in the Household • ▪ Xxxxx is a widow and has retiree insurance from her deceased former husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased former husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • ▪ Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Respondent Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob ▪ Xxx changes jobs between January 1st, 2014 2001 and the date of his MEPS interview, and both jobs provide provided health insurance. In this case, Bob Xxx has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob Xxx on the interview date. • ▪ Xxxxx quits her job in Round round 1 (Panel 196) but pays her previous employer to continue her health insurance while she looks for another job in Round round 2. In this case, Xxxxx’s Round round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC- 056. Xxxxx’s Round round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round round 1. Thus, the job jobs variables from Round round 1 are no longer current in Round round 2, but the link exists for users.

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 57,710 61,436 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-166HC-176. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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. No Private 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. Sources of Insurance: Employers and Other Establishments • 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-176. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-176. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC-176. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any other MEPS PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Unit (RU), but this PRPL record does not link to any records on any other MEPS PUFs. Changes in Insurance • Bob changes jobs between January 1st, 2014 2015 and the date of his MEPS interview, and both jobs provide health insurance. In this case, Bob has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob on the interview date. • Xxxxx quits her job in Round 1 (Panel 1920) but pays her previous employer to continue her health insurance while she looks for another job in Round 2. In this case, Xxxxx’s Round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC-176. Xxxxx’s Round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round 1. Thus, the job variables from Round 1 are no longer current in Round 2, but the link exists for users.

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 57,710 62,736 total records. The PRPL file contains records for persons insured through establishments providing hospital/physician, Medigapmedigap, 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 the one job record in HC-166HC-074. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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 '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. No Private 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. Sources of Insurance: Employers and Other Establishments • 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-074. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-074. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC- 074. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased former husband’s 's former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased former husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Respondent Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob changes jobs between January 1st, 2014 2003 and the date of his MEPS interview, and both jobs provide provided health insurance. In this case, Bob has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob on the interview date. • Xxxxx quits her job in Round round 1 (Panel 19) 8) but pays her previous employer to continue her health insurance while she looks for another job in Round round 2. In this case, Xxxxx’s Round ’ round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC- 074. Xxxxx’s Round round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round round 1. Thus, the job jobs variables from Round round 1 are no longer current in Round round 2, but the link exists for users.

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 57,710 55,500 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-166HC-133. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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. No Private 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. Sources of Insurance: Employers and Other Establishments • 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-133. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-133. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC-133. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased former husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased former husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Respondent Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob Xxx changes jobs between January 1st, 2014 2010 and the date of his MEPS interview, and both jobs provide health insurance. In this case, Bob Xxx has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob Xxx on the interview date. • Xxxxx quits her job in Round 1 (Panel 1915) but pays her previous employer to continue her health insurance while she looks for another job in Round 2. In this case, Xxxxx’s Round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC-133. Xxxxx’s Round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round 1. Thus, the job jobs variables from Round 1 are no longer current in Round 2, but the link exists for users.

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 57,710 54,736 total records. The PRPL file contains records for persons insured through establishments providing hospital/physician, Medigapmedigap, dental, vision, prescription medication, or prescription medication long-term care 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 =s current main job and links to the one job record in HC-166HC-032. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • $ 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 =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. No Private 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. Sources of Insurance: Employers and Other Establishments • $ Xxxxxx is an employed parent with family coverage through his current main job. In this case, each family member’s =s PRPL record flags Xxxxxx’s Dexter=s current main job as the source of insurance, and each family member’s =s PRPL record links to that job record in PUF HC-166Public Use File (PUF) HC-032. • $ Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s =s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-032. • $ Xxxx has hospital/physician insurance through his employer, and he buys dental long-term care insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC- 032. Policyholders Not in the Household • $ Xxxxx is a widow and has retiree insurance from her deceased former husband’s =s former job. In this case, Xxxxx’s =s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased =s former husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • $ Xxxxxxx’s =s parents are divorced. She lives with her father, but her insurance is through her mother’s =s job. In this case, Xxxxxxx’s =s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s =s mother, where she is flagged as the policyholder and not residing in the Reporting Respondent Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • $ Bob changes jobs between January 1st, 2014 1999 and the date of his MEPS interview, and both jobs provide provided health insurance. In this case, Bob has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob on the interview date. • $ Xxxxx quits her job in Round round 1 (Panel 194) but pays her previous employer to continue her health insurance while she looks for another job in Round round 2. In this case, Xxxxx’s Round Xxxx=s round 1 PRPL record flags her current main job as the source of her his insurance and links to a job record in PUF HC-166HC-032. Xxxxx’s Round =s round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round round 1. Thus, the job jobs variables from Round round 1 are no longer current in Round round 2, but the link exists for users.

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 57,710 58,947 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-166HC-158. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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. No Private 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. Sources of Insurance: Employers and Other Establishments • 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-158. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-158. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC-158. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob changes jobs between January 1st, 2014 2013 and the date of his MEPS interview, and both jobs provide health insurance. In this case, Bob has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob on the interview date. • Xxxxx quits her job in Round 1 (Panel 1918) but pays her previous employer to continue her health insurance while she looks for another job in Round 2. In this case, Xxxxx’s Round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC-158. Xxxxx’s Round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round 1. Thus, the job variables from Round 1 are no longer current in Round 2, but the link exists for users.

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 57,710 61,495 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-166HC-185. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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. No Private 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. Sources of Insurance: Employers and Other Establishments • 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-185. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-185. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC-185. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any other MEPS PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Unit (RU), but this PRPL record does not link to any records on any other MEPS PUFs. Changes in Insurance • Bob changes jobs between January 1st, 2014 2016 and the date of his MEPS interview, and both jobs provide health insurance. In this case, Bob has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob on the interview date. • Xxxxx quits her job in Round 1 (Panel 1921) but pays her previous employer to continue her health insurance while she looks for another job in Round 2. In this case, Xxxxx’s Round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC-185. Xxxxx’s Round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round 1. Thus, the job variables from Round 1 are no longer current in Round 2, but the link exists for users.

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 57,710 63,361 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-166HC-150. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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. No Private 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. Sources of Insurance: Employers and Other Establishments • 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-150. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-150. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC-150. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob changes jobs between January 1st, 2014 2012 and the date of his MEPS interview, and both jobs provide health insurance. In this case, Bob has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob on the interview date. • Xxxxx quits her job in Round 1 (Panel 1917) but pays her previous employer to continue her health insurance while she looks for another job in Round 2. In this case, Xxxxx’s Round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC-150. Xxxxx’s Round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round 1. Thus, the job jobs variables from Round 1 are no longer current in Round 2, but the link exists for users.

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 57,710 61,514 total records. The PRPL file contains records for persons insured through establishments providing hospital/physician, Medigapmedigap, 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-166HC-091. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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. No Private 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. Sources of Insurance: Employers and Other Establishments • 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC- 091. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-091. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC-091. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased former husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased former husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Respondent Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob Xxx changes jobs between January 1st, 2014 2005 and the date of his MEPS interview, and both jobs provide provided health insurance. In this case, Bob Xxx has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob Xxx on the interview date. • Xxxxx quits her job in Round 1 (Panel 1910) but pays her previous employer to continue her health insurance while she looks for another job in Round 2. In this case, Xxxxx’s Round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC-091. Xxxxx’s Round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round 1. Thus, the job jobs variables from Round 1 are no longer current in Round 2, but the link exists for users.

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 57,710 78,004 total records. The PRPL file contains records for persons insured through establishments providing hospital/physician, Medigapmedigap, 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 the one job record in HC-166HC-063. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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 =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. No Private 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. Sources of Insurance: Employers and Other Establishments • Xxxxxx Dexter 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-063. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-063. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC- 063. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased former husband’s =s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased former husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Respondent Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob Xxx changes jobs between January 1st, 2014 2002 and the date of his MEPS interview, and both jobs provide provided health insurance. In this case, Bob Xxx has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob Xxx on the interview date. • Xxxxx quits her job in Round round 1 (Panel 197) but pays her previous employer to continue her health insurance while she looks for another job in Round round 2. In this case, Xxxxx’s Round ’ round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC- 063. Xxxxx’s Round round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round round 1. Thus, the job jobs variables from Round round 1 are no longer current in Round round 2, but the link exists for users.

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 57,710 54,427 total records. The PRPL file contains records for persons insured through establishments providing hospital/physician, Medigapmedigap, dental, vision, prescription medication, or prescription medication long-term care 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 =s current main job and links to the one job record in HC-166HC-040. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • $ 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 =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. No Private 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. Sources of Insurance: Employers and Other Establishments • $ Xxxxxx is an employed parent with family coverage through his current main job. In this case, each family member’s =s PRPL record flags Xxxxxx’s Dexter=s current main job as the source of insurance, and each family member’s =s PRPL record links to that job record in PUF HC-166Public Use File (PUF) HC-040. • $ Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s =s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-040. • $ Xxxx has hospital/physician insurance through his employer, and he buys dental long-term care insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC- 040. Policyholders Not in the Household • $ Xxxxx is a widow and has retiree insurance from her deceased former husband’s =s former job. In this case, Xxxxx’s =s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased =s former husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • $ Xxxxxxx’s =s parents are divorced. She lives with her father, but her insurance is through her mother’s =s job. In this case, Xxxxxxx’s =s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s =s mother, where she is flagged as the policyholder and not residing in the Reporting Respondent Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • $ Bob changes jobs between January 1st, 2014 2000 and the date of his MEPS interview, and both jobs provide provided health insurance. In this case, Bob has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob on the interview date. • $ Xxxxx quits her job in Round round 1 (Panel 195) but pays her previous employer to continue her health insurance while she looks for another job in Round round 2. In this case, Xxxxx’s Round Xxxx=s round 1 PRPL record flags her current main job as the source of her his insurance and links to a job record in PUF HC-166HC-040. Xxxxx’s Round =s round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round round 1. Thus, the job jobs variables from Round round 1 are no longer current in Round round 2, but the link exists for users.

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 57,710 56,214 total records. The PRPL file contains records for persons insured through establishments providing hospital/physician, Medigapmedigap, 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-166HC-108. However, other cases are more complex, and some hypothetical examples follow. Multiple Establishments • 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. No Private 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. Sources of Insurance: Employers and Other Establishments • Xxxxxx Dexter 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-166HC-108. • Xxxxxx is employed, but she does not have insurance through her job. Instead she buys a plan directly from an HMO. In this case, Xxxxxx’s PRPL records do not flag her current main job, nor do they link to any job records in PUF HC-166HC-108. • Xxxx has hospital/physician insurance through his employer, and he buys dental insurance through an insurance agent. In this case, Xxxx has two PRPL records, and only the employment-based insurance flags his current main job and links to a job record in PUF HC-166HC-108. Policyholders Not in the Household • Xxxxx is a widow and has retiree insurance from her deceased former husband’s former job. In this case, Xxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxx’s deceased former husband, where he is flagged as the policyholder and flagged as deceased, but this record does not link to any records on any PUFs. • Xxxxxxx’s parents are divorced. She lives with her father, but her insurance is through her mother’s job. In this case, Xxxxxxx’s PRPL record does not link to any employment information in the MEPS. There is also a PRPL record for Xxxxxxx’s mother, where she is flagged as the policyholder and not residing in the Reporting Respondent Unit (RU), but this PRPL record does not link to any records on any PUFs. Changes in Insurance • Bob changes jobs between January 1st, 2014 2007 and the date of his MEPS interview, and both jobs provide provided health insurance. In this case, Bob has two PRPL records for the round. EVALCOVR shows whether one or both plans covered Bob on the interview date. • Xxxxx quits her job in Round 1 (Panel 1912) but pays her previous employer to continue her health insurance while she looks for another job in Round 2. In this case, Xxxxx’s Round 1 PRPL record flags her current main job as the source of her insurance and links to a job record in PUF HC-166HC-108. Xxxxx’s Round 2 PRPL record does not flag her current main job as the source of her insurance, but it links to the same job record from Round 1. Thus, the job jobs variables from Round 1 are no longer current in Round 2, but the link exists for users.