_1218.encounters_soap_labels

Field	Type	Null	Default	Key	Extra	Comment
esl_id	int(11)	NO		PRI	auto_increment
esl_cli_id	int(11)	NO		MUL
esl_label_name	varchar(512)	NO				Official custom field name
esl_display_name	varchar(512)	NO				Dispayed custom field name
esl_default_text	longtext	NO				Content of the SOAP label
esl_frm_id	int(11)	YES	0	MUL
esl_sys	tinyint(1)	NO	0			Indicates that this is a structured custom field
esl_grid	tinyint(1)	NO	0
esl_esnc_id	int(11)	NO	1
esl_on_all	char(1)	NO
esl_cs_id	int(11)	YES				Coding systems id
esl_code	varchar(50)	YES				Encounters SOAP Labels code
esl_desc	varchar(125)	YES				Encounters SOAP Labels description
esl_override_1	char(1)	NO	0
esl_override_2	char(1)	NO	0
esl_editable_in_chart	char(1)	NO	0
esl_patient_history	char(1)	NO
esl_disabled	char(1)	NO
esl_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
esl_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

esl_id

Table	Column
_1.encounter_soap_labels_values_groups	eslvg_esl_id
_1.encounters_soap_labels_components	eslc_esl_id
_1.encounters_soap_labels_templates	eslt_esl_id
_1.encounters_soap_labels_values	eslv_esl_id
_1.patient_history_fields	phf_esl_id
_1.soap_labels_system_component_map	slsm_esl_id
_1.systems_components	scmp_esl_id
_1188.encounters_soap_labels_components	eslc_esl_id
_1188.encounters_soap_labels_templates	eslt_esl_id
_1188.encounters_soap_labels_values	eslv_esl_id
_1188.patient_history_fields	phf_esl_id
_1188.soap_labels_system_component_map	slsm_esl_id
_1188.systems_components	scmp_esl_id
_1218.encounter_soap_labels_values_groups	eslvg_esl_id
_1218.encounters_soap_labels_components	eslc_esl_id
_1218.encounters_soap_labels_templates	eslt_esl_id
_1218.encounters_soap_labels_values	eslv_esl_id
_1218.patient_history_fields	phf_esl_id
_1218.soap_labels_system_component_map	slsm_esl_id
_1218.systems_components	scmp_esl_id
_1548.encounter_soap_labels_values_groups	eslvg_esl_id
_1548.encounters_soap_labels_components	eslc_esl_id
_1548.encounters_soap_labels_templates	eslt_esl_id
_1548.encounters_soap_labels_values	eslv_esl_id
_1548.patient_history_fields	phf_esl_id
_1548.soap_labels_system_component_map	slsm_esl_id
_1548.systems_components	scmp_esl_id
_435.encounter_soap_labels_values_groups	eslvg_esl_id
_435.encounters_soap_labels_components	eslc_esl_id
_435.encounters_soap_labels_templates	eslt_esl_id
_435.encounters_soap_labels_values	eslv_esl_id
_435.patient_history_fields	phf_esl_id
_435.soap_labels_system_component_map	slsm_esl_id
_435.systems_components	scmp_esl_id
_436.encounter_soap_labels_values_groups	eslvg_esl_id
_436.encounters_soap_labels_components	eslc_esl_id
_436.encounters_soap_labels_templates	eslt_esl_id
_436.encounters_soap_labels_values	eslv_esl_id
_436.patient_history_fields	phf_esl_id
_436.soap_labels_system_component_map	slsm_esl_id
_436.systems_components	scmp_esl_id
_436_archive_testing.encounter_soap_labels_values_groups	eslvg_esl_id
_436_archive_testing.encounters_soap_labels_components	eslc_esl_id
_436_archive_testing.encounters_soap_labels_templates	eslt_esl_id
_436_archive_testing.encounters_soap_labels_values	eslv_esl_id
_436_archive_testing.patient_history_fields	phf_esl_id
_436_archive_testing.soap_labels_system_component_map	slsm_esl_id
_436_archive_testing.systems_components	scmp_esl_id
_437.encounter_soap_labels_values_groups	eslvg_esl_id
_437.encounters_soap_labels_components	eslc_esl_id
_437.encounters_soap_labels_templates	eslt_esl_id
_437.encounters_soap_labels_values	eslv_esl_id
_437.patient_history_fields	phf_esl_id
_437.soap_labels_system_component_map	slsm_esl_id
_437.systems_components	scmp_esl_id
_8.encounter_soap_labels_values_groups	eslvg_esl_id
_8.encounters_soap_labels_components	eslc_esl_id
_8.encounters_soap_labels_templates	eslt_esl_id
_8.encounters_soap_labels_values	eslv_esl_id
_8.patient_history_fields	phf_esl_id
_8.soap_labels_system_component_map	slsm_esl_id
_8.systems_components	scmp_esl_id
_81.encounters_soap_labels_components	eslc_esl_id
_81.encounters_soap_labels_templates	eslt_esl_id
_81.encounters_soap_labels_values	eslv_esl_id
_81.patient_history_fields	phf_esl_id
_81.soap_labels_system_component_map	slsm_esl_id
_81.systems_components	scmp_esl_id
_999.encounter_soap_labels_values_groups	eslvg_esl_id
_999.encounters_soap_labels_components	eslc_esl_id
_999.encounters_soap_labels_templates	eslt_esl_id
_999.encounters_soap_labels_values	eslv_esl_id
_999.patient_history_fields	phf_esl_id
_999.soap_labels_system_component_map	slsm_esl_id
_999.systems_components	scmp_esl_id
template_library.encounters_soap_labels_templates	eslt_esl_id
template_library.soap_labels_system_component_map	slsm_esl_id
template_library.systems_components	scmp_esl_id