_8.clinical_interventions

Field	Type	Null	Default	Key	Extra	Comment
ci_id	int(11)	NO		PRI	auto_increment
ci_cus_id	int(11)	NO		MUL
ci_cli_id	int(11)	NO		MUL
ci_name	varchar(80)	NO
ci_text	text	NO
ci_medline	char(1)	NO	0
ci_pat_sex	varchar(10)	NO
ci_seo_id	int(11)	NO	0	MUL		Sexual Orientation ID#
ci_gi_id	int(11)	NO	0	MUL		Gender Identity ID#
ci_eth_id	int(11)	NO	0			Primary Ethnicity
ci_pat_age_operator	varchar(10)	NO
ci_pat_age_lower	int(11)	NO
ci_pat_age_upper	int(11)	NO
ci_pat_age_unit	varchar(4)	NO
ci_marital_status	varchar(30)	NO
ci_language	varchar(30)	NO
ci_ethnicity	varchar(30)	NO
ci_bibliographical_citation	varchar(255)	NO
ci_dev	varchar(45)	NO
ci_funding	varchar(45)	NO
ci_rem_freq	int(11)	NO				Reminder Frequency for Intervention
ci_review_share	tinyint(1)	NO	0			Switch for review sharing between users
ci_disabled	char(1)	NO		MUL
ci_creator_usr_id	int(11)	NO		MUL
ci_modifier_usr_id	int(11)	NO		MUL
ci_enabler_usr_id	int(11)	NO		MUL
ci_disabler_usr_id	int(11)	NO		MUL
ci_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
ci_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

ci_id

Table	Column
_1.audits	aud_ci_id
_1.audits_archive	aud_ci_id
_1.clinical_interventions_allergies_map	ciam_ci_id
_1.clinical_interventions_coded_attributes	cica_ci_id
_1.clinical_interventions_cpt_codes_map	ciccm_ci_id
_1.clinical_interventions_ethnicities_map	ciem_ci_id
_1.clinical_interventions_groups_map	cigm_ci_id
_1.clinical_interventions_lab_results_map	cilrm_ci_id
_1.clinical_interventions_medications_map	cimm_ci_id
_1.clinical_interventions_patients_races_map	ciprm_ci_id
_1.clinical_interventions_problems_map	cipm_ci_id
_1.clinical_interventions_resources	cir_ci_id
_1.clinical_interventions_review_map	cirm_ci_id
_1.clinical_interventions_test_codes_map	citcm_ci_id
_1.clinical_interventions_users_map	cium_ci_id
_1.clinical_interventions_vitals_map	civm_ci_id
_1188.audits	aud_ci_id
_1188.audits_archive	aud_ci_id
_1188.clinical_interventions_allergies_map	ciam_ci_id
_1188.clinical_interventions_cpt_codes_map	ciccm_ci_id
_1188.clinical_interventions_ethnicities_map	ciem_ci_id
_1188.clinical_interventions_groups_map	cigm_ci_id
_1188.clinical_interventions_lab_results_map	cilrm_ci_id
_1188.clinical_interventions_medications_map	cimm_ci_id
_1188.clinical_interventions_patients_races_map	ciprm_ci_id
_1188.clinical_interventions_problems_map	cipm_ci_id
_1188.clinical_interventions_resources	cir_ci_id
_1188.clinical_interventions_review_map	cirm_ci_id
_1188.clinical_interventions_test_codes_map	citcm_ci_id
_1188.clinical_interventions_users_map	cium_ci_id
_1188.clinical_interventions_vitals_map	civm_ci_id
_1218.audits	aud_ci_id
_1218.audits_archive	aud_ci_id
_1218.clinical_interventions_allergies_map	ciam_ci_id
_1218.clinical_interventions_cpt_codes_map	ciccm_ci_id
_1218.clinical_interventions_ethnicities_map	ciem_ci_id
_1218.clinical_interventions_groups_map	cigm_ci_id
_1218.clinical_interventions_lab_results_map	cilrm_ci_id
_1218.clinical_interventions_medications_map	cimm_ci_id
_1218.clinical_interventions_patients_races_map	ciprm_ci_id
_1218.clinical_interventions_problems_map	cipm_ci_id
_1218.clinical_interventions_resources	cir_ci_id
_1218.clinical_interventions_review_map	cirm_ci_id
_1218.clinical_interventions_test_codes_map	citcm_ci_id
_1218.clinical_interventions_users_map	cium_ci_id
_1218.clinical_interventions_vitals_map	civm_ci_id
_1548.audits	aud_ci_id
_1548.audits_archive	aud_ci_id
_1548.clinical_interventions_allergies_map	ciam_ci_id
_1548.clinical_interventions_coded_attributes	cica_ci_id
_1548.clinical_interventions_cpt_codes_map	ciccm_ci_id
_1548.clinical_interventions_ethnicities_map	ciem_ci_id
_1548.clinical_interventions_groups_map	cigm_ci_id
_1548.clinical_interventions_lab_results_map	cilrm_ci_id
_1548.clinical_interventions_medications_map	cimm_ci_id
_1548.clinical_interventions_patients_races_map	ciprm_ci_id
_1548.clinical_interventions_problems_map	cipm_ci_id
_1548.clinical_interventions_resources	cir_ci_id
_1548.clinical_interventions_review_map	cirm_ci_id
_1548.clinical_interventions_test_codes_map	citcm_ci_id
_1548.clinical_interventions_users_map	cium_ci_id
_1548.clinical_interventions_vitals_map	civm_ci_id
_435.audits	aud_ci_id
_435.audits_archive	aud_ci_id
_435.clinical_interventions_allergies_map	ciam_ci_id
_435.clinical_interventions_coded_attributes	cica_ci_id
_435.clinical_interventions_cpt_codes_map	ciccm_ci_id
_435.clinical_interventions_ethnicities_map	ciem_ci_id
_435.clinical_interventions_groups_map	cigm_ci_id
_435.clinical_interventions_lab_results_map	cilrm_ci_id
_435.clinical_interventions_medications_map	cimm_ci_id
_435.clinical_interventions_patients_races_map	ciprm_ci_id
_435.clinical_interventions_problems_map	cipm_ci_id
_435.clinical_interventions_resources	cir_ci_id
_435.clinical_interventions_review_map	cirm_ci_id
_435.clinical_interventions_test_codes_map	citcm_ci_id
_435.clinical_interventions_users_map	cium_ci_id
_435.clinical_interventions_vitals_map	civm_ci_id
_436.audits	aud_ci_id
_436.audits_archive	aud_ci_id
_436.clinical_interventions_allergies_map	ciam_ci_id
_436.clinical_interventions_coded_attributes	cica_ci_id
_436.clinical_interventions_cpt_codes_map	ciccm_ci_id
_436.clinical_interventions_ethnicities_map	ciem_ci_id
_436.clinical_interventions_groups_map	cigm_ci_id
_436.clinical_interventions_lab_results_map	cilrm_ci_id
_436.clinical_interventions_medications_map	cimm_ci_id
_436.clinical_interventions_patients_races_map	ciprm_ci_id
_436.clinical_interventions_problems_map	cipm_ci_id
_436.clinical_interventions_resources	cir_ci_id
_436.clinical_interventions_review_map	cirm_ci_id
_436.clinical_interventions_test_codes_map	citcm_ci_id
_436.clinical_interventions_users_map	cium_ci_id
_436.clinical_interventions_vitals_map	civm_ci_id
_436_archive_testing.audits	aud_ci_id
_436_archive_testing.audits_archive	aud_ci_id
_436_archive_testing.clinical_interventions_allergies_map	ciam_ci_id
_436_archive_testing.clinical_interventions_coded_attributes	cica_ci_id
_436_archive_testing.clinical_interventions_cpt_codes_map	ciccm_ci_id
_436_archive_testing.clinical_interventions_ethnicities_map	ciem_ci_id
_436_archive_testing.clinical_interventions_groups_map	cigm_ci_id
_436_archive_testing.clinical_interventions_lab_results_map	cilrm_ci_id
_436_archive_testing.clinical_interventions_medications_map	cimm_ci_id
_436_archive_testing.clinical_interventions_patients_races_map	ciprm_ci_id
_436_archive_testing.clinical_interventions_problems_map	cipm_ci_id
_436_archive_testing.clinical_interventions_resources	cir_ci_id
_436_archive_testing.clinical_interventions_review_map	cirm_ci_id
_436_archive_testing.clinical_interventions_test_codes_map	citcm_ci_id
_436_archive_testing.clinical_interventions_users_map	cium_ci_id
_436_archive_testing.clinical_interventions_vitals_map	civm_ci_id
_437.audits	aud_ci_id
_437.audits_archive	aud_ci_id
_437.clinical_interventions_allergies_map	ciam_ci_id
_437.clinical_interventions_coded_attributes	cica_ci_id
_437.clinical_interventions_cpt_codes_map	ciccm_ci_id
_437.clinical_interventions_ethnicities_map	ciem_ci_id
_437.clinical_interventions_groups_map	cigm_ci_id
_437.clinical_interventions_lab_results_map	cilrm_ci_id
_437.clinical_interventions_medications_map	cimm_ci_id
_437.clinical_interventions_patients_races_map	ciprm_ci_id
_437.clinical_interventions_problems_map	cipm_ci_id
_437.clinical_interventions_resources	cir_ci_id
_437.clinical_interventions_review_map	cirm_ci_id
_437.clinical_interventions_test_codes_map	citcm_ci_id
_437.clinical_interventions_users_map	cium_ci_id
_437.clinical_interventions_vitals_map	civm_ci_id
_8.audits	aud_ci_id
_8.audits_archive	aud_ci_id
_8.clinical_interventions_allergies_map	ciam_ci_id
_8.clinical_interventions_coded_attributes	cica_ci_id
_8.clinical_interventions_cpt_codes_map	ciccm_ci_id
_8.clinical_interventions_ethnicities_map	ciem_ci_id
_8.clinical_interventions_groups_map	cigm_ci_id
_8.clinical_interventions_lab_results_map	cilrm_ci_id
_8.clinical_interventions_medications_map	cimm_ci_id
_8.clinical_interventions_patients_races_map	ciprm_ci_id
_8.clinical_interventions_problems_map	cipm_ci_id
_8.clinical_interventions_resources	cir_ci_id
_8.clinical_interventions_review_map	cirm_ci_id
_8.clinical_interventions_test_codes_map	citcm_ci_id
_8.clinical_interventions_users_map	cium_ci_id
_8.clinical_interventions_vitals_map	civm_ci_id
_81.audits	aud_ci_id
_81.audits_archive	aud_ci_id
_81.clinical_interventions_allergies_map	ciam_ci_id
_81.clinical_interventions_cpt_codes_map	ciccm_ci_id
_81.clinical_interventions_ethnicities_map	ciem_ci_id
_81.clinical_interventions_groups_map	cigm_ci_id
_81.clinical_interventions_lab_results_map	cilrm_ci_id
_81.clinical_interventions_medications_map	cimm_ci_id
_81.clinical_interventions_patients_races_map	ciprm_ci_id
_81.clinical_interventions_problems_map	cipm_ci_id
_81.clinical_interventions_resources	cir_ci_id
_81.clinical_interventions_review_map	cirm_ci_id
_81.clinical_interventions_test_codes_map	citcm_ci_id
_81.clinical_interventions_users_map	cium_ci_id
_81.clinical_interventions_vitals_map	civm_ci_id
_999.audits	aud_ci_id
_999.audits_archive	aud_ci_id
_999.clinical_interventions_allergies_map	ciam_ci_id
_999.clinical_interventions_coded_attributes	cica_ci_id
_999.clinical_interventions_cpt_codes_map	ciccm_ci_id
_999.clinical_interventions_ethnicities_map	ciem_ci_id
_999.clinical_interventions_groups_map	cigm_ci_id
_999.clinical_interventions_lab_results_map	cilrm_ci_id
_999.clinical_interventions_medications_map	cimm_ci_id
_999.clinical_interventions_patients_races_map	ciprm_ci_id
_999.clinical_interventions_problems_map	cipm_ci_id
_999.clinical_interventions_resources	cir_ci_id
_999.clinical_interventions_review_map	cirm_ci_id
_999.clinical_interventions_test_codes_map	citcm_ci_id
_999.clinical_interventions_users_map	cium_ci_id
_999.clinical_interventions_vitals_map	civm_ci_id