ahsmaster schema
Go back to database start page
=== tables ===
* adolsoyblack
* adolsoywhite
* ahs2reconsent2024 * ahsuslc_fixed * allcancers_tmp * allqids * analysisid * arhs1participants20191030 * arhs2a * arhs2b * arhs2c * arhs2d * arhs_20070122_black * arhs_20070122_nonblack * arhs_cases_for_rhonda * arhs_clinic_blacks_20070327 * arhs_deceased_error_2017 * arhs_m2_b * arhs_m2_nb * arhs_wave2 * arhs_wave2_3000_nobiomrs_randomized * arhs_wave2_hispanic * arhsblacklistwithids * arhswhitelistwithids * at_temp * backupofarhsremaildateremoval * bademailaddresses * barbarascancers * barbarascancers2 * birthdaypilot * blackcommunityfielddata * blackcommunityfielddata2 * blackcommunityminilifestyle * blackcommunityminilifestyle2 * blackcommunityminilifestyletemp * blackcommunityminilifestyletemp2 * blackcommunityminilifestyletemp3 * blackpilot * blackpilotpastors * blackstatusnew * blacksteps * brecruitingmemos * canadian_address_updates * canadianchurchesfrominternet * canadiancondeathlinks * canadianconfdeaths * canadianconferencedeaths * canadianncoa_201304 * cancerphirequests * cancertissue * cancertissuebak * cancertissuephirequests * cannotuseall * checkedandaccepted * churchaddress
* churchaddressforandrew * churchaddresshistory * churches * churcheshistory * churchliststatus * churchmemo * conferences * contractrecruiters * countyzips * dtproperties * dupdetdel * eadv2024_updatesfrom2017 * eadv2024_updatesfrom2018 * eadvdeceasedforbarbara * eadventist_ahsdata201806 * eadventistaddrcurr * eadventistaddrcurrbak * eadventistaddrdelivnote * eadventistmatches * eadventistmatches201806 * eadventistmatchesauto * eadventistmatchesmanual * eadventistsource * eadventistsourceaddr * eadventistsourceemail * eadventistsourcephone * eadvmasterlist * email_optout * email_optout_results * f_activitieswithnotes * f_par * f_par_activities_cyclingcategoryadded * f_par_activitieswithdates * f_par_minute_summaries * f_recalls_doc * facilities * fayth20200410 * file2 * fmo_linkage_matches * fmo_patients * geodistance * geodistance_auc_ma * geodistance_brooklyn * geodistance_florida * geodistance_hinsdale * geodistance_la_area * geodistance_ll_medcenter * geodistance_oakwood * geodistance_portland * geodistance_wallawalla * geodistance_wau_md * grasp * hh4_telephoneentry * hh4_telephoneentry_bak20121227 * hh5_telephoneentry * hh5_telephoneentry_bak20130220 * hh5_telephoneentry_bak20130221 * hhq5_b1_m1_canadian * hhq5_b1_m1_southcentral * hhq5_b1_m1_us * hhq5_b1_m2_canadian * hhq5_b1_m2_us_exclsouthcentral * hhreturnfixes * hi_consent * hispanicsforkaren * israelisubjectsforfraser * jisooapprovedstates * jisoograsp * jisoograsp2 * jisoograsp20180508 * jisoophirequests * jk_randomchf * jk_randomnonchf * jkwon_master_nonchf_response_sheet * jkwon_mergedfile * linkfile2 * links_using2012completiondates * llu103_customer_copy_ex * llud * lluf * localblacks * logins * lorton20070914 * lorton20080417 * lorton20090714 * lorton201004 * lorton201010 * lorton201203 * lorton201204_canadian * lorton20120904 * lorton201401 * lorton201401b * lorton201410 * lorton201702 * lorton201801 * lorton_201304 * lortontmp * lowdairyvegetarians * mailroom * mb_201303 * mb_enhancedpeoplesearch * mb_enhancedpeoplesearch2 * medicare2010mbsfab * medicare2010mbsfcc * medicare2010mbsfcu * medicare2010mbsfd * medicare2010medpsl * medicare2011mbsfab * medicare2011mbsfcc * medicare2011mbsfcu * medicare2011mbsfd * medicare2011medpsl * medicareforjboh * medicareforjerrylee * medicareforjerryleeoutdated * medicaressnbenex * medicaressnbenex2022 * medicaressnbenex2024 * medicaresubjects2024 * microbilt_20120420 * microbilt_20120420b * microbilt_20120706 * microbiome * microbiome_bak * microbiome_bak20160630 * microbiomebak * microbiomecounts201811 * microbiomefiber20170306 * microbiomenci20170306 * microbiomenci20170512 * microbiomeqredata20170306 * microbiomevolunteers * miscmailings * miscmailings_bak * miscmailings_bak20090922 * miscmailings_bak20120827 * miscmailingscopy * miscmailingsold * miscmailingsold2 * miscmailingsold3 * missinglithos * mssqltables * mt_consent_mailing * ncoa_updates_20131014 * ndi_2002_2008 * ndi_2002_2009 * ndi_2002_2013_missed * ndi_2002_2013_missed2 * ndi_2002_2013_missed2_raw * ndi_2002_2013_missed_withdup * ndi_2009 * ndi_2010 * ndi_2011 * ndi_2011_raw * ndi_2012_2013 * ndi_2012_2013_old * ndi_2012_2013_raw * ndi_2014 * ndi_2014_raw * ndi_2015 * ndi_2015_raw * ndi_2016_arhs * ndi_2016_arhs_raw * ndi_2017_arhs * ndi_2017_arhs_raw * ndi_duplicates_2015 * ndi_final * ndi_final_bak * ndi_submitted_2002to2005 * ndi_test * ndi_tracking * ndisubmitted20022013supplemental * ndisubmittedarhsfor2016 * ndisubmittedarhsfor2017 * ndisubmittedarhsfor2018 * ndisubmittedfor2002 * ndisubmittedfor20022013supp2 * ndisubmittedfor2003 * ndisubmittedfor2004 * ndisubmittedfor2005 * ndisubmittedfor2006 * ndisubmittedfor2007 * ndisubmittedfor2008 * ndisubmittedfor2009 * ndisubmittedfor2010 * ndisubmittedfor2011 * ndisubmittedfor2012 * ndisubmittedfor2013 * ndisubmittedfor2014 * ndisubmittedfor2015 * newqsurveylist * newsletter_black_canadian_20130503 * newsletter_non_black_canadian_20130503 * ocr_entry * ocr_entry2 * officialzips_2011 * onehundredsubjforfraser * onehundredsubjforkaren * onehundredsubjforucsd * onlineenrollmentchurchinfo * op30kchurches * ophthalmology * originaladdress * overlap * par_activitieswithdates * pastorstatus * people * people_archive * people_bak20150624 * people_bak20160328 * people_bak20160802 * people_bak20161109 * people_bak20180130 * people_bak20180314 * people_includingnonrespondents * peoplebak20161018 * peopledeleted2016nov * peoplehistory * peoplesaddresses * peoplesaddresses_bak20130411 * peoplesaddresses_bak20140711 * peoplesaddresses_bak20141031 * peoplesaddresses_bak20170214 * peoplesaddresses_test * peoplesaddresses_timeline2014 * peoplesaddresses_timeline2015 * peoplesaddresses_timeline2016 * peoplesaddressesbak20140529 * peoplesaddresseshistory * peoplescities_timeline2015 * peoplescontactinfo * peoplescontactinfo_bak20150902 * peoplescontactinfohistory * peoplesnames * peoplesstates_timeline2015 * peoplewithduplicatessn * peridata20180921 * periobesity * peripilot * personnelinfo * personnelinfohistory * prescanquesttrack * programmingtasks * psymrs2mail * qidcidmerge20140220 * ridparticipants * seth_id * sherzai * sherzaimatches * shorterformfeedback * soyprot * spouses * spousesaddresstmp * spousesnametmp * states * statesprovincesterritories * stepstatus * stepstatushistory * substudyparticipation * synnovescancertissue20160107 * telematch * telephony_log * telephony_projects * telephony_status * telephony_subjects * tmp * tmpblacksforsynnove20141008 * tmplocrec * tmpop30000data * tmptelef-u * tmptoh1 * twopageerrormailing * unions * whitestatus * whitesteps * zipcodesfromcensus * zipradii * zipradii2