aurora_standard.chmmhast

Field Type Null Default Key Extra Comment
record_type char(1) YES
pat_type char(2) YES
facility_id char(4) YES
filler char(8) YES
mr_no char(9) YES
mr_no_mother char(9) YES
pat_id char(30) YES
pat_dob char(8) YES
pat_sex char(1) YES
pat_race char(1) YES
ethnicity char(1) YES
pat_zipcode char(5) YES
pat_zipcode_ext char(4) YES
admit_dt char(8) YES
dischg_dt char(8) YES
adm_type char(1) YES
adm_poa char(1) YES
readm_ind char(1) YES
dis_status char(2) YES
dnr_order char(1) YES
pri_payer char(2) YES
sec_payer char(2) YES
tot_charges char(8) YES
att_phy char(10) YES
filler_1 char(3) YES
surgeon char(10) YES
filler2 char(3) YES
adm_dx char(5) YES
prin_dx char(5) YES
other_dx1 char(5) YES
other_dx2 char(5) YES
other_dx3 char(5) YES
other_dx4 char(5) YES
other_dx5 char(5) YES
other_dx6 char(5) YES
other_dx7 char(5) YES
other_dx8 char(5) YES
other_dx9 char(5) YES
other_dx10 char(5) YES
other_dx11 char(5) YES
other_dx12 char(5) YES
other_dx13 char(5) YES
other_dx14 char(5) YES
other_dx15 char(5) YES
other_dx16 char(5) YES
other_dx17 char(5) YES
other_dx18 char(5) YES
other_dx19 char(5) YES
other_dx20 char(5) YES
other_dx21 char(5) YES
other_dx22 char(5) YES
other_dx23 char(5) YES
other_dx24 char(5) YES
other_dx25 char(5) YES
other_dx26 char(5) YES
other_dx27 char(5) YES
other_dx28 char(5) YES
other_dx29 char(5) YES
prin_icd9 char(4) YES
prin_icd9_dt char(6) YES
proc01 char(4) YES
proc01_dt char(6) YES
proc02 char(4) YES
proc02_dt char(6) YES
proc03 char(4) YES
proc03_dt char(6) YES
proc04 char(4) YES
proc04_dt char(6) YES
proc05 char(4) YES
proc05_dt char(6) YES
proc06 char(4) YES
proc06_dt char(6) YES
proc07 char(4) YES
proc07_dt char(6) YES
proc08 char(4) YES
proc08_dt char(6) YES
proc09 char(4) YES
proc09_dt char(6) YES
proc10 char(4) YES
proc10_dt char(6) YES
proc11 char(4) YES
proc11_dt char(6) YES
proc12 char(4) YES
proc12_dt char(6) YES
proc13 char(4) YES
proc13_dt char(6) YES
proc14 char(4) YES
proc14_dt char(6) YES
proc15 char(4) YES
proc15_dt char(6) YES
proc16 char(4) YES
proc16_dt char(6) YES
proc17 char(4) YES
proc17_dt char(6) YES
proc18 char(4) YES
proc18_dt char(6) YES
proc19 char(4) YES
proc19_dt char(6) YES
proc20 char(4) YES
proc20_dt char(6) YES
proc21 char(4) YES
proc21_dt char(6) YES
proc22 char(4) YES
proc22_dt char(6) YES
proc23 char(4) YES
proc23_dt char(6) YES
proc24 char(4) YES
proc24_dt char(6) YES
proc25 char(4) YES
proc25_dt char(6) YES
proc26 char(4) YES
proc26_dt char(6) YES
proc27 char(4) YES
proc27_dt char(6) YES
proc28 char(4) YES
proc28_dt char(6) YES
proc29 char(4) YES
proc29_dt char(6) YES
prin_cpt4 char(5) YES
prin_cpt4_dt char(6) YES
cpt01 char(5) YES
cpt01_dt char(6) YES
cpt02 char(5) YES
cpt02_dt char(6) YES
cpt03 char(5) YES
cpt03_dt char(6) YES
cpt04 char(5) YES
cpt04_dt char(6) YES
cpt05 char(5) YES
cpt05_dt char(6) YES
cpt06 char(5) YES
cpt06_dt char(6) YES
cpt07 char(5) YES
cpt07_dt char(6) YES
cpt08 char(5) YES
cpt08_dt char(6) YES
cpt09 char(5) YES
cpt09_dt char(6) YES
cpt10 char(5) YES
cpt10_dt char(6) YES
cpt11 char(5) YES
cpt11_dt char(6) YES
cpt12 char(5) YES
cpt12_dt char(6) YES
cpt13 char(5) YES
cpt13_dt char(6) YES
cpt14 char(5) YES
cpt14_dt char(6) YES
cpt15 char(5) YES
cpt15_dt char(6) YES
cpt16 char(5) YES
cpt16_dt char(6) YES
cpt17 char(5) YES
cpt17_dt char(6) YES
cpt18 char(5) YES
cpt18_dt char(6) YES
cpt19 char(5) YES
cpt19_dt char(6) YES
cpt20 char(5) YES
cpt20_dt char(6) YES
cpt21 char(5) YES
cpt21_dt char(6) YES
cpt22 char(5) YES
cpt22_dt char(6) YES
cpt23 char(5) YES
cpt23_dt char(6) YES
cpt24 char(5) YES
cpt24_dt char(6) YES
cpt25 char(5) YES
cpt25_dt char(6) YES
cpt26 char(5) YES
cpt26_dt char(6) YES
hos_ser_cd char(2) YES
icu_used char(1) YES
icu_days char(2) YES
ccu_used char(1) YES
ccu_days char(2) YES
prin_proc_tis char(1) YES
surg_expediency char(1) YES
outlier_age char(1) YES
outlier_charges char(1) YES
outlier_los char(1) YES
filler3 char(2) YES
homeless_status char(1) YES
filler4 char(73) YES
pat_first_nm char(15) YES
pat_mid_int char(1) YES
pat_last_nm char(24) YES
pat_hic_no char(12) YES
pat_ssn char(9) YES
co_mr_flag char(1) YES
co_mr_no char(17) YES
pat_cont_no char(20) YES
co_att_flag char(1) YES
co_att_phy char(16) YES
filler5 char(16) YES
co_sur_flag char(1) YES
co_surg char(16) YES
ref_phy char(16) YES
other_phy char(16) YES
consult_phy char(16) YES
filler6 char(16) YES
filler7 char(94) YES
birth_wt char(4) YES
fac_npi char(10) YES
att_phy_npi char(10) YES
surg_npi char(10) YES
poa_prin_dx char(1) YES
poa_dx1 char(1) YES
poa_dx2 char(1) YES
poa_dx3 char(1) YES
poa_dx4 char(1) YES
poa_dx5 char(1) YES
poa_dx6 char(1) YES
poa_dx7 char(1) YES
poa_dx8 char(1) YES
poa_dx9 char(1) YES
poa_dx10 char(1) YES
poa_dx11 char(1) YES
poa_dx12 char(1) YES
poa_dx13 char(1) YES
poa_dx14 char(1) YES
poa_dx15 char(1) YES
poa_dx16 char(1) YES
poa_dx17 char(1) YES
poa_dx18 char(1) YES
poa_dx19 char(1) YES
poa_dx20 char(1) YES
poa_dx21 char(1) YES
poa_dx22 char(1) YES
poa_dx23 char(1) YES
poa_dx24 char(1) YES
poa_dx25 char(1) YES
poa_dx26 char(1) YES
poa_dx27 char(1) YES
poa_dx28 char(1) YES
poa_dx29 char(1) YES
filler8 char(1) YES
filler9 char(44) YES

References

Local Column References
pat_id
TableColumn
AzaleaStats.erx_debuged_pat_id
_1.appointment_recurrencearec_pat_id
_1.appointmentsapt_pat_id
_1.appointments_requestsaptreq_pat_id
_1.auditsaud_pat_id
_1.audits_archiveaud_pat_id
_1.audits_newaud_pat_id
_1.audits_new_archiveaud_pat_id
_1.card_connect_profilescconp_pat_id
_1.chartschrt_pat_id
_1.charts_care_planccp_pat_id
_1.charts_cpt_codeschcp_pat_id
_1.charts_diagnosiscdx_pat_id
_1.charts_icd9_codescic_pat_id
_1.charts_medicationscm_pat_id
_1.charts_numberscnum_pat_id
_1.charts_procedurescp_pat_id
_1.clinical_interventions_review_mapcirm_pat_id
_1.configured_encountersconfenc_pat_id
_1.cpoe_responsescpoe_res_pat_id
_1.cqm_entriescqme_pat_id
_1.cqm_errorscqmer_pat_id
_1.documentsdoc_pat_id
_1.encounter_soap_labels_values_groupseslvg_pat_id
_1.encountersenc_pat_id
_1.encountersenc_guarantor_linked_pat_id
_1.encountersenc_ins1_linked_pat_id
_1.encountersenc_ins2_linked_pat_id
_1.encountersenc_ins3_linked_pat_id
_1.encounters_cpt_codesecp_pat_id
_1.encounters_icd9_codeseic_pat_id
_1.encounters_numbersenum_pat_id
_1.encounters_patients_races_mapeprm_pat_id
_1.encounters_soap_labels_componentseslc_pat_id
_1.encounters_soap_labels_valueseslv_pat_id
_1.encounters_soap_labels_values_mapeslvm_pat_id
_1.encounters_soap_vitalsespv_pat_id
_1.encounters_stored_notes_patients_frequencyesnpf_pat_id
_1.encounters_ub04enc_ub04_pat_id
_1.erx_webservice_transactionsewt_pat_id
_1.hl7_accessionsacc_pat_id
_1.hl7_resultsres_pat_id
_1.insurances_repositoryirep_pat_id
_1.insurances_repositoryirep_linked_pat_id
_1.insurances_verificationiv_pat_id
_1.ledgerled_pat_id
_1.ordersord_pat_id
_1.orders_afpsoafp_pat_id
_1.orders_commentsorc_pat_id
_1.orders_icd9_codesoic_pat_id
_1.orders_papsopap_pat_id
_1.orders_paps_historyopaph_pat_id
_1.orders_standingost_pat_id
_1.orders_standing_datesosd_pat_id
_1.orders_test_codesotc_pat_id
_1.patient_access_restrictionpatar_pat_id
_1.patient_amendmentspa_pat_id
_1.patient_configured_encounterspce_pat_id
_1.patient_finance_recordspfr_pat_id
_1.patient_next_of_kinpnk_pat_id
_1.patient_portal_requestsppr_pat_id
_1.patientspat_merged_into_pat_id
_1.patientspat_guarantor_linked_pat_id
_1.patientspat_ins1_linked_pat_id
_1.patientspat_ins2_linked_pat_id
_1.patientspat_ins3_linked_pat_id
_1.patients_additional_providerspap_pat_id
_1.patients_allergiespalg_pat_id
_1.patients_authorization_numberspan_pat_id
_1.patients_classes_mappcm_pat_id
_1.patients_configured_encounters_schedulespces_pat_id
_1.patients_demographics_snapshotspds_pat_id
_1.patients_demographics_snapshotspds_guarantor_linked_pat_id
_1.patients_demographics_snapshotspds_ins1_linked_pat_id
_1.patients_demographics_snapshotspds_ins2_linked_pat_id
_1.patients_demographics_snapshotspds_ins3_linked_pat_id
_1.patients_document_assemblypda_pat_id
_1.patients_education_resultsperes_pat_id
_1.patients_enrollmentspert_pat_id
_1.patients_erx_updatespeu_pat_id
_1.patients_ethnicities_mappem_pat_id
_1.patients_handoutsphs_pat_id
_1.patients_health_concernsphc_pat_id
_1.patients_health_observationspho_pat_id
_1.patients_historiesph_pat_id
_1.patients_icd9_problemspip_pat_id
_1.patients_imagespi_pat_id
_1.patients_immunizationspim_pat_id
_1.patients_implantable_devicespid_pat_id
_1.patients_inventorypinv_pat_id
_1.patients_medicationspms_pat_id
_1.patients_namespn_pat_id
_1.patients_payment_methodspatpm_pat_id
_1.patients_payments_ledger_mappplm_pat_id
_1.patients_payments_schedulespps_pat_id
_1.patients_pidsppid_pat_id
_1.patients_prescriptionsprx_pat_id
_1.patients_races_mapprm_pat_id
_1.patients_referralspref_pat_id
_1.patients_relatives_mapprm_pat_id
_1.patients_reminderspr_pat_id
_1.patients_responsibility_estimatesprest_pat_id
_1.patients_smoking_statuspss_pat_id
_1.patients_social_answerspsa_pat_id
_1.patients_statements_mappstm_pat_id
_1.patients_stored_messagespsm_pat_id
_1.patients_taskspt_pat_id
_1.patients_urlspu_pat_id
_1.patients_vitalspvs_pat_id
_1.poapoa_pat_id
_1.portal_released_dataprd_pat_id
_1.portal_withheld_datapwd_pat_id
_1.precertspre_pat_id
_1.precerts_commentsprc_pat_id
_1.precerts_cpt_codespcp_pat_id
_1.precerts_icd9_codespic_pat_id
_1.precerts_numberspnum_pat_id
_1.procedures_resultspres_pat_id
_1.radiology_order_notesradnot_pat_id
_1.radiology_ordersrad_pat_id
_1.radiology_orders_icd9_codesric_pat_id
_1.radiology_orders_numbersradnum_pat_id
_1.radiology_resultsrad_res_pat_id
_1.radiology_results_test_codes_resultsrrtcres_pat_id
_1.recall_listrcl_pat_id
_1.requisition_numbersreq_pat_id
_1.stripe_customers_accountssca_pat_id
_1.structured_answerssra_pat_id
_1.voided_paymentsvp_pat_id
_1188.appointment_recurrencearec_pat_id
_1188.appointmentsapt_pat_id
_1188.appointments_requestsaptreq_pat_id
_1188.auditsaud_pat_id
_1188.audits_archiveaud_pat_id
_1188.audits_newaud_pat_id
_1188.audits_new_archiveaud_pat_id
_1188.card_connect_profilescconp_pat_id
_1188.chartschrt_pat_id
_1188.charts_care_planccp_pat_id
_1188.charts_cpt_codeschcp_pat_id
_1188.charts_diagnosiscdx_pat_id
_1188.charts_icd9_codescic_pat_id
_1188.charts_medicationscm_pat_id
_1188.charts_numberscnum_pat_id
_1188.charts_procedurescp_pat_id
_1188.clinical_interventions_review_mapcirm_pat_id
_1188.cpoe_responsescpoe_res_pat_id
_1188.cqm_entriescqme_pat_id
_1188.cqm_errorscqmer_pat_id
_1188.documentsdoc_pat_id
_1188.encountersenc_pat_id
_1188.encountersenc_guarantor_linked_pat_id
_1188.encountersenc_ins1_linked_pat_id
_1188.encountersenc_ins2_linked_pat_id
_1188.encountersenc_ins3_linked_pat_id
_1188.encounters_cpt_codesecp_pat_id
_1188.encounters_icd9_codeseic_pat_id
_1188.encounters_numbersenum_pat_id
_1188.encounters_patients_races_mapeprm_pat_id
_1188.encounters_soap_labels_componentseslc_pat_id
_1188.encounters_soap_labels_valueseslv_pat_id
_1188.encounters_soap_vitalsespv_pat_id
_1188.encounters_stored_notes_patients_frequencyesnpf_pat_id
_1188.encounters_ub04enc_ub04_pat_id
_1188.erx_webservice_transactionsewt_pat_id
_1188.hl7_accessionsacc_pat_id
_1188.hl7_resultsres_pat_id
_1188.insurances_repositoryirep_pat_id
_1188.insurances_repositoryirep_linked_pat_id
_1188.insurances_verificationiv_pat_id
_1188.ledgerled_pat_id
_1188.ordersord_pat_id
_1188.orders_afpsoafp_pat_id
_1188.orders_commentsorc_pat_id
_1188.orders_icd9_codesoic_pat_id
_1188.orders_papsopap_pat_id
_1188.orders_paps_historyopaph_pat_id
_1188.orders_standingost_pat_id
_1188.orders_standing_datesosd_pat_id
_1188.orders_test_codesotc_pat_id
_1188.patient_access_restrictionpatar_pat_id
_1188.patient_amendmentspa_pat_id
_1188.patient_configured_encounterspce_pat_id
_1188.patient_finance_recordspfr_pat_id
_1188.patient_next_of_kinpnk_pat_id
_1188.patient_portal_requestsppr_pat_id
_1188.patientspat_merged_into_pat_id
_1188.patientspat_guarantor_linked_pat_id
_1188.patientspat_ins1_linked_pat_id
_1188.patientspat_ins2_linked_pat_id
_1188.patientspat_ins3_linked_pat_id
_1188.patients_additional_providerspap_pat_id
_1188.patients_allergiespalg_pat_id
_1188.patients_authorization_numberspan_pat_id
_1188.patients_classes_mappcm_pat_id
_1188.patients_configured_encounters_schedulespces_pat_id
_1188.patients_demographics_snapshotspds_pat_id
_1188.patients_demographics_snapshotspds_guarantor_linked_pat_id
_1188.patients_demographics_snapshotspds_ins1_linked_pat_id
_1188.patients_demographics_snapshotspds_ins2_linked_pat_id
_1188.patients_demographics_snapshotspds_ins3_linked_pat_id
_1188.patients_document_assemblypda_pat_id
_1188.patients_education_resultsperes_pat_id
_1188.patients_enrollmentspert_pat_id
_1188.patients_erx_updatespeu_pat_id
_1188.patients_ethnicities_mappem_pat_id
_1188.patients_handoutsphs_pat_id
_1188.patients_health_concernsphc_pat_id
_1188.patients_health_observationspho_pat_id
_1188.patients_historiesph_pat_id
_1188.patients_icd9_problemspip_pat_id
_1188.patients_imagespi_pat_id
_1188.patients_immunizationspim_pat_id
_1188.patients_implantable_devicespid_pat_id
_1188.patients_inventorypinv_pat_id
_1188.patients_medicationspms_pat_id
_1188.patients_namespn_pat_id
_1188.patients_payment_methodspatpm_pat_id
_1188.patients_payments_ledger_mappplm_pat_id
_1188.patients_payments_schedulespps_pat_id
_1188.patients_pidsppid_pat_id
_1188.patients_prescriptionsprx_pat_id
_1188.patients_races_mapprm_pat_id
_1188.patients_referralspref_pat_id
_1188.patients_relatives_mapprm_pat_id
_1188.patients_reminderspr_pat_id
_1188.patients_responsibility_estimatesprest_pat_id
_1188.patients_smoking_statuspss_pat_id
_1188.patients_social_answerspsa_pat_id
_1188.patients_statements_mappstm_pat_id
_1188.patients_stored_messagespsm_pat_id
_1188.patients_taskspt_pat_id
_1188.patients_urlspu_pat_id
_1188.patients_vitalspvs_pat_id
_1188.poapoa_pat_id
_1188.portal_released_dataprd_pat_id
_1188.portal_withheld_datapwd_pat_id
_1188.precertspre_pat_id
_1188.precerts_commentsprc_pat_id
_1188.precerts_cpt_codespcp_pat_id
_1188.precerts_icd9_codespic_pat_id
_1188.precerts_numberspnum_pat_id
_1188.procedures_resultspres_pat_id
_1188.radiology_order_notesradnot_pat_id
_1188.radiology_ordersrad_pat_id
_1188.radiology_orders_icd9_codesric_pat_id
_1188.radiology_orders_numbersradnum_pat_id
_1188.radiology_resultsrad_res_pat_id
_1188.radiology_results_test_codes_resultsrrtcres_pat_id
_1188.recall_listrcl_pat_id
_1188.requisition_numbersreq_pat_id
_1188.stripe_customers_accountssca_pat_id
_1188.structured_answerssra_pat_id
_1188.voided_paymentsvp_pat_id
_1218.appointment_recurrencearec_pat_id
_1218.appointmentsapt_pat_id
_1218.appointments_requestsaptreq_pat_id
_1218.auditsaud_pat_id
_1218.audits_archiveaud_pat_id
_1218.audits_newaud_pat_id
_1218.audits_new_archiveaud_pat_id
_1218.card_connect_profilescconp_pat_id
_1218.chartschrt_pat_id
_1218.charts_care_planccp_pat_id
_1218.charts_cpt_codeschcp_pat_id
_1218.charts_diagnosiscdx_pat_id
_1218.charts_icd9_codescic_pat_id
_1218.charts_medicationscm_pat_id
_1218.charts_numberscnum_pat_id
_1218.charts_procedurescp_pat_id
_1218.clinical_interventions_review_mapcirm_pat_id
_1218.cpoe_responsescpoe_res_pat_id
_1218.cqm_entriescqme_pat_id
_1218.cqm_errorscqmer_pat_id
_1218.documentsdoc_pat_id
_1218.encounter_soap_labels_values_groupseslvg_pat_id
_1218.encountersenc_pat_id
_1218.encountersenc_guarantor_linked_pat_id
_1218.encountersenc_ins1_linked_pat_id
_1218.encountersenc_ins2_linked_pat_id
_1218.encountersenc_ins3_linked_pat_id
_1218.encounters_cpt_codesecp_pat_id
_1218.encounters_icd9_codeseic_pat_id
_1218.encounters_numbersenum_pat_id
_1218.encounters_patients_races_mapeprm_pat_id
_1218.encounters_soap_labels_componentseslc_pat_id
_1218.encounters_soap_labels_valueseslv_pat_id
_1218.encounters_soap_labels_values_mapeslvm_pat_id
_1218.encounters_soap_vitalsespv_pat_id
_1218.encounters_stored_notes_patients_frequencyesnpf_pat_id
_1218.encounters_ub04enc_ub04_pat_id
_1218.erx_webservice_transactionsewt_pat_id
_1218.hl7_accessionsacc_pat_id
_1218.hl7_resultsres_pat_id
_1218.insurances_repositoryirep_pat_id
_1218.insurances_repositoryirep_linked_pat_id
_1218.insurances_verificationiv_pat_id
_1218.ledgerled_pat_id
_1218.ordersord_pat_id
_1218.orders_afpsoafp_pat_id
_1218.orders_commentsorc_pat_id
_1218.orders_icd9_codesoic_pat_id
_1218.orders_papsopap_pat_id
_1218.orders_paps_historyopaph_pat_id
_1218.orders_standingost_pat_id
_1218.orders_standing_datesosd_pat_id
_1218.orders_test_codesotc_pat_id
_1218.patient_access_restrictionpatar_pat_id
_1218.patient_amendmentspa_pat_id
_1218.patient_configured_encounterspce_pat_id
_1218.patient_finance_recordspfr_pat_id
_1218.patient_next_of_kinpnk_pat_id
_1218.patient_portal_requestsppr_pat_id
_1218.patientspat_merged_into_pat_id
_1218.patientspat_guarantor_linked_pat_id
_1218.patientspat_ins1_linked_pat_id
_1218.patientspat_ins2_linked_pat_id
_1218.patientspat_ins3_linked_pat_id
_1218.patients_additional_providerspap_pat_id
_1218.patients_allergiespalg_pat_id
_1218.patients_authorization_numberspan_pat_id
_1218.patients_classes_mappcm_pat_id
_1218.patients_configured_encounters_schedulespces_pat_id
_1218.patients_demographics_snapshotspds_pat_id
_1218.patients_demographics_snapshotspds_guarantor_linked_pat_id
_1218.patients_demographics_snapshotspds_ins1_linked_pat_id
_1218.patients_demographics_snapshotspds_ins2_linked_pat_id
_1218.patients_demographics_snapshotspds_ins3_linked_pat_id
_1218.patients_document_assemblypda_pat_id
_1218.patients_education_resultsperes_pat_id
_1218.patients_enrollmentspert_pat_id
_1218.patients_erx_updatespeu_pat_id
_1218.patients_ethnicities_mappem_pat_id
_1218.patients_handoutsphs_pat_id
_1218.patients_health_concernsphc_pat_id
_1218.patients_health_observationspho_pat_id
_1218.patients_historiesph_pat_id
_1218.patients_icd9_problemspip_pat_id
_1218.patients_imagespi_pat_id
_1218.patients_immunizationspim_pat_id
_1218.patients_implantable_devicespid_pat_id
_1218.patients_inventorypinv_pat_id
_1218.patients_medicationspms_pat_id
_1218.patients_namespn_pat_id
_1218.patients_payment_methodspatpm_pat_id
_1218.patients_payments_ledger_mappplm_pat_id
_1218.patients_payments_schedulespps_pat_id
_1218.patients_pidsppid_pat_id
_1218.patients_prescriptionsprx_pat_id
_1218.patients_races_mapprm_pat_id
_1218.patients_referralspref_pat_id
_1218.patients_relatives_mapprm_pat_id
_1218.patients_reminderspr_pat_id
_1218.patients_responsibility_estimatesprest_pat_id
_1218.patients_smoking_statuspss_pat_id
_1218.patients_social_answerspsa_pat_id
_1218.patients_statements_mappstm_pat_id
_1218.patients_stored_messagespsm_pat_id
_1218.patients_taskspt_pat_id
_1218.patients_urlspu_pat_id
_1218.patients_vitalspvs_pat_id
_1218.poapoa_pat_id
_1218.portal_released_dataprd_pat_id
_1218.portal_withheld_datapwd_pat_id
_1218.precertspre_pat_id
_1218.precerts_commentsprc_pat_id
_1218.precerts_cpt_codespcp_pat_id
_1218.precerts_icd9_codespic_pat_id
_1218.precerts_numberspnum_pat_id
_1218.procedures_resultspres_pat_id
_1218.radiology_order_notesradnot_pat_id
_1218.radiology_ordersrad_pat_id
_1218.radiology_orders_icd9_codesric_pat_id
_1218.radiology_orders_numbersradnum_pat_id
_1218.radiology_resultsrad_res_pat_id
_1218.radiology_results_test_codes_resultsrrtcres_pat_id
_1218.recall_listrcl_pat_id
_1218.requisition_numbersreq_pat_id
_1218.stripe_customers_accountssca_pat_id
_1218.structured_answerssra_pat_id
_1218.voided_paymentsvp_pat_id
_1548.appointment_recurrencearec_pat_id
_1548.appointmentsapt_pat_id
_1548.appointments_requestsaptreq_pat_id
_1548.auditsaud_pat_id
_1548.audits_archiveaud_pat_id
_1548.audits_newaud_pat_id
_1548.audits_new_archiveaud_pat_id
_1548.card_connect_profilescconp_pat_id
_1548.chartschrt_pat_id
_1548.charts_care_planccp_pat_id
_1548.charts_cpt_codeschcp_pat_id
_1548.charts_diagnosiscdx_pat_id
_1548.charts_icd9_codescic_pat_id
_1548.charts_medicationscm_pat_id
_1548.charts_numberscnum_pat_id
_1548.charts_procedurescp_pat_id
_1548.clinical_interventions_review_mapcirm_pat_id
_1548.configured_encountersconfenc_pat_id
_1548.cpoe_responsescpoe_res_pat_id
_1548.cqm_entriescqme_pat_id
_1548.cqm_errorscqmer_pat_id
_1548.documentsdoc_pat_id
_1548.encounter_soap_labels_values_groupseslvg_pat_id
_1548.encountersenc_pat_id
_1548.encountersenc_guarantor_linked_pat_id
_1548.encountersenc_ins1_linked_pat_id
_1548.encountersenc_ins2_linked_pat_id
_1548.encountersenc_ins3_linked_pat_id
_1548.encounters_cpt_codesecp_pat_id
_1548.encounters_icd9_codeseic_pat_id
_1548.encounters_numbersenum_pat_id
_1548.encounters_patients_races_mapeprm_pat_id
_1548.encounters_soap_labels_componentseslc_pat_id
_1548.encounters_soap_labels_valueseslv_pat_id
_1548.encounters_soap_labels_values_mapeslvm_pat_id
_1548.encounters_soap_vitalsespv_pat_id
_1548.encounters_stored_notes_patients_frequencyesnpf_pat_id
_1548.encounters_ub04enc_ub04_pat_id
_1548.erx_webservice_transactionsewt_pat_id
_1548.hl7_accessionsacc_pat_id
_1548.hl7_resultsres_pat_id
_1548.insurances_repositoryirep_pat_id
_1548.insurances_repositoryirep_linked_pat_id
_1548.insurances_verificationiv_pat_id
_1548.ledgerled_pat_id
_1548.ordersord_pat_id
_1548.orders_afpsoafp_pat_id
_1548.orders_commentsorc_pat_id
_1548.orders_icd9_codesoic_pat_id
_1548.orders_papsopap_pat_id
_1548.orders_paps_historyopaph_pat_id
_1548.orders_standingost_pat_id
_1548.orders_standing_datesosd_pat_id
_1548.orders_test_codesotc_pat_id
_1548.patient_access_restrictionpatar_pat_id
_1548.patient_amendmentspa_pat_id
_1548.patient_configured_encounterspce_pat_id
_1548.patient_finance_recordspfr_pat_id
_1548.patient_next_of_kinpnk_pat_id
_1548.patient_portal_requestsppr_pat_id
_1548.patientspat_merged_into_pat_id
_1548.patientspat_guarantor_linked_pat_id
_1548.patientspat_ins1_linked_pat_id
_1548.patientspat_ins2_linked_pat_id
_1548.patientspat_ins3_linked_pat_id
_1548.patients_additional_providerspap_pat_id
_1548.patients_allergiespalg_pat_id
_1548.patients_authorization_numberspan_pat_id
_1548.patients_classes_mappcm_pat_id
_1548.patients_configured_encounters_schedulespces_pat_id
_1548.patients_demographics_snapshotspds_pat_id
_1548.patients_demographics_snapshotspds_guarantor_linked_pat_id
_1548.patients_demographics_snapshotspds_ins1_linked_pat_id
_1548.patients_demographics_snapshotspds_ins2_linked_pat_id
_1548.patients_demographics_snapshotspds_ins3_linked_pat_id
_1548.patients_document_assemblypda_pat_id
_1548.patients_education_resultsperes_pat_id
_1548.patients_enrollmentspert_pat_id
_1548.patients_erx_updatespeu_pat_id
_1548.patients_ethnicities_mappem_pat_id
_1548.patients_handoutsphs_pat_id
_1548.patients_health_concernsphc_pat_id
_1548.patients_health_observationspho_pat_id
_1548.patients_historiesph_pat_id
_1548.patients_icd9_problemspip_pat_id
_1548.patients_imagespi_pat_id
_1548.patients_immunizationspim_pat_id
_1548.patients_implantable_devicespid_pat_id
_1548.patients_inventorypinv_pat_id
_1548.patients_medicationspms_pat_id
_1548.patients_namespn_pat_id
_1548.patients_payment_methodspatpm_pat_id
_1548.patients_payments_ledger_mappplm_pat_id
_1548.patients_payments_schedulespps_pat_id
_1548.patients_pidsppid_pat_id
_1548.patients_prescriptionsprx_pat_id
_1548.patients_races_mapprm_pat_id
_1548.patients_referralspref_pat_id
_1548.patients_relatives_mapprm_pat_id
_1548.patients_reminderspr_pat_id
_1548.patients_responsibility_estimatesprest_pat_id
_1548.patients_smoking_statuspss_pat_id
_1548.patients_social_answerspsa_pat_id
_1548.patients_statements_mappstm_pat_id
_1548.patients_stored_messagespsm_pat_id
_1548.patients_taskspt_pat_id
_1548.patients_urlspu_pat_id
_1548.patients_vitalspvs_pat_id
_1548.poapoa_pat_id
_1548.portal_released_dataprd_pat_id
_1548.portal_withheld_datapwd_pat_id
_1548.precertspre_pat_id
_1548.precerts_commentsprc_pat_id
_1548.precerts_cpt_codespcp_pat_id
_1548.precerts_icd9_codespic_pat_id
_1548.precerts_numberspnum_pat_id
_1548.procedures_resultspres_pat_id
_1548.radiology_order_notesradnot_pat_id
_1548.radiology_ordersrad_pat_id
_1548.radiology_orders_icd9_codesric_pat_id
_1548.radiology_orders_numbersradnum_pat_id
_1548.radiology_resultsrad_res_pat_id
_1548.radiology_results_test_codes_resultsrrtcres_pat_id
_1548.recall_listrcl_pat_id
_1548.requisition_numbersreq_pat_id
_1548.stripe_customers_accountssca_pat_id
_1548.structured_answerssra_pat_id
_1548.voided_paymentsvp_pat_id
_435.appointment_recurrencearec_pat_id
_435.appointmentsapt_pat_id
_435.appointments_requestsaptreq_pat_id
_435.auditsaud_pat_id
_435.audits_archiveaud_pat_id
_435.audits_archive_2008aud_pat_id
_435.audits_archive_2009aud_pat_id
_435.audits_archive_2010aud_pat_id
_435.audits_archive_2011aud_pat_id
_435.audits_archive_2012aud_pat_id
_435.audits_archive_2013aud_pat_id
_435.audits_archive_2014aud_pat_id
_435.audits_archive_2015aud_pat_id
_435.audits_archive_2016aud_pat_id
_435.audits_archive_2017aud_pat_id
_435.audits_archive_2018aud_pat_id
_435.audits_archive_2019aud_pat_id
_435.audits_archive_2020aud_pat_id
_435.audits_newaud_pat_id
_435.audits_new_archiveaud_pat_id
_435.audits_new_trialaud_pat_id
_435.card_connect_profilescconp_pat_id
_435.chartschrt_pat_id
_435.charts_care_planccp_pat_id
_435.charts_cpt_codeschcp_pat_id
_435.charts_diagnosiscdx_pat_id
_435.charts_icd9_codescic_pat_id
_435.charts_medicationscm_pat_id
_435.charts_numberscnum_pat_id
_435.charts_procedurescp_pat_id
_435.clinical_interventions_review_mapcirm_pat_id
_435.configured_encountersconfenc_pat_id
_435.cpoe_responsescpoe_res_pat_id
_435.cqm_entriescqme_pat_id
_435.cqm_errorscqmer_pat_id
_435.documentsdoc_pat_id
_435.encounter_soap_labels_values_groupseslvg_pat_id
_435.encountersenc_pat_id
_435.encountersenc_guarantor_linked_pat_id
_435.encountersenc_ins1_linked_pat_id
_435.encountersenc_ins2_linked_pat_id
_435.encountersenc_ins3_linked_pat_id
_435.encounters_cpt_codesecp_pat_id
_435.encounters_icd9_codeseic_pat_id
_435.encounters_numbersenum_pat_id
_435.encounters_patients_races_mapeprm_pat_id
_435.encounters_soap_labels_componentseslc_pat_id
_435.encounters_soap_labels_valueseslv_pat_id
_435.encounters_soap_labels_values_mapeslvm_pat_id
_435.encounters_soap_vitalsespv_pat_id
_435.encounters_stored_notes_patients_frequencyesnpf_pat_id
_435.encounters_ub04enc_ub04_pat_id
_435.erx_webservice_transactionsewt_pat_id
_435.fitbit_tokensft_pat_id
_435.hl7_accessionsacc_pat_id
_435.hl7_resultsres_pat_id
_435.insurances_repositoryirep_pat_id
_435.insurances_repositoryirep_linked_pat_id
_435.insurances_verificationiv_pat_id
_435.ledgerled_pat_id
_435.ordersord_pat_id
_435.orders_afpsoafp_pat_id
_435.orders_commentsorc_pat_id
_435.orders_icd9_codesoic_pat_id
_435.orders_papsopap_pat_id
_435.orders_paps_historyopaph_pat_id
_435.orders_standingost_pat_id
_435.orders_standing_datesosd_pat_id
_435.orders_test_codesotc_pat_id
_435.patient_access_restrictionpatar_pat_id
_435.patient_amendmentspa_pat_id
_435.patient_configured_encounterspce_pat_id
_435.patient_finance_recordspfr_pat_id
_435.patient_next_of_kinpnk_pat_id
_435.patient_portal_requestsppr_pat_id
_435.patientspat_merged_into_pat_id
_435.patientspat_guarantor_linked_pat_id
_435.patientspat_ins1_linked_pat_id
_435.patientspat_ins2_linked_pat_id
_435.patientspat_ins3_linked_pat_id
_435.patients_additional_providerspap_pat_id
_435.patients_allergiespalg_pat_id
_435.patients_authorization_numberspan_pat_id
_435.patients_classes_mappcm_pat_id
_435.patients_configured_encounters_schedulespces_pat_id
_435.patients_demographics_snapshotspds_pat_id
_435.patients_demographics_snapshotspds_guarantor_linked_pat_id
_435.patients_demographics_snapshotspds_ins1_linked_pat_id
_435.patients_demographics_snapshotspds_ins2_linked_pat_id
_435.patients_demographics_snapshotspds_ins3_linked_pat_id
_435.patients_document_assemblypda_pat_id
_435.patients_education_resultsperes_pat_id
_435.patients_enrollmentspert_pat_id
_435.patients_erx_updatespeu_pat_id
_435.patients_ethnicities_mappem_pat_id
_435.patients_handoutsphs_pat_id
_435.patients_health_concernsphc_pat_id
_435.patients_health_observationspho_pat_id
_435.patients_historiesph_pat_id
_435.patients_icd9_problemspip_pat_id
_435.patients_imagespi_pat_id
_435.patients_immunizationspim_pat_id
_435.patients_implantable_devicespid_pat_id
_435.patients_inventorypinv_pat_id
_435.patients_medicationspms_pat_id
_435.patients_namespn_pat_id
_435.patients_payment_methodspatpm_pat_id
_435.patients_payments_ledger_mappplm_pat_id
_435.patients_payments_schedulespps_pat_id
_435.patients_pidsppid_pat_id
_435.patients_prescriptionsprx_pat_id
_435.patients_races_mapprm_pat_id
_435.patients_referralspref_pat_id
_435.patients_relatives_mapprm_pat_id
_435.patients_reminderspr_pat_id
_435.patients_responsibility_estimatesprest_pat_id
_435.patients_smoking_statuspss_pat_id
_435.patients_social_answerspsa_pat_id
_435.patients_statements_mappstm_pat_id
_435.patients_stored_messagespsm_pat_id
_435.patients_taskspt_pat_id
_435.patients_urlspu_pat_id
_435.patients_vitalspvs_pat_id
_435.poapoa_pat_id
_435.portal_released_dataprd_pat_id
_435.portal_withheld_datapwd_pat_id
_435.precertspre_pat_id
_435.precerts_commentsprc_pat_id
_435.precerts_cpt_codespcp_pat_id
_435.precerts_icd9_codespic_pat_id
_435.precerts_numberspnum_pat_id
_435.procedures_resultspres_pat_id
_435.radiology_order_notesradnot_pat_id
_435.radiology_ordersrad_pat_id
_435.radiology_orders_icd9_codesric_pat_id
_435.radiology_orders_numbersradnum_pat_id
_435.radiology_resultsrad_res_pat_id
_435.radiology_results_test_codes_resultsrrtcres_pat_id
_435.recall_listrcl_pat_id
_435.requisition_numbersreq_pat_id
_435.structured_answerssra_pat_id
_435.voided_paymentsvp_pat_id
_436.appointment_recurrencearec_pat_id
_436.appointmentsapt_pat_id
_436.appointments_requestsaptreq_pat_id
_436.auditsaud_pat_id
_436.audits_archiveaud_pat_id
_436.audits_newaud_pat_id
_436.audits_new_archiveaud_pat_id
_436.card_connect_profilescconp_pat_id
_436.chartschrt_pat_id
_436.charts_care_planccp_pat_id
_436.charts_cpt_codeschcp_pat_id
_436.charts_diagnosiscdx_pat_id
_436.charts_icd9_codescic_pat_id
_436.charts_medicationscm_pat_id
_436.charts_numberscnum_pat_id
_436.charts_procedurescp_pat_id
_436.clinical_interventions_review_mapcirm_pat_id
_436.configured_encountersconfenc_pat_id
_436.cpoe_responsescpoe_res_pat_id
_436.cqm_entriescqme_pat_id
_436.cqm_errorscqmer_pat_id
_436.documentsdoc_pat_id
_436.encounter_soap_labels_values_groupseslvg_pat_id
_436.encountersenc_pat_id
_436.encountersenc_guarantor_linked_pat_id
_436.encountersenc_ins1_linked_pat_id
_436.encountersenc_ins2_linked_pat_id
_436.encountersenc_ins3_linked_pat_id
_436.encounters_cpt_codesecp_pat_id
_436.encounters_icd9_codeseic_pat_id
_436.encounters_numbersenum_pat_id
_436.encounters_patients_races_mapeprm_pat_id
_436.encounters_soap_labels_componentseslc_pat_id
_436.encounters_soap_labels_valueseslv_pat_id
_436.encounters_soap_labels_values_mapeslvm_pat_id
_436.encounters_soap_vitalsespv_pat_id
_436.encounters_stored_notes_patients_frequencyesnpf_pat_id
_436.encounters_ub04enc_ub04_pat_id
_436.erx_webservice_transactionsewt_pat_id
_436.fitbit_tokensft_pat_id
_436.hl7_accessionsacc_pat_id
_436.hl7_resultsres_pat_id
_436.insurances_repositoryirep_pat_id
_436.insurances_repositoryirep_linked_pat_id
_436.insurances_verificationiv_pat_id
_436.ledgerled_pat_id
_436.ordersord_pat_id
_436.orders_afpsoafp_pat_id
_436.orders_commentsorc_pat_id
_436.orders_icd9_codesoic_pat_id
_436.orders_papsopap_pat_id
_436.orders_paps_historyopaph_pat_id
_436.orders_standingost_pat_id
_436.orders_standing_datesosd_pat_id
_436.orders_test_codesotc_pat_id
_436.patient_access_restrictionpatar_pat_id
_436.patient_amendmentspa_pat_id
_436.patient_configured_encounterspce_pat_id
_436.patient_finance_recordspfr_pat_id
_436.patient_next_of_kinpnk_pat_id
_436.patient_portal_requestsppr_pat_id
_436.patientspat_merged_into_pat_id
_436.patientspat_guarantor_linked_pat_id
_436.patientspat_ins1_linked_pat_id
_436.patientspat_ins2_linked_pat_id
_436.patientspat_ins3_linked_pat_id
_436.patients_additional_providerspap_pat_id
_436.patients_allergiespalg_pat_id
_436.patients_authorization_numberspan_pat_id
_436.patients_classes_mappcm_pat_id
_436.patients_configured_encounters_schedulespces_pat_id
_436.patients_demographics_snapshotspds_pat_id
_436.patients_demographics_snapshotspds_guarantor_linked_pat_id
_436.patients_demographics_snapshotspds_ins1_linked_pat_id
_436.patients_demographics_snapshotspds_ins2_linked_pat_id
_436.patients_demographics_snapshotspds_ins3_linked_pat_id
_436.patients_document_assemblypda_pat_id
_436.patients_education_resultsperes_pat_id
_436.patients_enrollmentspert_pat_id
_436.patients_erx_updatespeu_pat_id
_436.patients_ethnicities_mappem_pat_id
_436.patients_handoutsphs_pat_id
_436.patients_health_concernsphc_pat_id
_436.patients_health_observationspho_pat_id
_436.patients_historiesph_pat_id
_436.patients_icd9_problemspip_pat_id
_436.patients_imagespi_pat_id
_436.patients_immunizationspim_pat_id
_436.patients_implantable_devicespid_pat_id
_436.patients_inventorypinv_pat_id
_436.patients_medicationspms_pat_id
_436.patients_namespn_pat_id
_436.patients_payment_methodspatpm_pat_id
_436.patients_payments_ledger_mappplm_pat_id
_436.patients_payments_schedulespps_pat_id
_436.patients_pidsppid_pat_id
_436.patients_prescriptionsprx_pat_id
_436.patients_races_mapprm_pat_id
_436.patients_referralspref_pat_id
_436.patients_relatives_mapprm_pat_id
_436.patients_reminderspr_pat_id
_436.patients_responsibility_estimatesprest_pat_id
_436.patients_smoking_statuspss_pat_id
_436.patients_social_answerspsa_pat_id
_436.patients_statements_mappstm_pat_id
_436.patients_stored_messagespsm_pat_id
_436.patients_taskspt_pat_id
_436.patients_urlspu_pat_id
_436.patients_vitalspvs_pat_id
_436.poapoa_pat_id
_436.portal_released_dataprd_pat_id
_436.portal_withheld_datapwd_pat_id
_436.precertspre_pat_id
_436.precerts_commentsprc_pat_id
_436.precerts_cpt_codespcp_pat_id
_436.precerts_icd9_codespic_pat_id
_436.precerts_numberspnum_pat_id
_436.procedures_resultspres_pat_id
_436.radiology_order_notesradnot_pat_id
_436.radiology_ordersrad_pat_id
_436.radiology_orders_icd9_codesric_pat_id
_436.radiology_orders_numbersradnum_pat_id
_436.radiology_resultsrad_res_pat_id
_436.radiology_results_test_codes_resultsrrtcres_pat_id
_436.recall_listrcl_pat_id
_436.requisition_numbersreq_pat_id
_436.structured_answerssra_pat_id
_436.voided_paymentsvp_pat_id
_436_archive_testing.appointment_recurrencearec_pat_id
_436_archive_testing.appointmentsapt_pat_id
_436_archive_testing.appointments_requestsaptreq_pat_id
_436_archive_testing.auditsaud_pat_id
_436_archive_testing.audits_archiveaud_pat_id
_436_archive_testing.audits_archive_2008aud_pat_id
_436_archive_testing.audits_archive_2009aud_pat_id
_436_archive_testing.audits_archive_2010aud_pat_id
_436_archive_testing.audits_archive_2011aud_pat_id
_436_archive_testing.audits_archive_2012aud_pat_id
_436_archive_testing.audits_archive_2013aud_pat_id
_436_archive_testing.audits_archive_2014aud_pat_id
_436_archive_testing.audits_archive_2015aud_pat_id
_436_archive_testing.audits_archive_2016aud_pat_id
_436_archive_testing.audits_archive_2017aud_pat_id
_436_archive_testing.audits_archive_2018aud_pat_id
_436_archive_testing.audits_archive_2019aud_pat_id
_436_archive_testing.audits_archive_2020aud_pat_id
_436_archive_testing.audits_archive_2021aud_pat_id
_436_archive_testing.audits_newaud_pat_id
_436_archive_testing.audits_new_archiveaud_pat_id
_436_archive_testing.card_connect_profilescconp_pat_id
_436_archive_testing.chartschrt_pat_id
_436_archive_testing.charts_care_planccp_pat_id
_436_archive_testing.charts_cpt_codeschcp_pat_id
_436_archive_testing.charts_diagnosiscdx_pat_id
_436_archive_testing.charts_icd9_codescic_pat_id
_436_archive_testing.charts_medicationscm_pat_id
_436_archive_testing.charts_numberscnum_pat_id
_436_archive_testing.charts_procedurescp_pat_id
_436_archive_testing.clinical_interventions_review_mapcirm_pat_id
_436_archive_testing.configured_encountersconfenc_pat_id
_436_archive_testing.cpoe_responsescpoe_res_pat_id
_436_archive_testing.cqm_entriescqme_pat_id
_436_archive_testing.cqm_errorscqmer_pat_id
_436_archive_testing.documentsdoc_pat_id
_436_archive_testing.encounter_soap_labels_values_groupseslvg_pat_id
_436_archive_testing.encountersenc_pat_id
_436_archive_testing.encountersenc_guarantor_linked_pat_id
_436_archive_testing.encountersenc_ins1_linked_pat_id
_436_archive_testing.encountersenc_ins2_linked_pat_id
_436_archive_testing.encountersenc_ins3_linked_pat_id
_436_archive_testing.encounters_cpt_codesecp_pat_id
_436_archive_testing.encounters_icd9_codeseic_pat_id
_436_archive_testing.encounters_numbersenum_pat_id
_436_archive_testing.encounters_patients_races_mapeprm_pat_id
_436_archive_testing.encounters_soap_labels_componentseslc_pat_id
_436_archive_testing.encounters_soap_labels_valueseslv_pat_id
_436_archive_testing.encounters_soap_labels_values_mapeslvm_pat_id
_436_archive_testing.encounters_soap_vitalsespv_pat_id
_436_archive_testing.encounters_stored_notes_patients_frequencyesnpf_pat_id
_436_archive_testing.encounters_ub04enc_ub04_pat_id
_436_archive_testing.erx_webservice_transactionsewt_pat_id
_436_archive_testing.fitbit_tokensft_pat_id
_436_archive_testing.hl7_accessionsacc_pat_id
_436_archive_testing.hl7_resultsres_pat_id
_436_archive_testing.insurances_repositoryirep_pat_id
_436_archive_testing.insurances_repositoryirep_linked_pat_id
_436_archive_testing.insurances_verificationiv_pat_id
_436_archive_testing.ledgerled_pat_id
_436_archive_testing.ordersord_pat_id
_436_archive_testing.orders_afpsoafp_pat_id
_436_archive_testing.orders_commentsorc_pat_id
_436_archive_testing.orders_icd9_codesoic_pat_id
_436_archive_testing.orders_papsopap_pat_id
_436_archive_testing.orders_paps_historyopaph_pat_id
_436_archive_testing.orders_standingost_pat_id
_436_archive_testing.orders_standing_datesosd_pat_id
_436_archive_testing.orders_test_codesotc_pat_id
_436_archive_testing.patient_access_restrictionpatar_pat_id
_436_archive_testing.patient_amendmentspa_pat_id
_436_archive_testing.patient_configured_encounterspce_pat_id
_436_archive_testing.patient_finance_recordspfr_pat_id
_436_archive_testing.patient_next_of_kinpnk_pat_id
_436_archive_testing.patient_portal_requestsppr_pat_id
_436_archive_testing.patientspat_merged_into_pat_id
_436_archive_testing.patientspat_guarantor_linked_pat_id
_436_archive_testing.patientspat_ins1_linked_pat_id
_436_archive_testing.patientspat_ins2_linked_pat_id
_436_archive_testing.patientspat_ins3_linked_pat_id
_436_archive_testing.patients_additional_providerspap_pat_id
_436_archive_testing.patients_allergiespalg_pat_id
_436_archive_testing.patients_authorization_numberspan_pat_id
_436_archive_testing.patients_classes_mappcm_pat_id
_436_archive_testing.patients_configured_encounters_schedulespces_pat_id
_436_archive_testing.patients_demographics_snapshotspds_pat_id
_436_archive_testing.patients_demographics_snapshotspds_guarantor_linked_pat_id
_436_archive_testing.patients_demographics_snapshotspds_ins1_linked_pat_id
_436_archive_testing.patients_demographics_snapshotspds_ins2_linked_pat_id
_436_archive_testing.patients_demographics_snapshotspds_ins3_linked_pat_id
_436_archive_testing.patients_document_assemblypda_pat_id
_436_archive_testing.patients_education_resultsperes_pat_id
_436_archive_testing.patients_enrollmentspert_pat_id
_436_archive_testing.patients_erx_updatespeu_pat_id
_436_archive_testing.patients_ethnicities_mappem_pat_id
_436_archive_testing.patients_handoutsphs_pat_id
_436_archive_testing.patients_health_concernsphc_pat_id
_436_archive_testing.patients_health_observationspho_pat_id
_436_archive_testing.patients_historiesph_pat_id
_436_archive_testing.patients_icd9_problemspip_pat_id
_436_archive_testing.patients_imagespi_pat_id
_436_archive_testing.patients_immunizationspim_pat_id
_436_archive_testing.patients_implantable_devicespid_pat_id
_436_archive_testing.patients_inventorypinv_pat_id
_436_archive_testing.patients_medicationspms_pat_id
_436_archive_testing.patients_payment_methodspatpm_pat_id
_436_archive_testing.patients_payments_ledger_mappplm_pat_id
_436_archive_testing.patients_payments_schedulespps_pat_id
_436_archive_testing.patients_pidsppid_pat_id
_436_archive_testing.patients_prescriptionsprx_pat_id
_436_archive_testing.patients_races_mapprm_pat_id
_436_archive_testing.patients_referralspref_pat_id
_436_archive_testing.patients_relatives_mapprm_pat_id
_436_archive_testing.patients_reminderspr_pat_id
_436_archive_testing.patients_responsibility_estimatesprest_pat_id
_436_archive_testing.patients_smoking_statuspss_pat_id
_436_archive_testing.patients_social_answerspsa_pat_id
_436_archive_testing.patients_statements_mappstm_pat_id
_436_archive_testing.patients_stored_messagespsm_pat_id
_436_archive_testing.patients_taskspt_pat_id
_436_archive_testing.patients_urlspu_pat_id
_436_archive_testing.patients_vitalspvs_pat_id
_436_archive_testing.poapoa_pat_id
_436_archive_testing.portal_released_dataprd_pat_id
_436_archive_testing.portal_withheld_datapwd_pat_id
_436_archive_testing.precertspre_pat_id
_436_archive_testing.precerts_commentsprc_pat_id
_436_archive_testing.precerts_cpt_codespcp_pat_id
_436_archive_testing.precerts_icd9_codespic_pat_id
_436_archive_testing.precerts_numberspnum_pat_id
_436_archive_testing.procedures_resultspres_pat_id
_436_archive_testing.radiology_order_notesradnot_pat_id
_436_archive_testing.radiology_ordersrad_pat_id
_436_archive_testing.radiology_orders_icd9_codesric_pat_id
_436_archive_testing.radiology_orders_numbersradnum_pat_id
_436_archive_testing.radiology_resultsrad_res_pat_id
_436_archive_testing.radiology_results_test_codes_resultsrrtcres_pat_id
_436_archive_testing.recall_listrcl_pat_id
_436_archive_testing.requisition_numbersreq_pat_id
_436_archive_testing.structured_answerssra_pat_id
_436_archive_testing.voided_paymentsvp_pat_id
_437.appointment_recurrencearec_pat_id
_437.appointmentsapt_pat_id
_437.appointments_requestsaptreq_pat_id
_437.auditsaud_pat_id
_437.audits_archiveaud_pat_id
_437.audits_newaud_pat_id
_437.audits_new_archiveaud_pat_id
_437.chartschrt_pat_id
_437.charts_care_planccp_pat_id
_437.charts_cpt_codeschcp_pat_id
_437.charts_diagnosiscdx_pat_id
_437.charts_icd9_codescic_pat_id
_437.charts_medicationscm_pat_id
_437.charts_numberscnum_pat_id
_437.charts_procedurescp_pat_id
_437.clinical_interventions_review_mapcirm_pat_id
_437.configured_encountersconfenc_pat_id
_437.cpoe_responsescpoe_res_pat_id
_437.cqm_entriescqme_pat_id
_437.cqm_errorscqmer_pat_id
_437.documentsdoc_pat_id
_437.encounter_soap_labels_values_groupseslvg_pat_id
_437.encountersenc_pat_id
_437.encountersenc_guarantor_linked_pat_id
_437.encountersenc_ins1_linked_pat_id
_437.encountersenc_ins2_linked_pat_id
_437.encountersenc_ins3_linked_pat_id
_437.encounters_cpt_codesecp_pat_id
_437.encounters_icd9_codeseic_pat_id
_437.encounters_numbersenum_pat_id
_437.encounters_patients_races_mapeprm_pat_id
_437.encounters_soap_labels_componentseslc_pat_id
_437.encounters_soap_labels_valueseslv_pat_id
_437.encounters_soap_labels_values_mapeslvm_pat_id
_437.encounters_soap_vitalsespv_pat_id
_437.encounters_stored_notes_patients_frequencyesnpf_pat_id
_437.encounters_ub04enc_ub04_pat_id
_437.erx_webservice_transactionsewt_pat_id
_437.fitbit_tokensft_pat_id
_437.hl7_accessionsacc_pat_id
_437.hl7_resultsres_pat_id
_437.insurances_repositoryirep_pat_id
_437.insurances_repositoryirep_linked_pat_id
_437.insurances_verificationiv_pat_id
_437.ledgerled_pat_id
_437.ordersord_pat_id
_437.orders_afpsoafp_pat_id
_437.orders_commentsorc_pat_id
_437.orders_icd9_codesoic_pat_id
_437.orders_papsopap_pat_id
_437.orders_paps_historyopaph_pat_id
_437.orders_standingost_pat_id
_437.orders_standing_datesosd_pat_id
_437.orders_test_codesotc_pat_id
_437.patient_access_restrictionpatar_pat_id
_437.patient_amendmentspa_pat_id
_437.patient_configured_encounterspce_pat_id
_437.patient_finance_recordspfr_pat_id
_437.patient_next_of_kinpnk_pat_id
_437.patient_portal_requestsppr_pat_id
_437.patientspat_merged_into_pat_id
_437.patientspat_guarantor_linked_pat_id
_437.patientspat_ins1_linked_pat_id
_437.patientspat_ins2_linked_pat_id
_437.patientspat_ins3_linked_pat_id
_437.patients_additional_providerspap_pat_id
_437.patients_allergiespalg_pat_id
_437.patients_authorization_numberspan_pat_id
_437.patients_classes_mappcm_pat_id
_437.patients_configured_encounters_schedulespces_pat_id
_437.patients_demographics_snapshotspds_pat_id
_437.patients_demographics_snapshotspds_guarantor_linked_pat_id
_437.patients_demographics_snapshotspds_ins1_linked_pat_id
_437.patients_demographics_snapshotspds_ins2_linked_pat_id
_437.patients_demographics_snapshotspds_ins3_linked_pat_id
_437.patients_document_assemblypda_pat_id
_437.patients_education_resultsperes_pat_id
_437.patients_enrollmentspert_pat_id
_437.patients_erx_updatespeu_pat_id
_437.patients_ethnicities_mappem_pat_id
_437.patients_handoutsphs_pat_id
_437.patients_health_concernsphc_pat_id
_437.patients_health_observationspho_pat_id
_437.patients_historiesph_pat_id
_437.patients_icd9_problemspip_pat_id
_437.patients_imagespi_pat_id
_437.patients_immunizationspim_pat_id
_437.patients_implantable_devicespid_pat_id
_437.patients_inventorypinv_pat_id
_437.patients_medicationspms_pat_id
_437.patients_namespn_pat_id
_437.patients_payment_methodspatpm_pat_id
_437.patients_payments_ledger_mappplm_pat_id
_437.patients_payments_schedulespps_pat_id
_437.patients_pidsppid_pat_id
_437.patients_prescriptionsprx_pat_id
_437.patients_races_mapprm_pat_id
_437.patients_referralspref_pat_id
_437.patients_relatives_mapprm_pat_id
_437.patients_reminderspr_pat_id
_437.patients_responsibility_estimatesprest_pat_id
_437.patients_smoking_statuspss_pat_id
_437.patients_social_answerspsa_pat_id
_437.patients_statements_mappstm_pat_id
_437.patients_stored_messagespsm_pat_id
_437.patients_taskspt_pat_id
_437.patients_urlspu_pat_id
_437.patients_vitalspvs_pat_id
_437.poapoa_pat_id
_437.portal_released_dataprd_pat_id
_437.portal_withheld_datapwd_pat_id
_437.precertspre_pat_id
_437.precerts_commentsprc_pat_id
_437.precerts_cpt_codespcp_pat_id
_437.precerts_icd9_codespic_pat_id
_437.precerts_numberspnum_pat_id
_437.procedures_resultspres_pat_id
_437.radiology_order_notesradnot_pat_id
_437.radiology_ordersrad_pat_id
_437.radiology_orders_icd9_codesric_pat_id
_437.radiology_orders_numbersradnum_pat_id
_437.radiology_resultsrad_res_pat_id
_437.radiology_results_test_codes_resultsrrtcres_pat_id
_437.recall_listrcl_pat_id
_437.requisition_numbersreq_pat_id
_437.structured_answerssra_pat_id
_437.voided_paymentsvp_pat_id
_8.appointment_recurrencearec_pat_id
_8.appointmentsapt_pat_id
_8.appointments_requestsaptreq_pat_id
_8.auditsaud_pat_id
_8.audits_archiveaud_pat_id
_8.audits_archive_2020aud_pat_id
_8.audits_newaud_pat_id
_8.audits_new_archiveaud_pat_id
_8.card_connect_profilescconp_pat_id
_8.chartschrt_pat_id
_8.charts_care_planccp_pat_id
_8.charts_cpt_codeschcp_pat_id
_8.charts_diagnosiscdx_pat_id
_8.charts_icd9_codescic_pat_id
_8.charts_medicationscm_pat_id
_8.charts_numberscnum_pat_id
_8.charts_procedurescp_pat_id
_8.clinical_interventions_review_mapcirm_pat_id
_8.configured_encountersconfenc_pat_id
_8.cpoe_responsescpoe_res_pat_id
_8.cqm_entriescqme_pat_id
_8.cqm_errorscqmer_pat_id
_8.daily_close_calculationsdcc_pat_id
_8.documentsdoc_pat_id
_8.encounter_soap_labels_values_groupseslvg_pat_id
_8.encountersenc_pat_id
_8.encountersenc_guarantor_linked_pat_id
_8.encountersenc_ins1_linked_pat_id
_8.encountersenc_ins2_linked_pat_id
_8.encountersenc_ins3_linked_pat_id
_8.encounters_cpt_codesecp_pat_id
_8.encounters_icd9_codeseic_pat_id
_8.encounters_numbersenum_pat_id
_8.encounters_patients_races_mapeprm_pat_id
_8.encounters_soap_labels_componentseslc_pat_id
_8.encounters_soap_labels_valueseslv_pat_id
_8.encounters_soap_labels_values_mapeslvm_pat_id
_8.encounters_soap_vitalsespv_pat_id
_8.encounters_stored_notes_patients_frequencyesnpf_pat_id
_8.encounters_ub04enc_ub04_pat_id
_8.erx_webservice_transactionsewt_pat_id
_8.hl7_accessionsacc_pat_id
_8.hl7_resultsres_pat_id
_8.insurances_repositoryirep_pat_id
_8.insurances_repositoryirep_linked_pat_id
_8.insurances_verificationiv_pat_id
_8.ledgerled_pat_id
_8.ordersord_pat_id
_8.orders_afpsoafp_pat_id
_8.orders_commentsorc_pat_id
_8.orders_icd9_codesoic_pat_id
_8.orders_papsopap_pat_id
_8.orders_paps_historyopaph_pat_id
_8.orders_standingost_pat_id
_8.orders_standing_datesosd_pat_id
_8.orders_test_codesotc_pat_id
_8.patient_access_restrictionpatar_pat_id
_8.patient_amendmentspa_pat_id
_8.patient_configured_encounterspce_pat_id
_8.patient_finance_recordspfr_pat_id
_8.patient_next_of_kinpnk_pat_id
_8.patient_portal_requestsppr_pat_id
_8.patientspat_merged_into_pat_id
_8.patientspat_guarantor_linked_pat_id
_8.patientspat_ins1_linked_pat_id
_8.patientspat_ins2_linked_pat_id
_8.patientspat_ins3_linked_pat_id
_8.patients_additional_providerspap_pat_id
_8.patients_allergiespalg_pat_id
_8.patients_authorization_numberspan_pat_id
_8.patients_classes_mappcm_pat_id
_8.patients_configured_encounters_schedulespces_pat_id
_8.patients_demographics_snapshotspds_pat_id
_8.patients_demographics_snapshotspds_guarantor_linked_pat_id
_8.patients_demographics_snapshotspds_ins1_linked_pat_id
_8.patients_demographics_snapshotspds_ins2_linked_pat_id
_8.patients_demographics_snapshotspds_ins3_linked_pat_id
_8.patients_document_assemblypda_pat_id
_8.patients_education_resultsperes_pat_id
_8.patients_enrollmentspert_pat_id
_8.patients_erx_updatespeu_pat_id
_8.patients_ethnicities_mappem_pat_id
_8.patients_handoutsphs_pat_id
_8.patients_health_concernsphc_pat_id
_8.patients_health_observationspho_pat_id
_8.patients_historiesph_pat_id
_8.patients_icd9_problemspip_pat_id
_8.patients_imagespi_pat_id
_8.patients_immunizationspim_pat_id
_8.patients_implantable_devicespid_pat_id
_8.patients_inventorypinv_pat_id
_8.patients_medicationspms_pat_id
_8.patients_namespn_pat_id
_8.patients_payment_methodspatpm_pat_id
_8.patients_payments_ledger_mappplm_pat_id
_8.patients_payments_schedulespps_pat_id
_8.patients_pidsppid_pat_id
_8.patients_prescriptionsprx_pat_id
_8.patients_races_mapprm_pat_id
_8.patients_referralspref_pat_id
_8.patients_relatives_mapprm_pat_id
_8.patients_reminderspr_pat_id
_8.patients_responsibility_estimatesprest_pat_id
_8.patients_smoking_statuspss_pat_id
_8.patients_social_answerspsa_pat_id
_8.patients_statements_mappstm_pat_id
_8.patients_stored_messagespsm_pat_id
_8.patients_taskspt_pat_id
_8.patients_urlspu_pat_id
_8.patients_vitalspvs_pat_id
_8.poapoa_pat_id
_8.portal_released_dataprd_pat_id
_8.portal_withheld_datapwd_pat_id
_8.precertspre_pat_id
_8.precerts_commentsprc_pat_id
_8.precerts_cpt_codespcp_pat_id
_8.precerts_icd9_codespic_pat_id
_8.precerts_numberspnum_pat_id
_8.procedures_resultspres_pat_id
_8.radiology_order_notesradnot_pat_id
_8.radiology_ordersrad_pat_id
_8.radiology_orders_icd9_codesric_pat_id
_8.radiology_orders_numbersradnum_pat_id
_8.radiology_resultsrad_res_pat_id
_8.radiology_results_test_codes_resultsrrtcres_pat_id
_8.recall_listrcl_pat_id
_8.requisition_numbersreq_pat_id
_8.stripe_customers_accountssca_pat_id
_8.structured_answerssra_pat_id
_8.voided_paymentsvp_pat_id
_81.appointment_recurrencearec_pat_id
_81.appointmentsapt_pat_id
_81.appointments_requestsaptreq_pat_id
_81.auditsaud_pat_id
_81.audits_archiveaud_pat_id
_81.audits_newaud_pat_id
_81.audits_new_archiveaud_pat_id
_81.card_connect_profilescconp_pat_id
_81.chartschrt_pat_id
_81.charts_care_planccp_pat_id
_81.charts_cpt_codeschcp_pat_id
_81.charts_diagnosiscdx_pat_id
_81.charts_icd9_codescic_pat_id
_81.charts_medicationscm_pat_id
_81.charts_numberscnum_pat_id
_81.charts_procedurescp_pat_id
_81.clinical_interventions_review_mapcirm_pat_id
_81.cpoe_responsescpoe_res_pat_id
_81.cqm_entriescqme_pat_id
_81.cqm_errorscqmer_pat_id
_81.documentsdoc_pat_id
_81.encountersenc_pat_id
_81.encountersenc_guarantor_linked_pat_id
_81.encountersenc_ins1_linked_pat_id
_81.encountersenc_ins2_linked_pat_id
_81.encountersenc_ins3_linked_pat_id
_81.encounters_cpt_codesecp_pat_id
_81.encounters_icd9_codeseic_pat_id
_81.encounters_numbersenum_pat_id
_81.encounters_patients_races_mapeprm_pat_id
_81.encounters_soap_labels_componentseslc_pat_id
_81.encounters_soap_labels_valueseslv_pat_id
_81.encounters_soap_vitalsespv_pat_id
_81.encounters_stored_notes_patients_frequencyesnpf_pat_id
_81.encounters_ub04enc_ub04_pat_id
_81.erx_webservice_transactionsewt_pat_id
_81.hl7_accessionsacc_pat_id
_81.hl7_resultsres_pat_id
_81.insurances_repositoryirep_pat_id
_81.insurances_repositoryirep_linked_pat_id
_81.insurances_verificationiv_pat_id
_81.ledgerled_pat_id
_81.ordersord_pat_id
_81.orders_afpsoafp_pat_id
_81.orders_commentsorc_pat_id
_81.orders_icd9_codesoic_pat_id
_81.orders_papsopap_pat_id
_81.orders_paps_historyopaph_pat_id
_81.orders_standingost_pat_id
_81.orders_standing_datesosd_pat_id
_81.orders_test_codesotc_pat_id
_81.patient_access_restrictionpatar_pat_id
_81.patient_amendmentspa_pat_id
_81.patient_configured_encounterspce_pat_id
_81.patient_finance_recordspfr_pat_id
_81.patient_next_of_kinpnk_pat_id
_81.patient_portal_requestsppr_pat_id
_81.patientspat_merged_into_pat_id
_81.patientspat_guarantor_linked_pat_id
_81.patientspat_ins1_linked_pat_id
_81.patientspat_ins2_linked_pat_id
_81.patientspat_ins3_linked_pat_id
_81.patients_additional_providerspap_pat_id
_81.patients_allergiespalg_pat_id
_81.patients_authorization_numberspan_pat_id
_81.patients_classes_mappcm_pat_id
_81.patients_configured_encounters_schedulespces_pat_id
_81.patients_demographics_snapshotspds_pat_id
_81.patients_demographics_snapshotspds_guarantor_linked_pat_id
_81.patients_demographics_snapshotspds_ins1_linked_pat_id
_81.patients_demographics_snapshotspds_ins2_linked_pat_id
_81.patients_demographics_snapshotspds_ins3_linked_pat_id
_81.patients_document_assemblypda_pat_id
_81.patients_education_resultsperes_pat_id
_81.patients_enrollmentspert_pat_id
_81.patients_erx_updatespeu_pat_id
_81.patients_ethnicities_mappem_pat_id
_81.patients_handoutsphs_pat_id
_81.patients_health_concernsphc_pat_id
_81.patients_health_observationspho_pat_id
_81.patients_historiesph_pat_id
_81.patients_icd9_problemspip_pat_id
_81.patients_imagespi_pat_id
_81.patients_immunizationspim_pat_id
_81.patients_implantable_devicespid_pat_id
_81.patients_inventorypinv_pat_id
_81.patients_medicationspms_pat_id
_81.patients_namespn_pat_id
_81.patients_payment_methodspatpm_pat_id
_81.patients_payments_ledger_mappplm_pat_id
_81.patients_payments_schedulespps_pat_id
_81.patients_pidsppid_pat_id
_81.patients_prescriptionsprx_pat_id
_81.patients_races_mapprm_pat_id
_81.patients_referralspref_pat_id
_81.patients_relatives_mapprm_pat_id
_81.patients_reminderspr_pat_id
_81.patients_responsibility_estimatesprest_pat_id
_81.patients_smoking_statuspss_pat_id
_81.patients_social_answerspsa_pat_id
_81.patients_statements_mappstm_pat_id
_81.patients_stored_messagespsm_pat_id
_81.patients_taskspt_pat_id
_81.patients_urlspu_pat_id
_81.patients_vitalspvs_pat_id
_81.poapoa_pat_id
_81.portal_released_dataprd_pat_id
_81.portal_withheld_datapwd_pat_id
_81.precertspre_pat_id
_81.precerts_commentsprc_pat_id
_81.precerts_cpt_codespcp_pat_id
_81.precerts_icd9_codespic_pat_id
_81.precerts_numberspnum_pat_id
_81.procedures_resultspres_pat_id
_81.radiology_order_notesradnot_pat_id
_81.radiology_ordersrad_pat_id
_81.radiology_orders_icd9_codesric_pat_id
_81.radiology_orders_numbersradnum_pat_id
_81.radiology_resultsrad_res_pat_id
_81.radiology_results_test_codes_resultsrrtcres_pat_id
_81.recall_listrcl_pat_id
_81.requisition_numbersreq_pat_id
_81.stripe_customers_accountssca_pat_id
_81.structured_answerssra_pat_id
_81.voided_paymentsvp_pat_id
_999.appointment_recurrencearec_pat_id
_999.appointmentsapt_pat_id
_999.appointments_requestsaptreq_pat_id
_999.auditsaud_pat_id
_999.audits_archiveaud_pat_id
_999.audits_newaud_pat_id
_999.audits_new_archiveaud_pat_id
_999.card_connect_profilescconp_pat_id
_999.chartschrt_pat_id
_999.charts_care_planccp_pat_id
_999.charts_cpt_codeschcp_pat_id
_999.charts_diagnosiscdx_pat_id
_999.charts_icd9_codescic_pat_id
_999.charts_medicationscm_pat_id
_999.charts_numberscnum_pat_id
_999.charts_procedurescp_pat_id
_999.clinical_interventions_review_mapcirm_pat_id
_999.configured_encountersconfenc_pat_id
_999.cpoe_responsescpoe_res_pat_id
_999.cqm_entriescqme_pat_id
_999.cqm_errorscqmer_pat_id
_999.documentsdoc_pat_id
_999.encounter_soap_labels_values_groupseslvg_pat_id
_999.encountersenc_pat_id
_999.encountersenc_guarantor_linked_pat_id
_999.encountersenc_ins1_linked_pat_id
_999.encountersenc_ins2_linked_pat_id
_999.encountersenc_ins3_linked_pat_id
_999.encounters_cpt_codesecp_pat_id
_999.encounters_icd9_codeseic_pat_id
_999.encounters_numbersenum_pat_id
_999.encounters_patients_races_mapeprm_pat_id
_999.encounters_soap_labels_componentseslc_pat_id
_999.encounters_soap_labels_valueseslv_pat_id
_999.encounters_soap_labels_values_mapeslvm_pat_id
_999.encounters_soap_vitalsespv_pat_id
_999.encounters_stored_notes_patients_frequencyesnpf_pat_id
_999.encounters_ub04enc_ub04_pat_id
_999.erx_webservice_transactionsewt_pat_id
_999.hl7_accessionsacc_pat_id
_999.hl7_resultsres_pat_id
_999.insurances_repositoryirep_pat_id
_999.insurances_repositoryirep_linked_pat_id
_999.insurances_verificationiv_pat_id
_999.ledgerled_pat_id
_999.ordersord_pat_id
_999.orders_afpsoafp_pat_id
_999.orders_commentsorc_pat_id
_999.orders_icd9_codesoic_pat_id
_999.orders_papsopap_pat_id
_999.orders_paps_historyopaph_pat_id
_999.orders_standingost_pat_id
_999.orders_standing_datesosd_pat_id
_999.orders_test_codesotc_pat_id
_999.patient_access_restrictionpatar_pat_id
_999.patient_amendmentspa_pat_id
_999.patient_configured_encounterspce_pat_id
_999.patient_finance_recordspfr_pat_id
_999.patient_next_of_kinpnk_pat_id
_999.patient_portal_requestsppr_pat_id
_999.patientspat_merged_into_pat_id
_999.patientspat_guarantor_linked_pat_id
_999.patientspat_ins1_linked_pat_id
_999.patientspat_ins2_linked_pat_id
_999.patientspat_ins3_linked_pat_id
_999.patients_additional_providerspap_pat_id
_999.patients_allergiespalg_pat_id
_999.patients_authorization_numberspan_pat_id
_999.patients_classes_mappcm_pat_id
_999.patients_configured_encounters_schedulespces_pat_id
_999.patients_demographics_snapshotspds_pat_id
_999.patients_demographics_snapshotspds_guarantor_linked_pat_id
_999.patients_demographics_snapshotspds_ins1_linked_pat_id
_999.patients_demographics_snapshotspds_ins2_linked_pat_id
_999.patients_demographics_snapshotspds_ins3_linked_pat_id
_999.patients_document_assemblypda_pat_id
_999.patients_education_resultsperes_pat_id
_999.patients_enrollmentspert_pat_id
_999.patients_erx_updatespeu_pat_id
_999.patients_ethnicities_mappem_pat_id
_999.patients_handoutsphs_pat_id
_999.patients_health_concernsphc_pat_id
_999.patients_health_observationspho_pat_id
_999.patients_historiesph_pat_id
_999.patients_icd9_problemspip_pat_id
_999.patients_imagespi_pat_id
_999.patients_immunizationspim_pat_id
_999.patients_implantable_devicespid_pat_id
_999.patients_inventorypinv_pat_id
_999.patients_medicationspms_pat_id
_999.patients_namespn_pat_id
_999.patients_payment_methodspatpm_pat_id
_999.patients_payments_ledger_mappplm_pat_id
_999.patients_payments_schedulespps_pat_id
_999.patients_pidsppid_pat_id
_999.patients_prescriptionsprx_pat_id
_999.patients_races_mapprm_pat_id
_999.patients_referralspref_pat_id
_999.patients_relatives_mapprm_pat_id
_999.patients_reminderspr_pat_id
_999.patients_responsibility_estimatesprest_pat_id
_999.patients_smoking_statuspss_pat_id
_999.patients_social_answerspsa_pat_id
_999.patients_statements_mappstm_pat_id
_999.patients_stored_messagespsm_pat_id
_999.patients_taskspt_pat_id
_999.patients_urlspu_pat_id
_999.patients_vitalspvs_pat_id
_999.poapoa_pat_id
_999.portal_released_dataprd_pat_id
_999.portal_withheld_datapwd_pat_id
_999.precertspre_pat_id
_999.precerts_commentsprc_pat_id
_999.precerts_cpt_codespcp_pat_id
_999.precerts_icd9_codespic_pat_id
_999.precerts_numberspnum_pat_id
_999.procedures_resultspres_pat_id
_999.radiology_order_notesradnot_pat_id
_999.radiology_ordersrad_pat_id
_999.radiology_orders_icd9_codesric_pat_id
_999.radiology_orders_numbersradnum_pat_id
_999.radiology_resultsrad_res_pat_id
_999.radiology_results_test_codes_resultsrrtcres_pat_id
_999.recall_listrcl_pat_id
_999.requisition_numbersreq_pat_id
_999.stripe_customers_accountssca_pat_id
_999.structured_answerssra_pat_id
_999.voided_paymentsvp_pat_id
aurora_standard.hl7pidalt_pat_id
aurora_standard.hl7pidadalt_pat_id
common.ahi_auditsaud_pat_id
common.users_portal_accessupa_pat_id
facility_id
TableColumn
HSPI_System.organization_linkschart_access_facility_id
ethnicity
TableColumn
_1.chartschrt_ethnicity
_1.clinical_interventionsci_ethnicity
_1.encountersenc_ethnicity
_1.patientspat_ethnicity
_1.patients_demographics_snapshotspds_ethnicity
_1188.chartschrt_ethnicity
_1188.clinical_interventionsci_ethnicity
_1188.encountersenc_ethnicity
_1188.patientspat_ethnicity
_1188.patients_demographics_snapshotspds_ethnicity
_1218.chartschrt_ethnicity
_1218.clinical_interventionsci_ethnicity
_1218.encountersenc_ethnicity
_1218.patientspat_ethnicity
_1218.patients_demographics_snapshotspds_ethnicity
_1548.chartschrt_ethnicity
_1548.clinical_interventionsci_ethnicity
_1548.encountersenc_ethnicity
_1548.patientspat_ethnicity
_1548.patients_demographics_snapshotspds_ethnicity
_435.chartschrt_ethnicity
_435.clinical_interventionsci_ethnicity
_435.encountersenc_ethnicity
_435.patientspat_ethnicity
_435.patients_demographics_snapshotspds_ethnicity
_436.chartschrt_ethnicity
_436.clinical_interventionsci_ethnicity
_436.encountersenc_ethnicity
_436.patientspat_ethnicity
_436.patients_demographics_snapshotspds_ethnicity
_436_archive_testing.chartschrt_ethnicity
_436_archive_testing.clinical_interventionsci_ethnicity
_436_archive_testing.encountersenc_ethnicity
_436_archive_testing.patientspat_ethnicity
_436_archive_testing.patients_demographics_snapshotspds_ethnicity
_437.chartschrt_ethnicity
_437.clinical_interventionsci_ethnicity
_437.encountersenc_ethnicity
_437.patientspat_ethnicity
_437.patients_demographics_snapshotspds_ethnicity
_8.chartschrt_ethnicity
_8.clinical_interventionsci_ethnicity
_8.encountersenc_ethnicity
_8.patientspat_ethnicity
_8.patients_demographics_snapshotspds_ethnicity
_81.chartschrt_ethnicity
_81.clinical_interventionsci_ethnicity
_81.encountersenc_ethnicity
_81.patientspat_ethnicity
_81.patients_demographics_snapshotspds_ethnicity
_999.chartschrt_ethnicity
_999.clinical_interventionsci_ethnicity
_999.encountersenc_ethnicity
_999.patientspat_ethnicity
_999.patients_demographics_snapshotspds_ethnicity
aurora_standard.chmlastrpat_ethnicity
aurora_standard.chmtxstrpat_ethnicity
pat_sex
TableColumn
_1.clinical_alertsca_pat_sex
_1.clinical_interventionsci_pat_sex
_1188.clinical_alertsca_pat_sex
_1188.clinical_interventionsci_pat_sex
_1218.clinical_alertsca_pat_sex
_1218.clinical_interventionsci_pat_sex
_1548.clinical_alertsca_pat_sex
_1548.clinical_interventionsci_pat_sex
_435.clinical_alertsca_pat_sex
_435.clinical_interventionsci_pat_sex
_436.clinical_alertsca_pat_sex
_436.clinical_interventionsci_pat_sex
_436_archive_testing.clinical_alertsca_pat_sex
_436_archive_testing.clinical_interventionsci_pat_sex
_437.clinical_alertsca_pat_sex
_437.clinical_interventionsci_pat_sex
_8.clinical_alertsca_pat_sex
_8.clinical_interventionsci_pat_sex
_81.clinical_alertsca_pat_sex
_81.clinical_interventionsci_pat_sex
_999.clinical_alertsca_pat_sex
_999.clinical_interventionsci_pat_sex
mr_no
TableColumn
aurora_standard.bsinsursnf_mr_no
aurora_standard.bsinsurprev_mr_no
aurora_standard.chhcntrcauto_snf_mr_no
aurora_standard.chhcntrcauto_mr_no
aurora_standard.chmarbexpat_mr_no
aurora_standard.chmarsipat_mr_no
aurora_standard.chmbatexpat_mr_no
aurora_standard.chmcampipat_mr_no
aurora_standard.chmcntrcauto_snf_mr_no
aurora_standard.chmcntrcauto_mr_no
aurora_standard.chmexmpipat_mr_no
aurora_standard.chmhstmrpat_mr_no
aurora_standard.chmhstrmpat_mr_no
aurora_standard.chmlastrmother_mr_no
aurora_standard.chmmrhdrupd_mr_no
aurora_standard.chmnrcexpat_mr_no
aurora_standard.chmokipdpat_mr_no
aurora_standard.chmokopdpat_mr_no
aurora_standard.chmpatmrsnf_mr_no
aurora_standard.chmpatmrprev_mr_no
aurora_standard.chmradedpat_mr_no
aurora_standard.chmradexpat_mr_no
aurora_standard.chmreqsrofc_mr_no
aurora_standard.ncexmpipat_mr_no
filler
TableColumn
aurora_standard.chlmdssds_filler
aurora_standard.chlswbddcnt_filler
aurora_standard.chltrnsdcnt_filler
aurora_standard.chltrnsds_filler
aurora_standard.chmhaapypy_filler
aurora_standard.drg_workw_filler
aurora_standard.workdescw_filler
dischg_dt
TableColumn
aurora_standard.chmmhatrbegin_dischg_dt
aurora_standard.chmmhatrend_dischg_dt
proc01
TableColumn
aurora_standard.chmutah7cpt_proc01
aurora_standard.chmutahacpt_proc01
aurora_standard.chmutahaicd9_proc01
proc02
TableColumn
aurora_standard.chmutah7cpt_proc02
aurora_standard.chmutahacpt_proc02
aurora_standard.chmutahaicd9_proc02
proc03
TableColumn
aurora_standard.chmutah7cpt_proc03
aurora_standard.chmutahacpt_proc03
aurora_standard.chmutahaicd9_proc03
proc04
TableColumn
aurora_standard.chmutah7cpt_proc04
aurora_standard.chmutahacpt_proc04
aurora_standard.chmutahaicd9_proc04
proc05
TableColumn
aurora_standard.chmutah7cpt_proc05
aurora_standard.chmutahacpt_proc05
aurora_standard.chmutahaicd9_proc05