HEAD|76d6deb6-d3db-43f3-9846-f9de2e58dd5f|ACA Automation
EEID|200000002|200000002|AARON||CRANE|M|11/29/1981
OFFR|200000002|Qualifying Event - QE- Future date|Qualifying Event - QE- Future date|01/01/2016|03/01/2016|01/01/2016|12/31/2016|08/05/2016 12:53:32.5332 PM
OFFR|200000002|Qualifying Event - QE- Future date|Qualifying Event - QE- Future date|01/01/2016|03/01/2016|01/01/2016|12/31/2016|08/08/2016 12:26:02.262 PM
OFFR|200000002|Qualifying Event - QE- Future date|Qualifying Event - QE- Future date|01/01/2016|03/01/2016|01/01/2016|12/31/2016|08/16/2016 12:54:50.5450 PM
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE|Employee|Y|140.00|1150.00|Y|Y|N|N|Y|89.15|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE|Employee|Y|140.00|1150.00|Y|Y|N|N|Y|89.15|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE|Employee|Y|140.00|1150.00|Y|Y|N|N|Y|89.15|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE+Family|Employee + Family|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE+Family|Employee + Family|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE+Family|Employee + Family|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE + CH|Employee + 1|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE + CH|Employee + 1|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE + CH|Employee + 1|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE + SP|Employee + Spouse|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE + SP|Employee + Spouse|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|EE + SP|Employee + Spouse|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|Employee + Child|Employee + Child|Y|40.00|760.00|Y|Y|N|N|Y|95.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|Employee + Child|Employee + Child|Y|40.00|760.00|Y|Y|N|N|Y|95.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanOne_OLD|BSG plan one|Employee + Child|Employee + Child|Y|40.00|760.00|Y|Y|N|N|Y|95.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
ELIG|200000002|Qualifying Event - QE- Future date|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|200000002|Qualifying Event - QE- Future date|01/01/2016|BSGPlanOne_OLD|BSG plan one|EE|Employee|140.00|1150.00|03/01/2016||||||||08/05/2016 12:00:00.00 AM
COVG|200000002|Qualifying Event - QE- Future date|01/01/2016|BSGPlanOne_OLD|BSG plan one|EE|Employee|140.00|1150.00|03/01/2016||||||||08/05/2016 12:00:00.00 AM
COVG|200000002|Qualifying Event - QE- Future date|01/01/2016|BSGPlanOne_OLD|BSG plan one|EE|Employee|140.00|1150.00|03/01/2016||||||||08/05/2016 12:00:00.00 AM
EEID|200000008|200000008|IRIS||CARSON|M|07/24/1983
OFFR|200000008|Qualifying Event - Admin Change|Qualifying Event - Admin Change|03/01/2016|03/01/2016|01/01/2016|12/31/2016|08/08/2016 02:17:49.1749 PM
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE|Employee|Y|130.00|230.00|Y|Y|Y|Y|Y|63.89|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE+Family|Employee + Family|Y|135.00|240.00|Y|Y|Y|Y|Y|64.00|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE + CH|Employee + 1|Y|133.00|232.00|Y|Y|Y|Y|Y|63.56|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE + SP|Employee + Spouse|Y|122.00|248.00|Y|Y|Y|Y|Y|67.03|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|Employee + Child|Employee + Child|Y|133.00|232.00|Y|Y|Y|Y|Y|63.56|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE|Employee|Y|130.00|230.00|Y|Y|Y|N|Y|63.89|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE+Family|Employee + Family|Y|135.00|240.00|Y|Y|Y|N|Y|64.00|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE + CH|Employee + 1|Y|133.00|232.00|Y|Y|Y|N|Y|63.56|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE + SP|Employee + Spouse|Y|122.00|248.00|Y|Y|Y|N|Y|67.03|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|Employee + Child|Employee + Child|Y|133.00|232.00|Y|Y|Y|N|Y|63.56|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|200000008|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|200000008|Qualifying Event - Admin Change|03/01/2016|BSGPThree+OLD|BSG plan Three Plus|EE|Employee|130.00|230.00|03/01/2016||||||||08/08/2016 12:00:00.00 AM
EEID|200000017|200000017|ADRIANA||NAVARRETE|M|12/23/1976
OFFR|200000017|Qualifying Event - Admin Change|Qualifying Event - Admin Change|03/01/2016|03/01/2016|01/01/2016|12/31/2016|08/08/2016 03:13:51.1351 PM
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE|Employee|Y|130.00|230.00|Y|Y|Y|Y|Y|63.89|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE+Family|Employee + Family|Y|135.00|240.00|Y|Y|Y|Y|Y|64.00|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE + CH|Employee + 1|Y|133.00|232.00|Y|Y|Y|Y|Y|63.56|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE + SP|Employee + Spouse|Y|122.00|248.00|Y|Y|Y|Y|Y|67.03|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|Employee + Child|Employee + Child|Y|133.00|232.00|Y|Y|Y|Y|Y|63.56|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE|Employee|Y|130.00|230.00|Y|Y|Y|N|Y|63.89|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE+Family|Employee + Family|Y|135.00|240.00|Y|Y|Y|N|Y|64.00|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE + CH|Employee + 1|Y|133.00|232.00|Y|Y|Y|N|Y|63.56|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE + SP|Employee + Spouse|Y|122.00|248.00|Y|Y|Y|N|Y|67.03|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|Employee + Child|Employee + Child|Y|133.00|232.00|Y|Y|Y|N|Y|63.56|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|200000017|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|200000017|Qualifying Event - Admin Change|03/01/2016|BSGPlanThre_OLD|BSG plan Three|EE|Employee|130.00|230.00|03/01/2016||||||||08/08/2016 12:00:00.00 AM
EEID|200000001|200000001|DANISSE||SALOMON|M|05/14/1963
OFFR|200000001|Qualifying Event - Admin Change|Qualifying Event - Admin Change|03/01/2016|03/01/2016|01/01/2016|12/31/2016|08/08/2016 11:50:30.5030 AM
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanTwo_OLD|BSG plan Two|EE|Employee|Y|120.00|220.00|Y|Y|N|Y|Y|64.71|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanTwo_OLD|BSG plan Two|EE+Family|Employee + Family|Y|125.00|225.00|Y|Y|N|Y|Y|64.29|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanTwo_OLD|BSG plan Two|EE + CH|Employee + 1|Y|125.00|225.00|Y|Y|N|Y|Y|64.29|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanTwo_OLD|BSG plan Two|EE + SP|Employee + Spouse|Y|125.00|225.00|Y|Y|N|Y|Y|64.29|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|200000001|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|200000001|Qualifying Event - Admin Change|03/01/2016|BSGPlanTwo_OLD|BSG plan Two|EE|Employee|120.00|220.00|03/01/2016||||||||08/08/2016 12:00:00.00 AM
EEID|100000027|100000027|STEVE||ZAEH|M|02/21/1953
OFFR|100000027|Qualifying Event - Admin Change|Qualifying Event - Admin Change|03/02/2016|03/02/2016|01/01/2016|12/31/2016|08/09/2016 05:02:48.248 PM
ELIG|100000027|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|100000027|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000027|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000027|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000027|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|100000027|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|100000027|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|100000027|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|100000027|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|100000027|Qualifying Event - Admin Change|03/02/2016|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|240.00|410.00|03/02/2016||||||||08/09/2016 12:00:00.00 AM
EEID|100000028|100000028|GARY||RICE|M|05/01/1955
OFFR|100000028|Qualifying Event - Admin Change|Qualifying Event - Admin Change|03/02/2016|03/02/2016|01/01/2016|12/31/2016|08/09/2016 04:43:55.4355 PM
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanOne_OLD|BSG plan one|EE|Employee|Y|140.00|1150.00|Y|Y|N|N|Y|89.15|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanOne_OLD|BSG plan one|EE+Family|Employee + Family|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanOne_OLD|BSG plan one|EE + CH|Employee + 1|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanOne_OLD|BSG plan one|EE + SP|Employee + Spouse|Y|142.50|1167.50|Y|Y|N|N|Y|89.12|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanOne_OLD|BSG plan one|Employee + Child|Employee + Child|Y|40.00|760.00|Y|Y|N|N|Y|95.00|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|100000028|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|100000028|Qualifying Event - Admin Change|03/02/2016|BSGPlanFour+OLD|BSG Plan Four|EE + F|Employee + Family|250.00|420.00|03/02/2016||||||||08/09/2016 12:00:00.00 AM
DEPI|100000028|110000028|110000028|Sp||Sp|Spouse|Y|01/01/1980|F|03/02/2016||A|100000028
DEPI|100000028|120000028|120000028|Ch||Ch|Natural child|N|01/01/2010|M|03/02/2016||A|100000028
EEID|200000004|200000004|BAMBI||ALANIS|M|05/09/1979
OFFR|200000004|Qualifying Event - Admin Change|Qualifying Event - Admin Change|03/01/2016|03/01/2016|01/01/2016|12/31/2016|08/08/2016 01:59:21.5921 PM
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE|Employee|Y|130.00|230.00|Y|Y|Y|Y|Y|63.89|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE+Family|Employee + Family|Y|135.00|240.00|Y|Y|Y|Y|Y|64.00|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE + CH|Employee + 1|Y|133.00|232.00|Y|Y|Y|Y|Y|63.56|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE + SP|Employee + Spouse|Y|122.00|248.00|Y|Y|Y|Y|Y|67.03|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|Employee + Child|Employee + Child|Y|133.00|232.00|Y|Y|Y|Y|Y|63.56|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE|Employee|Y|130.00|230.00|Y|Y|Y|N|Y|63.89|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE+Family|Employee + Family|Y|135.00|240.00|Y|Y|Y|N|Y|64.00|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE + CH|Employee + 1|Y|133.00|232.00|Y|Y|Y|N|Y|63.56|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE + SP|Employee + Spouse|Y|122.00|248.00|Y|Y|Y|N|Y|67.03|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|Employee + Child|Employee + Child|Y|133.00|232.00|Y|Y|Y|N|Y|63.56|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|200000004|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|200000004|Qualifying Event - Admin Change|03/01/2016|BSGPlanThre_OLD|BSG plan Three|EE + F|Employee + Family|135.00|240.00|03/01/2016||||||||08/08/2016 12:00:00.00 AM
DEPI|200000004|200000033|200000033|Neeta||ALANIS|Spouse|Y|01/01/1987|F|03/01/2016||A|200000004
DEPI|200000004|200000026|200000026|TERESA||WRIGHT|Natural child|N|04/23/2013|M|03/01/2016||A|200000004
EEID|100000002|100000002|GINA||HUNTER|M|12/13/1968
OFFR|100000002|Qualifying Event - Admin Change|Qualifying Event - Admin Change|03/01/2016|03/01/2016|01/01/2016|12/31/2016|08/05/2016 12:08:39.839 PM
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE|Employee|Y|130.00|230.00|Y|Y|Y|Y|Y|63.89|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE+Family|Employee + Family|Y|135.00|240.00|Y|Y|Y|Y|Y|64.00|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE + CH|Employee + 1|Y|133.00|232.00|Y|Y|Y|Y|Y|63.56|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|EE + SP|Employee + Spouse|Y|122.00|248.00|Y|Y|Y|Y|Y|67.03|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanThre_OLD|BSG plan Three|Employee + Child|Employee + Child|Y|133.00|232.00|Y|Y|Y|Y|Y|63.56|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE|Employee|Y|130.00|230.00|Y|Y|Y|N|Y|63.89|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE+Family|Employee + Family|Y|135.00|240.00|Y|Y|Y|N|Y|64.00|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE + CH|Employee + 1|Y|133.00|232.00|Y|Y|Y|N|Y|63.56|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|EE + SP|Employee + Spouse|Y|122.00|248.00|Y|Y|Y|N|Y|67.03|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPThree+OLD|BSG plan Three Plus|Employee + Child|Employee + Child|Y|133.00|232.00|Y|Y|Y|N|Y|63.56|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE|Employee|Y|240.00|410.00|Y|Y|Y|Y|Y|63.08|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE+Family|Employee + Family|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + CH|Employee + 1|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanFour+OLD|BSG Plan Four|EE + SP|Employee + Spouse|Y|250.00|420.00|Y|Y|Y|Y|Y|62.69|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE|Employee|Y|50.00|150.00|Y|Y|Y|Y|Y|75.00|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE+Family|Employee + Family|Y|75.00|175.00|Y|Y|Y|Y|Y|70.00|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + CH|Employee + 1|Y|65.00|160.00|Y|Y|Y|Y|Y|71.11|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|EE + SP|Employee + Spouse|Y|60.00|175.00|Y|Y|Y|Y|Y|74.47|Y|
ELIG|100000002|Qualifying Event - Admin Change|BSGPlanFive_OLD|BSG Plan Five|Employee + Child|Employee + Child|Y|70.00|180.00|Y|Y|Y|Y|Y|72.00|Y|
COVG|100000002|Qualifying Event - Admin Change|03/01/2016|BSGPlanThre_OLD|BSG plan Three|EE|Employee|130.00|230.00|03/01/2016||||||||08/05/2016 12:00:00.00 AM
FOOT|8