_999.encounters_soap_templates

Field	Type	Null	Default	Key	Extra	Comment
est_id	int(11)	NO		PRI	auto_increment
est_cus_id	int(11)	NO		MUL
est_cli_id	int(11)	NO		MUL
est_enc_id	int(11)	NO		MUL
est_name	text	NO
est_chief_complaint	text	NO
est_subjective	text	NO
est_objective	text	NO
est_assessment	text	NO
est_procedure	text	NO
est_plan	text	NO
est_notes	text	NO
est_exported	char(1)	NO
est_phy_fname	text	YES
est_phy_lname	text	NO
est_phy_title	varchar(45)	NO
est_spec_id	int(11)	NO	0
est_vwc_id	int(11)	NO
est_disabled	tinyint(1)	NO	0			Indicates if the template is disabled
est_hidden	char(1)	NO	0
est_modified	datetime	YES	CURRENT_TIMESTAMP
est_created	datetime	YES	CURRENT_TIMESTAMP

References

Local Column

References

est_id

Table	Column
_1.encounters_cpt_codes_templates	ecpt_est_id
_1.encounters_icd9_codes_templates	eict_est_id
_1.encounters_soap_images_templates	espit_est_id
_1.encounters_soap_labels_templates	eslt_est_id
_1.encounters_soap_templates_access	esta_est_id
_1.encounters_soap_templates_care_plans	estcp_est_id
_1.encounters_soap_templates_frequency	estf_est_id
_1.orders_comments_templates	orct_est_id
_1.orders_icd9_codes_templates	oict_est_id
_1.orders_standing_templates	ostt_est_id
_1.orders_templates	ordt_est_id
_1.orders_test_codes_templates	otct_est_id
_1.patients_immunizations_templates	pimt_est_id
_1.recall_list_templates	rclt_est_id
_1188.encounters_cpt_codes_templates	ecpt_est_id
_1188.encounters_icd9_codes_templates	eict_est_id
_1188.encounters_soap_images_templates	espit_est_id
_1188.encounters_soap_labels_templates	eslt_est_id
_1188.encounters_soap_templates_access	esta_est_id
_1188.encounters_soap_templates_care_plans	estcp_est_id
_1188.encounters_soap_templates_frequency	estf_est_id
_1188.orders_comments_templates	orct_est_id
_1188.orders_icd9_codes_templates	oict_est_id
_1188.orders_standing_templates	ostt_est_id
_1188.orders_templates	ordt_est_id
_1188.orders_test_codes_templates	otct_est_id
_1188.patients_immunizations_templates	pimt_est_id
_1188.recall_list_templates	rclt_est_id
_1218.encounters_cpt_codes_templates	ecpt_est_id
_1218.encounters_icd9_codes_templates	eict_est_id
_1218.encounters_soap_images_templates	espit_est_id
_1218.encounters_soap_labels_templates	eslt_est_id
_1218.encounters_soap_templates_access	esta_est_id
_1218.encounters_soap_templates_care_plans	estcp_est_id
_1218.encounters_soap_templates_frequency	estf_est_id
_1218.orders_comments_templates	orct_est_id
_1218.orders_icd9_codes_templates	oict_est_id
_1218.orders_standing_templates	ostt_est_id
_1218.orders_templates	ordt_est_id
_1218.orders_test_codes_templates	otct_est_id
_1218.patients_immunizations_templates	pimt_est_id
_1218.recall_list_templates	rclt_est_id
_1548.encounters_cpt_codes_templates	ecpt_est_id
_1548.encounters_icd9_codes_templates	eict_est_id
_1548.encounters_soap_images_templates	espit_est_id
_1548.encounters_soap_labels_templates	eslt_est_id
_1548.encounters_soap_templates_access	esta_est_id
_1548.encounters_soap_templates_care_plans	estcp_est_id
_1548.encounters_soap_templates_frequency	estf_est_id
_1548.orders_comments_templates	orct_est_id
_1548.orders_icd9_codes_templates	oict_est_id
_1548.orders_standing_templates	ostt_est_id
_1548.orders_templates	ordt_est_id
_1548.orders_test_codes_templates	otct_est_id
_1548.patients_immunizations_templates	pimt_est_id
_1548.recall_list_templates	rclt_est_id
_435.encounters_cpt_codes_templates	ecpt_est_id
_435.encounters_icd9_codes_templates	eict_est_id
_435.encounters_soap_images_templates	espit_est_id
_435.encounters_soap_labels_templates	eslt_est_id
_435.encounters_soap_templates_access	esta_est_id
_435.encounters_soap_templates_care_plans	estcp_est_id
_435.encounters_soap_templates_frequency	estf_est_id
_435.orders_comments_templates	orct_est_id
_435.orders_icd9_codes_templates	oict_est_id
_435.orders_standing_templates	ostt_est_id
_435.orders_templates	ordt_est_id
_435.orders_test_codes_templates	otct_est_id
_435.patients_immunizations_templates	pimt_est_id
_435.recall_list_templates	rclt_est_id
_436.encounters_cpt_codes_templates	ecpt_est_id
_436.encounters_icd9_codes_templates	eict_est_id
_436.encounters_soap_images_templates	espit_est_id
_436.encounters_soap_labels_templates	eslt_est_id
_436.encounters_soap_templates_access	esta_est_id
_436.encounters_soap_templates_care_plans	estcp_est_id
_436.encounters_soap_templates_frequency	estf_est_id
_436.orders_comments_templates	orct_est_id
_436.orders_icd9_codes_templates	oict_est_id
_436.orders_standing_templates	ostt_est_id
_436.orders_templates	ordt_est_id
_436.orders_test_codes_templates	otct_est_id
_436.patients_immunizations_templates	pimt_est_id
_436.recall_list_templates	rclt_est_id
_436_archive_testing.encounters_cpt_codes_templates	ecpt_est_id
_436_archive_testing.encounters_icd9_codes_templates	eict_est_id
_436_archive_testing.encounters_soap_images_templates	espit_est_id
_436_archive_testing.encounters_soap_labels_templates	eslt_est_id
_436_archive_testing.encounters_soap_templates_access	esta_est_id
_436_archive_testing.encounters_soap_templates_care_plans	estcp_est_id
_436_archive_testing.encounters_soap_templates_frequency	estf_est_id
_436_archive_testing.orders_comments_templates	orct_est_id
_436_archive_testing.orders_icd9_codes_templates	oict_est_id
_436_archive_testing.orders_standing_templates	ostt_est_id
_436_archive_testing.orders_templates	ordt_est_id
_436_archive_testing.orders_test_codes_templates	otct_est_id
_436_archive_testing.patients_immunizations_templates	pimt_est_id
_436_archive_testing.recall_list_templates	rclt_est_id
_437.encounters_cpt_codes_templates	ecpt_est_id
_437.encounters_icd9_codes_templates	eict_est_id
_437.encounters_soap_images_templates	espit_est_id
_437.encounters_soap_labels_templates	eslt_est_id
_437.encounters_soap_templates_access	esta_est_id
_437.encounters_soap_templates_care_plans	estcp_est_id
_437.encounters_soap_templates_frequency	estf_est_id
_437.orders_comments_templates	orct_est_id
_437.orders_icd9_codes_templates	oict_est_id
_437.orders_standing_templates	ostt_est_id
_437.orders_templates	ordt_est_id
_437.orders_test_codes_templates	otct_est_id
_437.patients_immunizations_templates	pimt_est_id
_437.recall_list_templates	rclt_est_id
_8.encounters_cpt_codes_templates	ecpt_est_id
_8.encounters_icd9_codes_templates	eict_est_id
_8.encounters_soap_images_templates	espit_est_id
_8.encounters_soap_labels_templates	eslt_est_id
_8.encounters_soap_templates_access	esta_est_id
_8.encounters_soap_templates_care_plans	estcp_est_id
_8.encounters_soap_templates_frequency	estf_est_id
_8.orders_comments_templates	orct_est_id
_8.orders_icd9_codes_templates	oict_est_id
_8.orders_standing_templates	ostt_est_id
_8.orders_templates	ordt_est_id
_8.orders_test_codes_templates	otct_est_id
_8.patients_immunizations_templates	pimt_est_id
_8.recall_list_templates	rclt_est_id
_81.encounters_cpt_codes_templates	ecpt_est_id
_81.encounters_icd9_codes_templates	eict_est_id
_81.encounters_soap_images_templates	espit_est_id
_81.encounters_soap_labels_templates	eslt_est_id
_81.encounters_soap_templates_access	esta_est_id
_81.encounters_soap_templates_care_plans	estcp_est_id
_81.encounters_soap_templates_frequency	estf_est_id
_81.orders_comments_templates	orct_est_id
_81.orders_icd9_codes_templates	oict_est_id
_81.orders_standing_templates	ostt_est_id
_81.orders_templates	ordt_est_id
_81.orders_test_codes_templates	otct_est_id
_81.patients_immunizations_templates	pimt_est_id
_81.recall_list_templates	rclt_est_id
_999.encounters_cpt_codes_templates	ecpt_est_id
_999.encounters_icd9_codes_templates	eict_est_id
_999.encounters_soap_images_templates	espit_est_id
_999.encounters_soap_labels_templates	eslt_est_id
_999.encounters_soap_templates_access	esta_est_id
_999.encounters_soap_templates_care_plans	estcp_est_id
_999.encounters_soap_templates_frequency	estf_est_id
_999.orders_comments_templates	orct_est_id
_999.orders_icd9_codes_templates	oict_est_id
_999.orders_standing_templates	ostt_est_id
_999.orders_templates	ordt_est_id
_999.orders_test_codes_templates	otct_est_id
_999.patients_immunizations_templates	pimt_est_id
_999.recall_list_templates	rclt_est_id
template_library.encounters_cpt_codes_templates	ecpt_est_id
template_library.encounters_icd9_codes_templates	eict_est_id
template_library.encounters_soap_images_templates	espit_est_id
template_library.encounters_soap_labels_templates	eslt_est_id
template_library.encounters_soap_templates_care_plans	estcp_est_id
template_library.orders_comments_templates	orct_est_id
template_library.orders_icd9_codes_templates	oict_est_id
template_library.orders_standing_templates	ostt_est_id
template_library.orders_templates	ordt_est_id
template_library.orders_test_codes_templates	otct_est_id
template_library.patients_immunizations_templates	pimt_est_id