aurora_standard.ohonotes

Field Type Null Default Key Extra Comment
pat_no varchar(10) YES MUL
note_dt varchar(20) YES
action varchar(30) YES
action_dt varchar(20) YES
note_1 varchar(70) YES
note_2 varchar(70) YES
note_3 varchar(70) YES
note_4 varchar(70) YES
note_5 varchar(70) YES
note_6 varchar(70) YES
note_7 varchar(70) YES
note_8 varchar(70) YES
note_9 varchar(70) YES
note_10 varchar(70) YES
note_11 varchar(70) YES
note_12 varchar(70) YES
note_13 varchar(70) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
action
TableColumn
HSPI_System.web_hook_triggersevent_action
_1.auditsaud_action
_1.audits_archiveaud_action
_1.audits_newaud_action
_1.audits_new_archiveaud_action
_1.charts_medicationscm_action
_1.delta_typedt_action
_1.encountersenc_action_dt
_1.patients_medicationspms_action
_1.patients_prescriptionsprx_action
_1188.auditsaud_action
_1188.audits_archiveaud_action
_1188.audits_newaud_action
_1188.audits_new_archiveaud_action
_1188.charts_medicationscm_action
_1188.delta_typedt_action
_1188.encountersenc_action_dt
_1188.patients_medicationspms_action
_1188.patients_prescriptionsprx_action
_1218.auditsaud_action
_1218.audits_archiveaud_action
_1218.audits_newaud_action
_1218.audits_new_archiveaud_action
_1218.charts_medicationscm_action
_1218.delta_typedt_action
_1218.encountersenc_action_dt
_1218.patients_medicationspms_action
_1218.patients_prescriptionsprx_action
_1548.auditsaud_action
_1548.audits_archiveaud_action
_1548.audits_newaud_action
_1548.audits_new_archiveaud_action
_1548.charts_medicationscm_action
_1548.delta_typedt_action
_1548.encountersenc_action_dt
_1548.patients_medicationspms_action
_1548.patients_prescriptionsprx_action
_435.auditsaud_action
_435.audits_archiveaud_action
_435.audits_archive_2008aud_action
_435.audits_archive_2009aud_action
_435.audits_archive_2010aud_action
_435.audits_archive_2011aud_action
_435.audits_archive_2012aud_action
_435.audits_archive_2013aud_action
_435.audits_archive_2014aud_action
_435.audits_archive_2015aud_action
_435.audits_archive_2016aud_action
_435.audits_archive_2017aud_action
_435.audits_archive_2018aud_action
_435.audits_archive_2019aud_action
_435.audits_archive_2020aud_action
_435.audits_newaud_action
_435.audits_new_archiveaud_action
_435.audits_new_trialaud_action
_435.charts_medicationscm_action
_435.delta_typedt_action
_435.encountersenc_action_dt
_435.patients_medicationspms_action
_435.patients_prescriptionsprx_action
_436.auditsaud_action
_436.audits_archiveaud_action
_436.audits_newaud_action
_436.audits_new_archiveaud_action
_436.charts_medicationscm_action
_436.delta_typedt_action
_436.encountersenc_action_dt
_436.patients_medicationspms_action
_436.patients_prescriptionsprx_action
_436_archive_testing.auditsaud_action
_436_archive_testing.audits_archiveaud_action
_436_archive_testing.audits_archive_2008aud_action
_436_archive_testing.audits_archive_2009aud_action
_436_archive_testing.audits_archive_2010aud_action
_436_archive_testing.audits_archive_2011aud_action
_436_archive_testing.audits_archive_2012aud_action
_436_archive_testing.audits_archive_2013aud_action
_436_archive_testing.audits_archive_2014aud_action
_436_archive_testing.audits_archive_2015aud_action
_436_archive_testing.audits_archive_2016aud_action
_436_archive_testing.audits_archive_2017aud_action
_436_archive_testing.audits_archive_2018aud_action
_436_archive_testing.audits_archive_2019aud_action
_436_archive_testing.audits_archive_2020aud_action
_436_archive_testing.audits_archive_2021aud_action
_436_archive_testing.audits_newaud_action
_436_archive_testing.audits_new_archiveaud_action
_436_archive_testing.charts_medicationscm_action
_436_archive_testing.delta_typedt_action
_436_archive_testing.encountersenc_action_dt
_436_archive_testing.patients_medicationspms_action
_436_archive_testing.patients_prescriptionsprx_action
_437.auditsaud_action
_437.audits_archiveaud_action
_437.audits_newaud_action
_437.audits_new_archiveaud_action
_437.charts_medicationscm_action
_437.delta_typedt_action
_437.encountersenc_action_dt
_437.patients_medicationspms_action
_437.patients_prescriptionsprx_action
_8.auditsaud_action
_8.audits_archiveaud_action
_8.audits_archive_2020aud_action
_8.audits_newaud_action
_8.audits_new_archiveaud_action
_8.charts_medicationscm_action
_8.delta_typedt_action
_8.encountersenc_action_dt
_8.patients_medicationspms_action
_8.patients_prescriptionsprx_action
_81.auditsaud_action
_81.audits_archiveaud_action
_81.audits_newaud_action
_81.audits_new_archiveaud_action
_81.charts_medicationscm_action
_81.delta_typedt_action
_81.encountersenc_action_dt
_81.patients_medicationspms_action
_81.patients_prescriptionsprx_action
_999.auditsaud_action
_999.audits_archiveaud_action
_999.audits_newaud_action
_999.audits_new_archiveaud_action
_999.charts_medicationscm_action
_999.delta_typedt_action
_999.encountersenc_action_dt
_999.patients_medicationspms_action
_999.patients_prescriptionsprx_action
ahiWiki.logginglog_action
ahiWiki.recentchangesrc_log_action
aurora_standard.anotesdan_action
aurora_standard.chmadmqrlast_action
aurora_standard.chmadmqrnext_action_dt
aurora_standard.chmopseclast_action
common.ahi_auditsaud_action
common.users_historyuhs_action
note_dt
TableColumn
aurora_standard.chmadmqrlast_note_dt
aurora_standard.ohovisqrlast_note_dt