aurora_standard.surpcnotesd

Field Type Null Default Key Extra Comment
card_no int(11) NO PRI
seq_no int(11) NO PRI
notes varchar(255) YES
note_seq int(11) NO 0 PRI

References

Local Column References
notes
TableColumn
_1.appointments_requestsaptreq_notes
_1.charts_medicationscm_notes
_1.charts_procedurescp_notes
_1.encountersenc_notes
_1.encounters_soapesp_notes
_1.encounters_soap_templatesest_notes
_1.encounters_soap_vitalsespv_notes
_1.inventoryinv_notes
_1.patientspat_notes
_1.patientspat_popup_notes
_1.patients_demographics_snapshotspds_notes
_1.patients_demographics_snapshotspds_popup_notes
_1.patients_enrollmentspert_notes
_1.patients_immunizationspim_admin_notes
_1.patients_inventorypinv_administered_notes
_1.patients_medicationspms_notes
_1.patients_payments_ledger_mappplm_notes
_1.patients_prescriptionsprx_notes
_1.patients_vitalspvs_notes
_1.precertspre_notes
_1.soapssoap_notes
_1188.appointments_requestsaptreq_notes
_1188.charts_medicationscm_notes
_1188.charts_procedurescp_notes
_1188.encountersenc_notes
_1188.encounters_soapesp_notes
_1188.encounters_soap_templatesest_notes
_1188.encounters_soap_vitalsespv_notes
_1188.inventoryinv_notes
_1188.patientspat_notes
_1188.patientspat_popup_notes
_1188.patients_demographics_snapshotspds_notes
_1188.patients_demographics_snapshotspds_popup_notes
_1188.patients_enrollmentspert_notes
_1188.patients_immunizationspim_admin_notes
_1188.patients_inventorypinv_administered_notes
_1188.patients_medicationspms_notes
_1188.patients_payments_ledger_mappplm_notes
_1188.patients_prescriptionsprx_notes
_1188.patients_vitalspvs_notes
_1188.precertspre_notes
_1188.soapssoap_notes
_1218.appointments_requestsaptreq_notes
_1218.charts_medicationscm_notes
_1218.charts_procedurescp_notes
_1218.encountersenc_notes
_1218.encounters_soapesp_notes
_1218.encounters_soap_templatesest_notes
_1218.encounters_soap_vitalsespv_notes
_1218.inventoryinv_notes
_1218.patientspat_notes
_1218.patientspat_popup_notes
_1218.patients_demographics_snapshotspds_notes
_1218.patients_demographics_snapshotspds_popup_notes
_1218.patients_enrollmentspert_notes
_1218.patients_immunizationspim_admin_notes
_1218.patients_inventorypinv_administered_notes
_1218.patients_medicationspms_notes
_1218.patients_payments_ledger_mappplm_notes
_1218.patients_prescriptionsprx_notes
_1218.patients_vitalspvs_notes
_1218.precertspre_notes
_1218.soapssoap_notes
_1548.appointments_requestsaptreq_notes
_1548.charts_medicationscm_notes
_1548.charts_procedurescp_notes
_1548.encountersenc_notes
_1548.encounters_soapesp_notes
_1548.encounters_soap_templatesest_notes
_1548.encounters_soap_vitalsespv_notes
_1548.inventoryinv_notes
_1548.patientspat_notes
_1548.patientspat_popup_notes
_1548.patients_demographics_snapshotspds_notes
_1548.patients_demographics_snapshotspds_popup_notes
_1548.patients_enrollmentspert_notes
_1548.patients_immunizationspim_admin_notes
_1548.patients_inventorypinv_administered_notes
_1548.patients_medicationspms_notes
_1548.patients_payments_ledger_mappplm_notes
_1548.patients_prescriptionsprx_notes
_1548.patients_vitalspvs_notes
_1548.precertspre_notes
_1548.soapssoap_notes
_435.appointments_requestsaptreq_notes
_435.charts_medicationscm_notes
_435.charts_procedurescp_notes
_435.encountersenc_notes
_435.encounters_soapesp_notes
_435.encounters_soap_templatesest_notes
_435.encounters_soap_vitalsespv_notes
_435.inventoryinv_notes
_435.patientspat_notes
_435.patientspat_popup_notes
_435.patients_demographics_snapshotspds_notes
_435.patients_demographics_snapshotspds_popup_notes
_435.patients_enrollmentspert_notes
_435.patients_immunizationspim_admin_notes
_435.patients_inventorypinv_administered_notes
_435.patients_medicationspms_notes
_435.patients_payments_ledger_mappplm_notes
_435.patients_prescriptionsprx_notes
_435.patients_vitalspvs_notes
_435.precertspre_notes
_435.soapssoap_notes
_436.appointments_requestsaptreq_notes
_436.charts_medicationscm_notes
_436.charts_procedurescp_notes
_436.encountersenc_notes
_436.encounters_soapesp_notes
_436.encounters_soap_templatesest_notes
_436.encounters_soap_vitalsespv_notes
_436.inventoryinv_notes
_436.patientspat_notes
_436.patientspat_popup_notes
_436.patients_demographics_snapshotspds_notes
_436.patients_demographics_snapshotspds_popup_notes
_436.patients_enrollmentspert_notes
_436.patients_immunizationspim_admin_notes
_436.patients_inventorypinv_administered_notes
_436.patients_medicationspms_notes
_436.patients_payments_ledger_mappplm_notes
_436.patients_prescriptionsprx_notes
_436.patients_vitalspvs_notes
_436.precertspre_notes
_436.soapssoap_notes
_436_archive_testing.appointments_requestsaptreq_notes
_436_archive_testing.charts_medicationscm_notes
_436_archive_testing.charts_procedurescp_notes
_436_archive_testing.encountersenc_notes
_436_archive_testing.encounters_soapesp_notes
_436_archive_testing.encounters_soap_templatesest_notes
_436_archive_testing.encounters_soap_vitalsespv_notes
_436_archive_testing.inventoryinv_notes
_436_archive_testing.patientspat_notes
_436_archive_testing.patientspat_popup_notes
_436_archive_testing.patients_demographics_snapshotspds_notes
_436_archive_testing.patients_demographics_snapshotspds_popup_notes
_436_archive_testing.patients_enrollmentspert_notes
_436_archive_testing.patients_immunizationspim_admin_notes
_436_archive_testing.patients_inventorypinv_administered_notes
_436_archive_testing.patients_medicationspms_notes
_436_archive_testing.patients_payments_ledger_mappplm_notes
_436_archive_testing.patients_prescriptionsprx_notes
_436_archive_testing.patients_vitalspvs_notes
_436_archive_testing.precertspre_notes
_436_archive_testing.soapssoap_notes
_437.appointments_requestsaptreq_notes
_437.charts_medicationscm_notes
_437.charts_procedurescp_notes
_437.encountersenc_notes
_437.encounters_soapesp_notes
_437.encounters_soap_templatesest_notes
_437.encounters_soap_vitalsespv_notes
_437.inventoryinv_notes
_437.patientspat_notes
_437.patientspat_popup_notes
_437.patients_demographics_snapshotspds_notes
_437.patients_demographics_snapshotspds_popup_notes
_437.patients_enrollmentspert_notes
_437.patients_immunizationspim_admin_notes
_437.patients_inventorypinv_administered_notes
_437.patients_medicationspms_notes
_437.patients_payments_ledger_mappplm_notes
_437.patients_prescriptionsprx_notes
_437.patients_vitalspvs_notes
_437.precertspre_notes
_437.soapssoap_notes
_8.appointments_requestsaptreq_notes
_8.charts_medicationscm_notes
_8.charts_procedurescp_notes
_8.encountersenc_notes
_8.encounters_soapesp_notes
_8.encounters_soap_templatesest_notes
_8.encounters_soap_vitalsespv_notes
_8.inventoryinv_notes
_8.patientspat_notes
_8.patientspat_popup_notes
_8.patients_demographics_snapshotspds_notes
_8.patients_demographics_snapshotspds_popup_notes
_8.patients_enrollmentspert_notes
_8.patients_immunizationspim_admin_notes
_8.patients_inventorypinv_administered_notes
_8.patients_medicationspms_notes
_8.patients_payments_ledger_mappplm_notes
_8.patients_prescriptionsprx_notes
_8.patients_vitalspvs_notes
_8.precertspre_notes
_8.soapssoap_notes
_81.appointments_requestsaptreq_notes
_81.charts_medicationscm_notes
_81.charts_procedurescp_notes
_81.encountersenc_notes
_81.encounters_soapesp_notes
_81.encounters_soap_templatesest_notes
_81.encounters_soap_vitalsespv_notes
_81.inventoryinv_notes
_81.patientspat_notes
_81.patientspat_popup_notes
_81.patients_demographics_snapshotspds_notes
_81.patients_demographics_snapshotspds_popup_notes
_81.patients_enrollmentspert_notes
_81.patients_immunizationspim_admin_notes
_81.patients_inventorypinv_administered_notes
_81.patients_medicationspms_notes
_81.patients_payments_ledger_mappplm_notes
_81.patients_prescriptionsprx_notes
_81.patients_vitalspvs_notes
_81.precertspre_notes
_81.soapssoap_notes
_999.appointments_requestsaptreq_notes
_999.charts_medicationscm_notes
_999.charts_procedurescp_notes
_999.encountersenc_notes
_999.encounters_soapesp_notes
_999.encounters_soap_templatesest_notes
_999.encounters_soap_vitalsespv_notes
_999.inventoryinv_notes
_999.patientspat_notes
_999.patientspat_popup_notes
_999.patients_demographics_snapshotspds_notes
_999.patients_demographics_snapshotspds_popup_notes
_999.patients_enrollmentspert_notes
_999.patients_immunizationspim_admin_notes
_999.patients_inventorypinv_administered_notes
_999.patients_medicationspms_notes
_999.patients_payments_ledger_mappplm_notes
_999.patients_prescriptionsprx_notes
_999.patients_vitalspvs_notes
_999.precertspre_notes
_999.soapssoap_notes
aurora_standard.bookmarksuser_notes
aurora_standard.chmbenedi_send_prog_notes
aurora_standard.chmbenedo_send_prog_notes
aurora_standard.chmcolacall_notes
aurora_standard.chmibendr_send_prog_notes
aurora_standard.stucntrcprint_notes
common.clients_contract_dataccd_termination_notes
common.clients_contract_dataccd_follow_up_notes
common.clients_contract_dataccd_finance_notes
common.clients_contract_dataccd_at_risk_notes
common.contactscon_notes
common.enrollments_optionsertop_notes
common.leads_vendors_maplvm_notes
common.vaccinesvac_notes
common.vaccines_manufacturersmvx_notes
template_library.encounters_soap_templatesest_notes
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
card_no
TableColumn
aurora_standard.stpvendrcredit_card_no
aurora_standard.styrtimdrec_card_no
aurora_standard.styrtimerec_card_no