aurora_standard.chm835pd

Field Type Null Default Key Extra Comment
batch_id char(10) NO MUL
batch_complete varchar(1) YES
remit_date date NO
control_no char(10) NO
item_err_msg char(60) YES
visit_no int(11) NO MUL
bill_id char(3) YES
seq_no int(11) YES
priority varchar(1) YES
ins_co_payer smallint(6) YES
claim_status char(3) YES
billed_amt decimal(16,2) YES
payment_amt decimal(16,2) YES
contract_adj decimal(16,2) YES
pat_resp decimal(16,2) YES
bill_typ char(3) YES
drg_no smallint(6) YES
deductible decimal(16,2) YES
coinsurance decimal(16,2) YES
co_pay decimal(16,2) YES
non_cov_amt decimal(16,2) YES
non_cov_days smallint(6) YES
last_nm char(30) YES
first_nm char(20) YES
mid_nm char(20) YES
pat_id_qual char(6) YES
pat_id char(30) YES
xover_to char(30) YES
drg_amt decimal(16,2) YES
cov_days smallint(6) YES
payer_received_dt date YES
claim_filing_ind varchar(6) YES
allowed_amt decimal(16,2) YES
denied_amt decimal(16,2) YES
pps_outlier_amt decimal(16,2) YES
msp_pass_thru decimal(16,2) YES
remark_1 varchar(10) YES
remark_2 varchar(10) YES
remark_3 varchar(10) YES
remark_4 varchar(10) YES
remark_5 varchar(10) YES
adj_reason_1 varchar(10) YES
adj_reason_2 varchar(10) YES
adj_reason_3 varchar(10) YES
adj_reason_4 varchar(10) YES
adj_reason_5 varchar(10) YES
adj_reason_6 varchar(10) YES
chs_rowID bigint(255) NO PRI auto_increment

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
priority
TableColumn
AzaleaStats.jirajira_priority
Icd.icd10_snomed_mapi10snom_map_priority
Messaging.messages_accessmxs_priority
_1.charts_care_planccp_priority
_1.charts_medicationscm_priority
_1.claims_rulescr_priority
_1.patients_referralspref_priority
_1.roomsrms_priority
_1.taskstask_priority
_1188.charts_care_planccp_priority
_1188.charts_medicationscm_priority
_1188.claims_rulescr_priority
_1188.encounters_classesec_priority
_1188.patients_referralspref_priority
_1188.roomsrms_priority
_1188.taskstask_priority
_1218.charts_care_planccp_priority
_1218.charts_medicationscm_priority
_1218.claims_rulescr_priority
_1218.encounters_classesec_priority
_1218.patients_referralspref_priority
_1218.roomsrms_priority
_1218.taskstask_priority
_1548.charts_care_planccp_priority
_1548.charts_medicationscm_priority
_1548.claims_rulescr_priority
_1548.patients_referralspref_priority
_1548.roomsrms_priority
_1548.taskstask_priority
_435.charts_care_planccp_priority
_435.charts_medicationscm_priority
_435.claims_rulescr_priority
_435.encounters_classesec_priority
_435.patients_referralspref_priority
_435.roomsrms_priority
_435.taskstask_priority
_436.charts_care_planccp_priority
_436.charts_medicationscm_priority
_436.claims_rulescr_priority
_436.encounters_classesec_priority
_436.patients_referralspref_priority
_436.roomsrms_priority
_436.taskstask_priority
_436_archive_testing.charts_care_planccp_priority
_436_archive_testing.charts_medicationscm_priority
_436_archive_testing.claims_rulescr_priority
_436_archive_testing.encounters_classesec_priority
_436_archive_testing.patients_referralspref_priority
_436_archive_testing.roomsrms_priority
_436_archive_testing.taskstask_priority
_437.charts_care_planccp_priority
_437.charts_medicationscm_priority
_437.claims_rulescr_priority
_437.encounters_classesec_priority
_437.patients_referralspref_priority
_437.roomsrms_priority
_437.taskstask_priority
_8.charts_care_planccp_priority
_8.charts_medicationscm_priority
_8.claims_rulescr_priority
_8.encounters_classesec_priority
_8.patients_referralspref_priority
_8.roomsrms_priority
_8.taskstask_priority
_81.charts_care_planccp_priority
_81.charts_medicationscm_priority
_81.claims_rulescr_priority
_81.encounters_classesec_priority
_81.patients_referralspref_priority
_81.roomsrms_priority
_81.taskstask_priority
_999.charts_care_planccp_priority
_999.charts_medicationscm_priority
_999.claims_rulescr_priority
_999.encounters_classesec_priority
_999.patients_referralspref_priority
_999.roomsrms_priority
_999.taskstask_priority
aurora_standard.chhl7in1coord_ben_priority
aurora_standard.chmlevlcdisplay_priority
aurora_standard.hl7gt1guar_priority
aurora_standard.hl7gt1adguar_priority
aurora_standard.hl7in1coord_ben_priority
aurora_standard.hl7in1adcoord_ben_priority
common.dev_requestsdev_priority
common.service_ticketsstc_priority
common.test_codes_aoetcaoe_priority
xlnt.jira_issuesjira_priority
batch_id
TableColumn
HSPI_Bastrop.chargescharge_batch_id
HSPI_Bastrop.claim_itemsclaim_batch_id
HSPI_Bastrop.claimsclaim_batch_id
HSPI_Bastrop.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Bastrop.invoicesinvoice_batch_id
HSPI_Bastrop.transactionstransaction_batch_id
HSPI_CURES2015_B1.chargescharge_batch_id
HSPI_CURES2015_B1.claim_itemsclaim_batch_id
HSPI_CURES2015_B1.claimsclaim_batch_id
HSPI_CURES2015_B1.claims_claim_batches_mapclaim_batch_id
HSPI_CURES2015_B1.fa_transaction_wrapperstransaction_batch_id
HSPI_CURES2015_B1.invoice_batches_facilities_mapinvoice_batch_id
HSPI_CURES2015_B1.invoicesinvoice_batch_id
HSPI_CURES2015_B1.transaction_batch_financial_accountstransaction_batch_id
HSPI_CURES2015_B1.transactionstransaction_batch_id
HSPI_Central_Hospital.chargescharge_batch_id
HSPI_Central_Hospital.claim_filesclaim_batch_id
HSPI_Central_Hospital.claim_itemsclaim_batch_id
HSPI_Central_Hospital.claimsclaim_batch_id
HSPI_Central_Hospital.claims_claim_batches_mapclaim_batch_id
HSPI_Central_Hospital.fa_transaction_wrapperstransaction_batch_id
HSPI_Central_Hospital.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Central_Hospital.invoicesinvoice_batch_id
HSPI_Central_Hospital.transaction_batch_financial_accountstransaction_batch_id
HSPI_Central_Hospital.transactionstransaction_batch_id
HSPI_Dewitt.chargescharge_batch_id
HSPI_Dewitt.claim_filesclaim_batch_id
HSPI_Dewitt.claim_itemsclaim_batch_id
HSPI_Dewitt.claimsclaim_batch_id
HSPI_Dewitt.claims_claim_batches_mapclaim_batch_id
HSPI_Dewitt.fa_transaction_wrapperstransaction_batch_id
HSPI_Dewitt.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Dewitt.invoicesinvoice_batch_id
HSPI_Dewitt.transaction_batch_financial_accountstransaction_batch_id
HSPI_Dewitt.transactionstransaction_batch_id
HSPI_Fulton.chargescharge_batch_id
HSPI_Fulton.claim_filesclaim_batch_id
HSPI_Fulton.claim_itemsclaim_batch_id
HSPI_Fulton.claimsclaim_batch_id
HSPI_Fulton.claims_claim_batches_mapclaim_batch_id
HSPI_Fulton.fa_transaction_wrapperstransaction_batch_id
HSPI_Fulton.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Fulton.invoicesinvoice_batch_id
HSPI_Fulton.transaction_batch_financial_accountstransaction_batch_id
HSPI_Fulton.transactionstransaction_batch_id
HSPI_Inferno.chargescharge_batch_id
HSPI_Inferno.claim_filesclaim_batch_id
HSPI_Inferno.claim_itemsclaim_batch_id
HSPI_Inferno.claimsclaim_batch_id
HSPI_Inferno.claims_claim_batches_mapclaim_batch_id
HSPI_Inferno.fa_transaction_wrapperstransaction_batch_id
HSPI_Inferno.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Inferno.invoicesinvoice_batch_id
HSPI_Inferno.transaction_batch_financial_accountstransaction_batch_id
HSPI_Inferno.transactionstransaction_batch_id
HSPI_MU2015_E1.chargescharge_batch_id
HSPI_MU2015_E1.claim_filesclaim_batch_id
HSPI_MU2015_E1.claim_itemsclaim_batch_id
HSPI_MU2015_E1.claimsclaim_batch_id
HSPI_MU2015_E1.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_E1.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_E1.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_E1.invoicesinvoice_batch_id
HSPI_MU2015_E1.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_E1.transactionstransaction_batch_id
HSPI_MU2015_G2.chargescharge_batch_id
HSPI_MU2015_G2.claim_filesclaim_batch_id
HSPI_MU2015_G2.claim_itemsclaim_batch_id
HSPI_MU2015_G2.claimsclaim_batch_id
HSPI_MU2015_G2.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_G2.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_G2.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_G2.invoicesinvoice_batch_id
HSPI_MU2015_G2.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_G2.transactionstransaction_batch_id
HSPI_MU2015_G9.chargescharge_batch_id
HSPI_MU2015_G9.claim_filesclaim_batch_id
HSPI_MU2015_G9.claim_itemsclaim_batch_id
HSPI_MU2015_G9.claimsclaim_batch_id
HSPI_MU2015_G9.claims_claim_batches_mapclaim_batch_id
HSPI_MU2015_G9.fa_transaction_wrapperstransaction_batch_id
HSPI_MU2015_G9.invoice_batches_facilities_mapinvoice_batch_id
HSPI_MU2015_G9.invoicesinvoice_batch_id
HSPI_MU2015_G9.transaction_batch_financial_accountstransaction_batch_id
HSPI_MU2015_G9.transactionstransaction_batch_id
HSPI_Sandbox.chargescharge_batch_id
HSPI_Sandbox.claim_filesclaim_batch_id
HSPI_Sandbox.claim_itemsclaim_batch_id
HSPI_Sandbox.claimsclaim_batch_id
HSPI_Sandbox.claims_claim_batches_mapclaim_batch_id
HSPI_Sandbox.fa_transaction_wrapperstransaction_batch_id
HSPI_Sandbox.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Sandbox.invoicesinvoice_batch_id
HSPI_Sandbox.transaction_batch_financial_accountstransaction_batch_id
HSPI_Sandbox.transactionstransaction_batch_id
HSPI_Summit_General.chargescharge_batch_id
HSPI_Summit_General.claim_filesclaim_batch_id
HSPI_Summit_General.claim_itemsclaim_batch_id
HSPI_Summit_General.claimsclaim_batch_id
HSPI_Summit_General.claims_claim_batches_mapclaim_batch_id
HSPI_Summit_General.fa_transaction_wrapperstransaction_batch_id
HSPI_Summit_General.invoice_batches_facilities_mapinvoice_batch_id
HSPI_Summit_General.invoicesinvoice_batch_id
HSPI_Summit_General.transaction_batch_financial_accountstransaction_batch_id
HSPI_Summit_General.transactionstransaction_batch_id
HSPI_United_Physicians.chargescharge_batch_id
HSPI_United_Physicians.claim_filesclaim_batch_id
HSPI_United_Physicians.claim_itemsclaim_batch_id
HSPI_United_Physicians.claimsclaim_batch_id
HSPI_United_Physicians.claims_claim_batches_mapclaim_batch_id
HSPI_United_Physicians.fa_transaction_wrapperstransaction_batch_id
HSPI_United_Physicians.invoice_batches_facilities_mapinvoice_batch_id
HSPI_United_Physicians.invoicesinvoice_batch_id
HSPI_United_Physicians.transaction_batch_financial_accountstransaction_batch_id
HSPI_United_Physicians.transactionstransaction_batch_id
MPI.chargescharge_batch_id
MPI.claim_filesclaim_batch_id
MPI.claim_itemsclaim_batch_id
MPI.claimsclaim_batch_id
MPI.claims_claim_batches_mapclaim_batch_id
MPI.fa_transaction_wrapperstransaction_batch_id
MPI.invoice_batches_facilities_mapinvoice_batch_id
MPI.invoicesinvoice_batch_id
MPI.transaction_batch_financial_accountstransaction_batch_id
MPI.transactionstransaction_batch_id
aurora_standard.hl7ft1trans_batch_id
xlnt.selenium_test_queueselenium_test_batch_id
deductible
TableColumn
_1.patients_responsibility_estimatesprest_deductible
_1.patients_responsibility_estimates_servicesprests_deductible
_1188.patients_responsibility_estimatesprest_deductible
_1188.patients_responsibility_estimates_servicesprests_deductible
_1218.patients_responsibility_estimatesprest_deductible
_1218.patients_responsibility_estimates_servicesprests_deductible
_1548.patients_responsibility_estimatesprest_deductible
_1548.patients_responsibility_estimates_servicesprests_deductible
_435.patients_responsibility_estimatesprest_deductible
_435.patients_responsibility_estimates_servicesprests_deductible
_436.patients_responsibility_estimatesprest_deductible
_436.patients_responsibility_estimates_servicesprests_deductible
_436_archive_testing.patients_responsibility_estimatesprest_deductible
_436_archive_testing.patients_responsibility_estimates_servicesprests_deductible
_437.patients_responsibility_estimatesprest_deductible
_437.patients_responsibility_estimates_servicesprests_deductible
_8.patients_responsibility_estimatesprest_deductible
_8.patients_responsibility_estimates_servicesprests_deductible
_81.patients_responsibility_estimatesprest_deductible
_81.patients_responsibility_estimates_servicesprests_deductible
_999.patients_responsibility_estimatesprest_deductible
_999.patients_responsibility_estimates_servicesprests_deductible
aurora_standard.chminsrddef_deductible
aurora_standard.chpinsucdep_deductible
aurora_standard.hl7in2daily_deductible
co_pay
TableColumn
_1.patients_responsibility_estimatesprest_co_pay
_1.patients_responsibility_estimates_servicesprests_co_pay
_1188.patients_responsibility_estimatesprest_co_pay
_1188.patients_responsibility_estimates_servicesprests_co_pay
_1218.patients_responsibility_estimatesprest_co_pay
_1218.patients_responsibility_estimates_servicesprests_co_pay
_1548.patients_responsibility_estimatesprest_co_pay
_1548.patients_responsibility_estimates_servicesprests_co_pay
_435.patients_responsibility_estimatesprest_co_pay
_435.patients_responsibility_estimates_servicesprests_co_pay
_436.patients_responsibility_estimatesprest_co_pay
_436.patients_responsibility_estimates_servicesprests_co_pay
_436_archive_testing.patients_responsibility_estimatesprest_co_pay
_436_archive_testing.patients_responsibility_estimates_servicesprests_co_pay
_437.patients_responsibility_estimatesprest_co_pay
_437.patients_responsibility_estimates_servicesprests_co_pay
_8.patients_responsibility_estimatesprest_co_pay
_8.patients_responsibility_estimates_servicesprests_co_pay
_81.patients_responsibility_estimatesprest_co_pay
_81.patients_responsibility_estimates_servicesprests_co_pay
_999.patients_responsibility_estimatesprest_co_pay
_999.patients_responsibility_estimates_servicesprests_co_pay
aurora_standard.chminsrddef_co_pay
pat_resp
TableColumn
_1.patients_responsibility_estimatesprest_est_pat_resp
_1.patients_responsibility_estimates_servicesprests_est_pat_resp
_1188.patients_responsibility_estimatesprest_est_pat_resp
_1188.patients_responsibility_estimates_servicesprests_est_pat_resp
_1218.patients_responsibility_estimatesprest_est_pat_resp
_1218.patients_responsibility_estimates_servicesprests_est_pat_resp
_1548.patients_responsibility_estimatesprest_est_pat_resp
_1548.patients_responsibility_estimates_servicesprests_est_pat_resp
_435.patients_responsibility_estimatesprest_est_pat_resp
_435.patients_responsibility_estimates_servicesprests_est_pat_resp
_436.patients_responsibility_estimatesprest_est_pat_resp
_436.patients_responsibility_estimates_servicesprests_est_pat_resp
_436_archive_testing.patients_responsibility_estimatesprest_est_pat_resp
_436_archive_testing.patients_responsibility_estimates_servicesprests_est_pat_resp
_437.patients_responsibility_estimatesprest_est_pat_resp
_437.patients_responsibility_estimates_servicesprests_est_pat_resp
_8.patients_responsibility_estimatesprest_est_pat_resp
_8.patients_responsibility_estimates_servicesprests_est_pat_resp
_81.patients_responsibility_estimatesprest_est_pat_resp
_81.patients_responsibility_estimates_servicesprests_est_pat_resp
_999.patients_responsibility_estimatesprest_est_pat_resp
_999.patients_responsibility_estimates_servicesprests_est_pat_resp
visit_no
TableColumn
aurora_standard.anotesdan_visit_no
aurora_standard.bdfiledbd_visit_no
aurora_standard.chmarsipat_visit_no
aurora_standard.chmcampipat_visit_no
aurora_standard.chmcombrto_visit_no
aurora_standard.chmexmpipat_visit_no
aurora_standard.chmokipdpat_visit_no
aurora_standard.chmokopdpat_visit_no
aurora_standard.chmradedpat_visit_no
aurora_standard.chmradexpat_visit_no
aurora_standard.chrcombrto_visit_no
aurora_standard.ncexmpipat_visit_no
seq_no
TableColumn
aurora_standard.chmarstarec_seq_no
aurora_standard.chmarstacrec_seq_no
aurora_standard.chmarstairec_seq_no
aurora_standard.chmarstdrec_seq_no
aurora_standard.chmarstdirec_seq_no
aurora_standard.chmarsterec_seq_no
aurora_standard.chmarsthrec_seq_no
aurora_standard.chmarsthirec_seq_no
aurora_standard.chmarstphrec_seq_no
aurora_standard.chmarstpirec_seq_no
aurora_standard.chmarstporec_seq_no
aurora_standard.chmarstpqrec_seq_no
aurora_standard.chmarstprrec_seq_no
aurora_standard.chmarstpsrec_seq_no
aurora_standard.chmarstptrec_seq_no
aurora_standard.chmarstpyrec_seq_no
aurora_standard.chmcostarec_seq_no
aurora_standard.chmcostbrec_seq_no
aurora_standard.chmcostdrec_seq_no
aurora_standard.chmcostrcrec_seq_no
aurora_standard.chmgltcda_seq_no
aurora_standard.chmgltcdb_seq_no
aurora_standard.chmhid4arec_seq_no
aurora_standard.chmhid4brec_seq_no
aurora_standard.chmhid4crec_seq_no
aurora_standard.chmhid4drec_seq_no
aurora_standard.chmhid4grec_seq_no
aurora_standard.chrhhdcclisting_seq_no
aurora_standard.chrhhmprlisting_seq_no
aurora_standard.chrhhndclisting_seq_no
aurora_standard.chrhhndcfirm_seq_no
aurora_standard.chrhhroclisting_seq_no
aurora_standard.chrmndclisting_seq_no
aurora_standard.chrmndcfirm_seq_no
aurora_standard.chxhistdh_seq_no
aurora_standard.chyhistdh_seq_no
aurora_standard.drugclaslisting_seq_no
aurora_standard.formulatlisting_seq_no
aurora_standard.listingslisting_seq_no
aurora_standard.listingsfirm_seq_no
aurora_standard.packagelisting_seq_no
aurora_standard.routeslisting_seq_no
cov_days
TableColumn
aurora_standard.chmblogdnon_cov_days
aurora_standard.chmbremdnon_cov_days
aurora_standard.chmplogdnon_cov_days
aurora_standard.logdetldnon_cov_days
first_nm
TableColumn
aurora_standard.chmmhastpat_first_nm
aurora_standard.chmpatirinsured_first_nm
aurora_standard.chmpyr1vinsured_first_nm
last_nm
TableColumn
aurora_standard.chmmhastpat_last_nm