ahsmaster schema

Go back to database start page

=== tables ===
* 30k_exclusions_1
* 30k_exclusions_2
* 30k_exclusions_3
* 30k_exclusions_4
* 30k_exclusions_5
* 30k_exclusions_6
* 30k_exclusions_7
* addressassess
* addressassess2
* addresstimeline
* addresstimeline2
* addresstimeline2015
* addresstimeline2016
* 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