INSERT INTO `prj_healthaccess_mn`.`DPageItemType` (`id`, `type`, `title`, `sorter`) VALUES (NULL, 'ResultText_', 'Result Text', '210'), (NULL, 'FPL_', 'FPL', '220'), (NULL, 'MPC_', 'MPC', '230'), (NULL, 'BenchmarkPlans_', 'BenchmarkPlans', '240'); CREATE TABLE IF NOT EXISTS `ResultText` ( `id` int(11) NOT NULL, `name` varchar(255) NOT NULL, `description` text, `added` datetime NOT NULL, `changed` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ; INSERT INTO `ResultText` (`id`, `name`, `description`, `added`, `changed`) VALUES (1, 'Not MN resident', '
It looks like your legal residence is outside MN. To find your state's marketplace, click here.
\r\n', '2015-06-26 12:14:45', '2015-07-13 17:31:20'), (2, 'Disabled', 'It looks like you qualify for Medicare because of a disability. MNsure and Medicare are separate systems, but you still might be able to get financial help with your insurance costs. To find out more, call the Disability Linkage Line at 1-866-333-2466. It’s a free service.
\r\n', '2015-06-26 12:15:13', '2015-07-13 16:53:09'), (3, 'Over age 64', 'It looks like you qualify for Medicare because you are 65 or older. MNsure and Medicare are separate systems, but you still might be able to get financial help with your insurance costs. To find out more, call the Senior Linkage Line at 1-800-333-2433. It’s a free service.
\r\n', '2015-06-26 12:15:40', '2015-07-13 17:31:34'), (4, 'MA', 'Medical Assistance (MA)
\r\n\r\nYou may be eligible for Medical Assistance, a public program with no monthly premium and very low costs. You can apply for MA any time of year, so click the MNsure link below to get started!
\r\n', '2015-06-26 12:16:17', '2015-07-13 17:38:53'), (5, 'MCRE', 'MinnesotaCare (MCRE)
\r\n\r\nYou may be eligible for MinnesotaCare, a public program with low monthly premiums and low costs. You can apply for MCRE any time of year, so click the MNsure link below to get started!
\r\n', '2015-06-26 12:16:39', '2015-07-13 17:39:35'), (6, 'QHP-APTC & CSR', 'Qualified Health Plan with Subsidies
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure, with tax credits that will reduce your monthly premium. You can apply the tax credits to any plan you choose. Also, if you decide to pick a silver plan, you qualify for a plan with slightly lower out-of-pocket costs. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-06-26 12:17:04', '2015-07-13 17:35:10'), (7, 'QHP-CSR', 'Qualified Health Plan with Subsidies
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure. If you decide to pick a silver plan, you qualify for a plan with slightly lower out-of-pocket costs. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-06-26 12:17:25', '2015-07-13 17:40:12'), (8, 'QHP-APTC', 'Qualified Health Plan with Subsidies
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure, with tax credits that will reduce your monthly premium. You can apply the tax credits to any plan you choose. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-06-26 12:17:52', '2015-07-13 17:40:54'), (9, 'QHP', 'Qualified Health Plan
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure. That means you will be able to compare plans side-by-side from several insurers and find the one that works best for your needs and budget. Also, you may qualify for a tax credit when file your taxes next year, depending on how much income you had. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-06-26 12:18:14', '2015-07-13 17:41:15'), (10, 'Not lawfully present; pregnant', 'Due to your immigration status and income, it looks you are not eligible to use MNsure. If you have a medical emergency, you may be able to get Emergency Medical Assistance. You can find more information by clicking here.
', '2015-06-26 12:18:43', '2015-06-26 12:18:43'), (11, 'Not lawfully present; not pregnant', 'Due to your immigration status, it looks you are not eligible to use MNsure. If you have a medical emergency, you may be able to get Emergency Medical Assistance. You can find more information by clicking here.
\r\n', '2015-06-26 12:19:11', '2015-06-26 12:19:11'), (12, 'Other immigration status', 'Note about your eligibility estimate: You said your immigration status was one other than those we listed. Some immigration statuses will affect your eligibility, but we can’t tell from what you provided. Please be sure to speak to an assister before applying (instructions are above).
\r\n', '2015-06-26 12:19:30', '2015-06-26 12:19:30'), (13, 'Student / worker; pregnant', 'Note about residency: Your estimate is based on an assumption that Minnesota is your legal residence. If you have not changed your residence or have specific plans to leave, that may change the result. Please be sure to speak to an assister before applying (instructions are above).
\r\n', '2015-06-26 12:20:27', '2015-06-26 12:20:27'), (14, 'DACA; pregnant', 'Due to your immigration status and income, it looks you are not eligible to use MNsure. If you have a medical emergency, you may be able to get Emergency Medical Assistance. You can find more information by clicking here.
\r\n', '2015-06-26 12:21:04', '2015-06-26 12:21:04'), (15, 'DACA; not pregnant; under 21', 'Due to your immigration status, it looks you are not eligible to use MNsure. If you have a medical emergency, you may be able to get Emergency Medical Assistance. You can find more information by clicking here.
\r\n', '2015-06-26 12:21:53', '2015-06-26 12:21:53'), (16, 'LPR or VAWA; not for 5 yrs; didn''t enter as Refugee or Asylee; not pregnant; not under 21', '', '2015-06-26 12:22:12', '2015-06-26 12:22:12'), (17, 'Student / worker; not pregnant; not under 21', 'Note about residency: Your estimate is based on an assumption that Minnesota is your legal residence. If you have not changed your residence or have specific plans to leave, that may change the result. Please be sure to speak to an assister before applying (instructions are above).
\r\n
Due to your immigration status, it looks you are not eligible to use MNsure. If you have a medical emergency, you may be able to get Emergency Medical Assistance. You can find more information by clicking here.
\r\n', '2015-06-26 12:23:39', '2015-06-26 12:23:39'), (20, 'Ineligible for MCRE/APTC/CSR because enrolled in ESI', 'Qualified Health Plan
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure. Because you are enrolled in employer coverage, though, you may be better off staying with your employer’s insurance. Please be sure to speak to an assister before applying (instructions are above).
\r\n', '2015-06-26 12:24:47', '2015-07-13 17:44:46'), (21, 'Ineligible for MCRE/APTC/CSR because eligible for affordable ESI w/ minimum value', 'Qualified Health Plan
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure. You may also be eligible for discounts on the insurance in the future, but your employer’s offer of insurance may prevent that. You will need to weigh your options carefully, and should speak to an assister before applying (instructions are above).
\r\n', '2015-06-26 12:24:56', '2015-07-13 17:45:23'), (22, 'Non-Filer', 'Qualified Health Plan
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure. You may also be eligible for tax credits or other discounts that reduce the cost, but you would need to file taxes to take advantage of those. Since you don’t plan to file taxes, they are not included here. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-06-26 12:25:07', '2015-07-13 17:46:06'), (23, 'Not Filing Jointly – Living Together', 'Qualified Health Plan
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure. You may also be eligible for tax credits or other discounts that reduce the cost, but you would need to file taxes jointly with your spouse to take advantage of those. Since you don’t plan to file taxes with your spouse, they are not included here. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-06-26 12:25:23', '2015-07-13 17:46:37'), (24, 'Not Filing Jointly – Living Apart', 'Qualified Health Plan
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure. You may also be eligible for tax credits or other discounts that reduce the cost, but you usually would need to file taxes jointly with your spouse to take advantage of those. Since you don’t live with your spouse, there are a few exceptions (for spousal abuse, abandonment, and for those who can file as Head of Household). You can speak to an assister about these (instructions are above). You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-06-26 12:25:31', '2015-07-13 17:47:02'), (25, 'AI; MinnesotaCare', 'MinnesotaCare (MCRE)
\r\n\r\nYou may be eligible for MinnesotaCare, a public program with low monthly premiums and low costs. Also, as an American Indian, you may have no out-of-pocket costs and you and your household members may have no monthly premium for MCRE. You can apply for MCRE any time of year, so click the MNsure link below to get started!
\r\n', '2015-07-06 14:54:07', '2015-07-13 17:47:35'), (26, 'AI; QHP-APTC & CSR (200%-300% FPL)', 'Qualified Health Plan with Subsidies
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure, with tax credits that will reduce your monthly premium. You can apply the tax credits to any plan you choose. Also, as an American Indian, you may qualify to have your out-of-pocket costs paid for. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-07-06 15:06:22', '2015-07-13 17:48:02'), (27, 'AI; QHP-CSR (200%-300% FPL)', 'Qualified Health Plan with Subsidies
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure. Also, as an American Indian, you may qualify to have your out-of-pocket costs paid for. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-07-06 15:11:08', '2015-07-13 17:48:34'), (28, 'AI; QHP-APTC & CSR (300%-400% FPL)', 'Qualified Health Plan with Subsidies
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure, with tax credits that will reduce your monthly premium. You can apply the tax credits to any plan you choose. Also, as an American Indian, you may qualify to have your out-of-pocket costs paid for, but only if you get services or referrals from specific tribal and related providers. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-07-06 15:13:33', '2015-07-13 17:48:55'), (29, 'AI; QHP-CSR (300%-400% FPL)', 'Qualified Health Plan with Subsidies
\r\n\r\nIt looks like you are eligible to purchase a health plan (QHP) through MNsure. Also, as an American Indian, you may qualify to have your out-of-pocket costs paid for, but only if you get services or referrals from specific tribal and related providers. You can purchase a QHP during open enrollment (Nov. 1, 2015 to Jan. 31, 2016), or anytime if you have a qualifying life change. Click the MNsure link below to get started!
\r\n', '2015-07-06 15:16:32', '2015-07-13 17:49:17'), (30, 'AI; All other results', 'As an American Indian, you may be able to benefit from certain protections for tribal members and other American Indians. For more information, speak to an assister (instructions are above) or call MNsure at 1-855-366-7873 and ask for the American Indian specialist.
\n', '2015-07-06 15:18:56', '2015-07-06 15:18:56'); CREATE TABLE IF NOT EXISTS `FPL` ( `id` int(11) NOT NULL, `size` int(11) NOT NULL, `FPL` decimal(10,2) NOT NULL, `yearId` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `FPLYears` ( `id` int(11) NOT NULL, `year` int(4) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `MPC` ( `id` int(11) NOT NULL, `FPLStart` int(11) NOT NULL, `FPLEnd` int(11) NOT NULL, `MPCStart` decimal(10,2) NOT NULL, `MPCEnd` decimal(10,2) NOT NULL, `added` datetime NOT NULL, `changed` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; INSERT INTO `MPC` (`id`, `FPLStart`, `FPLEnd`, `MPCStart`, `MPCEnd`, `added`, `changed`) VALUES (1, 0, 133, '2.01', '2.01', '2015-07-01 17:11:41', '2015-07-01 17:11:41'), (2, 133, 150, '3.02', '4.02', '2015-07-01 17:12:36', '2015-07-01 17:12:36'), (3, 150, 200, '4.02', '6.34', '2015-07-01 17:13:39', '2015-07-01 17:13:39'); CREATE TABLE IF NOT EXISTS `BenchmarkPlans` ( `id` int(11) NOT NULL, `file` varchar(255) NOT NULL, `min` int(11) DEFAULT NULL, `max` int(11) DEFAULT NULL, `year` int(4) NOT NULL `added` datetime NOT NULL, `changed` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `BenchmarkPlansData` ( `id` int(11) NOT NULL, `age` varchar(5) NOT NULL, `rate` decimal(10,2) NOT NULL, `benchmarkId` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; `id` int(11) NOT NULL, `zipCode` int(11) NOT NULL, `countyId` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; INSERT INTO `ZipCodes` (`id`, `zipCode`, `countyId`) VALUES (1, 55441, 1), (2, 55431, 1); CREATE TABLE IF NOT EXISTS `DCounties` ( `id` int(11) NOT NULL, `county` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=88 ; INSERT INTO `DCounties` (`id`, `county`) VALUES (1, 'Hennepin'), (2, 'Scott'), (3, 'Dakota'), (4, 'Rice'), (5, 'Aitkin'), (6, 'Anoka'), (7, 'Becker'), (8, 'Beltrami'), (9, 'Benton'), (10, 'Big Stone'), (11, 'Blue Earth'), (12, 'Brown'), (13, 'Carlton'), (14, 'Carver'), (15, 'Cass'), (16, 'Chippewa'), (17, 'Chisago'), (18, 'Clay'), (19, 'Clearwater'), (20, 'Cook'), (21, 'Cottonwood'), (22, 'Crow Wing'), (23, 'Dodge'), (24, 'Douglas'), (25, 'Faribault'), (26, 'Fillmore'), (27, 'Freeborn'), (28, 'Goodhue'), (29, 'Grant'), (30, 'Houston'), (31, 'Hubbard'), (32, 'Isanti'), (33, 'Itasca'), (34, 'Jackson'), (35, 'Kanabec'), (36, 'Kandiyohi'), (37, 'Kittson'), (38, 'Koochiching'), (39, 'Lac qui Parle'), (40, 'Lake'), (41, 'Lake of the Woods'), (42, 'Le Sueur'), (43, 'Lincoln'), (44, 'Lyon'), (45, 'Mahnomen'), (46, 'Marshall'), (47, 'Martin'), (48, 'McLeod'), (49, 'Meeker'), (50, 'Mille Lacs'), (51, 'Morrison'), (52, 'Mower'), (53, 'Murray'), (54, 'Nicollet'), (55, 'Nobles'), (56, 'Norman'), (57, 'Olmsted'), (58, 'Otter Tail'), (59, 'Pennington'), (60, 'Pine'), (61, 'Pipestone'), (62, 'Polk'), (63, 'Pope'), (64, 'Ramsey'), (65, 'Red Lake'), (66, 'Redwood'), (67, 'Renville'), (68, 'Rock'), (69, 'Roseau'), (70, 'Sherburne'), (71, 'Sibley'), (72, 'St. Louis'), (73, 'Stearns'), (74, 'Steele'), (75, 'Stevens'), (76, 'Swift'), (77, 'Todd'), (78, 'Traverse'), (79, 'Wabasha'), (80, 'Wadena'), (81, 'Waseca'), (82, 'Washington'), (83, 'Watonwan'), (84, 'Wilkin'), (85, 'Winona'), (86, 'Wright'), (87, 'Yellow Medicine'); CREATE TABLE IF NOT EXISTS `DCounties2BenchmarkPlans` ( `id` int(11) NOT NULL, `countyId` int(11) NOT NULL, `benchmarkId` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; ALTER TABLE `BenchmarkPlans` ADD PRIMARY KEY (`id`); ALTER TABLE `BenchmarkPlansData` ADD PRIMARY KEY (`id`), ADD KEY `benchmarkId` (`benchmarkId`); ALTER TABLE `DCounties` ADD PRIMARY KEY (`id`); ALTER TABLE `DCounties2BenchmarkPlans` ADD PRIMARY KEY (`id`), ADD KEY `benchmarkId` (`benchmarkId`), ADD KEY `countyId` (`countyId`); ALTER TABLE `FPL` ADD PRIMARY KEY (`id`), ADD KEY `yearId` (`yearId`); ALTER TABLE `FPLYears` ADD PRIMARY KEY (`id`); ALTER TABLE `MPC` ADD PRIMARY KEY (`id`); ALTER TABLE `ResultText` ADD PRIMARY KEY (`id`); ALTER TABLE `ZipCodes` ADD PRIMARY KEY (`id`), ADD KEY `countyId` (`countyId`); ALTER TABLE `BenchmarkPlansData` ADD CONSTRAINT `BenchmarkPlansData_ibfk_1` FOREIGN KEY (`benchmarkId`) REFERENCES `BenchmarkPlans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `DCounties2BenchmarkPlans` ADD CONSTRAINT `DCounties2BenchmarkPlans_ibfk_3` FOREIGN KEY (`countyId`) REFERENCES `DCounties` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT `DCounties2BenchmarkPlans_ibfk_2` FOREIGN KEY (`benchmarkId`) REFERENCES `BenchmarkPlans` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `FPL` ADD CONSTRAINT `FPL_ibfk_1` FOREIGN KEY (`yearId`) REFERENCES `FPLYears` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `ZipCodes` ADD CONSTRAINT `ZipCodes_ibfk_1` FOREIGN KEY (`countyId`) REFERENCES `DCounties` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;