Last active
August 3, 2016 22:58
-
-
Save burlresearch/403874b3d600efc13b20968420362ba7 to your computer and use it in GitHub Desktop.
cpa-dataimport-snippets
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 3272 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>22873, "Comp_IdCust"=>"1902162 ", "Pers_PersonId"=>22888, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FFT", "comp_district"=>nil, "comp_cpadivisions"=>nil, "Pers_LastName"=>"Munro", "Pers_FirstName"=>"Jeffrey", "Pers_MiddleName"=>"D.", "Pers_Salutation"=>"Mr.", "Pers_Title"=>"", "Pers_EmailAddress"=>"kateandjeff@live.ca", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>"", "Pers_PhoneAreaCode"=>"709", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"466-5235", "pers_birthday"=>1978-01-09 00:00:00 UTC, "Addr_Address1"=>"130", "Addr_Address2"=>"Harbour Dr", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Clarenville", "Addr_State"=>"NL", "Addr_PostCode"=>"A5A 4J4", "Addr_Country"=>"CA", "pers_webusername"=>"kateandjeff@live.ca ", "pers_webpassword"=>"~~6J1bzb8FlZc= ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>"NFU", "comp_cancelreason"=>"Auto termination", "comp_cancelreasoncode"=>"AutoCancel", "pers_primaryemployment"=>"GHOSP", "pers_primaryempsector"=>"Public", "pers_regnumber"=>nil, "pext_edschoolca"=>"UDalhousie", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>"", "pext_edcredential"=>"Masters", "pext_edgraddate"=>2005-01-01 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2004-10-02 00:00:00 UTC, "graduation_year"=>2004, "comp_startdate"=>2008-10-01 00:00:00 UTC, "Comp_CreatedDate"=>2012-08-09 14:45:47 UTC, "Pers_CreatedDate"=>2006-08-07 14:23:34 UTC, "Addr_CreatedDate"=>2012-08-09 14:45:47 UTC} | |
| 4578 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>25375, "Comp_IdCust"=>"20074 ", "Pers_PersonId"=>25447, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FFT", "comp_district"=>"AB-CAL", "comp_cpadivisions"=>nil, "Pers_LastName"=>"Mitchell", "Pers_FirstName"=>"Dana", "Pers_MiddleName"=>"D.", "Pers_Salutation"=>"Mrs.", "Pers_Title"=>"Physical Therapist", "Pers_EmailAddress"=>"", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>"Peddle", "Pers_PhoneAreaCode"=>"403", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"225-0210", "pers_birthday"=>1969-02-14 00:00:00 UTC, "Addr_Address1"=>"333", "Addr_Address2"=>"Shawville Blvd SE", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Calgary", "Addr_State"=>"AB", "Addr_PostCode"=>"T2Y 4H3", "Addr_Country"=>"CA", "pers_webusername"=>" ", "pers_webpassword"=>"~~/fZogOYN4cI= ", "comp_physpracticelang"=>",,,English,", "comp_physpracticeareas"=>",,,ORTHO,SPORT,", "comp_physconditions"=>",PN-Arthritis,PN-Fibromyalgia,PN-Ostioporosis,OR-Back,OR-joints,OR-muscle,OR-scoliosis,OR-sports,OR-sprainstrain,SE-falls,SE-porosis,OR-Fractures,", "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>",,,EPH,gait-walking,manual_therapy,myofascial,", "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"GHOSP", "pers_primaryempsector"=>"Public", "pers_regnumber"=>"3778", "pext_edschoolca"=>"UAlberta", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>"", "pext_edcredential"=>"BAC", "pext_edgraddate"=>1995-01-01 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>1994-10-02 00:00:00 UTC, "graduation_year"=>1994, "comp_startdate"=>1995-05-23 00:00:00 UTC, "Comp_CreatedDate"=>2012-08-09 16:06:39 UTC, "Pers_CreatedDate"=>2006-08-07 14:23:34 UTC, "Addr_CreatedDate"=>1900-01-01 00:00:00 UTC} | |
| 5420 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>27088, "Comp_IdCust"=>"2010672 ", "Pers_PersonId"=>27163, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FFT", "comp_district"=>"ON-CT", "comp_cpadivisions"=>",DIVOPD,DIVPPD,", "Pers_LastName"=>"Braithwaite", "Pers_FirstName"=>"James", "Pers_MiddleName"=>"", "Pers_Salutation"=>"Mr.", "Pers_Title"=>nil, "Pers_EmailAddress"=>"", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>"", "Pers_PhoneAreaCode"=>"613", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"483-7390", "pers_birthday"=>1979-12-08 00:00:00 UTC, "Addr_Address1"=>"125 ", "Addr_Address2"=>"Maitland St.", "Addr_Address3"=>nil, "Addr_Address4"=>nil, "Addr_City"=>"Toronto", "Addr_State"=>"ON", "Addr_PostCode"=>"M4Y 1E5", "Addr_Country"=>"CA", "pers_webusername"=>" ", "pers_webpassword"=>"trombone ", "comp_physpracticelang"=>",,English,", "comp_physpracticeareas"=>",NEURO,ORTHO,SENIOR,SPORT,", "comp_physconditions"=>",PN-Arthritis,PN-Chronic,PN-Diabetes,PN-Fibromyalgia,PN-Headaches,PN-Sciatica,PN-TriggerPoints,NU-Balance,NU-Brain,NU-dyst,NU-MS,NU-parkinsons,NU-spinal,NU-Stroke,OR-Amputees,OR-Back,OR-Bursitis,OR-Fractures,OR-joints,OR-muscle,OR-neck,OR-scoliosis,OR-sports,OR-sprainstrain,OR-TMJ,OR-tendinitis,RE-copd,RE-cardiac,RE-emphysema,SE-falls,SE-parthritis,SE-porosis,", "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>",,ART,APDN,CARDIOREHAB,electrotherapy,Ergonomics,gait-walking,HomeVisits,manual_therapy,myofascial,neuromuscular-electrical,TENS,traction,ultrasound,work-hardening,", "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"GPPC", "pers_primaryempsector"=>"Private", "pers_regnumber"=>nil, "pext_edschoolca"=>"UQueens", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>"", "pext_edcredential"=>"MAS", "pext_edgraddate"=>2010-10-02 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2010-10-02 00:00:00 UTC, "graduation_year"=>2010, "comp_startdate"=>2010-09-20 00:00:00 UTC, "Comp_CreatedDate"=>2012-08-09 16:35:58 UTC, "Pers_CreatedDate"=>2008-09-29 06:08:40 UTC, "Addr_CreatedDate"=>2012-08-09 16:35:58 UTC} | |
| 6104 : UNKNOWN DIVISION IN : ["DIVACU", "DIVCAR", "DIVARD", "DIVIHD", "DIVLEAD", "DIVNEU", "DIVONC", "DIVOPD", "DIVPAIN", "DIVPED", "DIVPPD", "DIVSPC", "DIVSRS", "DIVWHD", "None"] companyid:28564 | |
| 8971 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>33614, "Comp_IdCust"=>"4794 ", "Pers_PersonId"=>33689, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FPT", "comp_district"=>"ON-HM", "comp_cpadivisions"=>",DIVACU,DIVOPD,DIVSRS,", "Pers_LastName"=>"Correa-Winn", "Pers_FirstName"=>"Jennifer", "Pers_MiddleName"=>"", "Pers_Salutation"=>"Mrs.", "Pers_Title"=>nil, "Pers_EmailAddress"=>nil, "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>"Correa", "Pers_PhoneAreaCode"=>nil, "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>nil, "pers_birthday"=>nil, "Addr_Address1"=>"11", "Addr_Address2"=>"Galloway Court", "Addr_Address3"=>nil, "Addr_Address4"=>nil, "Addr_City"=>"Hamilton", "Addr_State"=>"ON", "Addr_PostCode"=>"L9C 6G4", "Addr_Country"=>"CA", "pers_webusername"=>nil, "pers_webpassword"=>nil, "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"UMcMaster", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>"", "pext_edcredential"=>"DIP", "pext_edgraddate"=>1965-01-01 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>1964-10-02 00:00:00 UTC, "graduation_year"=>1964, "comp_startdate"=>1966-05-01 00:00:00 UTC, "Comp_CreatedDate"=>2012-08-09 17:51:28 UTC, "Pers_CreatedDate"=>2006-08-07 14:23:34 UTC, "Addr_CreatedDate"=>2012-08-09 17:51:28 UTC} | |
| 9316 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>34497, "Comp_IdCust"=>"9127 ", "Pers_PersonId"=>34572, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FFT", "comp_district"=>nil, "comp_cpadivisions"=>",DIVPAIN,", "Pers_LastName"=>"Zwingerman", "Pers_FirstName"=>"Edward", "Pers_MiddleName"=>"Y", "Pers_Salutation"=>"Mr.", "Pers_Title"=>nil, "Pers_EmailAddress"=>"ezwingy@gmail.com", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>"", "Pers_PhoneAreaCode"=>"204", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"694-2337", "pers_birthday"=>1955-03-07 00:00:00 UTC, "Addr_Address1"=>"35", "Addr_Address2"=>"Blundell Bay", "Addr_Address3"=>nil, "Addr_Address4"=>nil, "Addr_City"=>"Winnipeg", "Addr_State"=>"MB", "Addr_PostCode"=>"R2V 4M4", "Addr_Country"=>"CA", "pers_webusername"=>"ezwingy@gmail.com ", "pers_webpassword"=>"9127 ", "comp_physpracticelang"=>",,English,", "comp_physpracticeareas"=>",,ORTHO,PAIN,SPORT,", "comp_physconditions"=>",,PN-Arthritis,PN-Chronic,PN-Fibromyalgia,PN-Headaches,PN-Ostioporosis,PN-Sciatica,OR-Back,OR-Bursitis,OR-Fractures,OR-hand,OR-joints,OR-muscle,OR-neck,OR-scoliosis,OR-sports,OR-sprainstrain,OR-TMJ,OR-tendinitis,SE-parthritis,SE-porosis,", "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>",,APDN,AQUA,cryotherapy,electrotherapy,Ergonomics,EPH,gait-walking,manual_therapy,ndt,neuromuscular-electrical,orthotics,TENS,traction,ultrasound,work-hardening,", "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"GPPC", "pers_primaryempsector"=>"Private", "pers_regnumber"=>nil, "pext_edschoolca"=>"UM", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>"", "pext_edcredential"=>"BAC", "pext_edgraddate"=>1981-01-01 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>1980-10-02 00:00:00 UTC, "graduation_year"=>1980, "comp_startdate"=>1976-01-01 00:00:00 UTC, "Comp_CreatedDate"=>2012-08-09 18:02:16 UTC, "Pers_CreatedDate"=>2006-08-07 14:23:34 UTC, "Addr_CreatedDate"=>2012-08-09 18:02:16 UTC} | |
| 10322 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>72007, "Comp_IdCust"=>"2029469 ", "Pers_PersonId"=>69021, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FPPPQ", "comp_district"=>nil, "comp_cpadivisions"=>nil, "Pers_LastName"=>"Nguyen", "Pers_FirstName"=>"Jacqueline", "Pers_MiddleName"=>"JN", "Pers_Salutation"=>"Mlle", "Pers_Title"=>nil, "Pers_EmailAddress"=>"jacquelinenguyen514@gmail.com", "Pers_Gender"=>"Female", "pers_language"=>"FR", "comp_language"=>"FR", "pers_birthlastname"=>"", "Pers_PhoneAreaCode"=>nil, "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>nil, "pers_birthday"=>1987-05-30 00:00:00 UTC, "Addr_Address1"=>"2590", "Addr_Address2"=>"BEAUSÉJOUR #8", "Addr_Address3"=>nil, "Addr_Address4"=>nil, "Addr_City"=>"Longueuil", "Addr_State"=>"QC", "Addr_PostCode"=>"J4M 1M5", "Addr_Country"=>"CA", "pers_webusername"=>"jacquelinenguyen514@gmail.com ", "pers_webpassword"=>"password69021 ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>"Oasis", "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"GPPC", "pers_primaryempsector"=>"Private", "pers_regnumber"=>nil, "pext_edschoolca"=>"UMcGill", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>"", "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>2008-06-20 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2008-10-02 00:00:00 UTC, "graduation_year"=>2008, "comp_startdate"=>2015-09-16 00:00:00 UTC, "Comp_CreatedDate"=>2013-03-21 15:12:08 UTC, "Pers_CreatedDate"=>2006-10-05 20:12:27 UTC, "Addr_CreatedDate"=>nil} | |
| 10512 : COUNTRY_CODE_NIL : {"Comp_CompanyId"=>76750, "Comp_IdCust"=>"2022746 ", "Pers_PersonId"=>73287, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"PTAS", "comp_district"=>"ON-CT", "comp_cpadivisions"=>",DIVNEU,DIVIHD,DIVPPD,DIVSRS,DIVACU,DIVARD,DIVCAR,DIVLEAD,DIVONC,DIVOPD,DIVPED,DIVPAIN,DIVSPC,DIVWHD,", "Pers_LastName"=>"Tan", "Pers_FirstName"=>"Jovina", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Ms.", "Pers_Title"=>"", "Pers_EmailAddress"=>"tnjv0001@humbermail.ca", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"647", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"7097833", "pers_birthday"=>nil, "Addr_Address1"=>"#1010-2960", "Addr_Address2"=>"Don Mills Rd", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"North York", "Addr_State"=>"ON", "Addr_PostCode"=>"M2J 3B8", "Addr_Country"=>"", "pers_webusername"=>"tnjv0001@humbermail.ca ", "pers_webpassword"=>"~~P1f/GPI87T9wZHa7+83mdQ== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>nil, "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>nil, "pext_edgraddate"=>nil, "pext_swgraddate"=>2015-10-02 00:00:00 UTC, "pext_gradperiod"=>nil, "graduation_year"=>nil, "comp_startdate"=>2013-08-12 00:00:00 UTC, "Comp_CreatedDate"=>2013-08-12 21:17:00 UTC, "Pers_CreatedDate"=>2013-08-12 21:21:01 UTC, "Addr_CreatedDate"=>2013-08-12 21:21:01 UTC} | |
| 10512 : ADDRESS_INVALID : {"Comp_CompanyId"=>76750, "Comp_IdCust"=>"2022746 ", "Pers_PersonId"=>73287, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"PTAS", "comp_district"=>"ON-CT", "comp_cpadivisions"=>",DIVNEU,DIVIHD,DIVPPD,DIVSRS,DIVACU,DIVARD,DIVCAR,DIVLEAD,DIVONC,DIVOPD,DIVPED,DIVPAIN,DIVSPC,DIVWHD,", "Pers_LastName"=>"Tan", "Pers_FirstName"=>"Jovina", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Ms.", "Pers_Title"=>"", "Pers_EmailAddress"=>"tnjv0001@humbermail.ca", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"647", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"7097833", "pers_birthday"=>nil, "Addr_Address1"=>"#1010-2960", "Addr_Address2"=>"Don Mills Rd", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"North York", "Addr_State"=>"ON", "Addr_PostCode"=>"M2J 3B8", "Addr_Country"=>"", "pers_webusername"=>"tnjv0001@humbermail.ca ", "pers_webpassword"=>"~~P1f/GPI87T9wZHa7+83mdQ== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>nil, "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>nil, "pext_edgraddate"=>nil, "pext_swgraddate"=>2015-10-02 00:00:00 UTC, "pext_gradperiod"=>nil, "graduation_year"=>nil, "comp_startdate"=>2013-08-12 00:00:00 UTC, "Comp_CreatedDate"=>2013-08-12 21:17:00 UTC, "Pers_CreatedDate"=>2013-08-12 21:21:01 UTC, "Addr_CreatedDate"=>2013-08-12 21:21:01 UTC} | |
| 10548 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>76867, "Comp_IdCust"=>"2022785 ", "Pers_PersonId"=>73354, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"ON-LDN", "comp_cpadivisions"=>",DIVCAR,DIVNEU,DIVOPD,DIVSRS,DIVSPC,", "Pers_LastName"=>"Thibeault", "Pers_FirstName"=>"Rodney", "Pers_MiddleName"=>" M.", "Pers_Salutation"=>"Mr.", "Pers_Title"=>nil, "Pers_EmailAddress"=>nil, "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>nil, "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>nil, "pers_birthday"=>1971-08-30 00:00:00 UTC, "Addr_Address1"=>"852", "Addr_Address2"=>"Trafalgar Street", "Addr_Address3"=>"23", "Addr_Address4"=>nil, "Addr_City"=>"London", "Addr_State"=>"ON", "Addr_PostCode"=>"N5Z 1E7", "Addr_Country"=>"CA", "pers_webusername"=>" ", "pers_webpassword"=>"password73354 ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>nil, "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2015-10-02 00:00:00 UTC, "pext_swgraddate"=>2014-10-02 00:00:00 UTC, "pext_gradperiod"=>2015-10-02 00:00:00 UTC, "graduation_year"=>2015, "comp_startdate"=>2013-08-19 00:00:00 UTC, "Comp_CreatedDate"=>2013-08-19 14:39:21 UTC, "Pers_CreatedDate"=>2013-08-19 14:39:21 UTC, "Addr_CreatedDate"=>2013-08-19 14:39:21 UTC} | |
| 11136 : COUNTRY_CODE_NIL : {"Comp_CompanyId"=>78498, "Comp_IdCust"=>"2025316 ", "Pers_PersonId"=>74270, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"NS-HRB", "comp_cpadivisions"=>",DIVACU,DIVARD,DIVCAR,DIVIHD,DIVLEAD,DIVNEU,DIVONC,DIVOPD,DIVPED,DIVPAIN,DIVPPD,DIVSRS,DIVSPC,DIVWHD,", "Pers_LastName"=>"Nguyen", "Pers_FirstName"=>"Emily", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Ms.", "Pers_Title"=>"", "Pers_EmailAddress"=>"emily.nguyen624@gmail.com", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"902", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"449-4991", "pers_birthday"=>1989-10-08 00:00:00 UTC, "Addr_Address1"=>"96", "Addr_Address2"=>"Lakemist Court", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Dartmouth", "Addr_State"=>"NS", "Addr_PostCode"=>"B3A4Z1", "Addr_Country"=>"", "pers_webusername"=>"emily.nguyen624@gmail.com ", "pers_webpassword"=>"~~nDH/zcBtFCQ= ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"UDalhousie", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2014-10-02 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2015-10-02 00:00:00 UTC, "graduation_year"=>2015, "comp_startdate"=>2013-10-10 00:00:00 UTC, "Comp_CreatedDate"=>2013-10-10 14:23:34 UTC, "Pers_CreatedDate"=>2013-10-10 14:23:34 UTC, "Addr_CreatedDate"=>2013-10-10 14:23:34 UTC} | |
| 11136 : ADDRESS_INVALID : {"Comp_CompanyId"=>78498, "Comp_IdCust"=>"2025316 ", "Pers_PersonId"=>74270, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"NS-HRB", "comp_cpadivisions"=>",DIVACU,DIVARD,DIVCAR,DIVIHD,DIVLEAD,DIVNEU,DIVONC,DIVOPD,DIVPED,DIVPAIN,DIVPPD,DIVSRS,DIVSPC,DIVWHD,", "Pers_LastName"=>"Nguyen", "Pers_FirstName"=>"Emily", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Ms.", "Pers_Title"=>"", "Pers_EmailAddress"=>"emily.nguyen624@gmail.com", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"902", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"449-4991", "pers_birthday"=>1989-10-08 00:00:00 UTC, "Addr_Address1"=>"96", "Addr_Address2"=>"Lakemist Court", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Dartmouth", "Addr_State"=>"NS", "Addr_PostCode"=>"B3A4Z1", "Addr_Country"=>"", "pers_webusername"=>"emily.nguyen624@gmail.com ", "pers_webpassword"=>"~~nDH/zcBtFCQ= ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"UDalhousie", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2014-10-02 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2015-10-02 00:00:00 UTC, "graduation_year"=>2015, "comp_startdate"=>2013-10-10 00:00:00 UTC, "Comp_CreatedDate"=>2013-10-10 14:23:34 UTC, "Pers_CreatedDate"=>2013-10-10 14:23:34 UTC, "Addr_CreatedDate"=>2013-10-10 14:23:34 UTC} | |
| 11147 : FUTURE_BIRTHDAY : {"Comp_CompanyId"=>78514, "Comp_IdCust"=>"2025327 ", "Pers_PersonId"=>74284, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"PTAS", "comp_district"=>"ON-NON", "comp_cpadivisions"=>nil, "Pers_LastName"=>"Chong", "Pers_FirstName"=>"Asa", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Mrs.", "Pers_Title"=>"student", "Pers_EmailAddress"=>"asachong@yahoo.com", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>nil, "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>nil, "pers_birthday"=>2070-03-12 00:00:00 UTC, "Addr_Address1"=>"53", "Addr_Address2"=>"Parkinworth Pl", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Sault Ste Marie", "Addr_State"=>"ON", "Addr_PostCode"=>"P6A 6Y8", "Addr_Country"=>"CA", "pers_webusername"=>"asachong@yahoo.com ", "pers_webpassword"=>"~~npcsbe57RvuYfm9/kDcfFg== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>nil, "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>nil, "pext_edgraddate"=>nil, "pext_swgraddate"=>2015-10-02 00:00:00 UTC, "pext_gradperiod"=>nil, "graduation_year"=>nil, "comp_startdate"=>2013-10-11 00:00:00 UTC, "Comp_CreatedDate"=>2013-10-11 11:05:52 UTC, "Pers_CreatedDate"=>2013-10-11 11:08:59 UTC, "Addr_CreatedDate"=>2013-10-11 11:08:59 UTC} | |
| 11370 : COUNTRY_CODE_NIL : {"Comp_CompanyId"=>78866, "Comp_IdCust"=>"2025576 ", "Pers_PersonId"=>74566, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"NG-FT", "comp_district"=>"ON-CT", "comp_cpadivisions"=>",DIVOPD,", "Pers_LastName"=>"lelliott", "Pers_FirstName"=>"jessi", "Pers_MiddleName"=>"MW", "Pers_Salutation"=>"Mr.", "Pers_Title"=>"", "Pers_EmailAddress"=>"jessilelliott@gmail.com", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"416", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"4585472", "pers_birthday"=>1979-03-05 00:00:00 UTC, "Addr_Address1"=>"1", "Addr_Address2"=>"Market Street", "Addr_Address3"=>"3105", "Addr_Address4"=>"", "Addr_City"=>"Toronto", "Addr_State"=>"ON", "Addr_PostCode"=>"M5E0A2", "Addr_Country"=>"", "pers_webusername"=>"jessilelliott@gmail.com ", "pers_webpassword"=>"~~VMaVJuWNgYRi4Bj9jkamcw== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>"Change Member Tier", "comp_cancelreasoncode"=>"CHANGETIER", "pers_primaryemployment"=>"GPPC", "pers_primaryempsector"=>"Private", "pers_regnumber"=>nil, "pext_edschoolca"=>"UQueens", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2015-11-18 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2015-10-02 00:00:00 UTC, "graduation_year"=>2015, "comp_startdate"=>2013-10-25 00:00:00 UTC, "Comp_CreatedDate"=>2013-10-25 09:48:54 UTC, "Pers_CreatedDate"=>2013-10-25 09:48:54 UTC, "Addr_CreatedDate"=>2016-04-18 11:01:38 UTC} | |
| 11370 : ADDRESS_INVALID : {"Comp_CompanyId"=>78866, "Comp_IdCust"=>"2025576 ", "Pers_PersonId"=>74566, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"NG-FT", "comp_district"=>"ON-CT", "comp_cpadivisions"=>",DIVOPD,", "Pers_LastName"=>"lelliott", "Pers_FirstName"=>"jessi", "Pers_MiddleName"=>"MW", "Pers_Salutation"=>"Mr.", "Pers_Title"=>"", "Pers_EmailAddress"=>"jessilelliott@gmail.com", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"416", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"4585472", "pers_birthday"=>1979-03-05 00:00:00 UTC, "Addr_Address1"=>"1", "Addr_Address2"=>"Market Street", "Addr_Address3"=>"3105", "Addr_Address4"=>"", "Addr_City"=>"Toronto", "Addr_State"=>"ON", "Addr_PostCode"=>"M5E0A2", "Addr_Country"=>"", "pers_webusername"=>"jessilelliott@gmail.com ", "pers_webpassword"=>"~~VMaVJuWNgYRi4Bj9jkamcw== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>"Change Member Tier", "comp_cancelreasoncode"=>"CHANGETIER", "pers_primaryemployment"=>"GPPC", "pers_primaryempsector"=>"Private", "pers_regnumber"=>nil, "pext_edschoolca"=>"UQueens", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2015-11-18 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2015-10-02 00:00:00 UTC, "graduation_year"=>2015, "comp_startdate"=>2013-10-25 00:00:00 UTC, "Comp_CreatedDate"=>2013-10-25 09:48:54 UTC, "Pers_CreatedDate"=>2013-10-25 09:48:54 UTC, "Addr_CreatedDate"=>2016-04-18 11:01:38 UTC} | |
| 11609 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>80082, "Comp_IdCust"=>"2029211 ", "Pers_PersonId"=>75204, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"NG-FT", "comp_district"=>"ON-DH", "comp_cpadivisions"=>",DIVOPD,", "Pers_LastName"=>"Wiggers", "Pers_FirstName"=>"Alison", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Madame", "Pers_Title"=>"", "Pers_EmailAddress"=>"alison.wiggers14@gmail.com", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"226", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"2346866", "pers_birthday"=>2015-08-14 00:00:00 UTC, "Addr_Address1"=>"1196", "Addr_Address2"=>"Simcoe Street", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Beaverton", "Addr_State"=>"ON", "Addr_PostCode"=>"L0K1A0", "Addr_Country"=>"CA", "pers_webusername"=>"alison.wiggers14@gmail.com ", "pers_webpassword"=>"~~gRIJ/lgAAIixMby3PWQqog== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>"Change Member Tier", "comp_cancelreasoncode"=>"CHANGETIER", "pers_primaryemployment"=>"GPPC", "pers_primaryempsector"=>"Private", "pers_regnumber"=>"2025506", "pext_edschoolca"=>"UMcMaster", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2015-11-20 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2015-10-02 00:00:00 UTC, "graduation_year"=>2015, "comp_startdate"=>2015-07-15 00:00:00 UTC, "Comp_CreatedDate"=>2014-02-09 16:07:09 UTC, "Pers_CreatedDate"=>2014-02-09 16:12:23 UTC, "Addr_CreatedDate"=>2015-09-29 21:46:02 UTC} | |
| 11616 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>80201, "Comp_IdCust"=>"2025951 ", "Pers_PersonId"=>75238, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FFT", "comp_district"=>"ON-HM", "comp_cpadivisions"=>",DIVCAR,DIVLEAD,DIVNEU,DIVONC,DIVPAIN,DIVSRS,DIVWHD,", "Pers_LastName"=>"Park", "Pers_FirstName"=>"Debbie", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Mrs.", "Pers_Title"=>"", "Pers_EmailAddress"=>"deborah.park@trilliumhealthpartners.ca", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"905", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"848-7580 x3427", "pers_birthday"=>1966-05-19 00:00:00 UTC, "Addr_Address1"=>"377", "Addr_Address2"=>"Wilson Ave", "Addr_Address3"=>nil, "Addr_Address4"=>nil, "Addr_City"=>"Burlington", "Addr_State"=>"ON", "Addr_PostCode"=>"L7L 2N2", "Addr_Country"=>"CA", "pers_webusername"=>"deborah.park@trilliumhealthpartners.ca ", "pers_webpassword"=>"~~0MIVXkFwt6A= ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"GHOSP", "pers_primaryempsector"=>"Public", "pers_regnumber"=>"09158", "pext_edschoolca"=>"UMcMaster", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>nil, "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>1994-11-01 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>1994-10-02 00:00:00 UTC, "graduation_year"=>1994, "comp_startdate"=>2014-02-15 00:00:00 UTC, "Comp_CreatedDate"=>2014-02-15 08:45:14 UTC, "Pers_CreatedDate"=>2014-02-15 08:49:28 UTC, "Addr_CreatedDate"=>nil} | |
| 11678 : FUTURE_BIRTHDAY : {"Comp_CompanyId"=>80913, "Comp_IdCust"=>"2026081 ", "Pers_PersonId"=>75549, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FPT", "comp_district"=>"BC-KTY", "comp_cpadivisions"=>",DIVACU,DIVPPD,", "Pers_LastName"=>"Gracey", "Pers_FirstName"=>"Jayne", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Ms.", "Pers_Title"=>nil, "Pers_EmailAddress"=>"jaynegracey@hotmail.com", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"+1", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"6048495101", "pers_birthday"=>2084-05-19 00:00:00 UTC, "Addr_Address1"=>"1777", "Addr_Address2"=>"2nd Ave", "Addr_Address3"=>"", "Addr_Address4"=>"2322", "Addr_City"=>"Rossland", "Addr_State"=>"BC", "Addr_PostCode"=>"V0G 1Y0", "Addr_Country"=>"CA", "pers_webusername"=>"jaynegracey@hotmail.com ", "pers_webpassword"=>"~~1ZXtnm5e78Q= ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"GHOSP", "pers_primaryempsector"=>"Public", "pers_regnumber"=>"08049", "pext_edschoolca"=>nil, "pext_edschoolinca"=>"N", "pext_edschoolint"=>"UK", "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>2005-07-31 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2005-10-02 00:00:00 UTC, "graduation_year"=>2005, "comp_startdate"=>2014-04-03 00:00:00 UTC, "Comp_CreatedDate"=>2014-04-03 15:04:04 UTC, "Pers_CreatedDate"=>2014-04-03 15:14:25 UTC, "Addr_CreatedDate"=>2014-04-03 15:14:25 UTC} | |
| 11759 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>81388, "Comp_IdCust"=>"2026190 ", "Pers_PersonId"=>75812, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"PTAS", "comp_district"=>"ON-WG", "comp_cpadivisions"=>nil, "Pers_LastName"=>"Alomia", "Pers_FirstName"=>"Luis", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Mr.", "Pers_Title"=>"student", "Pers_EmailAddress"=>"benjaminalomiadesme@yahoo.com", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"905", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"5103747", "pers_birthday"=>1972-08-21 00:00:00 UTC, "Addr_Address1"=>"Oakville", "Addr_Address2"=>"Lynnwood Dr.", "Addr_Address3"=>"302", "Addr_Address4"=>"", "Addr_City"=>"Oakville", "Addr_State"=>"ON", "Addr_PostCode"=>"L6H 1M8", "Addr_Country"=>"CA", "pers_webusername"=>"benjaminalomiadesme@yahoo.com ", "pers_webpassword"=>"~~lfSZip+uYpk= ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>nil, "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>nil, "pext_edgraddate"=>nil, "pext_swgraddate"=>2015-09-30 00:00:00 UTC, "pext_gradperiod"=>nil, "graduation_year"=>nil, "comp_startdate"=>2014-05-21 00:00:00 UTC, "Comp_CreatedDate"=>2014-05-21 11:06:42 UTC, "Pers_CreatedDate"=>2014-05-21 11:10:06 UTC, "Addr_CreatedDate"=>2014-05-21 11:10:06 UTC} | |
| 12931 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>84770, "Comp_IdCust"=>"2028481 ", "Pers_PersonId"=>78141, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"QC", "comp_cpadivisions"=>nil, "Pers_LastName"=>"Gendron", "Pers_FirstName"=>"Sue-Anne", "Pers_MiddleName"=>nil, "Pers_Salutation"=>nil, "Pers_Title"=>nil, "Pers_EmailAddress"=>"sue-anne.gendron@usherbrooke.ca", "Pers_Gender"=>nil, "pers_language"=>"FR", "comp_language"=>"FR", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>nil, "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>nil, "pers_birthday"=>nil, "Addr_Address1"=>"3001", "Addr_Address2"=>"12e avenue Nord", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Sherbrooke", "Addr_State"=>"QC", "Addr_PostCode"=>"JiH 5N4", "Addr_Country"=>"CA", "pers_webusername"=>"sue-anne.gendron@usherbrooke.ca ", "pers_webpassword"=>"password78141 ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"Usherbrooke", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>nil, "pext_edgraddate"=>2016-02-10 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2015-10-02 00:00:00 UTC, "graduation_year"=>2015, "comp_startdate"=>2014-10-01 00:00:00 UTC, "Comp_CreatedDate"=>2015-01-09 13:36:55 UTC, "Pers_CreatedDate"=>2015-01-09 13:36:55 UTC, "Addr_CreatedDate"=>2015-01-09 13:36:55 UTC} | |
| 12933 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>84773, "Comp_IdCust"=>"2028484 ", "Pers_PersonId"=>78144, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"NG-FT", "comp_district"=>nil, "comp_cpadivisions"=>",DIVOPD,", "Pers_LastName"=>"Levesque", "Pers_FirstName"=>"Catherine", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Madame", "Pers_Title"=>nil, "Pers_EmailAddress"=>"catherine.levesque4@usherbrooke.ca", "Pers_Gender"=>"Female", "pers_language"=>"FR", "comp_language"=>"FR", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"418", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"914-3516", "pers_birthday"=>1993-04-27 00:00:00 UTC, "Addr_Address1"=>"7-595", "Addr_Address2"=>"Avenue de Norvège", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Québec", "Addr_State"=>"QC", "Addr_PostCode"=>"G1X 3E9", "Addr_Country"=>"CA", "pers_webusername"=>"catherine.levesque4@usherbrooke.ca ", "pers_webpassword"=>"~~kF0b5TjKb5g= ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>"member upgrading to new grad", "comp_cancelreasoncode"=>"Upgrading", "pers_primaryemployment"=>"SPPB", "pers_primaryempsector"=>"Private", "pers_regnumber"=>"16032", "pext_edschoolca"=>"USherbrooke", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2016-02-10 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2015-10-02 00:00:00 UTC, "graduation_year"=>2015, "comp_startdate"=>2014-10-01 00:00:00 UTC, "Comp_CreatedDate"=>2015-01-09 13:36:57 UTC, "Pers_CreatedDate"=>2015-01-09 13:36:57 UTC, "Addr_CreatedDate"=>2015-01-09 13:36:57 UTC} | |
| 13600 : FUTURE_BIRTHDAY : {"Comp_CompanyId"=>87590, "Comp_IdCust"=>"2029399 ", "Pers_PersonId"=>79969, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"SK-SASK", "comp_cpadivisions"=>",DIVACU,DIVARD,DIVIHD,DIVPAIN,DIVWHD,DIVNEU,DIVCAR,DIVLEAD,DIVONC,DIVOPD,DIVPED,DIVPPD,DIVSRS,DIVSPC,CPAJOURNALMAIL,", "Pers_LastName"=>"Rochefort", "Pers_FirstName"=>"Kelsey", "Pers_MiddleName"=>nil, "Pers_Salutation"=>nil, "Pers_Title"=>nil, "Pers_EmailAddress"=>"krr414@mail.usask.ca", "Pers_Gender"=>nil, "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"0", "Pers_PhoneCountryCode"=>"0 ", "Pers_PhoneNumber"=>"0", "pers_birthday"=>2016-09-25 00:00:00 UTC, "Addr_Address1"=>"Box 37020 North Park P.O.", "Addr_Address2"=>"Box 37020 North Park P.O.", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Saskatoon", "Addr_State"=>"SK", "Addr_PostCode"=>"S7K 8J2", "Addr_Country"=>"CA", "pers_webusername"=>"krr414@mail.usask.ca ", "pers_webpassword"=>"~~oDxQK4mWLYoU2ZwmEb3IHg== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>"Auto termination", "comp_cancelreasoncode"=>"AutoCancel", "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"USASK", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>2017-10-20 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2017-10-02 00:00:00 UTC, "graduation_year"=>2017, "comp_startdate"=>2015-11-09 00:00:00 UTC, "Comp_CreatedDate"=>2015-09-11 09:42:20 UTC, "Pers_CreatedDate"=>2015-09-11 09:42:21 UTC, "Addr_CreatedDate"=>2015-09-11 09:42:21 UTC} | |
| 13621 : COUNTRY_CODE_NIL : {"Comp_CompanyId"=>87648, "Comp_IdCust"=>"2029420 ", "Pers_PersonId"=>80008, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FFT", "comp_district"=>"NS-HRB", "comp_cpadivisions"=>",DIVOPD,DIVPAIN,DIVPPD,DIVSPC,", "Pers_LastName"=>"McFarland", "Pers_FirstName"=>"Jonathan Mark", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Mr.", "Pers_Title"=>"Physiotherapist", "Pers_EmailAddress"=>"markmcfarland@mac.com", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"902", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"4221555", "pers_birthday"=>1969-12-01 00:00:00 UTC, "Addr_Address1"=>"3480", "Addr_Address2"=>"Joseph Howe Drive", "Addr_Address3"=>"103", "Addr_Address4"=>"", "Addr_City"=>"Halifax", "Addr_State"=>"NS", "Addr_PostCode"=>"B3L4H7", "Addr_Country"=>"", "pers_webusername"=>"markmcfarland@mac.com ", "pers_webpassword"=>"~~KToS+0eaHXfw0I+NbIT3Pg== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"GPPC", "pers_primaryempsector"=>"Private", "pers_regnumber"=>"1096", "pext_edschoolca"=>"UDalhousie", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>nil, "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>1993-05-28 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>1993-10-02 00:00:00 UTC, "graduation_year"=>1993, "comp_startdate"=>2015-09-14 00:00:00 UTC, "Comp_CreatedDate"=>2015-09-14 08:15:31 UTC, "Pers_CreatedDate"=>2015-09-14 08:18:19 UTC, "Addr_CreatedDate"=>2015-09-14 08:18:19 UTC} | |
| 13621 : ADDRESS_INVALID : {"Comp_CompanyId"=>87648, "Comp_IdCust"=>"2029420 ", "Pers_PersonId"=>80008, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FFT", "comp_district"=>"NS-HRB", "comp_cpadivisions"=>",DIVOPD,DIVPAIN,DIVPPD,DIVSPC,", "Pers_LastName"=>"McFarland", "Pers_FirstName"=>"Jonathan Mark", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Mr.", "Pers_Title"=>"Physiotherapist", "Pers_EmailAddress"=>"markmcfarland@mac.com", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"902", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"4221555", "pers_birthday"=>1969-12-01 00:00:00 UTC, "Addr_Address1"=>"3480", "Addr_Address2"=>"Joseph Howe Drive", "Addr_Address3"=>"103", "Addr_Address4"=>"", "Addr_City"=>"Halifax", "Addr_State"=>"NS", "Addr_PostCode"=>"B3L4H7", "Addr_Country"=>"", "pers_webusername"=>"markmcfarland@mac.com ", "pers_webpassword"=>"~~KToS+0eaHXfw0I+NbIT3Pg== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"GPPC", "pers_primaryempsector"=>"Private", "pers_regnumber"=>"1096", "pext_edschoolca"=>"UDalhousie", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>nil, "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>1993-05-28 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>1993-10-02 00:00:00 UTC, "graduation_year"=>1993, "comp_startdate"=>2015-09-14 00:00:00 UTC, "Comp_CreatedDate"=>2015-09-14 08:15:31 UTC, "Pers_CreatedDate"=>2015-09-14 08:18:19 UTC, "Addr_CreatedDate"=>2015-09-14 08:18:19 UTC} | |
| 14021 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>88334, "Comp_IdCust"=>"2029838 ", "Pers_PersonId"=>80540, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"AB-ED", "comp_cpadivisions"=>nil, "Pers_LastName"=>"Lundmark", "Pers_FirstName"=>"Kelda", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Madame", "Pers_Title"=>"", "Pers_EmailAddress"=>"lundmark@ualberta.ca", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"0", "Pers_PhoneCountryCode"=>"0 ", "Pers_PhoneNumber"=>"0", "pers_birthday"=>nil, "Addr_Address1"=>"243233", "Addr_Address2"=>"Range Road 31", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Calgary", "Addr_State"=>"AB", "Addr_PostCode"=>"T3Z 3L7", "Addr_Country"=>"CA", "pers_webusername"=>"lundmark@ualberta.ca ", "pers_webpassword"=>"~~dFxXHh81qY0= ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"UAlberta", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>nil, "pext_edgraddate"=>2018-01-10 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2017-10-02 00:00:00 UTC, "graduation_year"=>2017, "comp_startdate"=>2015-09-26 00:00:00 UTC, "Comp_CreatedDate"=>2015-09-26 12:44:13 UTC, "Pers_CreatedDate"=>2015-09-26 12:44:13 UTC, "Addr_CreatedDate"=>2015-09-26 12:44:13 UTC} | |
| 14828 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>90221, "Comp_IdCust"=>"2030742 ", "Pers_PersonId"=>81928, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"ON-HM", "comp_cpadivisions"=>",DIVACU,DIVARD,DIVCAR,DIVIHD,DIVLEAD,DIVNEU,DIVONC,DIVOPD,DIVPED,DIVPAIN,DIVPPD,DIVSRS,DIVSPC,DIVWHD,", "Pers_LastName"=>"Sekhon", "Pers_FirstName"=>"Bhawandeep", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Mr.", "Pers_Title"=>nil, "Pers_EmailAddress"=>"sekhonb@mcmaster.ca", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>nil, "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>nil, "pers_birthday"=>1992-06-23 00:00:00 UTC, "Addr_Address1"=>"160", "Addr_Address2"=>"Market St", "Addr_Address3"=>nil, "Addr_Address4"=>nil, "Addr_City"=>"Hamilton", "Addr_State"=>"ON", "Addr_PostCode"=>"L8R 3J6", "Addr_Country"=>"CA", "pers_webusername"=>"sekhonb@mcmaster.ca ", "pers_webpassword"=>"password81928 ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"OTH", "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"UMcMaster", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2017-09-12 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2017-10-02 00:00:00 UTC, "graduation_year"=>2017, "comp_startdate"=>2016-01-12 00:00:00 UTC, "Comp_CreatedDate"=>2016-01-12 13:58:26 UTC, "Pers_CreatedDate"=>2016-01-12 13:58:27 UTC, "Addr_CreatedDate"=>2016-01-12 13:58:26 UTC} | |
| 14832 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>90238, "Comp_IdCust"=>"2030747 ", "Pers_PersonId"=>81938, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"QC", "comp_cpadivisions"=>",DIVACU,DIVARD,DIVCAR,DIVIHD,DIVLEAD,DIVNEU,DIVONC,DIVOPD,DIVPED,DIVPAIN,DIVPPD,DIVSRS,DIVSPC,DIVWHD,CPAJOURNALMAIL,", "Pers_LastName"=>"Daigle", "Pers_FirstName"=>"Michelle", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Madame", "Pers_Title"=>"", "Pers_EmailAddress"=>"michelle.daigle.2@ulaval.ca", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>nil, "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"506", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"479-1441", "pers_birthday"=>1993-11-12 00:00:00 UTC, "Addr_Address1"=>"10290", "Addr_Address2"=>"route 144", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Saint-André", "Addr_State"=>"NB", "Addr_PostCode"=>"E3Y 3J4", "Addr_Country"=>"CA", "pers_webusername"=>"michelle.daigle.2@ulaval.ca ", "pers_webpassword"=>"~~+gmYsQatRvrvFv60M9nvBw== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"ULaval", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>2017-12-15 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2017-10-02 00:00:00 UTC, "graduation_year"=>2017, "comp_startdate"=>2016-01-13 00:00:00 UTC, "Comp_CreatedDate"=>2016-01-13 15:10:38 UTC, "Pers_CreatedDate"=>2016-01-13 15:15:52 UTC, "Addr_CreatedDate"=>2016-01-13 15:15:52 UTC} | |
| 14836 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>90248, "Comp_IdCust"=>"2030758 ", "Pers_PersonId"=>81947, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"NS-HRB", "comp_cpadivisions"=>",DIVPED,DIVNEU,DIVLEAD,DIVSRS,", "Pers_LastName"=>"Roy", "Pers_FirstName"=>"Jenny", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Ms.", "Pers_Title"=>"", "Pers_EmailAddress"=>"jenny.roy@dal.ca", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>nil, "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"902", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"233-0015", "pers_birthday"=>1993-09-19 00:00:00 UTC, "Addr_Address1"=>"60", "Addr_Address2"=>"Adlington Court", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Bedford", "Addr_State"=>"NS", "Addr_PostCode"=>"B4Z 3Z1", "Addr_Country"=>"CA", "pers_webusername"=>"jenny.roy@dal.ca ", "pers_webpassword"=>"~~BPaYDxx3qZ1xhMNS2cJ/2g== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"UDalhousie", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2017-09-01 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2017-10-02 00:00:00 UTC, "graduation_year"=>2017, "comp_startdate"=>2016-01-15 00:00:00 UTC, "Comp_CreatedDate"=>2016-01-14 13:16:06 UTC, "Pers_CreatedDate"=>2016-01-14 13:17:32 UTC, "Addr_CreatedDate"=>2016-01-14 13:17:32 UTC} | |
| 14979 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>90956, "Comp_IdCust"=>"2030892 ", "Pers_PersonId"=>82365, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"ON-CT", "comp_cpadivisions"=>",DIVACU,DIVOPD,DIVPPD,DIVSPC,", "Pers_LastName"=>"Bhuvanendrarajah", "Pers_FirstName"=>"Gowshigan", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Mr.", "Pers_Title"=>"Student", "Pers_EmailAddress"=>"gowshigan.bhuvanendrarajah@mail.utoronto.ca ", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"416", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"9063641", "pers_birthday"=>1992-10-14 00:00:00 UTC, "Addr_Address1"=>"148", "Addr_Address2"=>"Allegro Drive", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Brampton", "Addr_State"=>"ON", "Addr_PostCode"=>"L6Y5Y2", "Addr_Country"=>"CA", "pers_webusername"=>"gowshigan.bhuvanendrarajah@mail.utoronto.ca ", "pers_webpassword"=>"~~2AAIckWgyKuyhPQuQkvEwA== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"UT", "pext_edschoolinca"=>"Y", "pext_edschoolint"=>nil, "pext_edcredential"=>"Masters", "pext_edgraddate"=>2017-08-31 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2017-10-02 00:00:00 UTC, "graduation_year"=>2017, "comp_startdate"=>2016-03-10 00:00:00 UTC, "Comp_CreatedDate"=>2016-03-10 15:58:48 UTC, "Pers_CreatedDate"=>2016-03-10 16:00:36 UTC, "Addr_CreatedDate"=>2016-03-10 16:00:37 UTC} | |
| 15008 : FUTURE_BIRTHDAY : {"Comp_CompanyId"=>91094, "Comp_IdCust"=>"2030925 ", "Pers_PersonId"=>82450, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"QC", "comp_cpadivisions"=>",DIVNEU,DIVPED,DIVSPC,DIVPAIN,CPAJOURNALMAIL,DIVIHD,", "Pers_LastName"=>"Selvarajah", "Pers_FirstName"=>"Pavitha", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Madame", "Pers_Title"=>"", "Pers_EmailAddress"=>"pavitha_30@hotmail.com", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>nil, "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"514", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"6778287", "pers_birthday"=>2016-09-30 00:00:00 UTC, "Addr_Address1"=>"55", "Addr_Address2"=>"Maple", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Dollard des Ormeaux", "Addr_State"=>"QC", "Addr_PostCode"=>"H9B1E6", "Addr_Country"=>"CA", "pers_webusername"=>"pavitha_30@hotmail.com ", "pers_webpassword"=>"~~oXzENtiSdN70Feh7pBmdbA== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"UMcGill", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>2017-04-03 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2017-10-02 00:00:00 UTC, "graduation_year"=>2017, "comp_startdate"=>2016-03-22 00:00:00 UTC, "Comp_CreatedDate"=>2016-03-22 09:34:00 UTC, "Pers_CreatedDate"=>2016-03-22 09:35:36 UTC, "Addr_CreatedDate"=>2016-03-22 09:35:36 UTC} | |
| 15086 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>91440, "Comp_IdCust"=>"2031008 ", "Pers_PersonId"=>82666, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"STD", "comp_district"=>"ON-HM", "comp_cpadivisions"=>",DIVNEU,DIVOPD,DIVPED,DIVSPC,", "Pers_LastName"=>"Zavaglia", "Pers_FirstName"=>"Elysia", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Ms.", "Pers_Title"=>"", "Pers_EmailAddress"=>"zavaglie@mcmaster.ca", "Pers_Gender"=>"Female", "pers_language"=>"US", "comp_language"=>nil, "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"905", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"3207802", "pers_birthday"=>1992-12-11 00:00:00 UTC, "Addr_Address1"=>"2194", "Addr_Address2"=>"Donald Rd", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Burlington", "Addr_State"=>"ON", "Addr_PostCode"=>"L7M 3R9", "Addr_Country"=>"CA", "pers_webusername"=>"zavaglie@mcmaster.ca ", "pers_webpassword"=>"~~GjtRc6zlNj7dx/iaLIcmhQ== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>nil, "pers_primaryempsector"=>nil, "pers_regnumber"=>nil, "pext_edschoolca"=>"UMcMaster", "pext_edschoolinca"=>nil, "pext_edschoolint"=>nil, "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>2017-09-30 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2017-10-02 00:00:00 UTC, "graduation_year"=>2017, "comp_startdate"=>2016-04-21 00:00:00 UTC, "Comp_CreatedDate"=>2016-04-21 11:23:19 UTC, "Pers_CreatedDate"=>2016-04-21 11:24:42 UTC, "Addr_CreatedDate"=>2016-04-21 11:24:42 UTC} | |
| 15283 : USERNAME_DUPLICATE : {"Comp_CompanyId"=>92150, "Comp_IdCust"=>"2031221 ", "Pers_PersonId"=>83127, "comp_orgtype"=>"Member", "Comp_Status"=>"Active", "Comp_Type"=>"Customer ", "comp_membertier"=>"FFT", "comp_district"=>"ON-WG", "comp_cpadivisions"=>nil, "Pers_LastName"=>"Philip", "Pers_FirstName"=>"Aju", "Pers_MiddleName"=>nil, "Pers_Salutation"=>"Mr.", "Pers_Title"=>nil, "Pers_EmailAddress"=>"ajuphilip07@gmail.com", "Pers_Gender"=>"Male ", "pers_language"=>"US", "comp_language"=>"US", "pers_birthlastname"=>nil, "Pers_PhoneAreaCode"=>"416", "Pers_PhoneCountryCode"=>nil, "Pers_PhoneNumber"=>"5006234", "pers_birthday"=>1977-03-28 00:00:00 UTC, "Addr_Address1"=>"3944", "Addr_Address2"=>"quiet creek Dr", "Addr_Address3"=>"", "Addr_Address4"=>"", "Addr_City"=>"Mississauga", "Addr_State"=>"ON", "Addr_PostCode"=>"l5m8b4", "Addr_Country"=>"CA", "pers_webusername"=>"ajuphilip07@gmail.com ", "pers_webpassword"=>"~~BUJOGtACEdnWvRUQ3R33Mg== ", "comp_physpracticelang"=>nil, "comp_physpracticeareas"=>nil, "comp_physconditions"=>nil, "comp_physpracticespecialist"=>nil, "comp_phystreatments"=>nil, "comp_notrenewreason"=>nil, "comp_cancelreason"=>nil, "comp_cancelreasoncode"=>nil, "pers_primaryemployment"=>"VAB", "pers_primaryempsector"=>"Public", "pers_regnumber"=>"16931", "pext_edschoolca"=>nil, "pext_edschoolinca"=>"N", "pext_edschoolint"=>"IN", "pext_edcredential"=>"Bachelors", "pext_edgraddate"=>2001-05-14 00:00:00 UTC, "pext_swgraddate"=>nil, "pext_gradperiod"=>2001-10-02 00:00:00 UTC, "graduation_year"=>2001, "comp_startdate"=>2016-06-22 00:00:00 UTC, "Comp_CreatedDate"=>2016-06-22 10:06:41 UTC, "Pers_CreatedDate"=>2016-06-22 10:13:22 UTC, "Addr_CreatedDate"=>2016-06-22 10:13:23 UTC} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- NB we do not need any addresses marked as: Comp_PrimaryAddressId | |
| SELECT | |
| (SELECT TOP 1 link.AdLi_CompanyID | |
| FROM Address_Link link | |
| WHERE link.AdLi_AddressId = a.Addr_AddressId) AddrCompanyID | |
| , (SELECT TOP 1 link.AdLi_Type | |
| FROM Address_Link link | |
| WHERE link.AdLi_AddressId = a.Addr_AddressId) AddrType | |
| , a.* | |
| INTO xpt_Address | |
| FROM Address a | |
| WHERE a.Addr_AddressId IN ( | |
| SELECT DISTINCT a.Addr_AddressId | |
| FROM Address a | |
| JOIN Address_Link al ON al.AdLi_AddressId = a.Addr_AddressId | |
| WHERE al.AdLi_CompanyID IN ( | |
| SELECT DISTINCT Comp_CompanyId | |
| FROM xpt_Membership | |
| ) | |
| AND a.Addr_AddressId NOT IN ( | |
| SELECT Addr_AddressId | |
| FROM xpt_Membership | |
| ) | |
| ) | |
| ORDER BY AddrCompanyID |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| c.Comp_CompanyId | |
| , c.Comp_PrimaryPersonId | |
| , el.ELink_LinkID | |
| , el.ELink_EntityID | |
| , el.ELink_RecordID | |
| , el.ELink_Type | |
| , e.Emai_EmailAddress | |
| , e.Emai_CreatedDate | |
| , e.Emai_UpdatedDate | |
| FROM Company c | |
| JOIN EmailLink el ON (el.ELink_RecordID = c.Comp_CompanyId AND el.ELink_EntityID = 5) OR (el.ELink_RecordID = c.Comp_PrimaryPersonId AND el.ELink_EntityID = 13) | |
| JOIN Email e ON e.Emai_EmailId = el.ELink_EmailId | |
| JOIN Person p ON p.Pers_CompanyId = c.Comp_CompanyId | |
| WHERE el.ELink_Deleted IS NULL | |
| AND c.Comp_CompanyId IN (SELECT DISTINCT Comp_CompanyId FROM xpt_Membership) | |
| ORDER BY c.Comp_CompanyId |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| Comp_CompanyId | |
| , Comp_IdCust | |
| , Pers_PersonId | |
| , comp_orgtype | |
| , rtrim(Comp_Status) Comp_Status | |
| , Comp_Type | |
| , rtrim(comp_membertier) comp_membertier | |
| , Comp_SecTerr | |
| , rtrim(comp_district) comp_district | |
| , comp_cpadivisions | |
| , rtrim(Pers_LastName) Pers_LastName | |
| , rtrim(Pers_FirstName) Pers_FirstName | |
| , rtrim(Pers_MiddleName) Pers_MiddleName | |
| , rtrim(Pers_Salutation) Pers_Salutation | |
| , rtrim(Pers_Title) Pers_Title | |
| , Pers_EmailAddress | |
| , Pers_Gender | |
| , pers_language | |
| , comp_language | |
| , pers_birthlastname | |
| , Pers_PhoneAreaCode | |
| , Pers_PhoneCountryCode | |
| , Pers_PhoneNumber | |
| , pers_birthday | |
| , Addr_AddressId | |
| , Addr_Address1 | |
| , Addr_Address2 | |
| , Addr_Address3 | |
| , Addr_Address4 | |
| , Addr_City | |
| , Addr_State | |
| , Addr_PostCode | |
| , Addr_Country | |
| , pers_webusername | |
| , pers_webpassword | |
| , comp_physpracticelang | |
| , comp_physpracticeareas | |
| , comp_physconditions | |
| , comp_physpracticespecialist | |
| , comp_phystreatments | |
| , comp_notrenewreason | |
| , comp_cancelreason | |
| , comp_cancelreasoncode | |
| , pers_primaryemployment | |
| , pers_primaryempsector | |
| , pers_regnumber | |
| , pext_edschoolca | |
| , pext_edschoolinca | |
| , pext_edschoolint | |
| , pext_edcredential | |
| , pext_edgraddate | |
| , pext_swgraddate | |
| , pext_gradperiod | |
| , year(pext_gradperiod) graduation_year | |
| , comp_startdate | |
| , Comp_CreatedDate | |
| , Pers_CreatedDate | |
| , Addr_CreatedDate | |
| INTO xpt_Membership | |
| FROM Company c | |
| JOIN vPerson p ON c.Comp_PrimaryPersonId = p.Pers_PersonId | |
| JOIN Address a ON c.Comp_PrimaryAddressId = a.Addr_AddressId | |
| JOIN Person_Extended px ON p.Pers_PersonId = px.pext_personid | |
| WHERE c.Comp_Deleted IS NULL | |
| AND c.comp_orgtype IN ('Member') | |
| AND c.Comp_Status IN ('Active') | |
| ORDER BY c.Comp_Status, c.Comp_CompanyId; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| c.Comp_CompanyId | |
| , c.Comp_PrimaryPersonId | |
| , n.* | |
| FROM Company c | |
| JOIN Notes n ON (n.Note_ForeignId = c.Comp_CompanyId AND n.Note_ForeignTableId = 5) OR (n.Note_ForeignId = c.Comp_PrimaryPersonId AND n.Note_ForeignTableId = 13) | |
| WHERE n.Note_Deleted IS NULL |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| Quot_QuoteId quoteid | |
| , Quot_CompanyId companyid | |
| , quot_total total | |
| , quot_taxtotal taxtotal | |
| , CONVERT(DATE, mmbr_datestart) datestart | |
| , CONVERT(DATE, mmbr_dateend) dateend | |
| , Quot_CreatedDate datequote | |
| INTO xpt_Order | |
| FROM C21_OE_Quote q | |
| JOIN C21_Assoc_Membership a ON a.mmbr_quoteid = q.Quot_QuoteId | |
| WHERE Quot_Deleted IS NULL | |
| AND q.quot_stage = 'Order' | |
| AND q.quot_ordcategory IN ('RENEWMEM', 'NEWMEM') | |
| AND Quot_CompanyId IN ( | |
| SELECT DISTINCT Comp_CompanyId | |
| FROM xpt_Membership | |
| ) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| QtDt_QuoteId quoteid | |
| , QtDt_Item quote_item_id | |
| , QtDt_ExtendedPrice price | |
| , RTRIM(qtdt_AccpacITEMNO) code | |
| , RTRIM(QtDt_ItemDescription) description | |
| , QtDt_CreatedDate created | |
| INTO xpt_OrderDetail | |
| FROM C21_OE_QuoteDetail | |
| WHERE QtDt_Deleted IS NULL | |
| AND QtDt_QuoteId IN ( | |
| SELECT DISTINCT quoteid | |
| FROM xpt_Order | |
| ) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| pl.PLink_Type | |
| , p.Phon_CountryCode | |
| , p.Phon_AreaCode | |
| , p.Phon_Number | |
| , pl.PLink_UpdatedDate created_at | |
| , p.Phon_UpdatedDate updated_at | |
| FROM Company c | |
| JOIN PhoneLink pl ON (pl.PLink_RecordID = c.Comp_CompanyId AND pl.PLink_EntityID = 5) | |
| OR (pl.PLink_RecordID = c.Comp_PrimaryPersonId AND pl.PLink_EntityID = 13) | |
| JOIN Phone p ON p.Phon_PhoneId = pl.PLink_PhoneId | |
| WHERE pl.PLink_Deleted IS NULL | |
| AND p.Phon_Deleted IS NULL |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment