_81.hl7_results

Field	Type	Null	Default	Key	Extra	Comment
res_id	int(11)	NO		PRI	auto_increment
res_cus_id	int(11)	NO	0	MUL
res_cli_id	int(11)	NO	0	MUL
res_pat_id	int(11)	NO	0	MUL		Patient ID#
res_enc_id	int(11)	NO	0	MUL		Encounter ID#
res_acc_id	int(11)	NO	0	MUL
res_ord_id	int(11)	NO	0	MUL
res_lips_id	int(11)	YES
res_seq_num	smallint(6)	NO	0
res_seq_num2	smallint(6)	NO
res_data_value_type	varchar(2)	NO
res_cs_id	int(11)	NO	10			Coding System ID#
res_code	varchar(45)	NO		MUL		Standard code for a result. res_cs_id applies to this
res_tcr_id	int(11)	NO	0
res_observ_id	varchar(20)	NO		MUL
res_observ_name	varchar(128)	NO
res_observ_result	varchar(80)	NO
res_observ_result_desc	varchar(80)	YES
res_observ_units	varchar(40)	NO
res_observ_result_cs_id	int(11)	NO	0			Code System id for code result values
res_observ_range	varchar(60)	NO
res_flags	varchar(5)	NO
res_status	char(1)	NO
res_charge_code	varchar(10)	NO
res_lab_key	varchar(10)	NO
res_education_provided	char(1)	NO
res_org_id	int(11)	NO
res_type_code_id	char(11)	NO
res_reported_dt	datetime	YES		MUL		Time results are recorded in system
res_reported	tinyint(1)	NO	1			Indicates if Free Result is fully reported
res_modified	timestamp	YES	CURRENT_TIMESTAMP		on update CURRENT_TIMESTAMP
res_created	timestamp	YES	CURRENT_TIMESTAMP

References

Local Column

References

res_id

Table	Column
_1.audits	aud_rad_res_id
_1.audits_archive	aud_rad_res_id
_1.cpoe_responses	cpoe_res_id
_1.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_1.cqm_entries	cqme_res_id
_1.encounters_edi_errors	eep_res_id
_1.hl7_notes	not_res_id
_1.radiology_orders	rad_rad_res_id
_1.radiology_orders_test_codes_map	rtcm_rad_res_id
_1.radiology_results	rad_res_id
_1.radiology_results_docs	rrdoc_rad_res_id
_1.radiology_results_notes	rrnot_rad_res_id
_1.radiology_results_signed	rrsig_rad_res_id
_1.radiology_results_test_codes_map	rrtcm_rad_res_id
_1.radiology_results_test_codes_results	rrtcres_rad_res_id
_1188.audits	aud_rad_res_id
_1188.audits_archive	aud_rad_res_id
_1188.cpoe_responses	cpoe_res_id
_1188.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_1188.cqm_entries	cqme_res_id
_1188.encounters_edi_errors	eep_res_id
_1188.hl7_notes	not_res_id
_1188.radiology_orders	rad_rad_res_id
_1188.radiology_orders_test_codes_map	rtcm_rad_res_id
_1188.radiology_results	rad_res_id
_1188.radiology_results_docs	rrdoc_rad_res_id
_1188.radiology_results_notes	rrnot_rad_res_id
_1188.radiology_results_signed	rrsig_rad_res_id
_1188.radiology_results_test_codes_map	rrtcm_rad_res_id
_1188.radiology_results_test_codes_results	rrtcres_rad_res_id
_1218.audits	aud_rad_res_id
_1218.audits_archive	aud_rad_res_id
_1218.cpoe_responses	cpoe_res_id
_1218.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_1218.cqm_entries	cqme_res_id
_1218.encounters_edi_errors	eep_res_id
_1218.hl7_notes	not_res_id
_1218.radiology_orders	rad_rad_res_id
_1218.radiology_orders_test_codes_map	rtcm_rad_res_id
_1218.radiology_results	rad_res_id
_1218.radiology_results_docs	rrdoc_rad_res_id
_1218.radiology_results_notes	rrnot_rad_res_id
_1218.radiology_results_signed	rrsig_rad_res_id
_1218.radiology_results_test_codes_map	rrtcm_rad_res_id
_1218.radiology_results_test_codes_results	rrtcres_rad_res_id
_1548.audits	aud_rad_res_id
_1548.audits_archive	aud_rad_res_id
_1548.cpoe_responses	cpoe_res_id
_1548.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_1548.cqm_entries	cqme_res_id
_1548.encounters_edi_errors	eep_res_id
_1548.hl7_notes	not_res_id
_1548.radiology_orders	rad_rad_res_id
_1548.radiology_orders_test_codes_map	rtcm_rad_res_id
_1548.radiology_results	rad_res_id
_1548.radiology_results_docs	rrdoc_rad_res_id
_1548.radiology_results_notes	rrnot_rad_res_id
_1548.radiology_results_signed	rrsig_rad_res_id
_1548.radiology_results_test_codes_map	rrtcm_rad_res_id
_1548.radiology_results_test_codes_results	rrtcres_rad_res_id
_435.audits	aud_rad_res_id
_435.audits_archive	aud_rad_res_id
_435.cpoe_responses	cpoe_res_id
_435.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_435.cqm_entries	cqme_res_id
_435.encounters_edi_errors	eep_res_id
_435.hl7_notes	not_res_id
_435.radiology_orders	rad_rad_res_id
_435.radiology_orders_test_codes_map	rtcm_rad_res_id
_435.radiology_results	rad_res_id
_435.radiology_results_docs	rrdoc_rad_res_id
_435.radiology_results_notes	rrnot_rad_res_id
_435.radiology_results_signed	rrsig_rad_res_id
_435.radiology_results_test_codes_map	rrtcm_rad_res_id
_435.radiology_results_test_codes_results	rrtcres_rad_res_id
_436.audits	aud_rad_res_id
_436.audits_archive	aud_rad_res_id
_436.cpoe_responses	cpoe_res_id
_436.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_436.cqm_entries	cqme_res_id
_436.encounters_edi_errors	eep_res_id
_436.hl7_notes	not_res_id
_436.radiology_orders	rad_rad_res_id
_436.radiology_orders_test_codes_map	rtcm_rad_res_id
_436.radiology_results	rad_res_id
_436.radiology_results_docs	rrdoc_rad_res_id
_436.radiology_results_notes	rrnot_rad_res_id
_436.radiology_results_signed	rrsig_rad_res_id
_436.radiology_results_test_codes_map	rrtcm_rad_res_id
_436.radiology_results_test_codes_results	rrtcres_rad_res_id
_436_archive_testing.audits	aud_rad_res_id
_436_archive_testing.audits_archive	aud_rad_res_id
_436_archive_testing.cpoe_responses	cpoe_res_id
_436_archive_testing.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_436_archive_testing.cqm_entries	cqme_res_id
_436_archive_testing.encounters_edi_errors	eep_res_id
_436_archive_testing.hl7_notes	not_res_id
_436_archive_testing.radiology_orders	rad_rad_res_id
_436_archive_testing.radiology_orders_test_codes_map	rtcm_rad_res_id
_436_archive_testing.radiology_results	rad_res_id
_436_archive_testing.radiology_results_docs	rrdoc_rad_res_id
_436_archive_testing.radiology_results_notes	rrnot_rad_res_id
_436_archive_testing.radiology_results_signed	rrsig_rad_res_id
_436_archive_testing.radiology_results_test_codes_map	rrtcm_rad_res_id
_436_archive_testing.radiology_results_test_codes_results	rrtcres_rad_res_id
_437.audits	aud_rad_res_id
_437.audits_archive	aud_rad_res_id
_437.cpoe_responses	cpoe_res_id
_437.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_437.cqm_entries	cqme_res_id
_437.encounters_edi_errors	eep_res_id
_437.hl7_notes	not_res_id
_437.radiology_orders	rad_rad_res_id
_437.radiology_orders_test_codes_map	rtcm_rad_res_id
_437.radiology_results	rad_res_id
_437.radiology_results_docs	rrdoc_rad_res_id
_437.radiology_results_notes	rrnot_rad_res_id
_437.radiology_results_signed	rrsig_rad_res_id
_437.radiology_results_test_codes_map	rrtcm_rad_res_id
_437.radiology_results_test_codes_results	rrtcres_rad_res_id
_8.audits	aud_rad_res_id
_8.audits_archive	aud_rad_res_id
_8.cpoe_responses	cpoe_res_id
_8.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_8.cqm_entries	cqme_res_id
_8.encounters_edi_errors	eep_res_id
_8.hl7_notes	not_res_id
_8.radiology_orders	rad_rad_res_id
_8.radiology_orders_test_codes_map	rtcm_rad_res_id
_8.radiology_results	rad_res_id
_8.radiology_results_docs	rrdoc_rad_res_id
_8.radiology_results_notes	rrnot_rad_res_id
_8.radiology_results_signed	rrsig_rad_res_id
_8.radiology_results_test_codes_map	rrtcm_rad_res_id
_8.radiology_results_test_codes_results	rrtcres_rad_res_id
_81.audits	aud_rad_res_id
_81.audits_archive	aud_rad_res_id
_81.cpoe_responses	cpoe_res_id
_81.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_81.cqm_entries	cqme_res_id
_81.encounters_edi_errors	eep_res_id
_81.hl7_notes	not_res_id
_81.radiology_orders	rad_rad_res_id
_81.radiology_orders_test_codes_map	rtcm_rad_res_id
_81.radiology_results	rad_res_id
_81.radiology_results_docs	rrdoc_rad_res_id
_81.radiology_results_notes	rrnot_rad_res_id
_81.radiology_results_signed	rrsig_rad_res_id
_81.radiology_results_test_codes_map	rrtcm_rad_res_id
_81.radiology_results_test_codes_results	rrtcres_rad_res_id
_999.audits	aud_rad_res_id
_999.audits_archive	aud_rad_res_id
_999.cpoe_responses	cpoe_res_id
_999.cpoe_responses_test_codes_map	cpoe_restc_cpoe_res_id
_999.cqm_entries	cqme_res_id
_999.encounters_edi_errors	eep_res_id
_999.hl7_notes	not_res_id
_999.radiology_orders	rad_rad_res_id
_999.radiology_orders_test_codes_map	rtcm_rad_res_id
_999.radiology_results	rad_res_id
_999.radiology_results_docs	rrdoc_rad_res_id
_999.radiology_results_notes	rrnot_rad_res_id
_999.radiology_results_signed	rrsig_rad_res_id
_999.radiology_results_test_codes_map	rrtcm_rad_res_id
_999.radiology_results_test_codes_results	rrtcres_rad_res_id

res_cus_id

Table	Column
_1.cpoe_responses	cpoe_res_cus_id
_1.radiology_results	rad_res_cus_id
_1188.cpoe_responses	cpoe_res_cus_id
_1188.radiology_results	rad_res_cus_id
_1218.cpoe_responses	cpoe_res_cus_id
_1218.radiology_results	rad_res_cus_id
_1548.cpoe_responses	cpoe_res_cus_id
_1548.radiology_results	rad_res_cus_id
_435.cpoe_responses	cpoe_res_cus_id
_435.radiology_results	rad_res_cus_id
_436.cpoe_responses	cpoe_res_cus_id
_436.radiology_results	rad_res_cus_id
_436_archive_testing.cpoe_responses	cpoe_res_cus_id
_436_archive_testing.radiology_results	rad_res_cus_id
_437.cpoe_responses	cpoe_res_cus_id
_437.radiology_results	rad_res_cus_id
_8.cpoe_responses	cpoe_res_cus_id
_8.radiology_results	rad_res_cus_id
_81.cpoe_responses	cpoe_res_cus_id
_81.radiology_results	rad_res_cus_id
_999.cpoe_responses	cpoe_res_cus_id
_999.radiology_results	rad_res_cus_id

res_cli_id

Table	Column
_1.cpoe_responses	cpoe_res_cli_id
_1.radiology_results	rad_res_cli_id
_1188.cpoe_responses	cpoe_res_cli_id
_1188.radiology_results	rad_res_cli_id
_1218.cpoe_responses	cpoe_res_cli_id
_1218.radiology_results	rad_res_cli_id
_1548.cpoe_responses	cpoe_res_cli_id
_1548.radiology_results	rad_res_cli_id
_435.cpoe_responses	cpoe_res_cli_id
_435.radiology_results	rad_res_cli_id
_436.cpoe_responses	cpoe_res_cli_id
_436.radiology_results	rad_res_cli_id
_436_archive_testing.cpoe_responses	cpoe_res_cli_id
_436_archive_testing.radiology_results	rad_res_cli_id
_437.cpoe_responses	cpoe_res_cli_id
_437.radiology_results	rad_res_cli_id
_8.cpoe_responses	cpoe_res_cli_id
_8.radiology_results	rad_res_cli_id
_81.cpoe_responses	cpoe_res_cli_id
_81.radiology_results	rad_res_cli_id
_999.cpoe_responses	cpoe_res_cli_id
_999.radiology_results	rad_res_cli_id

res_pat_id

Table	Column
_1.cpoe_responses	cpoe_res_pat_id
_1.radiology_results	rad_res_pat_id
_1188.cpoe_responses	cpoe_res_pat_id
_1188.radiology_results	rad_res_pat_id
_1218.cpoe_responses	cpoe_res_pat_id
_1218.radiology_results	rad_res_pat_id
_1548.cpoe_responses	cpoe_res_pat_id
_1548.radiology_results	rad_res_pat_id
_435.cpoe_responses	cpoe_res_pat_id
_435.radiology_results	rad_res_pat_id
_436.cpoe_responses	cpoe_res_pat_id
_436.radiology_results	rad_res_pat_id
_436_archive_testing.cpoe_responses	cpoe_res_pat_id
_436_archive_testing.radiology_results	rad_res_pat_id
_437.cpoe_responses	cpoe_res_pat_id
_437.radiology_results	rad_res_pat_id
_8.cpoe_responses	cpoe_res_pat_id
_8.radiology_results	rad_res_pat_id
_81.cpoe_responses	cpoe_res_pat_id
_81.radiology_results	rad_res_pat_id
_999.cpoe_responses	cpoe_res_pat_id
_999.radiology_results	rad_res_pat_id

res_status

Table	Column
_1.cpoe_responses	cpoe_res_status
_1.radiology_results	rad_res_status
_1188.cpoe_responses	cpoe_res_status
_1188.radiology_results	rad_res_status
_1218.cpoe_responses	cpoe_res_status
_1218.radiology_results	rad_res_status
_1548.cpoe_responses	cpoe_res_status
_1548.radiology_results	rad_res_status
_435.cpoe_responses	cpoe_res_status
_435.radiology_results	rad_res_status
_436.cpoe_responses	cpoe_res_status
_436.radiology_results	rad_res_status
_436_archive_testing.cpoe_responses	cpoe_res_status
_436_archive_testing.radiology_results	rad_res_status
_437.cpoe_responses	cpoe_res_status
_437.radiology_results	rad_res_status
_8.cpoe_responses	cpoe_res_status
_8.radiology_results	rad_res_status
_81.cpoe_responses	cpoe_res_status
_81.radiology_results	rad_res_status
_999.cpoe_responses	cpoe_res_status
_999.radiology_results	rad_res_status

res_modified

Table	Column
_1.cpoe_responses	cpoe_res_modified
_1.radiology_results	rad_res_modified
_1188.cpoe_responses	cpoe_res_modified
_1188.radiology_results	rad_res_modified
_1218.cpoe_responses	cpoe_res_modified
_1218.radiology_results	rad_res_modified
_1548.cpoe_responses	cpoe_res_modified
_1548.radiology_results	rad_res_modified
_435.cpoe_responses	cpoe_res_modified
_435.radiology_results	rad_res_modified
_436.cpoe_responses	cpoe_res_modified
_436.radiology_results	rad_res_modified
_436_archive_testing.cpoe_responses	cpoe_res_modified
_436_archive_testing.radiology_results	rad_res_modified
_437.cpoe_responses	cpoe_res_modified
_437.radiology_results	rad_res_modified
_8.cpoe_responses	cpoe_res_modified
_8.radiology_results	rad_res_modified
_81.cpoe_responses	cpoe_res_modified
_81.radiology_results	rad_res_modified
_999.cpoe_responses	cpoe_res_modified
_999.radiology_results	rad_res_modified

res_created

Table	Column
_1.cpoe_responses	cpoe_res_created
_1.radiology_results	rad_res_created
_1188.cpoe_responses	cpoe_res_created
_1188.radiology_results	rad_res_created
_1218.cpoe_responses	cpoe_res_created
_1218.radiology_results	rad_res_created
_1548.cpoe_responses	cpoe_res_created
_1548.radiology_results	rad_res_created
_435.cpoe_responses	cpoe_res_created
_435.radiology_results	rad_res_created
_436.cpoe_responses	cpoe_res_created
_436.radiology_results	rad_res_created
_436_archive_testing.cpoe_responses	cpoe_res_created
_436_archive_testing.radiology_results	rad_res_created
_437.cpoe_responses	cpoe_res_created
_437.radiology_results	rad_res_created
_8.cpoe_responses	cpoe_res_created
_8.radiology_results	rad_res_created
_81.cpoe_responses	cpoe_res_created
_81.radiology_results	rad_res_created
_999.cpoe_responses	cpoe_res_created
_999.radiology_results	rad_res_created