_1188.configured_encounters_templates

Field	Type	Null	Default	Key	Extra	Comment
cet_id	int(11)	NO		PRI	auto_increment
cet_cli_id	int(11)	NO				Client ID#
cet_cus_id	int(11)	NO				Customer ID#
cet_name	varchar(255)	NO		MUL		Descriptor for template
cet_dos	datetime	YES		MUL		Date of service
cet_phy_id	int(11)	YES		MUL		Rendering provider
cet_loc_id	int(11)	YES		MUL		Location
cet_cfs_id	int(11)	YES		MUL		Fee Schedule
cet_disabled	tinyint(1)	NO	0			Disabled Indicator
cet_usr_id_created	int(11)	NO				User that creates the template
cet_usr_id_modified	int(11)	YES				User that modifies the template
cet_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
cet_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

cet_id

Table	Column
_1.configured_encounters_templates_cpt_codes	cetcc_cet_id
_1.configured_encounters_templates_dx_codes	cetdxc_cet_id
_1.patient_configured_encounters	pce_cet_id
_1188.configured_encounters_templates_cpt_codes	cetcc_cet_id
_1188.configured_encounters_templates_dx_codes	cetdxc_cet_id
_1188.patient_configured_encounters	pce_cet_id
_1218.configured_encounters_templates_cpt_codes	cetcc_cet_id
_1218.configured_encounters_templates_dx_codes	cetdxc_cet_id
_1218.patient_configured_encounters	pce_cet_id
_1548.configured_encounters_templates_cpt_codes	cetcc_cet_id
_1548.configured_encounters_templates_dx_codes	cetdxc_cet_id
_1548.patient_configured_encounters	pce_cet_id
_435.configured_encounters_templates_cpt_codes	cetcc_cet_id
_435.configured_encounters_templates_dx_codes	cetdxc_cet_id
_435.patient_configured_encounters	pce_cet_id
_436.configured_encounters_templates_cpt_codes	cetcc_cet_id
_436.configured_encounters_templates_dx_codes	cetdxc_cet_id
_436.patient_configured_encounters	pce_cet_id
_436_archive_testing.configured_encounters_templates_cpt_codes	cetcc_cet_id
_436_archive_testing.configured_encounters_templates_dx_codes	cetdxc_cet_id
_436_archive_testing.patient_configured_encounters	pce_cet_id
_437.configured_encounters_templates_cpt_codes	cetcc_cet_id
_437.configured_encounters_templates_dx_codes	cetdxc_cet_id
_437.patient_configured_encounters	pce_cet_id
_8.configured_encounters_templates_cpt_codes	cetcc_cet_id
_8.configured_encounters_templates_dx_codes	cetdxc_cet_id
_8.patient_configured_encounters	pce_cet_id
_81.configured_encounters_templates_cpt_codes	cetcc_cet_id
_81.configured_encounters_templates_dx_codes	cetdxc_cet_id
_81.patient_configured_encounters	pce_cet_id
_999.configured_encounters_templates_cpt_codes	cetcc_cet_id
_999.configured_encounters_templates_dx_codes	cetdxc_cet_id
_999.patient_configured_encounters	pce_cet_id