aurora_standard.chmertmd

Field Type Null Default Key Extra Comment
er_no int(11) NO
activity_code char(10) YES
from_date date YES
from_time time YES
to_date date YES
to_time time YES
tot_tm time YES
input_by bigint(20) YES
upd_by bigint(20) YES
upd_date date YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
from_date
TableColumn
_1.encounters_ub04enc_ub04_06_from_date
_1.schedulessch_from_date
_1.schedules_eventssevnt_from_date
_1.taskstask_from_date
_1188.encounters_ub04enc_ub04_06_from_date
_1188.schedulessch_from_date
_1188.schedules_eventssevnt_from_date
_1188.taskstask_from_date
_1218.encounters_ub04enc_ub04_06_from_date
_1218.schedulessch_from_date
_1218.schedules_eventssevnt_from_date
_1218.taskstask_from_date
_1548.encounters_ub04enc_ub04_06_from_date
_1548.schedulessch_from_date
_1548.schedules_eventssevnt_from_date
_1548.taskstask_from_date
_435.encounters_ub04enc_ub04_06_from_date
_435.schedulessch_from_date
_435.schedules_eventssevnt_from_date
_435.taskstask_from_date
_436.encounters_ub04enc_ub04_06_from_date
_436.schedulessch_from_date
_436.schedules_eventssevnt_from_date
_436.taskstask_from_date
_436_archive_testing.encounters_ub04enc_ub04_06_from_date
_436_archive_testing.schedulessch_from_date
_436_archive_testing.schedules_eventssevnt_from_date
_436_archive_testing.taskstask_from_date
_437.encounters_ub04enc_ub04_06_from_date
_437.schedulessch_from_date
_437.schedules_eventssevnt_from_date
_437.taskstask_from_date
_8.encounters_ub04enc_ub04_06_from_date
_8.schedulessch_from_date
_8.schedules_eventssevnt_from_date
_8.taskstask_from_date
_81.encounters_ub04enc_ub04_06_from_date
_81.schedulessch_from_date
_81.schedules_eventssevnt_from_date
_81.taskstask_from_date
_999.encounters_ub04enc_ub04_06_from_date
_999.schedulessch_from_date
_999.schedules_eventssevnt_from_date
_999.taskstask_from_date
aurora_standard.chmardydrev_from_date
aurora_standard.chmcptvceff_from_date
aurora_standard.chmvrsnceff_from_date
common.rcm_stats_generalrcmsg_from_date
common.rcm_stats_practice_analysisrcmspa_from_date
to_date
TableColumn
_1.schedulessch_to_date
_1.schedules_eventssevnt_to_date
_1.taskstask_to_date
_1188.schedulessch_to_date
_1188.schedules_eventssevnt_to_date
_1188.taskstask_to_date
_1218.schedulessch_to_date
_1218.schedules_eventssevnt_to_date
_1218.taskstask_to_date
_1548.schedulessch_to_date
_1548.schedules_eventssevnt_to_date
_1548.taskstask_to_date
_435.schedulessch_to_date
_435.schedules_eventssevnt_to_date
_435.taskstask_to_date
_436.schedulessch_to_date
_436.schedules_eventssevnt_to_date
_436.taskstask_to_date
_436_archive_testing.schedulessch_to_date
_436_archive_testing.schedules_eventssevnt_to_date
_436_archive_testing.taskstask_to_date
_437.schedulessch_to_date
_437.schedules_eventssevnt_to_date
_437.taskstask_to_date
_8.schedulessch_to_date
_8.schedules_eventssevnt_to_date
_8.taskstask_to_date
_81.schedulessch_to_date
_81.schedules_eventssevnt_to_date
_81.taskstask_to_date
_999.schedulessch_to_date
_999.schedules_eventssevnt_to_date
_999.taskstask_to_date
common.rcm_stats_agingrcmsa_to_date
common.rcm_stats_generalrcmsg_to_date
common.rcm_stats_practice_analysisrcmspa_to_date