aurora_standard.schapptnoted

Field Type Null Default Key Extra Comment
note_id int(11) NO MUL
note_seq int(11) NO
note varchar(255) NO

References

Local Column References
note
TableColumn
Azalea.auditsaud_note
Azalea.timesheetsts_note
_1.appointmentsapt_note
_1.auditsaud_note
_1.audits_archiveaud_note
_1.audits_newaud_note
_1.audits_new_archiveaud_note
_1.charts_cpt_codeschcp_note
_1.configured_encounters_templates_cpt_codescetcc_note
_1.cpoe_responsescpoe_res_internal_note
_1.encounters_claims_statusesecs_note
_1.encounters_cpt_codesecp_note
_1.encounters_cpt_codes_templatesecpt_note
_1.encounters_paymentsepay_note
_1.erx_notification_countserx_not_note
_1.hl7_accessionsacc_internal_note
_1.insurancesins_note
_1.insurances_newins_note
_1.insurances_repositoryirep_note
_1.ledgerled_note
_1.notesnot_note
_1.patients_authorization_numberspan_note
_1.patients_icd9_problemspip_note
_1.patients_smoking_statuspss_note
_1.physiciansphy_note
_1.printable_signaturespsig_signature_note
_1.procedures_resultspres_note
_1.radiology_order_notesradnot_is_pat_note
_1.radiology_ordersrad_note
_1.radiology_resultsrad_res_internal_note
_1.recall_listrcl_note
_1.recall_list_templatesrclt_note
_1.slotsslts_note
_1.voided_paymentsvp_note
_1188.appointmentsapt_note
_1188.auditsaud_note
_1188.audits_archiveaud_note
_1188.audits_newaud_note
_1188.audits_new_archiveaud_note
_1188.charts_cpt_codeschcp_note
_1188.configured_encounters_templates_cpt_codescetcc_note
_1188.cpoe_responsescpoe_res_internal_note
_1188.encounters_claims_statusesecs_note
_1188.encounters_cpt_codesecp_note
_1188.encounters_cpt_codes_templatesecpt_note
_1188.encounters_paymentsepay_note
_1188.erx_notification_countserx_not_note
_1188.hl7_accessionsacc_internal_note
_1188.insurancesins_note
_1188.insurances_newins_note
_1188.insurances_repositoryirep_note
_1188.ledgerled_note
_1188.notesnot_note
_1188.patients_authorization_numberspan_note
_1188.patients_icd9_problemspip_note
_1188.patients_smoking_statuspss_note
_1188.physiciansphy_note
_1188.printable_signaturespsig_signature_note
_1188.procedures_resultspres_note
_1188.radiology_order_notesradnot_is_pat_note
_1188.radiology_ordersrad_note
_1188.radiology_resultsrad_res_internal_note
_1188.recall_listrcl_note
_1188.recall_list_templatesrclt_note
_1188.slotsslts_note
_1188.voided_paymentsvp_note
_1218.appointmentsapt_note
_1218.auditsaud_note
_1218.audits_archiveaud_note
_1218.audits_newaud_note
_1218.audits_new_archiveaud_note
_1218.charts_cpt_codeschcp_note
_1218.configured_encounters_templates_cpt_codescetcc_note
_1218.cpoe_responsescpoe_res_internal_note
_1218.encounters_claims_statusesecs_note
_1218.encounters_cpt_codesecp_note
_1218.encounters_cpt_codes_templatesecpt_note
_1218.encounters_paymentsepay_note
_1218.erx_notification_countserx_not_note
_1218.hl7_accessionsacc_internal_note
_1218.insurancesins_note
_1218.insurances_newins_note
_1218.insurances_repositoryirep_note
_1218.ledgerled_note
_1218.notesnot_note
_1218.patients_authorization_numberspan_note
_1218.patients_icd9_problemspip_note
_1218.patients_smoking_statuspss_note
_1218.physiciansphy_note
_1218.printable_signaturespsig_signature_note
_1218.procedures_resultspres_note
_1218.radiology_order_notesradnot_is_pat_note
_1218.radiology_ordersrad_note
_1218.radiology_resultsrad_res_internal_note
_1218.recall_listrcl_note
_1218.recall_list_templatesrclt_note
_1218.slotsslts_note
_1218.voided_paymentsvp_note
_1548.appointmentsapt_note
_1548.auditsaud_note
_1548.audits_archiveaud_note
_1548.audits_newaud_note
_1548.audits_new_archiveaud_note
_1548.charts_cpt_codeschcp_note
_1548.configured_encounters_templates_cpt_codescetcc_note
_1548.cpoe_responsescpoe_res_internal_note
_1548.encounters_claims_statusesecs_note
_1548.encounters_cpt_codesecp_note
_1548.encounters_cpt_codes_templatesecpt_note
_1548.encounters_paymentsepay_note
_1548.erx_notification_countserx_not_note
_1548.hl7_accessionsacc_internal_note
_1548.insurancesins_note
_1548.insurances_newins_note
_1548.insurances_repositoryirep_note
_1548.ledgerled_note
_1548.notesnot_note
_1548.patients_authorization_numberspan_note
_1548.patients_icd9_problemspip_note
_1548.patients_smoking_statuspss_note
_1548.physiciansphy_note
_1548.printable_signaturespsig_signature_note
_1548.procedures_resultspres_note
_1548.radiology_order_notesradnot_is_pat_note
_1548.radiology_ordersrad_note
_1548.radiology_resultsrad_res_internal_note
_1548.recall_listrcl_note
_1548.recall_list_templatesrclt_note
_1548.slotsslts_note
_1548.voided_paymentsvp_note
_435.appointmentsapt_note
_435.auditsaud_note
_435.audits_archiveaud_note
_435.audits_archive_2008aud_note
_435.audits_archive_2009aud_note
_435.audits_archive_2010aud_note
_435.audits_archive_2011aud_note
_435.audits_archive_2012aud_note
_435.audits_archive_2013aud_note
_435.audits_archive_2014aud_note
_435.audits_archive_2015aud_note
_435.audits_archive_2016aud_note
_435.audits_archive_2017aud_note
_435.audits_archive_2018aud_note
_435.audits_archive_2019aud_note
_435.audits_archive_2020aud_note
_435.audits_newaud_note
_435.audits_new_archiveaud_note
_435.audits_new_trialaud_note
_435.charts_cpt_codeschcp_note
_435.configured_encounters_templates_cpt_codescetcc_note
_435.cpoe_responsescpoe_res_internal_note
_435.encounters_claims_statusesecs_note
_435.encounters_cpt_codesecp_note
_435.encounters_cpt_codes_templatesecpt_note
_435.encounters_paymentsepay_note
_435.erx_notification_countserx_not_note
_435.hl7_accessionsacc_internal_note
_435.insurancesins_note
_435.insurances_newins_note
_435.insurances_repositoryirep_note
_435.ledgerled_note
_435.notesnot_note
_435.patients_authorization_numberspan_note
_435.patients_icd9_problemspip_note
_435.patients_smoking_statuspss_note
_435.physiciansphy_note
_435.printable_signaturespsig_signature_note
_435.procedures_resultspres_note
_435.radiology_order_notesradnot_is_pat_note
_435.radiology_ordersrad_note
_435.radiology_resultsrad_res_internal_note
_435.recall_listrcl_note
_435.recall_list_templatesrclt_note
_435.slotsslts_note
_435.voided_paymentsvp_note
_436.appointmentsapt_note
_436.auditsaud_note
_436.audits_archiveaud_note
_436.audits_newaud_note
_436.audits_new_archiveaud_note
_436.charts_cpt_codeschcp_note
_436.configured_encounters_templates_cpt_codescetcc_note
_436.cpoe_responsescpoe_res_internal_note
_436.encounters_claims_statusesecs_note
_436.encounters_cpt_codesecp_note
_436.encounters_cpt_codes_templatesecpt_note
_436.encounters_paymentsepay_note
_436.erx_notification_countserx_not_note
_436.hl7_accessionsacc_internal_note
_436.insurancesins_note
_436.insurances_newins_note
_436.insurances_repositoryirep_note
_436.ledgerled_note
_436.notesnot_note
_436.patients_authorization_numberspan_note
_436.patients_icd9_problemspip_note
_436.patients_smoking_statuspss_note
_436.physiciansphy_note
_436.printable_signaturespsig_signature_note
_436.procedures_resultspres_note
_436.radiology_order_notesradnot_is_pat_note
_436.radiology_ordersrad_note
_436.radiology_resultsrad_res_internal_note
_436.recall_listrcl_note
_436.recall_list_templatesrclt_note
_436.slotsslts_note
_436.voided_paymentsvp_note
_436_archive_testing.appointmentsapt_note
_436_archive_testing.auditsaud_note
_436_archive_testing.audits_archiveaud_note
_436_archive_testing.audits_archive_2008aud_note
_436_archive_testing.audits_archive_2009aud_note
_436_archive_testing.audits_archive_2010aud_note
_436_archive_testing.audits_archive_2011aud_note
_436_archive_testing.audits_archive_2012aud_note
_436_archive_testing.audits_archive_2013aud_note
_436_archive_testing.audits_archive_2014aud_note
_436_archive_testing.audits_archive_2015aud_note
_436_archive_testing.audits_archive_2016aud_note
_436_archive_testing.audits_archive_2017aud_note
_436_archive_testing.audits_archive_2018aud_note
_436_archive_testing.audits_archive_2019aud_note
_436_archive_testing.audits_archive_2020aud_note
_436_archive_testing.audits_archive_2021aud_note
_436_archive_testing.audits_newaud_note
_436_archive_testing.audits_new_archiveaud_note
_436_archive_testing.charts_cpt_codeschcp_note
_436_archive_testing.configured_encounters_templates_cpt_codescetcc_note
_436_archive_testing.cpoe_responsescpoe_res_internal_note
_436_archive_testing.encounters_claims_statusesecs_note
_436_archive_testing.encounters_cpt_codesecp_note
_436_archive_testing.encounters_cpt_codes_templatesecpt_note
_436_archive_testing.encounters_paymentsepay_note
_436_archive_testing.erx_notification_countserx_not_note
_436_archive_testing.hl7_accessionsacc_internal_note
_436_archive_testing.insurancesins_note
_436_archive_testing.insurances_newins_note
_436_archive_testing.insurances_repositoryirep_note
_436_archive_testing.ledgerled_note
_436_archive_testing.notesnot_note
_436_archive_testing.patients_authorization_numberspan_note
_436_archive_testing.patients_icd9_problemspip_note
_436_archive_testing.patients_smoking_statuspss_note
_436_archive_testing.physiciansphy_note
_436_archive_testing.printable_signaturespsig_signature_note
_436_archive_testing.procedures_resultspres_note
_436_archive_testing.radiology_order_notesradnot_is_pat_note
_436_archive_testing.radiology_ordersrad_note
_436_archive_testing.radiology_resultsrad_res_internal_note
_436_archive_testing.recall_listrcl_note
_436_archive_testing.recall_list_templatesrclt_note
_436_archive_testing.slotsslts_note
_436_archive_testing.voided_paymentsvp_note
_437.appointmentsapt_note
_437.auditsaud_note
_437.audits_archiveaud_note
_437.audits_newaud_note
_437.audits_new_archiveaud_note
_437.charts_cpt_codeschcp_note
_437.configured_encounters_templates_cpt_codescetcc_note
_437.cpoe_responsescpoe_res_internal_note
_437.encounters_claims_statusesecs_note
_437.encounters_cpt_codesecp_note
_437.encounters_cpt_codes_templatesecpt_note
_437.encounters_paymentsepay_note
_437.erx_notification_countserx_not_note
_437.hl7_accessionsacc_internal_note
_437.insurancesins_note
_437.insurances_newins_note
_437.insurances_repositoryirep_note
_437.ledgerled_note
_437.notesnot_note
_437.patients_authorization_numberspan_note
_437.patients_icd9_problemspip_note
_437.patients_smoking_statuspss_note
_437.physiciansphy_note
_437.printable_signaturespsig_signature_note
_437.procedures_resultspres_note
_437.radiology_order_notesradnot_is_pat_note
_437.radiology_ordersrad_note
_437.radiology_resultsrad_res_internal_note
_437.recall_listrcl_note
_437.recall_list_templatesrclt_note
_437.slotsslts_note
_437.voided_paymentsvp_note
_8.appointmentsapt_note
_8.auditsaud_note
_8.audits_archiveaud_note
_8.audits_archive_2020aud_note
_8.audits_newaud_note
_8.audits_new_archiveaud_note
_8.charts_cpt_codeschcp_note
_8.configured_encounters_templates_cpt_codescetcc_note
_8.cpoe_responsescpoe_res_internal_note
_8.daily_close_calculationsdcc_led_note
_8.encounters_claims_statusesecs_note
_8.encounters_cpt_codesecp_note
_8.encounters_cpt_codes_templatesecpt_note
_8.encounters_paymentsepay_note
_8.erx_notification_countserx_not_note
_8.hl7_accessionsacc_internal_note
_8.insurancesins_note
_8.insurances_newins_note
_8.insurances_repositoryirep_note
_8.ledgerled_note
_8.notesnot_note
_8.patients_authorization_numberspan_note
_8.patients_icd9_problemspip_note
_8.patients_smoking_statuspss_note
_8.physiciansphy_note
_8.printable_signaturespsig_signature_note
_8.procedures_resultspres_note
_8.radiology_order_notesradnot_is_pat_note
_8.radiology_ordersrad_note
_8.radiology_resultsrad_res_internal_note
_8.recall_listrcl_note
_8.recall_list_templatesrclt_note
_8.slotsslts_note
_8.voided_paymentsvp_note
_81.appointmentsapt_note
_81.auditsaud_note
_81.audits_archiveaud_note
_81.audits_newaud_note
_81.audits_new_archiveaud_note
_81.charts_cpt_codeschcp_note
_81.configured_encounters_templates_cpt_codescetcc_note
_81.cpoe_responsescpoe_res_internal_note
_81.encounters_claims_statusesecs_note
_81.encounters_cpt_codesecp_note
_81.encounters_cpt_codes_templatesecpt_note
_81.encounters_paymentsepay_note
_81.erx_notification_countserx_not_note
_81.hl7_accessionsacc_internal_note
_81.insurancesins_note
_81.insurances_newins_note
_81.insurances_repositoryirep_note
_81.ledgerled_note
_81.notesnot_note
_81.patients_authorization_numberspan_note
_81.patients_icd9_problemspip_note
_81.patients_smoking_statuspss_note
_81.physiciansphy_note
_81.printable_signaturespsig_signature_note
_81.procedures_resultspres_note
_81.radiology_order_notesradnot_is_pat_note
_81.radiology_ordersrad_note
_81.radiology_resultsrad_res_internal_note
_81.recall_listrcl_note
_81.recall_list_templatesrclt_note
_81.slotsslts_note
_81.voided_paymentsvp_note
_999.appointmentsapt_note
_999.auditsaud_note
_999.audits_archiveaud_note
_999.audits_newaud_note
_999.audits_new_archiveaud_note
_999.charts_cpt_codeschcp_note
_999.configured_encounters_templates_cpt_codescetcc_note
_999.cpoe_responsescpoe_res_internal_note
_999.encounters_claims_statusesecs_note
_999.encounters_cpt_codesecp_note
_999.encounters_cpt_codes_templatesecpt_note
_999.encounters_paymentsepay_note
_999.erx_notification_countserx_not_note
_999.hl7_accessionsacc_internal_note
_999.insurancesins_note
_999.insurances_newins_note
_999.insurances_repositoryirep_note
_999.ledgerled_note
_999.notesnot_note
_999.patients_authorization_numberspan_note
_999.patients_icd9_problemspip_note
_999.patients_smoking_statuspss_note
_999.physiciansphy_note
_999.printable_signaturespsig_signature_note
_999.procedures_resultspres_note
_999.radiology_order_notesradnot_is_pat_note
_999.radiology_ordersrad_note
_999.radiology_resultsrad_res_internal_note
_999.recall_listrcl_note
_999.recall_list_templatesrclt_note
_999.slotsslts_note
_999.voided_paymentsvp_note
aurora_standard.chmadmqrvery_last_note
aurora_standard.chmdfypddfy_note
aurora_standard.chmertmrdischg_note
aurora_standard.chmmbc40dme_rx_note
aurora_standard.chmnotecauto_note
aurora_standard.chmpatiradm_note
aurora_standard.chmpatirdiscont_note
aurora_standard.chmpnotcauto_note
aurora_standard.chmpsvcdsvc_note
aurora_standard.ohovisqrlast_note
aurora_standard.strinvceinv_note
aurora_standard.vault_icd9stf_for_note
common.ahi_auditsaud_note
common.ahi_notesnot_note
common.dev_requests_notesdvn_note
common.dev_requests_votesdvt_note
template_library.encounters_cpt_codes_templatesecpt_note