aurora_standard.chltrand

Field	Type	Null	Key	Extra
lname	varchar(18)	YES
fname	varchar(12)	YES
mname	varchar(1)	YES
sr_jr	varchar(3)	YES
admis_dte	varchar(8)	YES
ssn	varchar(9)	YES
prov_no	varchar(11)	YES
fed_no	varchar(11)	YES
gender	varchar(1)	YES
race	varchar(1)	YES
birthdate	varchar(8)	YES
occupation	varchar(15)	YES
language	varchar(1)	YES
other_lang	varchar(15)	YES
residenta	varchar(1)	YES
residentb	varchar(1)	YES
residentc	varchar(1)	YES
residentd	varchar(1)	YES
residente	varchar(1)	YES
mnt_hlth	varchar(1)	YES
mr_dda	varchar(1)	YES
mr_ddb	varchar(1)	YES
mr_ddc	varchar(1)	YES
mr_ddd	varchar(1)	YES
mr_dde	varchar(1)	YES
mr_ddf	varchar(1)	YES
mr_ddg	varchar(1)	YES
mr_ddh	varchar(1)	YES
admt_from	varchar(1)	YES
lv_alone	varchar(1)	YES
adm_infoa	varchar(1)	YES
dm_infob	varchar(1)	YES
adm_infoc	varchar(1)	YES
adm_infod	varchar(1)	YES
cust_rtea	varchar(1)	YES
cust_rteb	varchar(1)	YES
cust_rtec	varchar(1)	YES
cust_rted	varchar(1)	YES
cust_rtee	varchar(1)	YES
cust_rtef	varchar(1)	YES
cust_rteg	varchar(1)	YES
cust_rteh	varchar(1)	YES
cust_rtei	varchar(1)	YES
cust_rtej	varchar(1)	YES
cust_rtek	varchar(1)	YES
cust_rtel	varchar(1)	YES
cust_rtem	varchar(1)	YES
cust_rten	varchar(1)	YES
cust_rteo	varchar(1)	YES
cust_rtep	varchar(1)	YES
cust_rteq	varchar(1)	YES
cust_rter	varchar(1)	YES
cust_rtes	varchar(1)	YES
cust_rtet	varchar(1)	YES
cust_rteu	varchar(1)	YES
cust_rtev	varchar(1)	YES
cust_rtew	varchar(1)	YES
cust_rtex	varchar(1)	YES
cust_rtey	varchar(1)	YES
re_adm2	varchar(8)	YES
re_adm4	varchar(1)	YES
re_adm5	varchar(1)	YES
re_adm6	varchar(1)	YES
asmnt_dte	varchar(8)	YES
flag	varchar(1)	YES
medicare	varchar(12)	YES
medicaid	varchar(14)	YES
medrec_no	varchar(11)	YES
asmnt_rsna	varchar(1)	YES
asmnt_rsnb	varchar(1)	YES
asmnt_rsnc	varchar(1)	YES
asmnt_srca	varchar(1)	YES
pymnt_srcb	varchar(1)	YES
pymnt_srcc	varchar(1)	YES
pymnt_srcd	varchar(1)	YES
pymnt_srce	varchar(1)	YES
pymnt_srcf	varchar(1)	YES
guardiana	varchar(1)	YES
guardianb	varchar(1)	YES
guardianc	varchar(1)	YES
guardiand	varchar(1)	YES
guardiane	varchar(1)	YES
guardianf	varchar(1)	YES
adv_drcta	varchar(1)	YES
adv_drctb	varchar(1)	YES
adv_drctc	varchar(1)	YES
adv_drctd	varchar(1)	YES
adv_drcte	varchar(1)	YES
adv_drctf	varchar(1)	YES
adv_drctg	varchar(1)	YES
adv_drcth	varchar(1)	YES
adv_drcti	varchar(1)	YES
dischrg	varchar(1)	YES
marital	varchar(1)	YES
rm_num	varchar(4)	YES
hosp_adm	varchar(2)	YES
er_trans	varchar(2)	YES
comatose	varchar(1)	YES
memorya	varchar(1)	YES
memoryb	varchar(1)	YES
recalla	varchar(1)	YES
recallb	varchar(1)	YES
recallc	varchar(1)	YES
recalld	varchar(1)	YES
recalle	varchar(1)	YES
decision	varchar(1)	YES
indicatorsa	varchar(1)	YES
indicatorsb	varchar(1)	YES
indicatorsc	varchar(1)	YES
indicatorsd	varchar(1)	YES
indicatorse	varchar(1)	YES
indicatorsf	varchar(1)	YES
chng_cog	varchar(1)	YES
hearing	varchar(1)	YES
comm_techa	varchar(1)	YES
comm_techb	varchar(1)	YES
comm_techc	varchar(1)	YES
comm_techd	varchar(1)	YES
modesa	varchar(1)	YES
modesb	varchar(1)	YES
modesc	varchar(1)	YES
modesd	varchar(1)	YES
modese	varchar(1)	YES
modesf	varchar(1)	YES
modesg	varchar(1)	YES
undrstood	varchar(1)	YES
speech	varchar(1)	YES
undrstand	varchar(1)	YES
chng_comm	varchar(1)	YES
vision	varchar(1)	YES
vis_lmta	varchar(1)	YES
vis_lmtb	varchar(1)	YES
vis_lmtc	varchar(1)	YES
vis_appl	varchar(1)	YES
anx_mooda	varchar(1)	YES
anx_moodb	varchar(1)	YES
anx_moodc	varchar(1)	YES
anx_moodd	varchar(1)	YES
anx_moode	varchar(1)	YES
anx_moodf	varchar(1)	YES
anx_moodg	varchar(1)	YES
anx_moodh	varchar(1)	YES
anx_moodi	varchar(1)	YES
anx_moodj	varchar(1)	YES
anx_moodk	varchar(1)	YES
mood_pers	varchar(1)	YES
prob_behava	varchar(1)	YES
prob_behavb	varchar(1)	YES
prob_behavc	varchar(1)	YES
prob_behavd	varchar(1)	YES
rest_carea	varchar(1)	YES
rest_careb	varchar(1)	YES
rest_carec	varchar(1)	YES
rest_cared	varchar(1)	YES
behav_mgmnt	varchar(1)	YES
chng_mood	varchar(1)	YES
chng_pbehav	varchar(1)	YES
sense_inita	varchar(1)	YES
sense_initb	varchar(1)	YES
sense_initc	varchar(1)	YES
sense_initd	varchar(1)	YES
sense_inite	varchar(1)	YES
sense_initf	varchar(1)	YES
sense_initg	varchar(1)	YES
sense_inith	varchar(1)	YES
unsettlea	varchar(1)	YES
unsettleb	varchar(1)	YES
unsettlec	varchar(1)	YES
unsettled	varchar(1)	YES
unsettlee	varchar(1)	YES
unsettlef	varchar(1)	YES
unsettleg	varchar(1)	YES
unsettleh	varchar(1)	YES
past_rolesa	varchar(1)	YES
past_rolesb	varchar(1)	YES
past_rolesc	varchar(1)	YES
time_awakea	varchar(1)	YES
time_awakeb	varchar(1)	YES
time_awakec	varchar(1)	YES
time_awaked	varchar(1)	YES
avg_act	varchar(1)	YES
pref_acta	varchar(1)	YES
pref_actb	varchar(1)	YES
pref_actc	varchar(1)	YES
pref_actd	varchar(1)	YES
pref_acte	varchar(1)	YES
gen_acta	varchar(1)	YES
gen_actb	varchar(1)	YES
gen_actc	varchar(1)	YES
gen_actd	varchar(1)	YES
gen_acte	varchar(1)	YES
gen_actf	varchar(1)	YES
gen_actg	varchar(1)	YES
gen_acth	varchar(1)	YES
gen_acti	varchar(1)	YES
gen_actj	varchar(1)	YES
gen_actk	varchar(1)	YES
gen_actl	varchar(1)	YES
gen_actm	varchar(1)	YES
pref_dir_act	varchar(1)	YES
isolation	varchar(1)	YES
sensory	varchar(1)	YES
bed_mobility1	varchar(1)	YES
bed_mobility2	varchar(1)	YES
transfer1	varchar(1)	YES
transfer2	varchar(1)	YES
locomotion1	varchar(1)	YES
locomotion2	varchar(1)	YES
dressing1	varchar(1)	YES
dressing2	varchar(1)	YES
eating1	varchar(1)	YES
eating2	varchar(1)	YES
toilet_use1	varchar(1)	YES
toilet_use2	varchar(1)	YES
hygiene1	varchar(1)	YES
hygiene2	varchar(1)	YES
walking1a	varchar(1)	YES
walking2a	varchar(1)	YES
walking1b	varchar(1)	YES
walking2b	varchar(1)	YES
walking1c	varchar(1)	YES
walking2c	varchar(1)	YES
walking1d	varchar(1)	YES
walking2d	varchar(1)	YES
bathinga1	varchar(1)	YES
bathinga2	varchar(1)	YES
bathingba	varchar(1)	YES
bathingbb	varchar(1)	YES
bathingbc	varchar(1)	YES
bathingbd	varchar(1)	YES
bathingbe	varchar(1)	YES
bathingbf	varchar(1)	YES
body_conta	varchar(1)	YES
body_contb	varchar(1)	YES
body_contc	varchar(1)	YES
body_contd	varchar(1)	YES
body_conte	varchar(1)	YES
body_contf	varchar(1)	YES
body_contg	varchar(1)	YES
body_conth	varchar(1)	YES
body_conti	varchar(1)	YES
body_contj	varchar(1)	YES
body_contk	varchar(1)	YES
contracturesa	varchar(1)	YES
contracturesb	varchar(1)	YES
contracturesc	varchar(1)	YES
contracturesd	varchar(1)	YES
contracturese	varchar(1)	YES
contracturesf	varchar(1)	YES
contracturesg	varchar(1)	YES
mobility_appla	varchar(1)	YES
mobility_applb	varchar(1)	YES
mobility_applc	varchar(1)	YES
mobility_appld	varchar(1)	YES
mobility_apple	varchar(1)	YES
mobility_applf	varchar(1)	YES
mobility_applg	varchar(1)	YES
mobility_applh	varchar(1)	YES
mobility_appli	varchar(1)	YES
task_segment	varchar(1)	YES
adl_functa	varchar(1)	YES
adl_functb	varchar(1)	YES
adl_functc	varchar(1)	YES
adl_functd	varchar(1)	YES
adl_functe	varchar(1)	YES
adl_functf	varchar(1)	YES
adl_functg	varchar(1)	YES
adl_functh	varchar(1)	YES
chng_adl	varchar(1)	YES
bowel_cont	varchar(1)	YES
bladder_cont	varchar(1)	YES
appl_proga	varchar(1)	YES
appl_progb	varchar(1)	YES
appl_progc	varchar(1)	YES
appl_progd	varchar(1)	YES
appl_proge	varchar(1)	YES
appl_progf	varchar(1)	YES
appl_progg	varchar(1)	YES
appl_progh	varchar(1)	YES
appl_progi	varchar(1)	YES
incont_blada	varchar(1)	YES
incont_bladb	varchar(1)	YES
incont_bladc	varchar(1)	YES
incont_bladd	varchar(1)	YES
urinary_chng	varchar(1)	YES
statis_ulcera	varchar(1)	YES
press_ulcera	varchar(2)	YES
press_ulcerb	varchar(2)	YES
press_ulcerc	varchar(2)	YES
press_ulcerd	varchar(2)	YES
res_ulcers	varchar(1)	YES
skin_proba	varchar(1)	YES
skin_probb	varchar(1)	YES
skin_probc	varchar(1)	YES
skin_probd	varchar(1)	YES
skin_probe	varchar(1)	YES
skin_probf	varchar(1)	YES
skin_probg	varchar(1)	YES
skin_probh	varchar(1)	YES
skin_carea	varchar(1)	YES
skin_careb	varchar(1)	YES
skin_carec	varchar(1)	YES
skin_cared	varchar(1)	YES
skin_caree	varchar(1)	YES
skin_caref	varchar(1)	YES
skin_careg	varchar(1)	YES
skin_careh	varchar(1)	YES
skin_carei	varchar(1)	YES
skin_carej	varchar(1)	YES
skin_carek	varchar(1)	YES
foot_carea	varchar(1)	YES
foot_careb	varchar(1)	YES
foot_carec	varchar(1)	YES
foot_cared	varchar(1)	YES
diseasesa	varchar(1)	YES
diseasesb	varchar(1)	YES
diseasesc	varchar(1)	YES
diseasesd	varchar(1)	YES
diseasese	varchar(1)	YES
diseasesf	varchar(1)	YES
diseasesg	varchar(1)	YES
diseasesh	varchar(1)	YES
diseasesi	varchar(1)	YES
diseasesj	varchar(1)	YES
diseasesk	varchar(1)	YES
diseasesl	varchar(1)	YES
diseasesm	varchar(1)	YES
diseasesn	varchar(1)	YES
diseaseso	varchar(1)	YES
diseasesp	varchar(1)	YES
diseasesq	varchar(1)	YES
diseasesr	varchar(1)	YES
diseasess	varchar(1)	YES
diseasest	varchar(1)	YES
diseasesu	varchar(1)	YES
diseasesv	varchar(1)	YES
diseasesw	varchar(1)	YES
diseasesx	varchar(1)	YES
diseasesy	varchar(1)	YES
diseasesz	varchar(1)	YES
diseasesaa	varchar(1)	YES
diseasesbb	varchar(1)	YES
diseasescc	varchar(1)	YES
diseasesdd	varchar(1)	YES
diseasesee	varchar(1)	YES
diseasesff	varchar(1)	YES
diseasesgg	varchar(1)	YES
diseaseshh	varchar(1)	YES
diseasesii	varchar(1)	YES
diseasesjj	varchar(1)	YES
cur_diagnosesa	varchar(7)	YES
cur_diagnosesb	varchar(7)	YES
cur_diagnosesc	varchar(7)	YES
cur_diagnosesd	varchar(7)	YES
cur_diagnosese	varchar(7)	YES
cur_diagnosesf	varchar(7)	YES
cur_diagnosesg	varchar(1)	YES
prob_sympta	varchar(1)	YES
prob_symptb	varchar(1)	YES
prob_symptc	varchar(1)	YES
prob_symptd	varchar(1)	YES
prob_sympte	varchar(1)	YES
prob_symptf	varchar(1)	YES
prob_symptg	varchar(1)	YES
prob_sympth	varchar(1)	YES
prob_sympti	varchar(1)	YES
prob_symptj	varchar(1)	YES
prob_symptk	varchar(1)	YES
prob_symptl	varchar(1)	YES
prob_symptm	varchar(1)	YES
prob_symptn	varchar(1)	YES
prob_sympto	varchar(1)	YES
prob_symptp	varchar(1)	YES
edemaa	varchar(1)	YES
edemab	varchar(1)	YES
edemac	varchar(1)	YES
edemad	varchar(1)	YES
edemae	varchar(1)	YES
accidentsa	varchar(1)	YES
accidentsb	varchar(1)	YES
accidentsc	varchar(1)	YES
accidentsd	varchar(1)	YES
accidentse	varchar(1)	YES
stabilitya	varchar(1)	YES
stabilityb	varchar(1)	YES
stabilityc	varchar(1)	YES
orala	varchar(1)	YES
oralb	varchar(1)	YES
oralc	varchar(1)	YES
orald	varchar(1)	YES
hght_wghta	varchar(2)	YES
hght_wghtb	varchar(3)	YES
hght_wghtc	varchar(1)	YES
hght_wghtd	varchar(1)	YES
nutritiona	varchar(1)	YES
nutritionb	varchar(1)	YES
nutritionc	varchar(1)	YES
nutritiond	varchar(1)	YES
nutritione	varchar(1)	YES
nutritionf	varchar(1)	YES
nutrition4a	varchar(1)	YES
nutrition4b	varchar(1)	YES
nutrition4c	varchar(1)	YES
nutrition4d	varchar(1)	YES
nutrition4e	varchar(1)	YES
nutrition4f	varchar(1)	YES
nutrition4g	varchar(1)	YES
nutrition4h	varchar(1)	YES
feeding_evala	varchar(1)	YES
feeding_evalb	varchar(1)	YES
oral_stata	varchar(1)	YES
oral_statb	varchar(1)	YES
oral_statc	varchar(1)	YES
oral_statd	varchar(1)	YES
oral_state	varchar(1)	YES
oral_statf	varchar(1)	YES
oral_statg	varchar(1)	YES
spec_carea	varchar(1)	YES
spec_careb	varchar(1)	YES
spec_carec	varchar(1)	YES
spec_cared	varchar(1)	YES
spec_caree	varchar(1)	YES
spec_caref	varchar(1)	YES
spec_careg	varchar(1)	YES
spec_careh	varchar(1)	YES
spec_carei	varchar(1)	YES
spec_carej	varchar(1)	YES
spec_carek	varchar(1)	YES
spec_carel	varchar(1)	YES
spec_carem	varchar(1)	YES
spec_carel2	varchar(12)	YES
therapa	varchar(1)	YES
therapa2	varchar(4)	YES
therapb	varchar(1)	YES
therapb2	varchar(4)	YES
therapc	varchar(1)	YES
therapc2	varchar(4)	YES
therapd	varchar(1)	YES
therapd2	varchar(4)	YES
therape	varchar(1)	YES
therape2	varchar(4)	YES
therapf	varchar(1)	YES
therapf2	varchar(4)	YES
order_therapa	varchar(2)	YES
order_therapa2	varchar(4)	YES
order_therapb	varchar(2)	YES
order_therapb2	varchar(4)	YES
order_therapc	varchar(2)	YES
order_therapc2	varchar(4)	YES
rehaba	varchar(1)	YES
rehabb	varchar(1)	YES
rehabc	varchar(1)	YES
rehabd	varchar(1)	YES
rehabe	varchar(1)	YES
rehabf	varchar(1)	YES
rehabg	varchar(1)	YES
rehabh	varchar(1)	YES
rehabi	varchar(1)	YES
rehabj	varchar(1)	YES
rehabk	varchar(1)	YES
rehabl	varchar(1)	YES
devicesa	varchar(1)	YES
devicesb	varchar(1)	YES
devicesc	varchar(1)	YES
devicesd	varchar(1)	YES
phys_visits	varchar(2)	YES
phys_orders	varchar(2)	YES
abnorm_lab	varchar(1)	YES
num_med	varchar(2)	YES
new_med	varchar(1)	YES
injections	varchar(1)	YES
meda	varchar(1)	YES
medb	varchar(1)	YES
medc	varchar(1)	YES
prev_med_res	varchar(1)	YES
participateda	varchar(1)	YES
participatedb	varchar(1)	YES
participatedc	varchar(1)	YES
asmnt_incomp	varchar(1)	YES
asmnt_end	varchar(8)	YES
route	varchar(2)	YES
freq	varchar(2)	YES
prn	varchar(2)	YES
ndc_code	varchar(11)	YES
route2	varchar(2)	YES
freq2	varchar(2)	YES
prn2	varchar(2)	YES
ndc_code2	varchar(11)	YES
route3	varchar(2)	YES
freq3	varchar(2)	YES
prn3	varchar(2)	YES
ndc_code3	varchar(11)	YES
route4	varchar(2)	YES
freq4	varchar(2)	YES
prn4	varchar(2)	YES
ndc_code4	varchar(11)	YES
route5	varchar(2)	YES
freq5	varchar(2)	YES
prn5	varchar(2)	YES
ndc_code5	varchar(11)	YES
route6	varchar(2)	YES
freq6	varchar(2)	YES
prn6	varchar(2)	YES
ndc_code6	varchar(11)	YES
route7	varchar(2)	YES
freq7	varchar(2)	YES
prn7	varchar(2)	YES
ndc_code7	varchar(11)	YES
route8	varchar(2)	YES
freq8	varchar(2)	YES
prn8	varchar(2)	YES
ndc_code8	varchar(11)	YES
route9	varchar(2)	YES
freq9	varchar(2)	YES
prn9	varchar(2)	YES
ndc_code9	varchar(11)	YES
route10	varchar(2)	YES
freq10	varchar(2)	YES
prn10	varchar(2)	YES
ndc_code10	varchar(11)	YES
route11	varchar(2)	YES
freq11	varchar(2)	YES
prn11	varchar(2)	YES
ndc_code11	varchar(11)	YES
route12	varchar(2)	YES
freq12	varchar(2)	YES
prn12	varchar(2)	YES
ndc_code12	varchar(11)	YES
route13	varchar(2)	YES
freq13	varchar(2)	YES
prn13	varchar(2)	YES
ndc_code13	varchar(11)	YES
route14	varchar(2)	YES
freq14	varchar(2)	YES
prn14	varchar(2)	YES
ndc_code14	varchar(11)	YES
route15	varchar(2)	YES
freq15	varchar(2)	YES
prn15	varchar(2)	YES
ndc_code15	varchar(11)	YES
route16	varchar(2)	YES
freq16	varchar(2)	YES
prn16	varchar(2)	YES
ndc_code16	varchar(11)	YES
route17	varchar(2)	YES
freq17	varchar(2)	YES
prn17	varchar(2)	YES
ndc_code17	varchar(11)	YES
route18	varchar(2)	YES
freq18	varchar(2)	YES
prn18	varchar(2)	YES
ndc_code18	varchar(11)	YES
frm_vrsn	varchar(5)	YES
chs_rowID	bigint(20) unsigned	NO	PRI	auto_increment

References

Local Column

References

fname

Table	Column
Azalea.employees	emp_fname
_1.billing_providers	bp_fname
_1.charts	chrt_fname
_1.client_contacts	clicon_fname
_1.cpoe_responses	cpoe_res_fname
_1.donors	don_fname
_1.encounters	enc_fname
_1.encounters_soap_templates	est_phy_fname
_1.hl7_accessions	acc_fname
_1.non_patients	npat_fname
_1.orders	ord_fname
_1.patient_next_of_kin	pnk_fname
_1.patients	pat_fname
_1.patients	pat_birth_fname
_1.patients_demographics_snapshots	pds_fname
_1.patients_names	pn_fname
_1.patients_responsibility_estimates	prest_fname
_1.physicians	phy_fname
_1.precerts	pre_fname
_1.radiology_orders	rad_fname
_1.radiology_results	rad_res_fname
_1188.billing_providers	bp_fname
_1188.charts	chrt_fname
_1188.client_contacts	clicon_fname
_1188.cpoe_responses	cpoe_res_fname
_1188.donors	don_fname
_1188.encounters	enc_fname
_1188.encounters_soap_templates	est_phy_fname
_1188.hl7_accessions	acc_fname
_1188.non_patients	npat_fname
_1188.orders	ord_fname
_1188.patient_next_of_kin	pnk_fname
_1188.patients	pat_fname
_1188.patients	pat_birth_fname
_1188.patients_demographics_snapshots	pds_fname
_1188.patients_names	pn_fname
_1188.patients_responsibility_estimates	prest_fname
_1188.physicians	phy_fname
_1188.precerts	pre_fname
_1188.radiology_orders	rad_fname
_1188.radiology_results	rad_res_fname
_1218.billing_providers	bp_fname
_1218.charts	chrt_fname
_1218.client_contacts	clicon_fname
_1218.cpoe_responses	cpoe_res_fname
_1218.donors	don_fname
_1218.encounters	enc_fname
_1218.encounters_soap_templates	est_phy_fname
_1218.hl7_accessions	acc_fname
_1218.non_patients	npat_fname
_1218.orders	ord_fname
_1218.patient_next_of_kin	pnk_fname
_1218.patients	pat_fname
_1218.patients	pat_birth_fname
_1218.patients_demographics_snapshots	pds_fname
_1218.patients_names	pn_fname
_1218.patients_responsibility_estimates	prest_fname
_1218.physicians	phy_fname
_1218.precerts	pre_fname
_1218.radiology_orders	rad_fname
_1218.radiology_results	rad_res_fname
_1548.billing_providers	bp_fname
_1548.charts	chrt_fname
_1548.client_contacts	clicon_fname
_1548.cpoe_responses	cpoe_res_fname
_1548.donors	don_fname
_1548.encounters	enc_fname
_1548.encounters_soap_templates	est_phy_fname
_1548.hl7_accessions	acc_fname
_1548.non_patients	npat_fname
_1548.orders	ord_fname
_1548.patient_next_of_kin	pnk_fname
_1548.patients	pat_fname
_1548.patients	pat_birth_fname
_1548.patients_demographics_snapshots	pds_fname
_1548.patients_names	pn_fname
_1548.patients_responsibility_estimates	prest_fname
_1548.physicians	phy_fname
_1548.precerts	pre_fname
_1548.radiology_orders	rad_fname
_1548.radiology_results	rad_res_fname
_435.billing_providers	bp_fname
_435.charts	chrt_fname
_435.client_contacts	clicon_fname
_435.cpoe_responses	cpoe_res_fname
_435.donors	don_fname
_435.encounters	enc_fname
_435.encounters_soap_templates	est_phy_fname
_435.hl7_accessions	acc_fname
_435.non_patients	npat_fname
_435.orders	ord_fname
_435.patient_next_of_kin	pnk_fname
_435.patients	pat_fname
_435.patients	pat_birth_fname
_435.patients_demographics_snapshots	pds_fname
_435.patients_names	pn_fname
_435.patients_responsibility_estimates	prest_fname
_435.physicians	phy_fname
_435.precerts	pre_fname
_435.radiology_orders	rad_fname
_435.radiology_results	rad_res_fname
_436.billing_providers	bp_fname
_436.charts	chrt_fname
_436.client_contacts	clicon_fname
_436.cpoe_responses	cpoe_res_fname
_436.donors	don_fname
_436.encounters	enc_fname
_436.encounters_soap_templates	est_phy_fname
_436.hl7_accessions	acc_fname
_436.non_patients	npat_fname
_436.orders	ord_fname
_436.patient_next_of_kin	pnk_fname
_436.patients	pat_fname
_436.patients	pat_birth_fname
_436.patients_demographics_snapshots	pds_fname
_436.patients_names	pn_fname
_436.patients_responsibility_estimates	prest_fname
_436.physicians	phy_fname
_436.precerts	pre_fname
_436.radiology_orders	rad_fname
_436.radiology_results	rad_res_fname
_436_archive_testing.billing_providers	bp_fname
_436_archive_testing.charts	chrt_fname
_436_archive_testing.client_contacts	clicon_fname
_436_archive_testing.cpoe_responses	cpoe_res_fname
_436_archive_testing.donors	don_fname
_436_archive_testing.encounters	enc_fname
_436_archive_testing.encounters_soap_templates	est_phy_fname
_436_archive_testing.hl7_accessions	acc_fname
_436_archive_testing.non_patients	npat_fname
_436_archive_testing.orders	ord_fname
_436_archive_testing.patient_next_of_kin	pnk_fname
_436_archive_testing.patients	pat_fname
_436_archive_testing.patients	pat_birth_fname
_436_archive_testing.patients_demographics_snapshots	pds_fname
_436_archive_testing.patients_responsibility_estimates	prest_fname
_436_archive_testing.physicians	phy_fname
_436_archive_testing.precerts	pre_fname
_436_archive_testing.radiology_orders	rad_fname
_436_archive_testing.radiology_results	rad_res_fname
_437.billing_providers	bp_fname
_437.charts	chrt_fname
_437.client_contacts	clicon_fname
_437.cpoe_responses	cpoe_res_fname
_437.donors	don_fname
_437.encounters	enc_fname
_437.encounters_soap_templates	est_phy_fname
_437.hl7_accessions	acc_fname
_437.non_patients	npat_fname
_437.orders	ord_fname
_437.patient_next_of_kin	pnk_fname
_437.patients	pat_fname
_437.patients	pat_birth_fname
_437.patients_demographics_snapshots	pds_fname
_437.patients_names	pn_fname
_437.patients_responsibility_estimates	prest_fname
_437.physicians	phy_fname
_437.precerts	pre_fname
_437.radiology_orders	rad_fname
_437.radiology_results	rad_res_fname
_8.billing_providers	bp_fname
_8.charts	chrt_fname
_8.client_contacts	clicon_fname
_8.cpoe_responses	cpoe_res_fname
_8.donors	don_fname
_8.encounters	enc_fname
_8.encounters_soap_templates	est_phy_fname
_8.hl7_accessions	acc_fname
_8.non_patients	npat_fname
_8.orders	ord_fname
_8.patient_next_of_kin	pnk_fname
_8.patients	pat_fname
_8.patients	pat_birth_fname
_8.patients_demographics_snapshots	pds_fname
_8.patients_names	pn_fname
_8.patients_responsibility_estimates	prest_fname
_8.physicians	phy_fname
_8.precerts	pre_fname
_8.radiology_orders	rad_fname
_8.radiology_results	rad_res_fname
_81.billing_providers	bp_fname
_81.charts	chrt_fname
_81.client_contacts	clicon_fname
_81.cpoe_responses	cpoe_res_fname
_81.donors	don_fname
_81.encounters	enc_fname
_81.encounters_soap_templates	est_phy_fname
_81.hl7_accessions	acc_fname
_81.non_patients	npat_fname
_81.orders	ord_fname
_81.patient_next_of_kin	pnk_fname
_81.patients	pat_fname
_81.patients	pat_birth_fname
_81.patients_demographics_snapshots	pds_fname
_81.patients_names	pn_fname
_81.patients_responsibility_estimates	prest_fname
_81.physicians	phy_fname
_81.precerts	pre_fname
_81.radiology_orders	rad_fname
_81.radiology_results	rad_res_fname
_999.billing_providers	bp_fname
_999.charts	chrt_fname
_999.client_contacts	clicon_fname
_999.cpoe_responses	cpoe_res_fname
_999.donors	don_fname
_999.encounters	enc_fname
_999.encounters_soap_templates	est_phy_fname
_999.hl7_accessions	acc_fname
_999.non_patients	npat_fname
_999.orders	ord_fname
_999.patient_next_of_kin	pnk_fname
_999.patients	pat_fname
_999.patients	pat_birth_fname
_999.patients_demographics_snapshots	pds_fname
_999.patients_names	pn_fname
_999.patients_responsibility_estimates	prest_fname
_999.physicians	phy_fname
_999.precerts	pre_fname
_999.radiology_orders	rad_fname
_999.radiology_results	rad_res_fname
aurora_standard.abmmpi	gu_fname
aurora_standard.abmmpi	n1_fname
aurora_standard.abmmpi	n2_fname
aurora_standard.abmvis	gu_fname
aurora_standard.bhar	g_fname
aurora_standard.bmnkin	n_fname
aurora_standard.bpar	g_fname
aurora_standard.bpar2	g_fname
aurora_standard.c7mpi	gu_fname
aurora_standard.chmarstph	att_fname
aurora_standard.chmarstph	sur_fname
aurora_standard.chmarstph	oth_fname
aurora_standard.chmarstph	oth2_fname
aurora_standard.chmarstpo	att_fname
aurora_standard.chmarstpo	sur_fname
aurora_standard.chmarstpo	oth_fname
aurora_standard.chmarstpo	oth2_fname
aurora_standard.chmhcahp	dr_fname
aurora_standard.chmlastr	pat_fname
aurora_standard.chmlastr	adm_phy_fname
aurora_standard.chmlastr	rnd_phy_fname
aurora_standard.chmlastr	ref_phy_fname
aurora_standard.chmlastr	att_phy_fname
aurora_standard.chmlastr	op_phy_fname
aurora_standard.chmlastr	oth_phy_fname
aurora_standard.chmlastr	sub_fname
aurora_standard.chmpdemo	p_fname
aurora_standard.chmpdemo	sp_fname
aurora_standard.chmpdemo	gu_fname
aurora_standard.chmpdemo	fam_phy_fname
aurora_standard.chmpdemo	attend_phy_fname
aurora_standard.chmpdemo	admit_phy_fname
aurora_standard.chmpsvcd	rend_fname
aurora_standard.chmpsvcd	ref_fname
aurora_standard.chmtxstr	pat_fname
aurora_standard.chmtxstr	att_phy_fname
aurora_standard.chmtxstr	op_phy_fname
aurora_standard.chmtxstr	cons_phy_fname
aurora_standard.styoctcc	contact_fname
aurora_standard.styoctcc	gov_entity_contact_person_fname
aurora_standard.styoempd	depend_fname
aurora_standard.styoempr	empl_fname
common.applicants	app_fname
common.contacts	con_fname
common.dashboardmd_users	dmdu_fname
common.users	usr_fname
template_library.encounters_soap_templates	est_phy_fname

lname

Table	Column
Azalea.employees	emp_lname
_1.billing_providers	bp_lname
_1.charts	chrt_lname
_1.client_contacts	clicon_lname
_1.cpoe_responses	cpoe_res_lname
_1.donors	don_lname
_1.encounters	enc_lname
_1.encounters_soap_templates	est_phy_lname
_1.hl7_accessions	acc_lname
_1.non_patients	npat_lname
_1.orders	ord_lname
_1.patient_next_of_kin	pnk_lname
_1.patients	pat_lname
_1.patients	pat_birth_lname
_1.patients_demographics_snapshots	pds_lname
_1.patients_names	pn_lname
_1.patients_responsibility_estimates	prest_lname
_1.physicians	phy_lname
_1.precerts	pre_lname
_1.radiology_orders	rad_lname
_1.radiology_results	rad_res_lname
_1188.billing_providers	bp_lname
_1188.charts	chrt_lname
_1188.client_contacts	clicon_lname
_1188.cpoe_responses	cpoe_res_lname
_1188.donors	don_lname
_1188.encounters	enc_lname
_1188.encounters_soap_templates	est_phy_lname
_1188.hl7_accessions	acc_lname
_1188.non_patients	npat_lname
_1188.orders	ord_lname
_1188.patient_next_of_kin	pnk_lname
_1188.patients	pat_lname
_1188.patients	pat_birth_lname
_1188.patients_demographics_snapshots	pds_lname
_1188.patients_names	pn_lname
_1188.patients_responsibility_estimates	prest_lname
_1188.physicians	phy_lname
_1188.precerts	pre_lname
_1188.radiology_orders	rad_lname
_1188.radiology_results	rad_res_lname
_1218.billing_providers	bp_lname
_1218.charts	chrt_lname
_1218.client_contacts	clicon_lname
_1218.cpoe_responses	cpoe_res_lname
_1218.donors	don_lname
_1218.encounters	enc_lname
_1218.encounters_soap_templates	est_phy_lname
_1218.hl7_accessions	acc_lname
_1218.non_patients	npat_lname
_1218.orders	ord_lname
_1218.patient_next_of_kin	pnk_lname
_1218.patients	pat_lname
_1218.patients	pat_birth_lname
_1218.patients_demographics_snapshots	pds_lname
_1218.patients_names	pn_lname
_1218.patients_responsibility_estimates	prest_lname
_1218.physicians	phy_lname
_1218.precerts	pre_lname
_1218.radiology_orders	rad_lname
_1218.radiology_results	rad_res_lname
_1548.billing_providers	bp_lname
_1548.charts	chrt_lname
_1548.client_contacts	clicon_lname
_1548.cpoe_responses	cpoe_res_lname
_1548.donors	don_lname
_1548.encounters	enc_lname
_1548.encounters_soap_templates	est_phy_lname
_1548.hl7_accessions	acc_lname
_1548.non_patients	npat_lname
_1548.orders	ord_lname
_1548.patient_next_of_kin	pnk_lname
_1548.patients	pat_lname
_1548.patients	pat_birth_lname
_1548.patients_demographics_snapshots	pds_lname
_1548.patients_names	pn_lname
_1548.patients_responsibility_estimates	prest_lname
_1548.physicians	phy_lname
_1548.precerts	pre_lname
_1548.radiology_orders	rad_lname
_1548.radiology_results	rad_res_lname
_435.billing_providers	bp_lname
_435.charts	chrt_lname
_435.client_contacts	clicon_lname
_435.cpoe_responses	cpoe_res_lname
_435.donors	don_lname
_435.encounters	enc_lname
_435.encounters_soap_templates	est_phy_lname
_435.hl7_accessions	acc_lname
_435.non_patients	npat_lname
_435.orders	ord_lname
_435.patient_next_of_kin	pnk_lname
_435.patients	pat_lname
_435.patients	pat_birth_lname
_435.patients_demographics_snapshots	pds_lname
_435.patients_names	pn_lname
_435.patients_responsibility_estimates	prest_lname
_435.physicians	phy_lname
_435.precerts	pre_lname
_435.radiology_orders	rad_lname
_435.radiology_results	rad_res_lname
_436.billing_providers	bp_lname
_436.charts	chrt_lname
_436.client_contacts	clicon_lname
_436.cpoe_responses	cpoe_res_lname
_436.donors	don_lname
_436.encounters	enc_lname
_436.encounters_soap_templates	est_phy_lname
_436.hl7_accessions	acc_lname
_436.non_patients	npat_lname
_436.orders	ord_lname
_436.patient_next_of_kin	pnk_lname
_436.patients	pat_lname
_436.patients	pat_birth_lname
_436.patients_demographics_snapshots	pds_lname
_436.patients_names	pn_lname
_436.patients_responsibility_estimates	prest_lname
_436.physicians	phy_lname
_436.precerts	pre_lname
_436.radiology_orders	rad_lname
_436.radiology_results	rad_res_lname
_436_archive_testing.billing_providers	bp_lname
_436_archive_testing.charts	chrt_lname
_436_archive_testing.client_contacts	clicon_lname
_436_archive_testing.cpoe_responses	cpoe_res_lname
_436_archive_testing.donors	don_lname
_436_archive_testing.encounters	enc_lname
_436_archive_testing.encounters_soap_templates	est_phy_lname
_436_archive_testing.hl7_accessions	acc_lname
_436_archive_testing.non_patients	npat_lname
_436_archive_testing.orders	ord_lname
_436_archive_testing.patient_next_of_kin	pnk_lname
_436_archive_testing.patients	pat_lname
_436_archive_testing.patients	pat_birth_lname
_436_archive_testing.patients_demographics_snapshots	pds_lname
_436_archive_testing.patients_responsibility_estimates	prest_lname
_436_archive_testing.physicians	phy_lname
_436_archive_testing.precerts	pre_lname
_436_archive_testing.radiology_orders	rad_lname
_436_archive_testing.radiology_results	rad_res_lname
_437.billing_providers	bp_lname
_437.charts	chrt_lname
_437.client_contacts	clicon_lname
_437.cpoe_responses	cpoe_res_lname
_437.donors	don_lname
_437.encounters	enc_lname
_437.encounters_soap_templates	est_phy_lname
_437.hl7_accessions	acc_lname
_437.non_patients	npat_lname
_437.orders	ord_lname
_437.patient_next_of_kin	pnk_lname
_437.patients	pat_lname
_437.patients	pat_birth_lname
_437.patients_demographics_snapshots	pds_lname
_437.patients_names	pn_lname
_437.patients_responsibility_estimates	prest_lname
_437.physicians	phy_lname
_437.precerts	pre_lname
_437.radiology_orders	rad_lname
_437.radiology_results	rad_res_lname
_8.billing_providers	bp_lname
_8.charts	chrt_lname
_8.client_contacts	clicon_lname
_8.cpoe_responses	cpoe_res_lname
_8.donors	don_lname
_8.encounters	enc_lname
_8.encounters_soap_templates	est_phy_lname
_8.hl7_accessions	acc_lname
_8.non_patients	npat_lname
_8.orders	ord_lname
_8.patient_next_of_kin	pnk_lname
_8.patients	pat_lname
_8.patients	pat_birth_lname
_8.patients_demographics_snapshots	pds_lname
_8.patients_names	pn_lname
_8.patients_responsibility_estimates	prest_lname
_8.physicians	phy_lname
_8.precerts	pre_lname
_8.radiology_orders	rad_lname
_8.radiology_results	rad_res_lname
_81.billing_providers	bp_lname
_81.charts	chrt_lname
_81.client_contacts	clicon_lname
_81.cpoe_responses	cpoe_res_lname
_81.donors	don_lname
_81.encounters	enc_lname
_81.encounters_soap_templates	est_phy_lname
_81.hl7_accessions	acc_lname
_81.non_patients	npat_lname
_81.orders	ord_lname
_81.patient_next_of_kin	pnk_lname
_81.patients	pat_lname
_81.patients	pat_birth_lname
_81.patients_demographics_snapshots	pds_lname
_81.patients_names	pn_lname
_81.patients_responsibility_estimates	prest_lname
_81.physicians	phy_lname
_81.precerts	pre_lname
_81.radiology_orders	rad_lname
_81.radiology_results	rad_res_lname
_999.billing_providers	bp_lname
_999.charts	chrt_lname
_999.client_contacts	clicon_lname
_999.cpoe_responses	cpoe_res_lname
_999.donors	don_lname
_999.encounters	enc_lname
_999.encounters_soap_templates	est_phy_lname
_999.hl7_accessions	acc_lname
_999.non_patients	npat_lname
_999.orders	ord_lname
_999.patient_next_of_kin	pnk_lname
_999.patients	pat_lname
_999.patients	pat_birth_lname
_999.patients_demographics_snapshots	pds_lname
_999.patients_names	pn_lname
_999.patients_responsibility_estimates	prest_lname
_999.physicians	phy_lname
_999.precerts	pre_lname
_999.radiology_orders	rad_lname
_999.radiology_results	rad_res_lname
aurora_standard.abmmpi	gu_lname
aurora_standard.abmmpi	n1_lname
aurora_standard.abmmpi	n2_lname
aurora_standard.abmvis	gu_lname
aurora_standard.bhar	g_lname
aurora_standard.bmnkin	n_lname
aurora_standard.bpar	g_lname
aurora_standard.bpar2	g_lname
aurora_standard.c7mpi	gu_lname
aurora_standard.chmarstph	att_lname
aurora_standard.chmarstph	sur_lname
aurora_standard.chmarstph	oth_lname
aurora_standard.chmarstph	oth2_lname
aurora_standard.chmarstpo	att_lname
aurora_standard.chmarstpo	sur_lname
aurora_standard.chmarstpo	oth_lname
aurora_standard.chmarstpo	oth2_lname
aurora_standard.chmhcahp	dr_lname
aurora_standard.chmlastr	pat_lname
aurora_standard.chmlastr	adm_phy_lname
aurora_standard.chmlastr	rnd_phy_lname
aurora_standard.chmlastr	ref_phy_lname
aurora_standard.chmlastr	att_phy_lname
aurora_standard.chmlastr	op_phy_lname
aurora_standard.chmlastr	oth_phy_lname
aurora_standard.chmlastr	sub_lname
aurora_standard.chmlastr	oth_sub_lname
aurora_standard.chmpdemo	p_lname
aurora_standard.chmpdemo	sp_lname
aurora_standard.chmpdemo	gu_lname
aurora_standard.chmpdemo	fam_phy_lname
aurora_standard.chmpdemo	attend_phy_lname
aurora_standard.chmpdemo	admit_phy_lname
aurora_standard.chmpsvcd	rend_lname
aurora_standard.chmpsvcd	ref_lname
aurora_standard.chmtxstr	pat_lname
aurora_standard.chmtxstr	att_phy_lname
aurora_standard.chmtxstr	op_phy_lname
aurora_standard.chmtxstr	cons_phy_lname
aurora_standard.styoctcc	contact_lname
aurora_standard.styoctcc	gov_entity_contact_person_lname
aurora_standard.styoempd	depend_lname
aurora_standard.styoempr	empl_lname
common.applicants	app_lname
common.contacts	con_lname
common.dashboardmd_users	dmdu_lname
common.users	usr_lname
template_library.encounters_soap_templates	est_phy_lname

mname

Table	Column
Azalea.employees	emp_mname
_1.billing_providers	bp_mname
_1.charts	chrt_mname
_1.client_contacts	clicon_mname
_1.cpoe_responses	cpoe_res_mname
_1.donors	don_mname
_1.encounters	enc_mname
_1.hl7_accessions	acc_mname
_1.non_patients	npat_mname
_1.orders	ord_mname
_1.patient_next_of_kin	pnk_mname
_1.patients	pat_mname
_1.patients	pat_birth_mname
_1.patients_demographics_snapshots	pds_mname
_1.patients_names	pn_mname
_1.patients_responsibility_estimates	prest_mname
_1.physicians	phy_mname
_1.precerts	pre_mname
_1.radiology_orders	rad_mname
_1.radiology_results	rad_res_mname
_1188.billing_providers	bp_mname
_1188.charts	chrt_mname
_1188.client_contacts	clicon_mname
_1188.cpoe_responses	cpoe_res_mname
_1188.donors	don_mname
_1188.encounters	enc_mname
_1188.hl7_accessions	acc_mname
_1188.non_patients	npat_mname
_1188.orders	ord_mname
_1188.patient_next_of_kin	pnk_mname
_1188.patients	pat_mname
_1188.patients	pat_birth_mname
_1188.patients_demographics_snapshots	pds_mname
_1188.patients_names	pn_mname
_1188.patients_responsibility_estimates	prest_mname
_1188.physicians	phy_mname
_1188.precerts	pre_mname
_1188.radiology_orders	rad_mname
_1188.radiology_results	rad_res_mname
_1218.billing_providers	bp_mname
_1218.charts	chrt_mname
_1218.client_contacts	clicon_mname
_1218.cpoe_responses	cpoe_res_mname
_1218.donors	don_mname
_1218.encounters	enc_mname
_1218.hl7_accessions	acc_mname
_1218.non_patients	npat_mname
_1218.orders	ord_mname
_1218.patient_next_of_kin	pnk_mname
_1218.patients	pat_mname
_1218.patients	pat_birth_mname
_1218.patients_demographics_snapshots	pds_mname
_1218.patients_names	pn_mname
_1218.patients_responsibility_estimates	prest_mname
_1218.physicians	phy_mname
_1218.precerts	pre_mname
_1218.radiology_orders	rad_mname
_1218.radiology_results	rad_res_mname
_1548.billing_providers	bp_mname
_1548.charts	chrt_mname
_1548.client_contacts	clicon_mname
_1548.cpoe_responses	cpoe_res_mname
_1548.donors	don_mname
_1548.encounters	enc_mname
_1548.hl7_accessions	acc_mname
_1548.non_patients	npat_mname
_1548.orders	ord_mname
_1548.patient_next_of_kin	pnk_mname
_1548.patients	pat_mname
_1548.patients	pat_birth_mname
_1548.patients_demographics_snapshots	pds_mname
_1548.patients_names	pn_mname
_1548.patients_responsibility_estimates	prest_mname
_1548.physicians	phy_mname
_1548.precerts	pre_mname
_1548.radiology_orders	rad_mname
_1548.radiology_results	rad_res_mname
_435.billing_providers	bp_mname
_435.charts	chrt_mname
_435.client_contacts	clicon_mname
_435.cpoe_responses	cpoe_res_mname
_435.donors	don_mname
_435.encounters	enc_mname
_435.hl7_accessions	acc_mname
_435.non_patients	npat_mname
_435.orders	ord_mname
_435.patient_next_of_kin	pnk_mname
_435.patients	pat_mname
_435.patients	pat_birth_mname
_435.patients_demographics_snapshots	pds_mname
_435.patients_names	pn_mname
_435.patients_responsibility_estimates	prest_mname
_435.physicians	phy_mname
_435.precerts	pre_mname
_435.radiology_orders	rad_mname
_435.radiology_results	rad_res_mname
_436.billing_providers	bp_mname
_436.charts	chrt_mname
_436.client_contacts	clicon_mname
_436.cpoe_responses	cpoe_res_mname
_436.donors	don_mname
_436.encounters	enc_mname
_436.hl7_accessions	acc_mname
_436.non_patients	npat_mname
_436.orders	ord_mname
_436.patient_next_of_kin	pnk_mname
_436.patients	pat_mname
_436.patients	pat_birth_mname
_436.patients_demographics_snapshots	pds_mname
_436.patients_names	pn_mname
_436.patients_responsibility_estimates	prest_mname
_436.physicians	phy_mname
_436.precerts	pre_mname
_436.radiology_orders	rad_mname
_436.radiology_results	rad_res_mname
_436_archive_testing.billing_providers	bp_mname
_436_archive_testing.charts	chrt_mname
_436_archive_testing.client_contacts	clicon_mname
_436_archive_testing.cpoe_responses	cpoe_res_mname
_436_archive_testing.donors	don_mname
_436_archive_testing.encounters	enc_mname
_436_archive_testing.hl7_accessions	acc_mname
_436_archive_testing.non_patients	npat_mname
_436_archive_testing.orders	ord_mname
_436_archive_testing.patient_next_of_kin	pnk_mname
_436_archive_testing.patients	pat_mname
_436_archive_testing.patients	pat_birth_mname
_436_archive_testing.patients_demographics_snapshots	pds_mname
_436_archive_testing.patients_responsibility_estimates	prest_mname
_436_archive_testing.physicians	phy_mname
_436_archive_testing.precerts	pre_mname
_436_archive_testing.radiology_orders	rad_mname
_436_archive_testing.radiology_results	rad_res_mname
_437.billing_providers	bp_mname
_437.charts	chrt_mname
_437.client_contacts	clicon_mname
_437.cpoe_responses	cpoe_res_mname
_437.donors	don_mname
_437.encounters	enc_mname
_437.hl7_accessions	acc_mname
_437.non_patients	npat_mname
_437.orders	ord_mname
_437.patient_next_of_kin	pnk_mname
_437.patients	pat_mname
_437.patients	pat_birth_mname
_437.patients_demographics_snapshots	pds_mname
_437.patients_names	pn_mname
_437.patients_responsibility_estimates	prest_mname
_437.physicians	phy_mname
_437.precerts	pre_mname
_437.radiology_orders	rad_mname
_437.radiology_results	rad_res_mname
_8.billing_providers	bp_mname
_8.charts	chrt_mname
_8.client_contacts	clicon_mname
_8.cpoe_responses	cpoe_res_mname
_8.donors	don_mname
_8.encounters	enc_mname
_8.hl7_accessions	acc_mname
_8.non_patients	npat_mname
_8.orders	ord_mname
_8.patient_next_of_kin	pnk_mname
_8.patients	pat_mname
_8.patients	pat_birth_mname
_8.patients_demographics_snapshots	pds_mname
_8.patients_names	pn_mname
_8.patients_responsibility_estimates	prest_mname
_8.physicians	phy_mname
_8.precerts	pre_mname
_8.radiology_orders	rad_mname
_8.radiology_results	rad_res_mname
_81.billing_providers	bp_mname
_81.charts	chrt_mname
_81.client_contacts	clicon_mname
_81.cpoe_responses	cpoe_res_mname
_81.donors	don_mname
_81.encounters	enc_mname
_81.hl7_accessions	acc_mname
_81.non_patients	npat_mname
_81.orders	ord_mname
_81.patient_next_of_kin	pnk_mname
_81.patients	pat_mname
_81.patients	pat_birth_mname
_81.patients_demographics_snapshots	pds_mname
_81.patients_names	pn_mname
_81.patients_responsibility_estimates	prest_mname
_81.physicians	phy_mname
_81.precerts	pre_mname
_81.radiology_orders	rad_mname
_81.radiology_results	rad_res_mname
_999.billing_providers	bp_mname
_999.charts	chrt_mname
_999.client_contacts	clicon_mname
_999.cpoe_responses	cpoe_res_mname
_999.donors	don_mname
_999.encounters	enc_mname
_999.hl7_accessions	acc_mname
_999.non_patients	npat_mname
_999.orders	ord_mname
_999.patient_next_of_kin	pnk_mname
_999.patients	pat_mname
_999.patients	pat_birth_mname
_999.patients_demographics_snapshots	pds_mname
_999.patients_names	pn_mname
_999.patients_responsibility_estimates	prest_mname
_999.physicians	phy_mname
_999.precerts	pre_mname
_999.radiology_orders	rad_mname
_999.radiology_results	rad_res_mname
aurora_standard.abmmpi	gu_mname
aurora_standard.abmvis	gu_mname
aurora_standard.bhar	g_mname
aurora_standard.bmnkin	n_mname
aurora_standard.bpar	g_mname
aurora_standard.bpar2	g_mname
aurora_standard.c7mpi	gu_mname
aurora_standard.chmpdemo	p_mname
aurora_standard.chmpdemo	sp_mname
aurora_standard.chmpdemo	fam_phy_mname
aurora_standard.chmpdemo	attend_phy_mname
aurora_standard.chmpdemo	admit_phy_mname
aurora_standard.chmpsvcd	rend_mname
aurora_standard.chmpsvcd	ref_mname
aurora_standard.styoctcc	contact_mname
aurora_standard.styoctcc	gov_entity_contact_person_mname
aurora_standard.styoempd	depend_mname
aurora_standard.styoempr	empl_mname
common.applicants	app_mname
common.users	usr_mname

ssn

Table	Column
Azalea.employees	emp_ssn
_1.charts	chrt_ssn
_1.cpoe_responses	cpoe_res_ssn
_1.encounters	enc_ssn
_1.encounters	enc_guarantor_ssn
_1.encounters	enc_ins1_insured_ssn
_1.encounters	enc_ins2_insured_ssn
_1.encounters	enc_ins3_insured_ssn
_1.examples	exa_ssn
_1.hl7_accessions	acc_ssn
_1.insurances_repository	irep_ins_insured_ssn
_1.non_patients	npat_ssn
_1.orders	ord_ssn
_1.patients	pat_ssn
_1.patients	pat_guarantor_ssn
_1.patients	pat_ins1_insured_ssn
_1.patients	pat_ins2_insured_ssn
_1.patients	pat_ins3_insured_ssn
_1.patients_demographics_snapshots	pds_ssn
_1.patients_demographics_snapshots	pds_guarantor_ssn
_1.patients_demographics_snapshots	pds_ins1_insured_ssn
_1.patients_demographics_snapshots	pds_ins2_insured_ssn
_1.patients_demographics_snapshots	pds_ins3_insured_ssn
_1.patients_responsibility_estimates	prest_ssn
_1.precerts	pre_ssn
_1.precerts	pre_guarantor_ssn
_1.precerts	pre_ins1_insured_ssn
_1.precerts	pre_ins2_insured_ssn
_1.radiology_orders	rad_ssn
_1.radiology_results	rad_res_ssn
_1188.charts	chrt_ssn
_1188.cpoe_responses	cpoe_res_ssn
_1188.encounters	enc_ssn
_1188.encounters	enc_guarantor_ssn
_1188.encounters	enc_ins1_insured_ssn
_1188.encounters	enc_ins2_insured_ssn
_1188.encounters	enc_ins3_insured_ssn
_1188.examples	exa_ssn
_1188.hl7_accessions	acc_ssn
_1188.insurances_repository	irep_ins_insured_ssn
_1188.non_patients	npat_ssn
_1188.orders	ord_ssn
_1188.patients	pat_ssn
_1188.patients	pat_guarantor_ssn
_1188.patients	pat_ins1_insured_ssn
_1188.patients	pat_ins2_insured_ssn
_1188.patients	pat_ins3_insured_ssn
_1188.patients_demographics_snapshots	pds_ssn
_1188.patients_demographics_snapshots	pds_guarantor_ssn
_1188.patients_demographics_snapshots	pds_ins1_insured_ssn
_1188.patients_demographics_snapshots	pds_ins2_insured_ssn
_1188.patients_demographics_snapshots	pds_ins3_insured_ssn
_1188.patients_responsibility_estimates	prest_ssn
_1188.precerts	pre_ssn
_1188.precerts	pre_guarantor_ssn
_1188.precerts	pre_ins1_insured_ssn
_1188.precerts	pre_ins2_insured_ssn
_1188.radiology_orders	rad_ssn
_1188.radiology_results	rad_res_ssn
_1218.charts	chrt_ssn
_1218.cpoe_responses	cpoe_res_ssn
_1218.encounters	enc_ssn
_1218.encounters	enc_guarantor_ssn
_1218.encounters	enc_ins1_insured_ssn
_1218.encounters	enc_ins2_insured_ssn
_1218.encounters	enc_ins3_insured_ssn
_1218.examples	exa_ssn
_1218.hl7_accessions	acc_ssn
_1218.insurances_repository	irep_ins_insured_ssn
_1218.non_patients	npat_ssn
_1218.orders	ord_ssn
_1218.patients	pat_ssn
_1218.patients	pat_guarantor_ssn
_1218.patients	pat_ins1_insured_ssn
_1218.patients	pat_ins2_insured_ssn
_1218.patients	pat_ins3_insured_ssn
_1218.patients_demographics_snapshots	pds_ssn
_1218.patients_demographics_snapshots	pds_guarantor_ssn
_1218.patients_demographics_snapshots	pds_ins1_insured_ssn
_1218.patients_demographics_snapshots	pds_ins2_insured_ssn
_1218.patients_demographics_snapshots	pds_ins3_insured_ssn
_1218.patients_responsibility_estimates	prest_ssn
_1218.precerts	pre_ssn
_1218.precerts	pre_guarantor_ssn
_1218.precerts	pre_ins1_insured_ssn
_1218.precerts	pre_ins2_insured_ssn
_1218.radiology_orders	rad_ssn
_1218.radiology_results	rad_res_ssn
_1548.charts	chrt_ssn
_1548.cpoe_responses	cpoe_res_ssn
_1548.encounters	enc_ssn
_1548.encounters	enc_guarantor_ssn
_1548.encounters	enc_ins1_insured_ssn
_1548.encounters	enc_ins2_insured_ssn
_1548.encounters	enc_ins3_insured_ssn
_1548.examples	exa_ssn
_1548.hl7_accessions	acc_ssn
_1548.insurances_repository	irep_ins_insured_ssn
_1548.non_patients	npat_ssn
_1548.orders	ord_ssn
_1548.patients	pat_ssn
_1548.patients	pat_guarantor_ssn
_1548.patients	pat_ins1_insured_ssn
_1548.patients	pat_ins2_insured_ssn
_1548.patients	pat_ins3_insured_ssn
_1548.patients_demographics_snapshots	pds_ssn
_1548.patients_demographics_snapshots	pds_guarantor_ssn
_1548.patients_demographics_snapshots	pds_ins1_insured_ssn
_1548.patients_demographics_snapshots	pds_ins2_insured_ssn
_1548.patients_demographics_snapshots	pds_ins3_insured_ssn
_1548.patients_responsibility_estimates	prest_ssn
_1548.precerts	pre_ssn
_1548.precerts	pre_guarantor_ssn
_1548.precerts	pre_ins1_insured_ssn
_1548.precerts	pre_ins2_insured_ssn
_1548.radiology_orders	rad_ssn
_1548.radiology_results	rad_res_ssn
_435.charts	chrt_ssn
_435.cpoe_responses	cpoe_res_ssn
_435.encounters	enc_ssn
_435.encounters	enc_guarantor_ssn
_435.encounters	enc_ins1_insured_ssn
_435.encounters	enc_ins2_insured_ssn
_435.encounters	enc_ins3_insured_ssn
_435.examples	exa_ssn
_435.hl7_accessions	acc_ssn
_435.insurances_repository	irep_ins_insured_ssn
_435.non_patients	npat_ssn
_435.orders	ord_ssn
_435.patients	pat_ssn
_435.patients	pat_guarantor_ssn
_435.patients	pat_ins1_insured_ssn
_435.patients	pat_ins2_insured_ssn
_435.patients	pat_ins3_insured_ssn
_435.patients_demographics_snapshots	pds_ssn
_435.patients_demographics_snapshots	pds_guarantor_ssn
_435.patients_demographics_snapshots	pds_ins1_insured_ssn
_435.patients_demographics_snapshots	pds_ins2_insured_ssn
_435.patients_demographics_snapshots	pds_ins3_insured_ssn
_435.patients_responsibility_estimates	prest_ssn
_435.precerts	pre_ssn
_435.precerts	pre_guarantor_ssn
_435.precerts	pre_ins1_insured_ssn
_435.precerts	pre_ins2_insured_ssn
_435.radiology_orders	rad_ssn
_435.radiology_results	rad_res_ssn
_436.charts	chrt_ssn
_436.cpoe_responses	cpoe_res_ssn
_436.encounters	enc_ssn
_436.encounters	enc_guarantor_ssn
_436.encounters	enc_ins1_insured_ssn
_436.encounters	enc_ins2_insured_ssn
_436.encounters	enc_ins3_insured_ssn
_436.examples	exa_ssn
_436.hl7_accessions	acc_ssn
_436.insurances_repository	irep_ins_insured_ssn
_436.non_patients	npat_ssn
_436.orders	ord_ssn
_436.patients	pat_ssn
_436.patients	pat_guarantor_ssn
_436.patients	pat_ins1_insured_ssn
_436.patients	pat_ins2_insured_ssn
_436.patients	pat_ins3_insured_ssn
_436.patients_demographics_snapshots	pds_ssn
_436.patients_demographics_snapshots	pds_guarantor_ssn
_436.patients_demographics_snapshots	pds_ins1_insured_ssn
_436.patients_demographics_snapshots	pds_ins2_insured_ssn
_436.patients_demographics_snapshots	pds_ins3_insured_ssn
_436.patients_responsibility_estimates	prest_ssn
_436.precerts	pre_ssn
_436.precerts	pre_guarantor_ssn
_436.precerts	pre_ins1_insured_ssn
_436.precerts	pre_ins2_insured_ssn
_436.radiology_orders	rad_ssn
_436.radiology_results	rad_res_ssn
_436_archive_testing.charts	chrt_ssn
_436_archive_testing.cpoe_responses	cpoe_res_ssn
_436_archive_testing.encounters	enc_ssn
_436_archive_testing.encounters	enc_guarantor_ssn
_436_archive_testing.encounters	enc_ins1_insured_ssn
_436_archive_testing.encounters	enc_ins2_insured_ssn
_436_archive_testing.encounters	enc_ins3_insured_ssn
_436_archive_testing.examples	exa_ssn
_436_archive_testing.hl7_accessions	acc_ssn
_436_archive_testing.insurances_repository	irep_ins_insured_ssn
_436_archive_testing.non_patients	npat_ssn
_436_archive_testing.orders	ord_ssn
_436_archive_testing.patients	pat_ssn
_436_archive_testing.patients	pat_guarantor_ssn
_436_archive_testing.patients	pat_ins1_insured_ssn
_436_archive_testing.patients	pat_ins2_insured_ssn
_436_archive_testing.patients	pat_ins3_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ssn
_436_archive_testing.patients_demographics_snapshots	pds_guarantor_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins1_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins2_insured_ssn
_436_archive_testing.patients_demographics_snapshots	pds_ins3_insured_ssn
_436_archive_testing.patients_responsibility_estimates	prest_ssn
_436_archive_testing.precerts	pre_ssn
_436_archive_testing.precerts	pre_guarantor_ssn
_436_archive_testing.precerts	pre_ins1_insured_ssn
_436_archive_testing.precerts	pre_ins2_insured_ssn
_436_archive_testing.radiology_orders	rad_ssn
_436_archive_testing.radiology_results	rad_res_ssn
_437.charts	chrt_ssn
_437.cpoe_responses	cpoe_res_ssn
_437.encounters	enc_ssn
_437.encounters	enc_guarantor_ssn
_437.encounters	enc_ins1_insured_ssn
_437.encounters	enc_ins2_insured_ssn
_437.encounters	enc_ins3_insured_ssn
_437.examples	exa_ssn
_437.hl7_accessions	acc_ssn
_437.insurances_repository	irep_ins_insured_ssn
_437.non_patients	npat_ssn
_437.orders	ord_ssn
_437.patients	pat_ssn
_437.patients	pat_guarantor_ssn
_437.patients	pat_ins1_insured_ssn
_437.patients	pat_ins2_insured_ssn
_437.patients	pat_ins3_insured_ssn
_437.patients_demographics_snapshots	pds_ssn
_437.patients_demographics_snapshots	pds_guarantor_ssn
_437.patients_demographics_snapshots	pds_ins1_insured_ssn
_437.patients_demographics_snapshots	pds_ins2_insured_ssn
_437.patients_demographics_snapshots	pds_ins3_insured_ssn
_437.patients_responsibility_estimates	prest_ssn
_437.precerts	pre_ssn
_437.precerts	pre_guarantor_ssn
_437.precerts	pre_ins1_insured_ssn
_437.precerts	pre_ins2_insured_ssn
_437.radiology_orders	rad_ssn
_437.radiology_results	rad_res_ssn
_8.charts	chrt_ssn
_8.cpoe_responses	cpoe_res_ssn
_8.encounters	enc_ssn
_8.encounters	enc_guarantor_ssn
_8.encounters	enc_ins1_insured_ssn
_8.encounters	enc_ins2_insured_ssn
_8.encounters	enc_ins3_insured_ssn
_8.examples	exa_ssn
_8.hl7_accessions	acc_ssn
_8.insurances_repository	irep_ins_insured_ssn
_8.non_patients	npat_ssn
_8.orders	ord_ssn
_8.patients	pat_ssn
_8.patients	pat_guarantor_ssn
_8.patients	pat_ins1_insured_ssn
_8.patients	pat_ins2_insured_ssn
_8.patients	pat_ins3_insured_ssn
_8.patients_demographics_snapshots	pds_ssn
_8.patients_demographics_snapshots	pds_guarantor_ssn
_8.patients_demographics_snapshots	pds_ins1_insured_ssn
_8.patients_demographics_snapshots	pds_ins2_insured_ssn
_8.patients_demographics_snapshots	pds_ins3_insured_ssn
_8.patients_responsibility_estimates	prest_ssn
_8.precerts	pre_ssn
_8.precerts	pre_guarantor_ssn
_8.precerts	pre_ins1_insured_ssn
_8.precerts	pre_ins2_insured_ssn
_8.radiology_orders	rad_ssn
_8.radiology_results	rad_res_ssn
_81.charts	chrt_ssn
_81.cpoe_responses	cpoe_res_ssn
_81.encounters	enc_ssn
_81.encounters	enc_guarantor_ssn
_81.encounters	enc_ins1_insured_ssn
_81.encounters	enc_ins2_insured_ssn
_81.encounters	enc_ins3_insured_ssn
_81.examples	exa_ssn
_81.hl7_accessions	acc_ssn
_81.insurances_repository	irep_ins_insured_ssn
_81.non_patients	npat_ssn
_81.orders	ord_ssn
_81.patients	pat_ssn
_81.patients	pat_guarantor_ssn
_81.patients	pat_ins1_insured_ssn
_81.patients	pat_ins2_insured_ssn
_81.patients	pat_ins3_insured_ssn
_81.patients_demographics_snapshots	pds_ssn
_81.patients_demographics_snapshots	pds_guarantor_ssn
_81.patients_demographics_snapshots	pds_ins1_insured_ssn
_81.patients_demographics_snapshots	pds_ins2_insured_ssn
_81.patients_demographics_snapshots	pds_ins3_insured_ssn
_81.patients_responsibility_estimates	prest_ssn
_81.precerts	pre_ssn
_81.precerts	pre_guarantor_ssn
_81.precerts	pre_ins1_insured_ssn
_81.precerts	pre_ins2_insured_ssn
_81.radiology_orders	rad_ssn
_81.radiology_results	rad_res_ssn
_999.charts	chrt_ssn
_999.cpoe_responses	cpoe_res_ssn
_999.encounters	enc_ssn
_999.encounters	enc_guarantor_ssn
_999.encounters	enc_ins1_insured_ssn
_999.encounters	enc_ins2_insured_ssn
_999.encounters	enc_ins3_insured_ssn
_999.examples	exa_ssn
_999.hl7_accessions	acc_ssn
_999.insurances_repository	irep_ins_insured_ssn
_999.non_patients	npat_ssn
_999.orders	ord_ssn
_999.patients	pat_ssn
_999.patients	pat_guarantor_ssn
_999.patients	pat_ins1_insured_ssn
_999.patients	pat_ins2_insured_ssn
_999.patients	pat_ins3_insured_ssn
_999.patients_demographics_snapshots	pds_ssn
_999.patients_demographics_snapshots	pds_guarantor_ssn
_999.patients_demographics_snapshots	pds_ins1_insured_ssn
_999.patients_demographics_snapshots	pds_ins2_insured_ssn
_999.patients_demographics_snapshots	pds_ins3_insured_ssn
_999.patients_responsibility_estimates	prest_ssn
_999.precerts	pre_ssn
_999.precerts	pre_guarantor_ssn
_999.precerts	pre_ins1_insured_ssn
_999.precerts	pre_ins2_insured_ssn
_999.radiology_orders	rad_ssn
_999.radiology_results	rad_res_ssn
aurora_standard.abmmpi	gu_ssn
aurora_standard.abmvis	gu_ssn
aurora_standard.adupgu	guar_ssn
aurora_standard.aswguar	guar_ssn
aurora_standard.b2badd	p_ssn
aurora_standard.b2mrdr	p_ssn
aurora_standard.bdallvis	pat_ssn
aurora_standard.bdguar	guar_ssn
aurora_standard.bdmpi	p_ssn
aurora_standard.bdmpi	sp_ssn
aurora_standard.bdvis	pat_ssn
aurora_standard.bevis	p_ssn
aurora_standard.bevisbd	p_ssn
aurora_standard.bevisbd2	p_ssn
aurora_standard.bhar	p_ssn
aurora_standard.bhar	new_ssn
aurora_standard.bhar	g_ssn
aurora_standard.bhbadd	p_ssn
aurora_standard.bhguar	guar_ssn
aurora_standard.bhldgr	p_ssn
aurora_standard.bhldgr	guar_ssn
aurora_standard.bhmrdr	p_ssn
aurora_standard.bhppat	p_ssn
aurora_standard.bhtguar	guar_ssn
aurora_standard.bhtldgr	p_ssn
aurora_standard.bhtldgr	guar_ssn
aurora_standard.bhtmrdr	p_ssn
aurora_standard.bhtppat	p_ssn
aurora_standard.bmguar	guar_ssn
aurora_standard.bmmpi	p_ssn
aurora_standard.bmnkin	n_ssn
aurora_standard.bmpact	p_ssn
aurora_standard.bmpat	p_ssn
aurora_standard.bpar	p_ssn
aurora_standard.bpar	new_ssn
aurora_standard.bpar	g_ssn
aurora_standard.bpar2	p_ssn
aurora_standard.bpar2	new_ssn
aurora_standard.bpar2	g_ssn
aurora_standard.bpmpi	p_ssn
aurora_standard.bpmpi2	p_ssn
aurora_standard.bpmr	p_ssn
aurora_standard.bpmr2	p_ssn
aurora_standard.bsguar	guar_ssn
aurora_standard.bsinsur	spouse_ssn
aurora_standard.bsvis	pat_ssn
aurora_standard.bsvisbd	pat_ssn
aurora_standard.bvguar	gu_ssn
aurora_standard.bvmpi	p_ssn
aurora_standard.bvmpi2	p_ssn
aurora_standard.c7guarr	guar_ssn
aurora_standard.c7mpi	p_ssn
aurora_standard.c7mpi	gu_ssn
aurora_standard.c7vis	pat_ssn
aurora_standard.c8dtls	p_ssn
aurora_standard.c8guar	guar_ssn
aurora_standard.c8guar2	guar_ssn
aurora_standard.c9mpi	p_ssn
aurora_standard.c9vis	p_ssn
aurora_standard.cafc	pat_ssn
aurora_standard.caguarr	guar_ssn
aurora_standard.campi	spouse_ssn
aurora_standard.cavis	pat_ssn
aurora_standard.cavish	pat_ssn
aurora_standard.chhl7in2	ins_ssn
aurora_standard.chlmdssd	prev_ssn
aurora_standard.chltrnsd	prev_ssn
aurora_standard.chmarcnbf	g_ssn
aurora_standard.chmarcnbf	p_ssn
aurora_standard.chmarsi	pat_ssn
aurora_standard.chmarsi	gu_ssn
aurora_standard.chmarsi	sp_ssn
aurora_standard.chmazstd	pat_ssn
aurora_standard.chmazsti	pat_ssn
aurora_standard.chmazsto	pat_ssn
aurora_standard.chmcampi	pat_ssn
aurora_standard.chmcampi	gu_ssn
aurora_standard.chmcampi	sp_ssn
aurora_standard.chmcmhed	debtor_1_ssn
aurora_standard.chmcmhed	debtor_2_ssn
aurora_standard.chmcmhed	pat_ssn
aurora_standard.chmcssnd	new_ssn
aurora_standard.chmcssnd	old_ssn
aurora_standard.chmexmpi	pat_ssn
aurora_standard.chmexmpi	gu_ssn
aurora_standard.chmexmpi	sp_ssn
aurora_standard.chmexvis	pat_ssn
aurora_standard.chmguarr	guar_ssn
aurora_standard.chmhistp	p_ssn
aurora_standard.chmlastr	pat_ssn
aurora_standard.chmmhast	pat_ssn
aurora_standard.chmokipd	pat_ssn
aurora_standard.chmokopd	pat_ssn
aurora_standard.chmoperc	auto_ssn
aurora_standard.chmozpcd	debtor_1_ssn
aurora_standard.chmozpcd	debtor_2_ssn
aurora_standard.chmpatmr	spouse_ssn
aurora_standard.chmpatwc	mom_ssn
aurora_standard.chmpatwc	dad_ssn
aurora_standard.chmpdemo	p_ssn
aurora_standard.chmpdemo	sp_ssn
aurora_standard.chmpdemo	gu_ssn
aurora_standard.chmradex	pat_ssn
aurora_standard.chmradex	gu_ssn
aurora_standard.chmradex	sp_ssn
aurora_standard.chmtxstr	pat_ssn
aurora_standard.chpcobdd	dep_ssn
aurora_standard.chpdeped	depend_ssn
aurora_standard.chpempdd	person_ssn
aurora_standard.chxcntrc	id_is_ssn
aurora_standard.hl7gt1	guar_ssn
aurora_standard.hl7gt1ad	guar_ssn
aurora_standard.hl7in2	ins_ssn
aurora_standard.hl7in2ad	ins_ssn
aurora_standard.hl7pid	pat_ssn
aurora_standard.hl7pidad	pat_ssn
aurora_standard.kcvis	pat_ssn
aurora_standard.kcvisit	pat_ssn
aurora_standard.nbspouse	spouse_ssn
aurora_standard.ncexmpi	pat_ssn
aurora_standard.oddpaydd	empl_ssn
aurora_standard.oddpayid	empl_ssn
aurora_standard.oddpayod	empl_ssn
aurora_standard.oddpayre	empl_ssn
aurora_standard.odhpaydd	empl_ssn
aurora_standard.odhpayid	empl_ssn
aurora_standard.odhpayod	empl_ssn
aurora_standard.odhpayre	empl_ssn
aurora_standard.styoempd	depend_ssn
common.customers	cus_require_ssn

gender

Table	Column
Azalea.employees	emp_gender
_1.systems_components	scmp_gender
_1188.systems_components	scmp_gender
_1218.systems_components	scmp_gender
_1548.systems_components	scmp_gender
_435.systems_components	scmp_gender
_436.systems_components	scmp_gender
_436_archive_testing.systems_components	scmp_gender
_437.systems_components	scmp_gender
_8.systems_components	scmp_gender
_81.systems_components	scmp_gender
_999.systems_components	scmp_gender
aurora_standard.chmclaim	pat_gender
template_library.systems_components	scmp_gender

birthdate

Table	Column
Azalea.employees	emp_birthdate
aurora_standard.chmmrhdr	upd_birthdate

flag

Table	Column
HSPI_Bastrop.communication_recipients	read_flag
HSPI_CURES2015_B1.communication_recipients	read_flag
HSPI_Central_Hospital.communication_recipients	read_flag
HSPI_Dewitt.communication_recipients	read_flag
HSPI_Fulton.communication_recipients	read_flag
HSPI_Inferno.communication_recipients	read_flag
HSPI_MU2015_E1.communication_recipients	read_flag
HSPI_MU2015_G2.communication_recipients	read_flag
HSPI_MU2015_G9.communication_recipients	read_flag
HSPI_Sandbox.communication_recipients	read_flag
HSPI_Summit_General.communication_recipients	read_flag
HSPI_United_Physicians.communication_recipients	read_flag
MPI.communication_recipients	read_flag
_1.ancpdfs	ancpdf_status_flag
_1.encounters_cpt_codes	ecp_global_flag
_1.hl7_accessions_statuses	accstat_status_flag
_1188.ancpdfs	ancpdf_status_flag
_1188.encounters_cpt_codes	ecp_global_flag
_1188.hl7_accessions_statuses	accstat_status_flag
_1218.ancpdfs	ancpdf_status_flag
_1218.encounters_cpt_codes	ecp_global_flag
_1218.hl7_accessions_statuses	accstat_status_flag
_1548.ancpdfs	ancpdf_status_flag
_1548.encounters_cpt_codes	ecp_global_flag
_1548.hl7_accessions_statuses	accstat_status_flag
_435.ancpdfs	ancpdf_status_flag
_435.encounters_cpt_codes	ecp_global_flag
_435.hl7_accessions_statuses	accstat_status_flag
_436.ancpdfs	ancpdf_status_flag
_436.encounters_cpt_codes	ecp_global_flag
_436.hl7_accessions_statuses	accstat_status_flag
_436_archive_testing.ancpdfs	ancpdf_status_flag
_436_archive_testing.encounters_cpt_codes	ecp_global_flag
_436_archive_testing.hl7_accessions_statuses	accstat_status_flag
_437.ancpdfs	ancpdf_status_flag
_437.encounters_cpt_codes	ecp_global_flag
_437.hl7_accessions_statuses	accstat_status_flag
_8.ancpdfs	ancpdf_status_flag
_8.encounters_cpt_codes	ecp_global_flag
_8.hl7_accessions_statuses	accstat_status_flag
_81.ancpdfs	ancpdf_status_flag
_81.encounters_cpt_codes	ecp_global_flag
_81.hl7_accessions_statuses	accstat_status_flag
_999.ancpdfs	ancpdf_status_flag
_999.encounters_cpt_codes	ecp_global_flag
_999.hl7_accessions_statuses	accstat_status_flag
aurora_standard.aaclocd	cur_flag
aurora_standard.apsinsrc	active_flag
aurora_standard.apsvis	bd_flag
aurora_standard.audpadjd	gl_flag
aurora_standard.audpchgd	gl_flag
aurora_standard.audppayd	gl_flag
aurora_standard.audroomd	gl_flag
aurora_standard.axlscdm	inactive_flag
aurora_standard.axlscdm	ub_flag
aurora_standard.axlscdm	md_ub_flag
aurora_standard.axlscdm	ci_ub_flag
aurora_standard.bdallvis	arch_flag
aurora_standard.bdvis	arch_flag
aurora_standard.bmemplr	active_flag
aurora_standard.bminsrc	active_flag
aurora_standard.bmnkin	gu_flag
aurora_standard.bvmpi	dup_flag
aurora_standard.bvmpi2	dup_flag
aurora_standard.c5cdm	ub_flag
aurora_standard.c5cdm	inactive_flag
aurora_standard.c5cdmdr	ub_flag
aurora_standard.c5cdmdr	inactive_flag
aurora_standard.c7cdm	ub_flag
aurora_standard.c7cdm	inactive_flag
aurora_standard.c7vis	arch_flag
aurora_standard.c8cdm	ub_flag
aurora_standard.c8cdm	inactive_flag
aurora_standard.cavis	arch_flag
aurora_standard.cavish	arch_flag
aurora_standard.cgrsubgd	subg_flag
aurora_standard.cgrtyper	dflt_flag
aurora_standard.cgsmnsec	allow_flag
aurora_standard.cgxprntr	dflt_flag
aurora_standard.chhl7in1	notice_admis_flag
aurora_standard.chhl7in1	rpt_elig_flag
aurora_standard.chhl7lab	rx_flag
aurora_standard.chhl7mdd	rx_flag
aurora_standard.chhl7opd	rx_flag
aurora_standard.chhl7pxd	rx_flag
aurora_standard.chm1500r	emc_flag
aurora_standard.chm835pr	production_flag
aurora_standard.chmachgd	gl_flag
aurora_standard.chmadmtr	archive_flag
aurora_standard.chmappgc	active_flag
aurora_standard.chmapptr	print_flag
aurora_standard.chmappts	print_flag
aurora_standard.chmarsi	medicare_flag
aurora_standard.chmbadjd	gl_flag
aurora_standard.chmbchgd	gl_flag
aurora_standard.chmbitmd	serial_flag
aurora_standard.chmbpayd	gl_flag
aurora_standard.chmcampi	medicare_flag
aurora_standard.chmcashr	lock_flag
aurora_standard.chmcdepc	lock_flag
aurora_standard.chmchfcd	gl_flag
aurora_standard.chmchpsd	gl_flag
aurora_standard.chmclocd	cur_flag
aurora_standard.chmcontr	state_flag
aurora_standard.chmcosta	birth_flag
aurora_standard.chmcptcd	pay_flag
aurora_standard.chmcptcd	denial_flag
aurora_standard.chmcptcd	pkging_flag
aurora_standard.chmcptcd	pay_adj_flag
aurora_standard.chmdfysc	hold_flag
aurora_standard.chmemrxd	print_flag
aurora_standard.chmexmpi	archive_flag
aurora_standard.chmexvis	archive_flag
aurora_standard.chmfclsc	badd_flag
aurora_standard.chmmbc50	privacy_flag
aurora_standard.chmmbc51	primary_payor_flag
aurora_standard.chmmhast	co_mr_flag
aurora_standard.chmmhast	co_att_flag
aurora_standard.chmmhast	co_sur_flag
aurora_standard.chmmhbcr	emc_flag
aurora_standard.chmmhbcr	privacy_flag
aurora_standard.chmnbcgd	gl_flag
aurora_standard.chmnbpyd	gl_flag
aurora_standard.chmnchgd	gl_flag
aurora_standard.chmnpatr	statement_flag
aurora_standard.chmnpayd	gl_flag
aurora_standard.chmpadjd	gl_flag
aurora_standard.chmpchgd	gl_flag
aurora_standard.chmpnotc	alert_flag
aurora_standard.chmppayd	gl_flag
aurora_standard.chmpricc	ub_flag
aurora_standard.chmpricc	inactive_flag
aurora_standard.chmpricc	state_flag
aurora_standard.chmpsvcd	medicare_flag
aurora_standard.chmracec	active_flag
aurora_standard.chmradex	medicare_flag
aurora_standard.chmrchgd	gl_flag
aurora_standard.chmrefnd	approved_flag
aurora_standard.chmroomd	gl_flag
aurora_standard.chmrsrcc	active_flag
aurora_standard.chmschgd	serial_flag
aurora_standard.chmtpatr	statement_flag
aurora_standard.chmub04r	emc_flag
aurora_standard.chmub92r	emc_flag
aurora_standard.chmvtotd	visit_flag
aurora_standard.chnchrgc	active_flag
aurora_standard.chnchrsc	active_flag
aurora_standard.chnchrsc	response_flag
aurora_standard.chnchrtc	active_flag
aurora_standard.chnpatcd	print_flag
aurora_standard.chnpatcd	response_flag
aurora_standard.chnpatcr	active_flag
aurora_standard.chnrpsnr	active_flag
aurora_standard.chrdintr	substitution_flag
aurora_standard.chrdrugc	form_flag
aurora_standard.chrdrugc	audit_use_flag
aurora_standard.chrdrugc	stock_flag
aurora_standard.chrhomed	process_flag
aurora_standard.chrhomer	complete_flag
aurora_standard.chrhomer	allergy_flag
aurora_standard.chrordrr	allergy_flag
aurora_standard.chrpyxid	track_flag
aurora_standard.chrschdr	fill_list_flag
aurora_standard.chrschdr	process_flag
aurora_standard.chrschdr	prn_flag
aurora_standard.chrschdr	sun_flag
aurora_standard.chrschdr	mon_flag
aurora_standard.chrschdr	tue_flag
aurora_standard.chrschdr	wed_flag
aurora_standard.chrschdr	thu_flag
aurora_standard.chrschdr	fri_flag
aurora_standard.chrschdr	sat_flag
aurora_standard.chtcntrc	rounding_flag
aurora_standard.chtfdref	active_flag
aurora_standard.chtholic	type_flag
aurora_standard.chxcntrc	hl7_flag
aurora_standard.chxexamd	rpt_flag
aurora_standard.chxflocd	cur_flag
aurora_standard.chxleasd	rpt_flag
aurora_standard.chyrespd	rpt_flag
aurora_standard.defaults	rounding_flag
aurora_standard.dpmap	process_flag
aurora_standard.financial_class_changes	gl_flag
aurora_standard.glsprice	ub_flag
aurora_standard.glsprice	inactive_flag
aurora_standard.glsprice	state_flag
aurora_standard.hhmadmtr	archive_flag
aurora_standard.hl7gt1	guar_death_flag
aurora_standard.hl7in1	notice_admis_flag
aurora_standard.hl7in1	rpt_elig_flag
aurora_standard.hl7in1ad	notice_admis_flag
aurora_standard.hl7in1ad	rpt_elig_flag
aurora_standard.hl7in2	suspend_flag
aurora_standard.hl7in2	copay_limit_flag
aurora_standard.hl7in2	stoploss_lim_flag
aurora_standard.hl7orc	response_flag
aurora_standard.jkyemppd	print_flag
aurora_standard.jkyemppd	active_flag
aurora_standard.kcvis	arch_flag
aurora_standard.kcvisit	arch_flag
aurora_standard.lngdrg	add_flag
aurora_standard.lngdrg	deactivate_flag
aurora_standard.lngdrg	reactivate_flag
aurora_standard.lngdrg	ndc_change_flag
aurora_standard.lngdrg	solid_liquid_flag
aurora_standard.lngdrg	unit_dose_flag
aurora_standard.lngdrg	single_source_flag
aurora_standard.lngdrg	maint_drug_flag
aurora_standard.lngdrg	desi_drug_flag
aurora_standard.lngdrg	wac_start_flag
aurora_standard.lngdrg	awp_start_flag
aurora_standard.lngdrg	dp_start_flag
aurora_standard.lngdrg	ful_start_flag
aurora_standard.lngdrg	srp_start_flag
aurora_standard.oebatchaud	gl_flag
aurora_standard.pharm1	active_flag
aurora_standard.pharm1	form_flag
aurora_standard.schactivec	active_flag
aurora_standard.schgrpsetupc	active_flag
aurora_standard.schmultic	active_flag
aurora_standard.schprocedurc	active_flag
aurora_standard.schresourcec	active_flag
aurora_standard.stfdtabr	internal_flag
aurora_standard.stiinvtr	ub_flag
aurora_standard.stiinvtr	contract_flag
aurora_standard.stilocar	freez_flag
aurora_standard.stpinvce	fix_date_flag
aurora_standard.stuctlgd	active_flag
aurora_standard.stuordrd	note_flag
aurora_standard.stxfuncr	allow_flag
aurora_standard.stxparmd	sbd_flag
aurora_standard.stxsecud	allow_flag
aurora_standard.stxxrefd	active_flag
aurora_standard.stycntrc	apply_date_flag
aurora_standard.stycntrc	bonus_chk_flag
aurora_standard.stydedcr	limit_flag
aurora_standard.stydedcr	active_flag
aurora_standard.styempcd	print_flag
aurora_standard.styemppd	print_flag
aurora_standard.styemppd	active_flag
aurora_standard.stygrupr	active_flag
aurora_standard.styinccr	pto_flag
aurora_standard.stypaydd	mod_flag
aurora_standard.stypayid	mod_flag
aurora_standard.stypayod	mod_flag
aurora_standard.stypaypd	mod_flag
aurora_standard.styptoad	active_flag
aurora_standard.stytimee	used_flag
aurora_standard.surintrastpr	active_flag
aurora_standard.tmpctlgd	active_flag
aurora_standard.tmplocar	freez_flag
aurora_standard.tmpub04r	emc_flag
aurora_standard.ttiinvtr	ub_flag
aurora_standard.ttiinvtr	contract_flag
aurora_standard.vault_cpt_codes	active_flag
aurora_standard.vault_cpt_codes	valid_flag
aurora_standard.vault_icd9s	valid_flag
aurora_standard.vault_icd9s	active_flag
aurora_standard.vault_races	active_flag
aurora_standard.vault_relationships	active_flag
aurora_standard.vault_religions	active_flag

race

Table	Column
_1.charts	chrt_race
_1.encounters	enc_race
_1.orders_afps	oafp_race
_1.patients	pat_race
_1.precerts	pre_race
_1188.charts	chrt_race
_1188.encounters	enc_race
_1188.orders_afps	oafp_race
_1188.patients	pat_race
_1188.precerts	pre_race
_1218.charts	chrt_race
_1218.encounters	enc_race
_1218.orders_afps	oafp_race
_1218.patients	pat_race
_1218.precerts	pre_race
_1548.charts	chrt_race
_1548.encounters	enc_race
_1548.orders_afps	oafp_race
_1548.patients	pat_race
_1548.precerts	pre_race
_435.charts	chrt_race
_435.encounters	enc_race
_435.orders_afps	oafp_race
_435.patients	pat_race
_435.precerts	pre_race
_436.charts	chrt_race
_436.encounters	enc_race
_436.orders_afps	oafp_race
_436.patients	pat_race
_436.precerts	pre_race
_436_archive_testing.charts	chrt_race
_436_archive_testing.encounters	enc_race
_436_archive_testing.orders_afps	oafp_race
_436_archive_testing.patients	pat_race
_436_archive_testing.precerts	pre_race
_437.charts	chrt_race
_437.encounters	enc_race
_437.orders_afps	oafp_race
_437.patients	pat_race
_437.precerts	pre_race
_8.charts	chrt_race
_8.encounters	enc_race
_8.orders_afps	oafp_race
_8.patients	pat_race
_8.precerts	pre_race
_81.charts	chrt_race
_81.encounters	enc_race
_81.orders_afps	oafp_race
_81.patients	pat_race
_81.precerts	pre_race
_999.charts	chrt_race
_999.encounters	enc_race
_999.orders_afps	oafp_race
_999.patients	pat_race
_999.precerts	pre_race
aurora_standard.bhar	p_race
aurora_standard.bhar	g_race
aurora_standard.bhguar	g_race
aurora_standard.bhtguar	g_race
aurora_standard.bpar	p_race
aurora_standard.bpar	g_race
aurora_standard.bpar2	p_race
aurora_standard.bpar2	g_race
aurora_standard.bpmpi	p_race
aurora_standard.bpmpi2	p_race
aurora_standard.chmazstd	pat_race
aurora_standard.chmazsti	pat_race
aurora_standard.chmazsto	pat_race
aurora_standard.chmhistp	p_race
aurora_standard.chmlastr	pat_race
aurora_standard.chmmhast	pat_race
aurora_standard.chmokipd	pat_race
aurora_standard.chmokopd	pat_race
aurora_standard.chmtxstr	pat_race
aurora_standard.hl7gt1	guar_race
aurora_standard.tmpmrrpt	sex_race

route

Table	Column
_1.charts_medications	cm_route
_1.patients_immunizations	pim_admin_route
_1.patients_medications	pms_route
_1.patients_prescriptions	prx_route
_1188.charts_medications	cm_route
_1188.patients_immunizations	pim_admin_route
_1188.patients_medications	pms_route
_1188.patients_prescriptions	prx_route
_1218.charts_medications	cm_route
_1218.patients_immunizations	pim_admin_route
_1218.patients_medications	pms_route
_1218.patients_prescriptions	prx_route
_1548.charts_medications	cm_route
_1548.patients_immunizations	pim_admin_route
_1548.patients_medications	pms_route
_1548.patients_prescriptions	prx_route
_435.charts_medications	cm_route
_435.patients_immunizations	pim_admin_route
_435.patients_medications	pms_route
_435.patients_prescriptions	prx_route
_436.charts_medications	cm_route
_436.patients_immunizations	pim_admin_route
_436.patients_medications	pms_route
_436.patients_prescriptions	prx_route
_436_archive_testing.charts_medications	cm_route
_436_archive_testing.patients_immunizations	pim_admin_route
_436_archive_testing.patients_medications	pms_route
_436_archive_testing.patients_prescriptions	prx_route
_437.charts_medications	cm_route
_437.patients_immunizations	pim_admin_route
_437.patients_medications	pms_route
_437.patients_prescriptions	prx_route
_8.charts_medications	cm_route
_8.patients_immunizations	pim_admin_route
_8.patients_medications	pms_route
_8.patients_prescriptions	prx_route
_81.charts_medications	cm_route
_81.patients_immunizations	pim_admin_route
_81.patients_medications	pms_route
_81.patients_prescriptions	prx_route
_999.charts_medications	cm_route
_999.patients_immunizations	pim_admin_route
_999.patients_medications	pms_route
_999.patients_prescriptions	prx_route
aurora_standard.chrdrugc	default_route
aurora_standard.hhl7auda	hl7_route
common.drugs	drg_route

ndc_code

Table	Column
_1.clients_fee_schedules_map	cfsm_ndc_code
_1.clinical_interventions_medications_map	cimm_ndc_code
_1.cpt	cpt_ndc_code
_1.inventory	inv_ndc_code
_1.patients_inventory	pinv_ndc_code
_1.patients_responsibility_estimates_services	prests_ndc_code
_1188.clients_fee_schedules_map	cfsm_ndc_code
_1188.clinical_interventions_medications_map	cimm_ndc_code
_1188.cpt	cpt_ndc_code
_1188.inventory	inv_ndc_code
_1188.patients_inventory	pinv_ndc_code
_1188.patients_responsibility_estimates_services	prests_ndc_code
_1218.clients_fee_schedules_map	cfsm_ndc_code
_1218.clinical_interventions_medications_map	cimm_ndc_code
_1218.cpt	cpt_ndc_code
_1218.inventory	inv_ndc_code
_1218.patients_inventory	pinv_ndc_code
_1218.patients_responsibility_estimates_services	prests_ndc_code
_1548.clients_fee_schedules_map	cfsm_ndc_code
_1548.clinical_interventions_medications_map	cimm_ndc_code
_1548.cpt	cpt_ndc_code
_1548.inventory	inv_ndc_code
_1548.patients_inventory	pinv_ndc_code
_1548.patients_responsibility_estimates_services	prests_ndc_code
_435.clients_fee_schedules_map	cfsm_ndc_code
_435.clinical_interventions_medications_map	cimm_ndc_code
_435.cpt	cpt_ndc_code
_435.inventory	inv_ndc_code
_435.patients_inventory	pinv_ndc_code
_435.patients_responsibility_estimates_services	prests_ndc_code
_436.clients_fee_schedules_map	cfsm_ndc_code
_436.clinical_interventions_medications_map	cimm_ndc_code
_436.cpt	cpt_ndc_code
_436.inventory	inv_ndc_code
_436.patients_inventory	pinv_ndc_code
_436.patients_responsibility_estimates_services	prests_ndc_code
_436_archive_testing.clients_fee_schedules_map	cfsm_ndc_code
_436_archive_testing.clinical_interventions_medications_map	cimm_ndc_code
_436_archive_testing.cpt	cpt_ndc_code
_436_archive_testing.inventory	inv_ndc_code
_436_archive_testing.patients_inventory	pinv_ndc_code
_436_archive_testing.patients_responsibility_estimates_services	prests_ndc_code
_437.clients_fee_schedules_map	cfsm_ndc_code
_437.clinical_interventions_medications_map	cimm_ndc_code
_437.cpt	cpt_ndc_code
_437.inventory	inv_ndc_code
_437.patients_inventory	pinv_ndc_code
_437.patients_responsibility_estimates_services	prests_ndc_code
_8.clients_fee_schedules_map	cfsm_ndc_code
_8.clinical_interventions_medications_map	cimm_ndc_code
_8.cpt	cpt_ndc_code
_8.inventory	inv_ndc_code
_8.patients_inventory	pinv_ndc_code
_8.patients_responsibility_estimates_services	prests_ndc_code
_81.clients_fee_schedules_map	cfsm_ndc_code
_81.clinical_interventions_medications_map	cimm_ndc_code
_81.cpt	cpt_ndc_code
_81.inventory	inv_ndc_code
_81.patients_inventory	pinv_ndc_code
_81.patients_responsibility_estimates_services	prests_ndc_code
_999.clients_fee_schedules_map	cfsm_ndc_code
_999.clinical_interventions_medications_map	cimm_ndc_code
_999.cpt	cpt_ndc_code
_999.inventory	inv_ndc_code
_999.patients_inventory	pinv_ndc_code
_999.patients_responsibility_estimates_services	prests_ndc_code
aurora_standard.lngdrg	prev_ndc_code
template_library.cpt	cpt_ndc_code

language

Table	Column
_1.clinical_interventions	ci_language
_1188.clinical_interventions	ci_language
_1218.clinical_interventions	ci_language
_1548.clinical_interventions	ci_language
_435.clinical_interventions	ci_language
_436.clinical_interventions	ci_language
_436_archive_testing.clinical_interventions	ci_language
_437.clinical_interventions	ci_language
_8.clinical_interventions	ci_language
_81.clinical_interventions	ci_language
_999.clinical_interventions	ci_language
ahiWiki.sites	site_language
aurora_standard.bdmpi	prim_language
aurora_standard.bsinsur	prim_language
aurora_standard.campi	prim_language
aurora_standard.chmpatmr	prim_language
aurora_standard.hl7pid	prim_language
aurora_standard.hl7pidad	prim_language

freq

Table	Column
_1.clinical_interventions	ci_rem_freq
_1.insurances_stats	is_freq
_1188.clinical_interventions	ci_rem_freq
_1188.insurances_stats	is_freq
_1218.clinical_interventions	ci_rem_freq
_1218.insurances_stats	is_freq
_1548.clinical_interventions	ci_rem_freq
_1548.insurances_stats	is_freq
_435.clinical_interventions	ci_rem_freq
_435.insurances_stats	is_freq
_436.clinical_interventions	ci_rem_freq
_436.insurances_stats	is_freq
_436_archive_testing.clinical_interventions	ci_rem_freq
_436_archive_testing.insurances_stats	is_freq
_437.clinical_interventions	ci_rem_freq
_437.insurances_stats	is_freq
_8.clinical_interventions	ci_rem_freq
_8.insurances_stats	is_freq
_81.clinical_interventions	ci_rem_freq
_81.insurances_stats	is_freq
_999.clinical_interventions	ci_rem_freq
_999.insurances_stats	is_freq
aurora_standard.styaccrr	accr_freq
aurora_standard.stytimod	pay_freq

occupation

Table	Column
_1.encounters	enc_employer_occupation
_1.patients	pat_employer_occupation
_1.patients_demographics_snapshots	pds_employer_occupation
_1.precerts	pre_employer_occupation
_1188.encounters	enc_employer_occupation
_1188.patients	pat_employer_occupation
_1188.patients_demographics_snapshots	pds_employer_occupation
_1188.precerts	pre_employer_occupation
_1218.encounters	enc_employer_occupation
_1218.patients	pat_employer_occupation
_1218.patients_demographics_snapshots	pds_employer_occupation
_1218.precerts	pre_employer_occupation
_1548.encounters	enc_employer_occupation
_1548.patients	pat_employer_occupation
_1548.patients_demographics_snapshots	pds_employer_occupation
_1548.precerts	pre_employer_occupation
_435.encounters	enc_employer_occupation
_435.patients	pat_employer_occupation
_435.patients_demographics_snapshots	pds_employer_occupation
_435.precerts	pre_employer_occupation
_436.encounters	enc_employer_occupation
_436.patients	pat_employer_occupation
_436.patients_demographics_snapshots	pds_employer_occupation
_436.precerts	pre_employer_occupation
_436_archive_testing.encounters	enc_employer_occupation
_436_archive_testing.patients	pat_employer_occupation
_436_archive_testing.patients_demographics_snapshots	pds_employer_occupation
_436_archive_testing.precerts	pre_employer_occupation
_437.encounters	enc_employer_occupation
_437.patients	pat_employer_occupation
_437.patients_demographics_snapshots	pds_employer_occupation
_437.precerts	pre_employer_occupation
_8.encounters	enc_employer_occupation
_8.patients	pat_employer_occupation
_8.patients_demographics_snapshots	pds_employer_occupation
_8.precerts	pre_employer_occupation
_81.encounters	enc_employer_occupation
_81.patients	pat_employer_occupation
_81.patients_demographics_snapshots	pds_employer_occupation
_81.precerts	pre_employer_occupation
_999.encounters	enc_employer_occupation
_999.patients	pat_employer_occupation
_999.patients_demographics_snapshots	pds_employer_occupation
_999.precerts	pre_employer_occupation

marital

Table	Column
aurora_standard.chmarsi	pat_marital
aurora_standard.chmazstd	pat_marital
aurora_standard.chmazsti	pat_marital
aurora_standard.chmazsto	pat_marital
aurora_standard.chmcampi	pat_marital
aurora_standard.chmexmpi	pat_marital
aurora_standard.chmlastr	pat_marital
aurora_standard.chmmrhdr	upd_marital
aurora_standard.chmokipd	pat_marital
aurora_standard.chmokopd	pat_marital
aurora_standard.chmpdemo	p_marital
aurora_standard.chmradex	pat_marital
aurora_standard.chmtxstr	pat_marital
aurora_standard.ohoemadd	state_marital
aurora_standard.ohoemadd	fed_marital
aurora_standard.styemplr	state_marital
aurora_standard.stytaxtd	state_marital

medicare

Table	Column
aurora_standard.chmmbc40	pos_medicare
aurora_standard.oddpayre	ded_medicare
aurora_standard.oddpayre	obl_medicare
aurora_standard.odhpayre	ded_medicare
aurora_standard.odhpayre	obl_medicare
aurora_standard.stypayre	ded_medicare
aurora_standard.stypayre	obl_medicare

prn

Table	Column
aurora_standard.chrdrugc	default_prn