DOCS_RCVD_RES_INFO

Description:

The DOCS_RCVD_RES_INFO table contains information about compiled received results such as result time, procedure, status and specimen type.

Primary Key

Column Name	Ordinal Position
DOCUMENT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	DOCUMENT_ID	NUMERIC	No
	The unique ID of received documents.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	RESULT_INST_CMP_DTTM	DATETIME (Local)	No
	The instant when the result was collected or resulted.
4	RES_PROC_NAME_CMP	VARCHAR	No
	The free text name of the procedure.
5	RES_PROC_CMP_ID	NUMERIC	No
	The internal ID of the procedure to which this result was mapped. This column links to the CLARITY_EAP table.
6	RESULT_ENC_ID_CMP	VARCHAR	No
	The unique ID of the encounter during which the order took place.
7	RESULT_KEY_CMP	VARCHAR	No
	The unique key that links other result information to this order.
8	RES_STATUS_CMP_C_NAME	VARCHAR	No
	The result status category ID for the received information. May contain organization-specific values: No Category Entries: Aborted Active Cancelled Completed Held New Suspended Nullified Obsolete
9	RES_ABN_CMP	VARCHAR	No
	The value that indicates whether this result was flagged as abnormal or normal.
10	RSLT_SPECIMEN	VARCHAR	No
	Information about the specimen source/type as sent by the outside organization.
11	RSLT_UNSUCC_FLG_COMP_C_NAME	VARCHAR	No
	Indicates whether a result was deemed an unsuccessful attempt May contain organization-specific values: No Category Entries: Unsuccessful Attempt Documented on Wrong Patient
12	RSLT_UNSUCC_INST_COMP_UTC_DTTM	DATETIME (UTC)	No
	The instant the result unsuccessful flag was set