aurora_standard.chtcntrc

Field Type Null Default Key Extra Comment
period_begin_date date YES
period_end_date date YES
hospital_message1 varchar(70) YES
hospital_message2 varchar(70) YES
message_date date YES
on_call_code varchar(6) YES
rounding_flag smallint(6) YES
min_time_on_call time YES
stand_by_code varchar(6) YES
pay_method varchar(1) YES
fac_dept_val varchar(1) YES
electronic_sig varchar(1) YES
pre_holiday_offset time YES
min_time_auto_lunch time YES
dflt_shift varchar(6) YES
chs_rowID bigint(20) unsigned NO PRI auto_increment
dflt_shft_time varchar(255) YES
oc_screen varchar(255) YES
req_field varchar(255) YES

References

Local Column References
period_end_date
TableColumn
HSPI_Bastrop.medication_requestsdispense_period_end_date
HSPI_CURES2015_B1.medication_requestsdispense_period_end_date
HSPI_Central_Hospital.medication_requestsdispense_period_end_date
HSPI_Dewitt.medication_requestsdispense_period_end_date
HSPI_Fulton.medication_requestsdispense_period_end_date
HSPI_Inferno.medication_requestsdispense_period_end_date
HSPI_MU2015_E1.medication_requestsdispense_period_end_date
HSPI_MU2015_G2.medication_requestsdispense_period_end_date
HSPI_MU2015_G9.medication_requestsdispense_period_end_date
HSPI_Sandbox.medication_requestsdispense_period_end_date
HSPI_Summit_General.medication_requestsdispense_period_end_date
HSPI_United_Physicians.medication_requestsdispense_period_end_date
MPI.medication_requestsdispense_period_end_date
on_call_code
TableColumn
aurora_standard.chtemplrdflt_on_call_code