aurora_standard.chshotlr

Field Type Null Default Key Extra Comment
inc_date date YES MUL
inc_no smallint(6) YES MUL
inc_time time YES
caller varchar(20) YES
cust_code varchar(6) YES
dept_fac_no varchar(3) YES
other_phone varchar(20) YES
module_code varchar(5) YES
prob_desc1 varchar(70) YES
prob_desc2 varchar(70) YES
prob_desc3 varchar(70) YES
prob_desc4 varchar(70) YES
taken_by varchar(3) YES
owner varchar(3) YES
priority varchar(1) YES
close_date date YES
close_time time YES
resolved_by varchar(3) YES
contact_name varchar(20) YES
contact_form varchar(20) YES
resolv_1 varchar(70) YES
resolv_2 varchar(70) YES
follow_up varchar(20) YES
tot_hours decimal(5,2) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment

References

Local Column References
owner
TableColumn
API.partner_account_accessesis_owner
common.leadslea_owner
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
close_date
TableColumn
_1.closed_periodsclp_close_date
_1.closed_periods_dailyclpd_close_date
_1188.closed_periodsclp_close_date
_1188.closed_periods_dailyclpd_close_date
_1218.closed_periodsclp_close_date
_1218.closed_periods_dailyclpd_close_date
_1548.closed_periodsclp_close_date
_1548.closed_periods_dailyclpd_close_date
_435.closed_periodsclp_close_date
_435.closed_periods_dailyclpd_close_date
_436.closed_periodsclp_close_date
_436.closed_periods_dailyclpd_close_date
_436_archive_testing.closed_periodsclp_close_date
_436_archive_testing.closed_periods_dailyclpd_close_date
_437.closed_periodsclp_close_date
_437.closed_periods_dailyclpd_close_date
_8.closed_periodsclp_close_date
_8.closed_periods_dailyclpd_close_date
_81.closed_periodsclp_close_date
_81.closed_periods_dailyclpd_close_date
_999.closed_periodsclp_close_date
_999.closed_periods_dailyclpd_close_date