October 12, 2018 at 5:52 pm
I asked a developer to write a simple query against this table of mine. He looked at me and said "do it yourself, this is garbage." It's a table that holds insurance records and this is one person. Every time they make a change in insurance, a new row is added. He said I should just update the table rather than add a new row, LOL. How will I know the history if I do that? There are about 13K rows of data for 800 people. I told him to ignore the duplicates by using the latest intID, the old ones are for history only. Easy, right?
| intID | Fkey | Univ_ID | dtmDate | Enroll_date | Initial_enroll | New_hire | New_hire_date | Change_status | Change_status_date | DP | add_dp_date | Add_fam | Add_fam_date | add_fam_reason | Add_fam_other | Change_family | Change_family_date | Delete_family | Delete_family_date | Delete_family_reason | Delete_family_other | Cancel_waiver | Cancel_waiver_date | Waive_med | Waive_dent | Decline_vis | Decline_covered | Decline_covered_other | Decline_covered_reason | Decline_dp | Decline_child | Decline_dep_covered | Decline_dep_covered_other | Decline_dep_covered_reason | Enroll_med | Enroll_dent | Enroll_vis | Enroll_self | self_med | PCP_self | PCD_self | self_dent | self_vis | Disabled_self | Enroll_dp | Last_name_dp | MI_dp | First_name_dp | DOB_dp | SSN_dp | gender_dp | dp_med | dp_dent | dp_vis | PCP_dp | PCD_dp | Disabled_dp | start_dp | end_dp | Enroll_child1 | Last_name_child1 | MI_child1 | First_name_child1 | DOB_child1 | SSN_child1 | gender_child1 | Student_child1 | child1_med | child1_dent | child1_vis | PCP_child1 | PCD_child1 | Disabled_child1 | start_child1 | end_child1 | Enroll_child2 | Last_name_child2 | MI_child2 | First_name_child2 | DOB_child2 | SSN_child2 | gender_child2 | Student_child2 | child2_med | child2_dent | child2_vis | PCP_child2 | PCD_child2 | Disabled_child2 | start_child2 | end_child2 | Enroll_child3 | Last_name_child3 | MI_child3 | First_name_child3 | DOB_child3 | SSN_child3 | gender_child3 | Student_child3 | child3_med | child3_dent | child3_vis | PCP_child3 | PCD_child3 | Disabled_child3 | start_child3 | end_child3 | Enroll_child4 | Last_name_child4 | MI_child4 | First_name_child4 | DOB_child4 | SSN_child4 | gender_child4 | Student_child4 | child4_med | child4_dent | child4_vis | PCP_child4 | PCD_child4 | Disabled_child4 | start_child4 | end_child4 | Enroll_child5 | Last_name_child5 | MI_child5 | First_name_child5 | DOB_child5 | SSN_child5 | gender_child5 | Student_child5 | child5_med | child5_dent | child5_vis | PCP_child5 | PCD_child5 | Disabled_child5 | start_child5 | end_child5 | Benif1 | Benif1_relation | Benif1_DOB | Benif1_address | Benif1_percent | Benif2 | Benif2_relation | Benif2_DOB | Benif2_address | Benif2_percent | Benif3 | Benif3_relation | Benif3_DOB | Benif3_address | Benif3_percent | Contingent1 | Contingent1_relation | Contingent1_DOB | Contingent1_address | Contingent1_percent | Contingent2 | Contingent2_relation | Contingent2_DOB | Contingent2_address | Contingent2_percent | Contingent3 | Contingent3_relation | Contingent3_DOB | Contingent3_address | Contingent3_percent | Life | Premium | COBRA | Ins_privacy | marketplace | IP | Open_enroll | Waive_all | OE_reason | PCDA_self | PCDA_dp | PCDA_child1 | PCDA_child2 | PCDA_child3 | PCDA_child4 | PCDA_child5 | MHMO_P | MHMO_PS | MHMO_PC | MHMO_F | MPPO_P | MPPO_PS | MPPO_PC | MPPO_F | KMP_P | KMP_PS | KMP_PC | KMP_F | DHMO_P | DHMO_PS | DHMO_PC | DHMO_F | DPPO_P | DPPO_PS | DPPO_PC | DPPO_F | VIS_P | VIS_PS | VIS_PC | VIS_F | MHMO_P_ALT | MHMO_PS_ALT | MHMO_PC_ALT | MHMO_F_ALT | MPPO_P_ALT | MPPO_PS_ALT | MPPO_PC_ALT | MPPO_F_ALT | KMP_P_ALT | KMP_PS_ALT | KMP_PC_ALT | KMP_F_ALT | DHMO_P_ALT | DHMO_PS_ALT | DHMO_PC_ALT | DHMO_F_ALT | DPPO_P_ALT | DPPO_PS_ALT | DPPO_PC_ALT | DPPO_F_ALT | VIS_P_ALT | VIS_PS_ALT | VIS_PC_ALT | VIS_F_ALT | LIFE_P | LIFE_P_ALT | BI_PREM | BI_PREM_ALT | BI_MED | BI_MED_ALT | BI_DEN | BI_DEN_ALT | BI_VIS | BI_VIS_ALT | BI_LIFE | BI_LIFE_ALT | Privacy | Terms | role_dependent1 | intFormType | intWizard | intWaiverStep | mnthAmount |
| 9946 | 1630 | aaa | 4/4/2016 8:33 | 4/4/2016 0:00 | NULL | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | AHMO_E | NULL | NULL | E | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | NULL | 12.251.7.18 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 0 | NULL | 0 | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 9947 | 1630 | aaa | 4/4/2016 8:34 | 4/4/2016 0:00 | NULL | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | AHMO_E | NULL | NULL | E | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 29.06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 29.06 | 29.06 | 29.06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 9951 | 1630 | aaa | 4/4/2016 9:43 | 4/4/2016 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | W | W | NULL | Y | NULL | NULL | Y | Y | Y | NULL | NULL | AHMO_E | NULL | NULL | D | Y | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 11.08 | Y | Y | Y | 151.152.101.44 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 0 | NULL | 0 | NULL | 0 | NULL | Y | Y | NULL | NULL | NULL | NULL | NULL |
| 9952 | 1630 | aaa | 4/4/2016 9:59 | 4/4/2016 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | W | W | NULL | Y | NULL | NULL | Y | Y | Y | NULL | NULL | AHMO_C | NULL | NULL | D | N | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL |
| 9955 | 1630 | aaa | 4/4/2016 11:27 | 4/4/2016 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | W | W | NULL | Y | NULL | NULL | Y | Y | Y | NULL | NULL | AHMO_C | NULL | NULL | D | N | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL |
| 9980 | 1630 | aaa | 4/4/2016 11:27 | 4/4/2016 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | W | W | NULL | Y | NULL | NULL | Y | Y | Y | NULL | NULL | AHMO_C | NULL | NULL | D | N | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 10590 | 1630 | aaa | 9/1/2016 12:45 | 4/4/2016 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | W | W | NULL | Y | NULL | NULL | Y | Y | Y | NULL | NULL | AHMO_C | NULL | NULL | D | N | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 11038 | 1630 | aaa | 11/3/2016 15:21 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 1/12xxxx 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 11.08 | Y | Y | Y | 151.152.101.44 | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 0 | NULL | 0 | NULL | 0 | NULL | Y | Y | NULL | NULL | NULL | NULL | NULL |
| 11103 | 1630 | aaa | 11/10/2016 13:32 | 4/4/2016 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | W | W | NULL | Y | NULL | NULL | Y | Y | Y | NULL | NULL | AHMO_C | NULL | NULL | D | N | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | xxx | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | D | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
| 11349 | 1630 | aaa | 12/19/2016 16:00 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 1/12/x 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 11.08 | Y | Y | Y | 151.152.101.44 | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 0 | NULL | 0 | NULL | 0 | NULL | Y | Y | NULL | NULL | NULL | NULL | NULL |
| 11544 | 1630 | aaa | 12/20/2016 13:42 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 1/12/x 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68.86 | 0 | 0 | 0 | 10.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86.69 | 0 | 68.86 | 0 | 10.52 | 0 | 7.31 | 0 | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL |
| 12002 | 1630 | aaa | 4/6/2017 10:42 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 1/12/x 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68.86 | 0 | 0 | 0 | 10.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86.69 | 0 | 68.86 | 0 | 10.52 | 0 | 7.31 | 0 | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL |
| 12195 | 1630 | aaa | 6/8/2017 9:33 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 1/12/x12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68.86 | 0 | 0 | 0 | 10.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86.69 | 0 | 68.86 | 0 | 10.52 | 0 | 7.31 | 0 | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL |
| 12439 | 1630 | aaa | 7/21/2017 15:50 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | E | xxx | NULL | xxx | 1/12/x 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68.86 | 0 | 0 | 0 | 10.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86.69 | 0 | 68.86 | 0 | 10.52 | 0 | 7.31 | 0 | 0 | 0 | Y | Y | NULL | NULL | NULL | NULL | NULL |
| 12514 | 1630 | aaa | 8/3/2017 12:53 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | E | xxx | NULL | xxx | 1/12/x 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68.86 | 0 | 0 | 0 | 10.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86.69 | 0 | 68.86 | 0 | 10.52 | 0 | 7.31 | 0 | 0 | 0 | Y | Y | NULL | 0 | 0 | 0 | 0 |
| 12812 | 1630 | aaa | 9/14/2017 8:52 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | E | xxx | NULL | xxx | 1/12/x 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 68.86 | 0 | 0 | 0 | 10.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 86.69 | 0 | 68.86 | 0 | 10.52 | 0 | 7.31 | 0 | 0 | 0 | Y | Y | NULL | 0 | 0 | 0 | 0 |
| 13681 | 1630 | aaa | 12/28/2017 16:38 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | E | xxx | NULL | xxx | 1/12/x12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 69.42 | 0 | 0 | 0 | 10.74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 87.47 | 0 | 69.42 | 0 | 10.74 | 0 | 7.31 | 0 | 0 | 0 | Y | Y | NULL | 0 | 0 | 0 | 0 |
| 14936 | 1630 | aaa | 8/2/2018 16:29 | 4/4/2016 0:00 | NULL | Y | 3/28/2016 0:00 | NULL | NULL | NULL | NULL | Y | NULL | Open Enrollment | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | D | NULL | NULL | NULL | NULL | NULL | F | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | E | xxx | NULL | xxx | 1/12/x 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | 162943 | NULL | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 69.42 | 0 | 0 | 0 | 10.74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.31 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 87.47 | 0 | 69.42 | 0 | 10.74 | 0 | 7.31 | 0 | 0 | 0 | Y | Y | NULL | 0 | 0 | 0 | 0 |
| 15323 | 1630 | aaa | 9/21/2018 16:53 | 4/4/2016 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 10/1/2018 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | E | NULL | Ahmed | 3/12/xxx 12:00:00 AM | NULL | M | Y | Y | Y | NULL | NULL | NULL | NULL | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | E | xxx | NULL | xxx | 1/12/x 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 12.46 | Y | Y | Y | 151.152.101.44 | NULL | NULL | NULL | 162943 | 162943 | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 0 | NULL | 0 | NULL | 0 | NULL | Y | Y | NULL | 0 | 0 | 0 | 0 | |
| 15344 | 1630 | aaa | 9/27/2018 15:46 | 4/4/2016 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Y | 10/1/2018 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Kaiser_E | DHMO_E | E | E | Y | NULL | NULL | Y | Y | NULL | E | NULL | Ahmed | 3/12/xxx 12:00:00 AM | NULL | M | Y | Y | Y | NULL | NULL | NULL | 10/1/2018 0:00 | NULL | E | xxx | NULL | xxx | 2/11/xxxx 12:00:00 AM | NULL | F | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | E | xxx | NULL | xxx | 1/12/x 12:00:00 AM | NULL | M | N | Y | Y | Y | NULL | NULL | NULL | 1/1/2017 0:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | Y | Y | Y | NULL | NULL | NULL | NULL | 162943 | 162943 | 162943 | 162943 | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 100.27 | 0 | 0 | 0 | 14.14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.74 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 125.15 | 0 | 100.27 | 0 | 14.14 | 0 | 10.74 | 0 | 0 | 0 | Y | Y | NULL | 0 | 0 | 0 | 0 |
October 12, 2018 at 7:31 pm
So what is the question and what have you done to solve the problem?
October 13, 2018 at 4:01 am
What you do is what he said. You have one table with one record (the most recent updates). If you want version history, keep the individual rows in a history table with the date the record was archived.
October 13, 2018 at 5:53 am
Brandie Tarvin - Saturday, October 13, 2018 4:01 AMWhat you do is what he said. You have one table with one record (the most recent updates). If you want version history, keep the individual rows in a history table with the date the record was archived.
It depends ....
In most cases, the above advice is good. However, as always, there are exceptions.
On our busiest system we have a high-volume table that currently requires 405K individual upserts per minute. Each upsert is as a result of a real person clicking a button on a web page, and has a financial impact, so it needs proper auditing. In order to handle the volume, we simply always add a new record. We also use a composite clustered key to prevent hot-spotting. When reading, we then look for the most recent record per PK.
October 13, 2018 at 6:02 am
I'm not sure from your question what the column name is for a person? but you would need a query like this to get the most recent row for each person.;WITH CTE AS
(
SELECT DISTINCT PersonId
FROM myTable
)
SELECT B.*
FROM CTE A
CROSS APPLY(SELECT TOP(1) *
FROM myTable B
WHERE B.PersonId = A.PersonId
ORDER BY intID DESC) AS B
You will also need an index to make it perform well:CREATE UNIQUE INDEX IX_MyTable_1 ON MyTable(PersonId, intID)
October 13, 2018 at 10:23 am
DesNorton - Saturday, October 13, 2018 5:53 AMBrandie Tarvin - Saturday, October 13, 2018 4:01 AMWhat you do is what he said. You have one table with one record (the most recent updates). If you want version history, keep the individual rows in a history table with the date the record was archived.It depends ....
In most cases, the above advice is good. However, as always, there are exceptions.
On our busiest system we have a high-volume table that currently requires 405K individual upserts per minute. Each upsert is as a result of a real person clicking a button on a web page, and has a financial impact, so it needs proper auditing. In order to handle the volume, we simply always add a new record. We also use a composite clustered key to prevent hot-spotting. When reading, we then look for the most recent record per PK.
considering we're talking insurance - history is key. Keeping accurate records of who had what, when, is a fairly critical concept (but I suspect that Brandie knows that !)
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
October 13, 2018 at 10:36 am
Hmmm.... this is all starting to sound a bit different than what the actual wording of the post might convey. Please see the following...
https://www.sqlservercentral.com/Forums/2002689/Query-slow-Help-improve?Update=1#bm2002914
--Jeff Moden
Change is inevitable... Change for the better is not.
October 13, 2018 at 12:55 pm
Matt Miller (4) - Saturday, October 13, 2018 10:23 AMDesNorton - Saturday, October 13, 2018 5:53 AMBrandie Tarvin - Saturday, October 13, 2018 4:01 AMWhat you do is what he said. You have one table with one record (the most recent updates). If you want version history, keep the individual rows in a history table with the date the record was archived.It depends ....
In most cases, the above advice is good. However, as always, there are exceptions.
On our busiest system we have a high-volume table that currently requires 405K individual upserts per minute. Each upsert is as a result of a real person clicking a button on a web page, and has a financial impact, so it needs proper auditing. In order to handle the volume, we simply always add a new record. We also use a composite clustered key to prevent hot-spotting. When reading, we then look for the most recent record per PK.
considering we're talking insurance - history is key. Keeping accurate records of who had what, when, is a fairly critical concept (but I suspect that Brandie knows that !)
Why yes, I do. @=)
In fact, the versioning is what we do at my office (also an insurance company). Because the users need to see the actual current record, but agents, etc. need to see history via reporting. So the versioning is in a reporting database, accessible at need, and the current record is in the OLTP database. Actually, we have a history table in the OLTP database too, but it's replicated to the reporting db every day so that the reports don't hit current production.
October 15, 2018 at 3:45 pm
I'm actually restructuring all of the tables that this guy (the OP) created.
Flat tables, no normalization, insane naming conventions, no indexing, all nullable, multiple rows per clientid (fkLogin for "foreign key" Login. Not even a foreign key, he just calls it that) .
His queries for finding the latest row for each fkLogin are amazingly entertaining. Sample of his work for another table he has.
SELECT intID,
(SELECT TOP 1 First_name FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS First_name,
(SELECT TOP 1 Last_name FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS Last_name,
(SELECT TOP 1 Email FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS Email,
(SELECT TOP 1 Start_date FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS Start_date,
(SELECT TOP 1 End_date FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS End_date,
isnull((SELECT TOP 1 mnthAmount FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC),0) AS mnthAmount,
isnull((SELECT TOP 1 medPlan FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC),'NONE') AS medPlan,
(SELECT TOP 1 okBatch FROM xxx.MyTable WHERE fkLogin =xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS okBatch
FROM gpowers.mstr_tbl_Login
WHERE fkClientID = 16 AND (SELECT TOP 1 okBatch FROM [xxx].[MyTable] WHERE fkLogin = xxx.mstr_tbl_Login.intID ORDER BY intID DESC) = 'y'
ORDER BY strLName ASC
I just use a CTE and partition over fkLogin order by intId DESC then pull only row number 1 from the cte.
;with myCTE(RowNum, First, Last .......)
as(
ROW_NUMBER() OVER (PARTITION BY a.fkLogin ORDER BY a.intID DESC) -- Another intId in MyTable, not mst_tbl_Login
,a.First
,a.Last
,
.
from MyTable a
join mstr_tbl_Login b on b.intId = a.fkLogin
where a.OKBatch = 'Y' and b.fkClientId = 16
)
select first, last ..... from myCTE where RowNum = 1
October 15, 2018 at 4:58 pm
SQLStud 74876 - Monday, October 15, 2018 3:45 PMI'm actually restructuring all of the tables that this guy (the OP) created.
Flat tables, no normalization, insane naming conventions, no indexing, all nullable, multiple rows per clientid (fkLogin for "foreign key" Login. Not even a foreign key, he just calls it that) .
His queries for finding the latest row for each fkLogin are amazingly entertaining. Sample of his work for another table he has.
SELECT intID,
(SELECT TOP 1 First_name FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS First_name,
(SELECT TOP 1 Last_name FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS Last_name,
(SELECT TOP 1 Email FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS Email,
(SELECT TOP 1 Start_date FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS Start_date,
(SELECT TOP 1 End_date FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS End_date,
isnull((SELECT TOP 1 mnthAmount FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC),0) AS mnthAmount,
isnull((SELECT TOP 1 medPlan FROM xxx.MyTable WHERE fkLogin = xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC),'NONE') AS medPlan,
(SELECT TOP 1 okBatch FROM xxx.MyTable WHERE fkLogin =xxx.mstr_tbl_Login.intID AND okBatch = 'y' ORDER BY intID DESC) AS okBatch
FROM gpowers.mstr_tbl_Login
WHERE fkClientID = 16 AND (SELECT TOP 1 okBatch FROM [xxx].[MyTable] WHERE fkLogin = xxx.mstr_tbl_Login.intID ORDER BY intID DESC) = 'y'
ORDER BY strLName ASCI just use a CTE and partition over fkLogin order by intId DESC then pull only row number 1 from the cte.
;with myCTE(RowNum, First, Last .......)
as(
ROW_NUMBER() OVER (PARTITION BY a.fkLogin ORDER BY a.intID DESC) -- Another intId in MyTable, not mst_tbl_Login
,a.First
,a.Last
,
.
from MyTable a
join mstr_tbl_Login b on b.intId = a.fkLogin
where a.OKBatch = 'Y' and b.fkClientId = 16
)select first, last ..... from myCTE where RowNum = 1
Good lord.... I worked with a couple of moroffs that wrote code like the first one above and they claimed to be "experts" in both the front end and in T-SQL. Then they blamed the person in QA for "simply selecting too much data at one time" (by date span for year) when it ran for 12 minutes and timed out. When I got done with the rewrite, it ran so fast that QA thought it couldn't have possibly executed correctly.
I don't want or need to know the name of the company that you're trying to help. I can tell you that you have several kindred spirits on this forum that would do the same and, although I can't speak for them, I'm pretty happy to see someone new to these forums take such a bull by the horns and just "do it right". My hat's off to you
Heh... and thanks for the entertaining posts. I could "feel" your agony.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 21, 2018 at 9:50 am
SQLStud 74876 - Friday, October 12, 2018 5:52 PMI asked a developer to write a simple query against this table of mine. He looked at me and said "do it yourself, this is garbage." It's a table that holds insurance records and this is one person. Every time they make a change in insurance, a new row is added. He said I should just update the table rather than add a new row, LOL. How will I know the history if I do that? There are about 13K rows of data for 800 people. I told him to ignore the duplicates by using the latest intID, the old ones are for history only. Easy, right?
intID Fkey Univ_ID dtmDate Enroll_date Initial_enroll New_hire New_hire_date Change_status Change_status_date DP add_dp_date Add_fam Add_fam_date add_fam_reason Add_fam_other Change_family Change_family_date Delete_family Delete_family_date Delete_family_reason Delete_family_other Cancel_waiver Cancel_waiver_date Waive_med Waive_dent Decline_vis Decline_covered Decline_covered_other Decline_covered_reason Decline_dp Decline_child Decline_dep_covered Decline_dep_covered_other Decline_dep_covered_reason Enroll_med Enroll_dent Enroll_vis Enroll_self self_med PCP_self PCD_self self_dent self_vis Disabled_self Enroll_dp Last_name_dp MI_dp First_name_dp DOB_dp SSN_dp gender_dp dp_med dp_dent dp_vis PCP_dp PCD_dp Disabled_dp start_dp end_dp Enroll_child1 Last_name_child1 MI_child1 First_name_child1 DOB_child1 SSN_child1 gender_child1 Student_child1 child1_med child1_dent child1_vis PCP_child1 PCD_child1 Disabled_child1 start_child1 end_child1 Enroll_child2 Last_name_child2 MI_child2 First_name_child2 DOB_child2 SSN_child2 gender_child2 Student_child2 child2_med child2_dent child2_vis PCP_child2 PCD_child2 Disabled_child2 start_child2 end_child2 Enroll_child3 Last_name_child3 MI_child3 First_name_child3 DOB_child3 SSN_child3 gender_child3 Student_child3 child3_med child3_dent child3_vis PCP_child3 PCD_child3 Disabled_child3 start_child3 end_child3 Enroll_child4 Last_name_child4 MI_child4 First_name_child4 DOB_child4 SSN_child4 gender_child4 Student_child4 child4_med child4_dent child4_vis PCP_child4 PCD_child4 Disabled_child4 start_child4 end_child4 Enroll_child5 Last_name_child5 MI_child5 First_name_child5 DOB_child5 SSN_child5 gender_child5 Student_child5 child5_med child5_dent child5_vis PCP_child5 PCD_child5 Disabled_child5 start_child5 end_child5 Benif1 Benif1_relation Benif1_DOB Benif1_address Benif1_percent Benif2 Benif2_relation Benif2_DOB Benif2_address Benif2_percent Benif3 Benif3_relation Benif3_DOB Benif3_address Benif3_percent Contingent1 Contingent1_relation Contingent1_DOB Contingent1_address Contingent1_percent Contingent2 Contingent2_relation Contingent2_DOB Contingent2_address Contingent2_percent Contingent3 Contingent3_relation Contingent3_DOB Contingent3_address Contingent3_percent Life Premium COBRA Ins_privacy marketplace IP Open_enroll Waive_all OE_reason PCDA_self PCDA_dp PCDA_child1 PCDA_child2 PCDA_child3 PCDA_child4 PCDA_child5 MHMO_P MHMO_PS MHMO_PC MHMO_F MPPO_P MPPO_PS MPPO_PC MPPO_F KMP_P KMP_PS KMP_PC KMP_F DHMO_P DHMO_PS DHMO_PC DHMO_F DPPO_P DPPO_PS DPPO_PC DPPO_F VIS_P VIS_PS VIS_PC VIS_F MHMO_P_ALT MHMO_PS_ALT MHMO_PC_ALT MHMO_F_ALT MPPO_P_ALT MPPO_PS_ALT MPPO_PC_ALT MPPO_F_ALT KMP_P_ALT KMP_PS_ALT KMP_PC_ALT KMP_F_ALT DHMO_P_ALT DHMO_PS_ALT DHMO_PC_ALT DHMO_F_ALT DPPO_P_ALT DPPO_PS_ALT DPPO_PC_ALT DPPO_F_ALT VIS_P_ALT VIS_PS_ALT VIS_PC_ALT VIS_F_ALT LIFE_P LIFE_P_ALT BI_PREM BI_PREM_ALT BI_MED BI_MED_ALT BI_DEN BI_DEN_ALT BI_VIS BI_VIS_ALT BI_LIFE BI_LIFE_ALT Privacy Terms role_dependent1 intFormType intWizard intWaiverStep mnthAmount 9946 1630 aaa 4/4/2016 8:33 4/4/2016 0:00 NULL Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL AHMO_E NULL NULL E Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y NULL 12.251.7.18 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL 0 NULL 0 NULL 0 NULL NULL NULL NULL NULL NULL NULL NULL 9947 1630 aaa 4/4/2016 8:34 4/4/2016 0:00 NULL Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL AHMO_E NULL NULL E Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 29.06 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29.06 29.06 29.06 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 9951 1630 aaa 4/4/2016 9:43 4/4/2016 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL W W NULL Y NULL NULL Y Y Y NULL NULL AHMO_E NULL NULL D Y NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 11.08 Y Y Y 151.152.101.44 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL 0 NULL 0 NULL 0 NULL Y Y NULL NULL NULL NULL NULL 9952 1630 aaa 4/4/2016 9:59 4/4/2016 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL W W NULL Y NULL NULL Y Y Y NULL NULL AHMO_C NULL NULL D N NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y NULL NULL NULL NULL NULL 9955 1630 aaa 4/4/2016 11:27 4/4/2016 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL W W NULL Y NULL NULL Y Y Y NULL NULL AHMO_C NULL NULL D N NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Y Y NULL NULL NULL NULL NULL 9980 1630 aaa 4/4/2016 11:27 4/4/2016 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL W W NULL Y NULL NULL Y Y Y NULL NULL AHMO_C NULL NULL D N NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 10590 1630 aaa 9/1/2016 12:45 4/4/2016 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL W W NULL Y NULL NULL Y Y Y NULL NULL AHMO_C NULL NULL D N NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 11038 1630 aaa 11/3/2016 15:21 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL NULL NULL E xxx NULL xxx 1/12xxxx 12:00:00 AM NULL M N Y Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 11.08 Y Y Y 151.152.101.44 NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL 0 NULL 0 NULL 0 NULL Y Y NULL NULL NULL NULL NULL 11103 1630 aaa 11/10/2016 13:32 4/4/2016 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL W W NULL Y NULL NULL Y Y Y NULL NULL AHMO_C NULL NULL D N NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D xxx NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL D NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL NULL NULL NULL NULL NULL NULL 11349 1630 aaa 12/19/2016 16:00 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL NULL NULL E xxx NULL xxx 1/12/x 12:00:00 AM NULL M N Y Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 11.08 Y Y Y 151.152.101.44 NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL 0 NULL 0 NULL 0 NULL Y Y NULL NULL NULL NULL NULL 11544 1630 aaa 12/20/2016 13:42 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL NULL NULL E xxx NULL xxx 1/12/x 12:00:00 AM NULL M N Y Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 68.86 0 0 0 10.52 0 0 0 0 0 0 0 7.31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 86.69 0 68.86 0 10.52 0 7.31 0 0 0 Y Y NULL NULL NULL NULL NULL 12002 1630 aaa 4/6/2017 10:42 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL NULL NULL E xxx NULL xxx 1/12/x 12:00:00 AM NULL M N Y Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 68.86 0 0 0 10.52 0 0 0 0 0 0 0 7.31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 86.69 0 68.86 0 10.52 0 7.31 0 0 0 Y Y NULL NULL NULL NULL NULL 12195 1630 aaa 6/8/2017 9:33 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL NULL NULL E xxx NULL xxx 1/12/x12:00:00 AM NULL M N Y Y Y NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 68.86 0 0 0 10.52 0 0 0 0 0 0 0 7.31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 86.69 0 68.86 0 10.52 0 7.31 0 0 0 Y Y NULL NULL NULL NULL NULL 12439 1630 aaa 7/21/2017 15:50 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL E xxx NULL xxx 1/12/x 12:00:00 AM NULL M N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 68.86 0 0 0 10.52 0 0 0 0 0 0 0 7.31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 86.69 0 68.86 0 10.52 0 7.31 0 0 0 Y Y NULL NULL NULL NULL NULL 12514 1630 aaa 8/3/2017 12:53 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL E xxx NULL xxx 1/12/x 12:00:00 AM NULL M N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 68.86 0 0 0 10.52 0 0 0 0 0 0 0 7.31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 86.69 0 68.86 0 10.52 0 7.31 0 0 0 Y Y NULL 0 0 0 0 12812 1630 aaa 9/14/2017 8:52 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL E xxx NULL xxx 1/12/x 12:00:00 AM NULL M N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 68.86 0 0 0 10.52 0 0 0 0 0 0 0 7.31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 86.69 0 68.86 0 10.52 0 7.31 0 0 0 Y Y NULL 0 0 0 0 13681 1630 aaa 12/28/2017 16:38 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL E xxx NULL xxx 1/12/x12:00:00 AM NULL M N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 69.42 0 0 0 10.74 0 0 0 0 0 0 0 7.31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 87.47 0 69.42 0 10.74 0 7.31 0 0 0 Y Y NULL 0 0 0 0 14936 1630 aaa 8/2/2018 16:29 4/4/2016 0:00 NULL Y 3/28/2016 0:00 NULL NULL NULL NULL Y NULL Open Enrollment NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL D NULL NULL NULL NULL NULL F NULL NULL NULL NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL E xxx NULL xxx 1/12/x 12:00:00 AM NULL M N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL 162943 NULL 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 69.42 0 0 0 10.74 0 0 0 0 0 0 0 7.31 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 87.47 0 69.42 0 10.74 0 7.31 0 0 0 Y Y NULL 0 0 0 0 15323 1630 aaa 9/21/2018 16:53 4/4/2016 0:00 NULL NULL NULL NULL NULL NULL NULL NULL 10/1/2018 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL E NULL Ahmed 3/12/xxx 12:00:00 AM NULL M Y Y Y NULL NULL NULL NULL NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL E xxx NULL xxx 1/12/x 12:00:00 AM NULL M N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 12.46 Y Y Y 151.152.101.44 NULL NULL NULL 162943 162943 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 NULL 0 NULL 0 NULL 0 NULL Y Y NULL 0 0 0 0 15344 1630 aaa 9/27/2018 15:46 4/4/2016 0:00 NULL NULL NULL NULL NULL NULL NULL Y 10/1/2018 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL Kaiser_E DHMO_E E E Y NULL NULL Y Y NULL E NULL Ahmed 3/12/xxx 12:00:00 AM NULL M Y Y Y NULL NULL NULL 10/1/2018 0:00 NULL E xxx NULL xxx 2/11/xxxx 12:00:00 AM NULL F N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL E xxx NULL xxx 1/12/x 12:00:00 AM NULL M N Y Y Y NULL NULL NULL 1/1/2017 0:00 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 0 0 Y Y Y NULL NULL NULL NULL 162943 162943 162943 162943 NULL NULL NULL 0 0 0 0 0 0 0 0 0 0 0 100.27 0 0 0 14.14 0 0 0 0 0 0 0 10.74 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 125.15 0 100.27 0 14.14 0 10.74 0 0 0 Y Y NULL 0 0 0 0
The table is garbage indeed.
How many changes do you expect to see in SSN_dp or DOB_Child1 columns?
What are they doing in "History" table?
How do you deal with families with 6 children?
What if a child has died?
And what's the deal with these columns?
| Add_fam | Add_fam_date | add_fam_reason | Add_fam_other | Change_family | Change_family_date | Delete_family | Delete_family_date | Delete_family_reason | Delete_family_other |
Aren't add/delete actions are sorts of "change"?
Can a "family" be added after it's been deleted?
It's just a first pick, just to start the conversation.
_____________
Code for TallyGenerator
October 21, 2018 at 11:18 am
Sergiy,
Just so you know, please see the following.
https://www.sqlservercentral.com/Forums/FindPost2003341.aspx
--Jeff Moden
Change is inevitable... Change for the better is not.
October 21, 2018 at 8:06 pm
Jeff Moden - Sunday, October 21, 2018 11:18 AMSergiy,
Just so you know, please see the following.
https://www.sqlservercentral.com/Forums/FindPost2003341.aspx
No, I did not see that.
I must say I strongly disagree with you in this:
Few could be both that ignorant and arrogant about T-SQL, PII, and databases in general, especially all at once.
I recently had an experience with a company working for a major AUS/NZ retailer who had 9 or 10 SQL developers working for them
Want to know how many of them matched your description?
100%.
They maintain CustomerProfile table of 368 columns (the number must be much bigger by now, as 3 columns were added just within a month) which gets rebuilt on average twice a day.
It's rebuilt in a very "sophisticated" way:
1. Truncated.
2. Populated with all current CustomerID's and NULL's in every other column.
3. Updated column by column, one column per UPDATE.
The process takes about 2 hours (they've got very powerful servers).
Because every follow-up process and every report depends on this table there is effectively an outage for 2 hours.
You can imagine - there is a little point in indexing that "one-off" table - so it's all table-scan queries against 3.5 million rows table.
Transaction tables are clustered by TransactionID - I bet you guessed it.
There are about 3 millions of transactions recorded per day.
So, in order to make "last 3 month" aggregations finish before end of tomorrow they "partitioned" it into weekly sections, every one with week number in the name of the table.
Yep, heaps of dynamic SQL, heaps of weekly-recreated UNION ALL views, etc.
Of course, there is no indexing, because it won't make much difference on double-layer views union'ing 13 tables.
And you know - its all considered "up-t-standards" by the management.
That's apparently how it must be done, according to all the white pages they read in recent years.
It's a mainstream now.
They even won some awards for technological achievements last year.
So, go away, you retarded bugger - you don't have a clue about contemporary advanced technologies!
_____________
Code for TallyGenerator
October 22, 2018 at 4:44 am
Sergiy - Sunday, October 21, 2018 8:06 PMJeff Moden - Sunday, October 21, 2018 11:18 AMSergiy,
Just so you know, please see the following.
https://www.sqlservercentral.com/Forums/FindPost2003341.aspxNo, I did not see that.
I must say I strongly disagree with you in this:
Few could be both that ignorant and arrogant about T-SQL, PII, and databases in general, especially all at once.
I recently had an experience with a company working for a major AUS/NZ retailer who had 9 or 10 SQL developers working for them
Want to know how many of them matched your description?
100%.They maintain CustomerProfile table of 368 columns (the number must be much bigger by now, as 3 columns were added just within a month) which gets rebuilt on average twice a day.
It's rebuilt in a very "sophisticated" way:
1. Truncated.
2. Populated with all current CustomerID's and NULL's in every other column.
3. Updated column by column, one column per UPDATE.The process takes about 2 hours (they've got very powerful servers).
Because every follow-up process and every report depends on this table there is effectively an outage for 2 hours.You can imagine - there is a little point in indexing that "one-off" table - so it's all table-scan queries against 3.5 million rows table.
Transaction tables are clustered by TransactionID - I bet you guessed it.
There are about 3 millions of transactions recorded per day.
So, in order to make "last 3 month" aggregations finish before end of tomorrow they "partitioned" it into weekly sections, every one with week number in the name of the table.
Yep, heaps of dynamic SQL, heaps of weekly-recreated UNION ALL views, etc.
Of course, there is no indexing, because it won't make much difference on double-layer views union'ing 13 tables.And you know - its all considered "up-t-standards" by the management.
That's apparently how it must be done, according to all the white pages they read in recent years.
It's a mainstream now.
They even won some awards for technological achievements last year.So, go away, you retarded bugger - you don't have a clue about contemporary advanced technologies!
Heh... I must say that when I wrote...
Few could be both that ignorant and arrogant about T-SQL, PII, and databases in general, especially all at once.
... I did so with a grimace but suspected I knew the frustration of the person I was addressing.
I agree with you. It's been the norm rather than the exception since I can remember.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 22, 2018 at 5:08 am
Jeff Moden - Monday, October 22, 2018 4:44 AMI agree with you. It's been the norm rather than the exception since I can remember.
Did you see those statements - "In the last decade amount of data we collected increased by 10 .. 20 .. 50 .. whatever number of times".
That's so cool and progressive! Right?
Now, parse all those XML's, JSON's and all other data formats into a properly normalized relational data storage - where will that progress disappear?
Yep, nothing to show pretty much.
Lousy solutions are good for everyone.
Except may be for end users, but who asks them?
_____________
Code for TallyGenerator
Viewing 15 posts - 1 through 15 (of 16 total)
You must be logged in to reply to this topic. Login to reply