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 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-185. 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-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-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-185. • 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. • Bob changes jobs between January 1st, 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 21) 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-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-091. 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-185HC- 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-185HC-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-185HC-091. • 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 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 Respondent Unit (RU), but this PRPL record does not link to any records on any other MEPS PUFs. • Bob Xxx changes jobs between January 1st, 2016 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 2110) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-040. 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 =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 =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-185Public 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-185HC-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-185HC- 040. • $ 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 other MEPS 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 other MEPS PUFs. • $ Bob changes jobs between January 1st, 2016 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 215) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-056. 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-185HC-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-185HC-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-185HC-056. • ▪ 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 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 Respondent Unit (RU), but this PRPL record does not link to any records on any other MEPS PUFs. • Bob ▪ Xxx changes jobs between January 1st, 2016 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 216) 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-185HC- 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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-063. 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 =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 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-185HC-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-185HC-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-185HC- 063. • 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 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 Respondent Unit (RU), but this PRPL record does not link to any records on any other MEPS PUFs. • Bob Xxx changes jobs between January 1st, 2016 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 217) 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-185HC- 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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-032. 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 =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 =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-185Public 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-185HC-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-185HC- 032. • $ 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 other MEPS 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 other MEPS PUFs. • $ Bob changes jobs between January 1st, 2016 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 214) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-185HC-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-185HC-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-185HC-124. • 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 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 Respondent Unit (RU), but this PRPL record does not link to any records on any other MEPS PUFs. • Bob Xxx changes jobs between January 1st, 2016 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 2114) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-133. 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-185HC-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-185HC-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-185HC-133. • 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 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 Respondent Unit (RU), but this PRPL record does not link to any records on any other MEPS PUFs. • Bob Xxx changes jobs between January 1st, 2016 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 2115) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-074. 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 '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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-185HC-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-185HC-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-185HC- 074. • 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 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 Respondent Unit (RU), but this PRPL record does not link to any records on any other MEPS PUFs. • Bob changes jobs between January 1st, 2016 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 21) 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-185HC- 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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-150. 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-185HC-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-185HC-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-185HC-150. • 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. • Bob changes jobs between January 1st, 2016 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 2117) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-108. 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 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-185HC-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-185HC-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-185HC-108. • 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 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 Respondent Unit (RU), but this PRPL record does not link to any records on any other MEPS PUFs. • Bob changes jobs between January 1st, 2016 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 2112) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-176. 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-185HC-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-185HC-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-185HC-176. • 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. • Bob changes jobs between January 1st, 2016 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 2120) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-158. 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-185HC-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-185HC-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-185HC-158. • 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. • Bob changes jobs between January 1st, 2016 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 2118) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement
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 61,495 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-185HC-166. 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 source of insurance, and each family member’s PRPL record links to that job record in PUF HC-185HC-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-185HC-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-185HC-166. • 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. • Bob changes jobs between January 1st, 2016 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 2119) 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-185HC-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.
Appears in 1 contract
Samples: Data Use Agreement