text: TRUNCATE TABLE mdcd_native_test.drug_claims;
  TRUNCATE TABLE mdcd_native_test.enrollment_detail;
  TRUNCATE TABLE mdcd_native_test.enrollment_summary;
  TRUNCATE TABLE mdcd_native_test.facility_header;
  TRUNCATE TABLE mdcd_native_test.inpatient_admissions;
  TRUNCATE TABLE mdcd_native_test.inpatient_services;
  TRUNCATE TABLE mdcd_native_test.long_term_care;
  TRUNCATE TABLE mdcd_native_test.outpatient_services;
  -- 1: Patient has two different primary diagnoses between inpatient_services and inpatient_admissions, the inpatient_admissions PDX is used. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '1', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '2', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '9', '1', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', '2500', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-09', '20226', '2012-08-12', '10', '2012');
  INSERT INTO mdcd_native_test.inpatient_admissions(admdate, admtyp, boe, cap, caseid, days, disdate, dobyr, drg, drugcovg, dstatus, dx1, dx2, dxver, enrolid, hospnet, hosppay, mas, mdc, medicare, mhsacovg, pddate, pdx, physnet, physpay, plantyp, poadx12, poadx13, poadx14, poadx15, seqnum, sex, stdrace, totcob, totcoins, totcopay, totded, totnet, totpay, version, year) VALUES ('2012-01-01', '3', '5', '0', '2', '2', '2012-12-31', '2015', '795', '1', '01', 'V3000  ', '25000  ', '9', '1', '0.0', '0.0', '9', '14', '0', '1', '2015-09-29', '0092', '0.0', '0.0', '2', '1', '1', '1', '1', '366313', '2', '1', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '10', '2012');
  -- 3: Patient has the same diagnosis code in outpatient_services and facility_header but in different positions, outpatient_services dx is prioritized. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '3', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(dx1, dxver, enrolid, fachdid, svcdate, tsvcdat) VALUES ('1024', '9', '3', '4', '2012-10-16', '2012-10-16');
  INSERT INTO mdcd_native_test.facility_header(billtyp, boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dstatus, dx1, dx9, dxver, enrolid, fachdid, mas, mdc, medicare, mhsacovg, netpay, pddate, plantyp, proc3, proc4, proc5, proc6, seqnum, sex, stdplac, stdprov, stdrace, svcdate, tsvcdat, version, year) VALUES ('131', '2', '0', '0.0', '0.0', '0.0', '0.0', '1988', '1', '01', 'V221   ', '1024', '9', '3', '4', '9', '23', '0', '1', '0.0', '2013-07-12', '2', '734', '9904', '9904', '9672', '5521242', '2', '22', '1', '1', '2012-10-16', '2012-10-16', '10', '2015');
  -- 5: Patient has diagnosis in dx4 field in inpatient_services, condition_type_concept_id = 38000187. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '5', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dx4, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '57411', '9', '5', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-07-23', '20226', '2012-07-23', '10', '2014');
  -- 7: Patient has diagnosis in dx9 field in facility_header, condition_type_concept_id = 38000208. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '7', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, fachdid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2012-07-23', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '7', '8', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-07-23', '20226', '2012-07-23', '10', '2012');
  INSERT INTO mdcd_native_test.facility_header(billtyp, boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dstatus, dx1, dx9, dxver, enrolid, fachdid, mas, mdc, medicare, mhsacovg, netpay, pddate, plantyp, proc3, proc4, proc5, proc6, seqnum, sex, stdplac, stdprov, stdrace, svcdate, tsvcdat, version, year) VALUES ('131', '2', '0', '0.0', '0.0', '0.0', '0.0', '1988', '1', '01', 'V221   ', '4760', '9', '7', '8', '9', '23', '0', '1', '0.0', '2013-07-12', '2', '734', '9904', '9904', '9672', '5521242', '2', '22', '1', '1', '2012-07-23', '2012-07-23', '10', '2012');
  -- 9: Patient has revcode 0450 and diagnosis codes in the pdx and dx1 fields, ER record created and conditions have condition_type_concept_id = 38000215. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '9', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', '57411', '9', '9', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', '4760', '2', '1', '1', '0450', '13079562', '2', '21', '1', '1', '2012-04-14', '20226', '2012-04-14', '10', '2014');
  -- 11: Patient has diagnosis in a dx field that has domain=procedure, condition record moved to procedure_occurrence. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '11', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '9', '11', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V755', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-10-15', '20226', '2012-10-17', '10', '2014');
  -- 13: Patient has diagnosis in a dx field that has domain=observation, condition record moved to observation. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '13', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '9', '13', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'E0152', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-02-04', '20226', '2012-02-08', '10', '2014');
  -- 15: Patient has diagnosis in a dx field that has domain=measurement, condition record moved to measurement. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '15', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '9', '15', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V726', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-21', '20226', '2012-08-25', '10', '2014');
  -- 17: Patient has icd10 diagnosis in a dx field with dxver=0, condition record created with icd10 mapped to snomed. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '17', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'S42241S', '0', '17', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-09', '20226', '2012-08-12', '10', '2014');
  -- 19: patient has icd10cm diagnosis in a dx field that overlaps with an icd10 diagnosis, condition record created with icd10cm mapped to snomed. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '19', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V9001', '0', '19', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-09', '20226', '2012-08-12', '10', '2014');
  -- 21: Patient has icd10 diagnosis after 10/1/2015 in a dx field with dxver=null, condition record created with icd10 mapped to snomed. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2015-12-31', '2015-01-01', '21', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2015-11-09', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'S42241S', '', '21', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2015-11-09', '20226', '2015-11-12', '10', '2014');
  -- 23: Patient has icd9 diagnosis before 10/1/2015 in a dx field with dxver=null, used ICD9. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '23', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2012-08-09', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V9001', '', '23', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-09', '20226', '2012-08-12', '10', '2014');
  -- 25: Patient has two IP records in inpatient_services with svcdate = condition_start_date (HIX-1274). Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '25', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dx4, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '57411', '9', '25', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-07-01', '20226', '2012-07-01', '10', '2014');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dx4, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '57411', '9', '25', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-02', '20226', '2012-08-02', '10', '2014');
  -- 27: Patient has diagnosis in dx1 in ltc, condition_type_concept_id = 38000215. Id is PERSON_ID
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '27', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.long_term_care(boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dx1, dxver, enrolid, fachdid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, plantyp, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('1', '0', '0.0', '0.0', '0.0', '0.0', '1929', '0', 'v901', '9', '27', '11579986', 'F', '9', '01', '1', '1', '0.0', '0.0', '2010-08-30', '2', '1', '0190', '2563569', '2', '31', '31', '1', '11-05-2012', '10210', '11-10-2012', '10', '2017');
  -- 29: Patient condition_concept_id of 0, no condition_era record created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '29', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', '71978', '9', '29', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', '71978', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-04-21', '20226', '2012-04-22', '10', '2014');
  -- 31: Two records with same condition_concept_id are less than 30 days apart, one condition_era record created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '31', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(dx1, dxver, enrolid, svcdate) VALUES ('37613', '9', '31', '2012-07-01');
  INSERT INTO mdcd_native_test.outpatient_services(dx1, dxver, enrolid, svcdate) VALUES ('37613', '9', '31', '2012-07-12');
  -- 33: Two records with same condition_concept_id are more than 30 days apart, two condition_era records created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2013-12-31', '2012-01-01', '33', '9', '0', '31', '1', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(dx1, dxver, enrolid, svcdate) VALUES ('37613', '9', '33', '2012-07-01');
  INSERT INTO mdcd_native_test.outpatient_services(dx1, dxver, enrolid, svcdate) VALUES ('37613', '9', '33', '2012-08-12');
  -- 35: Date of death visit end date. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2015-12-31', '2012-01-01', '35', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '35', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2013-01-06', '20226', '2013-01-09', '10', '2013');
  INSERT INTO mdcd_native_test.outpatient_services(dx1, dxver, enrolid, fachdid, svcdate, tsvcdat, year) VALUES ('7981', '9', '35', '36', '2013-01-07', '2013-01-07', '2013');
  INSERT INTO mdcd_native_test.facility_header(billtyp, boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dstatus, dx1, dx9, dxver, enrolid, fachdid, mas, mdc, medicare, mhsacovg, netpay, pddate, plantyp, proc3, proc4, proc5, proc6, seqnum, sex, stdplac, stdprov, stdrace, svcdate, tsvcdat, version, year) VALUES ('131', '2', '0', '0.0', '0.0', '0.0', '0.0', '1988', '1', '01', 'V221   ', '7981', '9', '35', '36', '9', '23', '0', '1', '0.0', '2013-07-12', '2', '734', '9904', '9904', '9672', '5521242', '2', '22', '1', '1', '2013-01-07', '2013-01-07', '10', '2015');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2016-12-31', '2012-01-01', '37', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 37: ICD10 Death and Death Type Correct. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'I461', '0', '37', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2016-01-06', '20226', '2016-01-09', '10', '2016');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2015-12-31', '2012-01-01', '39', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 39: ICD9 Death and Death Type Correct. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', '798', '9', '39', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2013-01-06', '20226', '2013-01-09', '10', '2013');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2013-02-01', '2012-01-01', '41', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 41: Discharge Status and Death Type Correct. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '20', 'V3000  ', '41', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2013-01-06', '20226', '2013-01-09', '10', '2013');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2015-12-31', '2012-01-01', '43', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 43: Death by ICD9 and Death by Discharge, Keep the Discharge. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '20', '798', '9', '43', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2013-01-06', '20226', '2013-01-09', '10', '2013');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2015-12-31', '2012-01-01', '45', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 45: Death and then contined Activity Cancels Death. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '20', 'V3000  ', '45', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2013-01-06', '20226', '2013-01-09', '10', '2013');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, svcdate, year) VALUES ('45', '2013-03-12', '2013');
  -- 47: Patient has icd9 death cord in ltc, death record created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '47', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.long_term_care(boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dx1, dxver, enrolid, fachdid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, plantyp, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('1', '0', '0.0', '0.0', '0.0', '0.0', '1929', '0', '798', '9', '47', '11579986', 'F', '9', '01', '1', '1', '0.0', '0.0', '2010-08-30', '2', '1', '0190', '2563569', '2', '31', '31', '1', '11-02-2012', '10210', '11-22-2012', '10', '2017');
  -- 49: Duplicate drug records become one record in the CDM. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '49', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '49', '999999', '4', '0.0', '2', '9', '0', '0', '1', '36987257801', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '02-01-2012', '69', '08', '10', '2012');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '49', '999999', '4', '0.0', '2', '9', '0', '0', '1', '36987257801', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '02-01-2012', '69', '08', '10', '2012');
  -- 51: Negative daysupp should be 0 in cdm. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '51', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '-30', '6', '0.0', '0.0', '1961', '1', '51', '999999', '4', '0.0', '2', '9', '0', '0', '1', '58864060830', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '06-12-2012', '69', '08', '10', '2012');
  -- 53: Daysupp >365 should be 365 in cdm. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '53', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '432', '6', '0.0', '0.0', '1961', '1', '53', '999999', '4', '0.0', '2', '9', '0', '0', '1', '58864060830', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '08-07-2012', '69', '08', '10', '2012');
  -- 55: CPT4 drug code in inpatient record moves to drug_exposure. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '55', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proc1, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '56', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '55', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '90376', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-09', '20226', '2012-08-12', '10', '2012');
  -- 57: Days supply is NULL but DRUG_EXPOSURE_END_DATE is set to DRUG_EXPOSURE_START_DATE (HIX-1430). Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '57', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proc1, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '58', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '57', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '90376', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-09', '20226', '2012-08-12', '10', '2012');
  -- 59: Patient has 11 digit NDC that doesn''t map, should use first 9 digits instead. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '59', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '59', '999999', '4', '0.0', '2', '9', '0', '0', '1', '13533063670', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '01-17-2012', '69', '08', '10', '2012');
  -- 61: Patient has 9 digit NDC that doesn''t map, should use first 9 digits instead, should map to DRUG_CONCEPT_ID=0 because of the date filter. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2006-12-31', '2006-01-01', '61', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '61', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00006000543', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '07-08-2006', '69', '08', '10', '2006');
  -- 63: Patient has 9 digit NDC that doesn''t map, should use first 9 digits instead, should map to correct DRUG_CONCEPT_ID because of the date filter. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2014-12-31', '2014-01-01', '63', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '63', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00006032582', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '09-18-2014', '69', '08', '10', '2014');
  -- 65: Tofacitinib mapps to 11-digit DRUG_SOURCE_CONCEPT_ID instead of 9-digit (HIX-1534)
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2014-12-31', '2014-01-01', '65', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '65', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00069100101', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '09-18-2014', '69', '08', '10', '2014');
  -- 67: Two drugs with same ingredient within 30 days, should be one drug era. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '67', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '67', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '02-04-2012', '69', '08', '10', '2012');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '67', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '02-22-2012', '69', '08', '10', '2012');
  -- 69: Two drugs with same ingredient within 30 days, but 10 gap days. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '69', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '8', '6', '0.0', '0.0', '1961', '1', '69', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '02-04-2012', '69', '08', '10', '2012');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '69', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '02-22-2012', '69', '08', '10', '2012');
  -- 71: Three drugs with same ingredient within 30 days, but 10 gap days total (5 between each). Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '71', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '13', '6', '0.0', '0.0', '1961', '1', '71', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '02-04-2012', '69', '08', '10', '2012');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '14', '6', '0.0', '0.0', '1961', '1', '71', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '02-22-2012', '69', '08', '10', '2012');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '71', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '03-12-2012', '69', '08', '10', '2012');
  -- 73: Two drugs with same ingredient > 30 days apart, should be two drug eras. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '73', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '73', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '09-21-2012', '69', '08', '10', '2012');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '73', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '12-08-2012', '69', '08', '10', '2012');
  -- 75: Drug_era_end_date should be drug start date + days supply. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2010-01-01', '75', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '14', '6', '0.0', '0.0', '1961', '1', '75', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00349835305', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '12-08-2010', '69', '08', '10', '2012');
  -- 77: No drug era created from procedure drugs since they are not related to ingredients. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '77', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proc1, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '78', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '77', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '90376', '1', '1', '13079562', '2', '21', '1', '1', '2012-03-26', '20226', '2012-03-30', '10', '2012');
  -- 79: Drug with two ingredients should have two drug eras. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2010-01-01', '79', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '79', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00008419001', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '05-01-2010', '69', '08', '10', '2012');
  -- 81: Two drugs with same ingredient within 30 days, one occurs outside of observation_period. Drug era should only include drug inside observation_period. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '81', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '81', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '12-12-2011', '69', '08', '10', '2012');
  INSERT INTO mdcd_native_test.drug_claims(awp, boe, cap, cob, coins, copay, dawind, daysupp, deaclas, deduct, dispfee, dobyr, drugcovg, enrolid, generid, genind, ingcost, maintin, mas, medicare, metqty, mhsacovg, ndcnum, netpay, pay, pddate, plantyp, qty, refill, seqnum, sex, stdrace, svcdate, thercls, thergrp, version, year) VALUES ('0.0', '2', '1', '0.0', '0.0', '0.0', '01', '30', '6', '0.0', '0.0', '1961', '1', '81', '999999', '4', '0.0', '2', '9', '0', '0', '1', '00463303410', '0.0', '0.0', '2017-01-20', '4', '1', '0', '33815395', '2', '1', '01-08-2012', '69', '08', '10', '2012');
  -- 83: Subsumed enrollment test where two enrollment durations with the second subsumed by the first results in a single observation. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '83', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-07-31', '2012-06-01', '83', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 84: Combine enrollment test where two enrollment durations with the second within 30 days of the first results in a single observation. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-05-31', '2012-05-01', '84', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-06-15', '84', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 85: Gap enrollment test where two enrollment durations are 33 days apart results in two observations. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-06-01', '2012-01-01', '85', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-08-02', '85', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 86: Store Discharge Status. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2013-12-31', '2012-01-01', '86', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, dxver, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '51', '57411', '9', '86', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-07-23', '20226', '2012-07-23', '10', '2014');
  -- 88: Person has a gap of >32 days between enrollment periods with the same payer_source_value; person has two records. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2013-01-31', '2013-01-01', '88', '9', '1', '31', '0', '6', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2013-05-31', '2013-05-01', '88', '9', '1', '31', '0', '6', '43537441', '2', '1', '10', '2017');
  -- 89: Person does not have prescription benefits and is excluded. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '0', '2013-01-31', '2013-01-01', '89', '9', '0', '31', '0', '6', '43537441', '2', '1', '10', '2017');
  -- 90: Person switches plans in the middle of an enrollment period; person has two records with the first truncated. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-04-30', '2012-04-01', '90', '9', '1', '31', '0', '6', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-04-30', '2012-04-07', '90', '9', '1', '31', '0', '5', '43537441', '2', '1', '10', '2017');
  -- 91: Person has duplicate records, only one is brought into the cdm. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-04-30', '2012-04-01', '91', '9', '1', '31', '0', '6', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-04-30', '2012-04-01', '91', '9', '1', '31', '0', '6', '43537441', '2', '1', '10', '2017');
  -- 92: Person with two genders is excluded. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2017-06-30', '2017-06-01', '92', '9', '0', '31', '0', '4', '43537441', '1', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2017-06-30', '2017-06-01', '92', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 93: Person with two birth years >2 yrs apart is excluded. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '1970', '1', '2017-06-30', '2017-06-01', '93', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '1980', '1', '2017-06-30', '2017-06-01', '93', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 94: Person with two birth years <2 yrs apart is kept with last birth year selected. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '1970', '1', '2012-01-31', '2012-01-01', '94', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '1971', '1', '2012-02-28', '2012-02-01', '94', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 95: Person born before 1900 is excluded. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '1899', '1', '2017-06-30', '2017-06-01', '95', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 96: Person born in 2099 is excluded. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2099', '1', '2017-06-30', '2017-06-01', '96', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 97: Person born in 2014 but enrolled in 2012 is excluded. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2014', '1', '2012-01-31', '2012-01-01', '97', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 98: Person born in 2013 but enrolled in 2012 is kept, latest birth year taken. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2013', '1', '2012-01-31', '2012-01-01', '98', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 99: Person with two enrollment_detail records has one person record. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '1980', '1', '2012-01-31', '2012-01-01', '99', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '1980', '1', '2012-02-28', '2012-02-01', '99', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 100: Person with sex=3 is excluded. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2017-06-30', '2017-06-01', '100', '9', '0', '31', '0', '4', '43537441', '3', '1', '10', '2017');
  -- 101: Person has record with sex=3 but last record has sex=1, person is kept. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-01-31', '2012-01-01', '101', '9', '0', '31', '0', '4', '43537441', '3', '1', '10', '2017');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-02-28', '2012-02-01', '101', '9', '0', '31', '0', '4', '43537441', '1', '1', '10', '2017');
  -- 102: Person born the same year as enrolled, use first enrollment month to impute month of birth and day of birth. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2012', '1', '2012-04-30', '2012-04-01', '102', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 103: Person with DRUGCOVG=0 and MEDICARE=0, person is excluded. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '0', '2017-06-30', '2017-06-01', '103', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 104: Person with DRUGCOVG=1 and MEDICARE=0, person is kept. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2017-06-30', '2017-06-01', '104', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 105: Person with DRUGCOVG=0 and MEDICARE=1, person is kept. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '0', '2017-06-30', '2017-06-01', '105', '9', '1', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 106: Person with stdrace=1. Id is PERSON_ID. (HIX-1506)
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2017-06-30', '2017-06-01', '106', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 107: Person with stdrace=4. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2017-06-30', '2017-06-01', '107', '9', '0', '31', '0', '4', '43537441', '2', '4', '10', '2017');
  -- 108: Patient has two PPROC values, PPROC from inpatient_admissions is used. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '108', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, pproc, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '109', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '108', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '65779', '1', '1', '13079562', '2', '21', '1', '1', '2012-06-11', '20226', '2012-06-12', '10', '2012');
  INSERT INTO mdcd_native_test.inpatient_admissions(admdate, admtyp, boe, cap, caseid, days, disdate, dobyr, drg, drugcovg, dstatus, dx1, dx2, enrolid, hospnet, hosppay, mas, mdc, medicare, mhsacovg, pddate, pdx, physnet, physpay, plantyp, poadx12, poadx13, poadx14, poadx15, pproc, seqnum, sex, stdrace, totcob, totcoins, totcopay, totded, totnet, totpay, version, year) VALUES ('2012-01-01', '3', '5', '0', '109', '2', '2012-12-31', '2015', '795', '1', '01', 'V3000  ', '25000  ', '108', '0.0', '0.0', '9', '14', '0', '1', '2015-09-29', 'V3000  ', '0.0', '0.0', '2', '1', '1', '1', '1', '29914', '366313', '2', '1', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '10', '2012');
  -- 110: Patient has two different providers for the same procedure, the provider on the first line (ascending) is chosen. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '110', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_admissions(admdate, admtyp, boe, cap, caseid, days, disdate, dobyr, drg, drugcovg, dstatus, dx1, dx2, enrolid, hospnet, hosppay, mas, mdc, medicare, mhsacovg, pddate, pdx, physnet, physpay, plantyp, poadx12, poadx13, poadx14, poadx15, seqnum, sex, stdrace, totcob, totcoins, totcopay, totded, totnet, totpay, version, year) VALUES ('2012-01-01', '3', '5', '0', '111', '2', '2012-12-31', '2015', '795', '1', '01', 'V3000  ', '25000  ', '110', '0.0', '0.0', '9', '14', '0', '1', '2015-09-29', 'V3000  ', '0.0', '0.0', '2', '1', '1', '1', '1', '366313', '2', '1', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '10', '2012');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proc1, proctyp, prov_id, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '111', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '110', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '50760', '1', '3456789', '1', '13079562', '2', '21', '220', '1', '2012-10-20', '20226', '2012-10-22', '10', '2012');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proc1, proctyp, prov_id, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '111', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '110', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '50760', '1', '1234567', '1', '13079562', '2', '21', '540', '1', '2012-10-20', '20226', '2012-10-22', '10', '2012');
  -- 112: Patient has procedure in proc1 field in long_term_care table. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '112', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.long_term_care(boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dxver, enrolid, fachdid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, plantyp, proc1, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('1', '0', '0.0', '0.0', '0.0', '0.0', '1929', '0', '0', '112', '11579986', 'F', '9', '01', '1', '1', '0.0', '0.0', '2010-08-30', '2', '92568', '1', '0190', '2563569', '2', '31', '31', '1', '2012-09-15', '10210', '2012-10-30', '10', '2017');
  -- 114: Patient has two records for the same procedure, procedure in outpatient_services prioritized. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '114', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, fachdid, proc1, svcdate, tsvcdat, year) VALUES ('114', '115', '54861', '2012-02-15', '2012-02-15', '2012');
  INSERT INTO mdcd_native_test.facility_header(billtyp, boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dstatus, dx1, enrolid, fachdid, mas, mdc, medicare, mhsacovg, netpay, pddate, plantyp, proc1, proc3, proc4, proc5, proc6, seqnum, sex, stdplac, stdprov, stdrace, svcdate, tsvcdat, version, year) VALUES ('131', '2', '0', '0.0', '0.0', '0.0', '0.0', '1988', '1', '01', 'V221   ', '114', '115', '9', '23', '0', '1', '0.0', '2013-07-12', '2', '54861', '734', '9904', '9904', '9672', '5521242', '2', '22', '1', '1', '2012-02-15', '2012-02-15', '10', '2012');
  -- 116: Patient has procedure in proc5 position in facility header, procedure_type_concept_id = 38000273. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '116', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, fachdid, svcdate, tsvcdat, year) VALUES ('116', '117', '2012-03-03', '2012-03-03', '2012');
  INSERT INTO mdcd_native_test.facility_header(billtyp, boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dstatus, dx1, enrolid, fachdid, mas, mdc, medicare, mhsacovg, netpay, pddate, plantyp, proc3, proc4, proc5, proc6, seqnum, sex, stdplac, stdprov, stdrace, svcdate, tsvcdat, version, year) VALUES ('131', '2', '0', '0.0', '0.0', '0.0', '0.0', '1988', '1', '01', 'V221   ', '116', '117', '9', '23', '0', '1', '0.0', '2013-07-12', '2', '734', '9904', '93042', '9672', '5521242', '2', '22', '1', '1', '2012-03-03', '2012-03-03', '10', '2012');
  -- 118: Patient has procedure with domain = device, device record created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '118', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, fachdid, proc1, svcdate, tsvcdat, year) VALUES ('118', '119', 'E0304', '2012-04-03', '2012-04-03', '2012');
  INSERT INTO mdcd_native_test.facility_header(billtyp, boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dstatus, dx1, enrolid, fachdid, mas, mdc, medicare, mhsacovg, netpay, pddate, plantyp, proc3, proc4, proc5, proc6, seqnum, sex, stdplac, stdprov, stdrace, svcdate, tsvcdat, version, year) VALUES ('131', '2', '0', '0.0', '0.0', '0.0', '0.0', '1988', '1', '01', 'V221   ', '118', '119', '9', '23', '0', '1', '0.0', '2013-07-12', '2', '734', '9904', '9904', '9672', '5521242', '2', '22', '1', '1', '2012-04-03', '2012-04-03', '10', '2012');
  -- 120: Patient has procedure with domain = drug, drug record created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '120', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, proc1, svcdate, tsvcdat) VALUES ('120', '90686', '2012-05-03', '2012-05-03');
  -- 122: Patient has procedure with domain = measurement, measurement record created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '122', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, proc1, svcdate, tsvcdat) VALUES ('122', '82985', '2012-05-03', '2012-05-03');
  -- 124: Patient has procedure with domain = observation, observation record created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '124', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, proc1, svcdate, tsvcdat) VALUES ('124', 'S9368', '2012-05-03', '2012-05-03');
  -- 126: Patient has an ICD10PCS value in inpatient_admissions field pdx, pdx is correctly mapped and a procedure_occurrence record created (HIX-1255). Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2016-12-31', '2016-01-01', '126', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_admissions(admdate, admtyp, boe, cap, caseid, days, disdate, dobyr, drg, drugcovg, dstatus, dx1, dx2, enrolid, hospnet, hosppay, mas, mdc, medicare, mhsacovg, pddate, pdx, physnet, physpay, plantyp, poadx12, poadx13, poadx14, poadx15, seqnum, sex, stdrace, totcob, totcoins, totcopay, totded, totnet, totpay, version, year) VALUES ('2016-05-30', '3', '5', '0', '127', '2', '2016-06-05', '2015', '795', '1', '01', 'V3000  ', '25000  ', '126', '0.0', '0.0', '9', '14', '0', '1', '2015-09-29', 'DB025ZZ', '0.0', '0.0', '2', '1', '1', '1', '1', '366313', '2', '1', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '10', '2016');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '127', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '126', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', '', '2', '1', '1', '13079562', '2', '21', '1', '1', '2016-06-05', '20226', '2016-06-05', '10', '2016');
  -- 128: Provider in facility header table with stdprov=220, specialty = emergency medicine. Id is PROVIDER_SOURCE_VALUE
  INSERT INTO mdcd_native_test.facility_header(billtyp, boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dstatus, dx1, enrolid, fachdid, mas, mdc, medicare, mhsacovg, netpay, pddate, plantyp, proc3, proc4, proc5, proc6, prov_id, seqnum, sex, stdplac, stdprov, stdrace, svcdate, tsvcdat, version, year) VALUES ('131', '2', '0', '0.0', '0.0', '0.0', '0.0', '1988', '1', '01', 'V221   ', '129', '5521242', '9', '23', '0', '1', '0.0', '2013-07-12', '2', '734', '9904', '9904', '9672', '128', '5521242', '2', '22', '220', '1', '2019-10-01', '2017-05-31', '10', '2015');
  -- 130: Provider in outpatient_services table with stdprov=285, specialty = infectious disease. Id is PROVIDER_SOURCE_VALUE
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, prov_id, stdprov) VALUES ('131', '130', '285');
  -- 132: provider in inpatient_services table with stdprov=540, specialty = cardiac surgery. Id is PROVIDER_SOURCE_VALUE
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, prov_id, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '133', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '132', '1', '13079562', '2', '21', '540', '1', '2019-02-05', '20226', '2019-02-11', '10', '2014');
  -- 134: provider in long_term_care table with stdprov=22, specialty = addiction medicine. Id is PROVIDER_SOURCE_VALUE
  INSERT INTO mdcd_native_test.long_term_care(boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dxver, enrolid, fachdid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, plantyp, prov_id, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('1', '0', '0.0', '0.0', '0.0', '0.0', '1929', '0', '0', '135', '11579986', 'F', '9', '01', '1', '1', '0.0', '0.0', '2010-08-30', '2', '134', '1', '0190', '2563569', '2', '31', '22', '1', '2017-08-01', '10210', '2014-03-31', '10', '2017');
  -- 136: Even when PROVID IS NULL create a PROVIDER (HIX-1404)
  INSERT INTO mdcd_native_test.facility_header(billtyp, boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dstatus, dx1, enrolid, fachdid, mas, mdc, medicare, mhsacovg, netpay, pddate, plantyp, proc3, proc4, proc5, proc6, seqnum, sex, stdplac, stdprov, stdrace, svcdate, tsvcdat, version, year) VALUES ('131', '2', '0', '0.0', '0.0', '0.0', '0.0', '1988', '1', '01', 'V221   ', '137', '5521242', '9', '23', '0', '1', '0.0', '2013-07-12', '2', '734', '9904', '9904', '9672', '5521242', '2', '22', '220', '1', '2019-10-01', '2017-05-31', '10', '2015');
  -- 138: Patient with visit that starts before the observation period, start date trimmed to beginning of observation period. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '138', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '139', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '138', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2011-12-05', '20226', '2012-01-06', '10', '2014');
  -- 140: svcdate>tsvcdate, visit_end_date is svcdate. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '140', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '140', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-03-21', '20226', '2012-03-19', '10', '2014');
  -- 142: Service falls during observation period but ends after the period ends, visit_end_date is the observation_period_end_date. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '142', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '142', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-12-30', '20226', '2013-01-08', '10', '2014');
  -- 144: service in inpatient_services with revcode of 0450, visit classified as ER. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '144', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '144', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '0450', '13079562', '2', '21', '1', '1', '2012-04-12', '20226', '2012-04-12', '10', '2014');
  -- 146: service in outpatient_services with revcode of 0450, visit classified as ER. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '146', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, revcode, svcdate, tsvcdat) VALUES ('146', '0450', '2012-05-01', '2012-05-01');
  -- 148: service in outpatient_services with revcode of 0100, visit classified as IP. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '148', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, revcode, svcdate, tsvcdat) VALUES ('148', '0100', '2012-10-17', '2012-10-20');
  -- 150: Two visits created, expect a visit with a PRECEDING_VISIT_OCCURRENCE_ID. Id is PERSON_ID. (HIX-1521)
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '150', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '150', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-08', '20226', '2012-08-12', '10', '2014');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '150', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-10-01', '20226', '2012-10-05', '10', '2014');
  -- 152: patient has two lines in the inpatient_services table where the end_date of one line and the start_date of the next >1, two visits created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '152', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '152', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-08-08', '20226', '2012-08-12', '10', '2014');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '152', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-10-01', '20226', '2012-10-05', '10', '2014');
  -- 154: Patient has an ER record that starts and ends on the first day of the IP visit, separate ER visit created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '154', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '154', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '0450', '13079562', '2', '21', '1', '1', '2012-09-03', '20226', '2012-09-03', '10', '2014');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '154', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '0100', '13079562', '2', '21', '1', '1', '2012-09-03', '20226', '2012-09-10', '10', '2014');
  -- 156: Patient has two lines in the inpatient_services table where the difference between the end_date of one line and the start_date of the next is <= 1, one visit created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '156', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '156', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-05-15', '20226', '2012-05-16', '10', '2014');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '156', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-05-16', '20226', '2012-05-17', '10', '2014');
  -- 158: Setting Discharge_to_Concept_id for IP Record (HIX-1429). Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '158', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '158', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '1', '13079562', '2', '21', '1', '1', '2012-03-21', '20226', '2012-03-19', '10', '2014');
  -- 160: Patient has record in outpatient_services table but no rx benefits, visit dropped. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '0', '2012-12-31', '2012-01-01', '160', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.outpatient_services(enrolid, fachdid, svcdate, tsvcdat) VALUES ('160', '161', '2012-01-06', '2012-01-06');
  -- 162: Patient has two records in the same visit with different prov_id and provstd. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '162', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, prov_id, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '162', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '164', '1', '13079562', '2', '21', '220', '1', '2012-08-08', '20226', '2012-08-12', '10', '2014');
  INSERT INTO mdcd_native_test.inpatient_services(admdate, admtyp, boe, cap, caseid, cob, coins, copay, deduct, disdate, dobyr, drg, drugcovg, dstatus, dx1, enrolid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, pdx, plantyp, proctyp, prov_id, qty, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('2016-02-15', '2', '2', '0', '633982', '0.0', '0.0', '0.0', '0.0', '2015-04-17', '1957', '775', '1', '01', 'V3000  ', '162', 'F', '9', '14', '0', '1', '0.0', '0.0', '2015-03-31', 'V3000  ', '2', '1', '165', '1', '13079562', '2', '21', '540', '1', '2012-08-08', '20226', '2012-08-12', '10', '2014');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '166', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 166: Patient has two LTC claims where the end_date of the first is within one day of the start_date of the second, one visit created. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.long_term_care(boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dxver, enrolid, fachdid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, plantyp, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('1', '0', '0.0', '0.0', '0.0', '0.0', '1929', '0', '0', '166', '11579986', 'F', '9', '01', '1', '1', '0.0', '0.0', '2010-08-30', '2', '1', '0190', '2563569', '2', '31', '31', '1', '2012-06-18', '10210', '2012-06-30', '10', '2012');
  INSERT INTO mdcd_native_test.long_term_care(boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dxver, enrolid, fachdid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, plantyp, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('1', '0', '0.0', '0.0', '0.0', '0.0', '1929', '0', '0', '166', '11579986', 'F', '9', '01', '1', '1', '0.0', '0.0', '2010-08-30', '2', '1', '0190', '2563569', '2', '31', '31', '1', '2012-07-01', '10210', '2012-07-31', '10', '2012');
  INSERT INTO mdcd_native_test.enrollment_detail(boe, cap, dobyr, drugcovg, dtend, dtstart, enrolid, mas, medicare, memdays, mhsacovg, plantyp, seqnum, sex, stdrace, version, year) VALUES ('4', '1', '2006', '1', '2012-12-31', '2012-01-01', '168', '9', '0', '31', '0', '4', '43537441', '2', '1', '10', '2017');
  -- 168: Patient has LTC claim where the end_date = the start_date. Id is PERSON_ID.
  INSERT INTO mdcd_native_test.long_term_care(boe, cap, cob, coins, copay, deduct, dobyr, drugcovg, dxver, enrolid, fachdid, facprof, mas, mdc, medicare, mhsacovg, netpay, pay, pddate, plantyp, qty, revcode, seqnum, sex, stdplac, stdprov, stdrace, svcdate, svcscat, tsvcdat, version, year) VALUES ('1', '0', '0.0', '0.0', '0.0', '0.0', '1929', '0', '0', '168', '11579986', 'F', '9', '01', '1', '1', '0.0', '0.0', '2010-08-30', '2', '1', '0190', '2563569', '2', '31', '31', '1', '2012-08-03', '10210', '2012-08-03', '10', '2012');