ORDER_RESULTS

Description:

This table contains information on results from clinical system orders. This table extracts only the last Orders (ORD) contact for each ORD record.

Primary Key

Column Name	Ordinal Position
ORDER_PROC_ID	1
ORD_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	ORDER_PROC_ID	NUMERIC	No
	The unique ID of the procedure order record.
2	LINE	INTEGER	No
	The line number of each result component within each ordered procedure.
3	ORD_DATE_REAL	FLOAT	No
	This is a numeric representation of the date each order was placed in your system. The integer portion of the number specifies the date the order was placed. The digits after the decimal point indicate multiple orders on one day.
4	ORD_END_DATE_REAL	FLOAT	No
	This is a numeric representation of the end date for each order in your system. The integer portion of the number specifies the date the order was placed. The digits after the decimal point indicate multiple orders on one day.
5	RESULT_DATE	DATETIME	No
	The date the technician ran the tests for each order in calendar format.
6	COMPONENT_ID	NUMERIC	No
	The unique ID of each result component for each result.
7	COMPONENT_ID_NAME	VARCHAR	No
	The name of the component.
8	PAT_ENC_CSN_ID	NUMERIC	No
	A unique serial number for the associated patient encounter. This number is unique across all patients and encounters in the system.
9	ORD_VALUE	VARCHAR	No
	The value returned for each result component, in short free text format. NOTE: This is how the data is stored in the database; as string format. Interface data may come in with alpha characters and this field is designed to store exactly what is stored in the database. This field stores numeric and structured numeric values in M internal format, using a period as the decimal separator irrespective of locale.
10	ORD_NUM_VALUE	FLOAT	No
	A numeric representation of the value returned for each component where applicable. If the value contains any non-numeric characters, the value will display as 9999999.
11	RESULT_FLAG_C_NAME	VARCHAR	No
	The category value associated with a standard HL7 flag code to mark each component result as abnormal. Any value in this field not equal to 1 is considered abnormal. May contain organization-specific values: Yes Category Entries: (NONE) Abnormal Panic Low High Low Panic High Panic Low Off-Scale High Off-Scale Sig Change Up Sig Change Down Better Worse Sensitive Resistant Intermediate Moderately Sensitive Very Sensitive
12	REFERENCE_LOW	VARCHAR	No
	The lowest acceptable value for each result component. If the value in this column is a number or structured numeric, the numbers will be stored in M internal format, using a period as the decimal separator.
13	REFERENCE_HIGH	VARCHAR	No
	The highest acceptable value for each result component. If the value in this column is a number or structured numeric, the numbers will be stored in M internal format, using a period as the decimal separator.
14	REFERENCE_UNIT	VARCHAR	No
	The units for each result component value.
15	RESULT_STATUS_C_NAME	VARCHAR	No
	The category value corresponding to the status of each result record, such as 2-Preliminary, 3-Final, 4-Corrected, 5-Incomplete. May contain organization-specific values: No Category Entries: Preliminary Final Corrected Incomplete
16	RESULT_SUB_IDN	VARCHAR	No
	This item is populated with the unique organism identifier (OVR 700 or interface) when the component of an order result is an organism and can be joined to ORDER_SENSITIVITY.SENS_ORGANISM_SID to identify details about this organism.
17	LAB_STATUS_C_NAME	VARCHAR	No
	The category value associated with the status of each result, such as 1-In Progress, 2-Preliminary, 3-Final, 4-Edited. May contain organization-specific values: No Category Entries: In process Preliminary result Final result Edited Edited Result - FINAL
18	INTERFACE_YN	VARCHAR	No
	This Yes/No flag identifies whether each order was resulted through an interface. The field will display "Y" if the result came through an interface, otherwise the field will display "N". May contain organization-specific values: No Category Entries: Yes No
19	RESULTING_LAB_ID	NUMERIC	No
	The Unique ID of the Lab running the test.
20	RESULTING_LAB_ID_LLB_NAME	VARCHAR	No
	Interface laboratory name.
21	COMPONENT_COMMENT	VARCHAR	No
	Contains the comments associated with a order COMPONENT_ID, i.e. this is the comments associated with a specific order component's results. If comment data is too long to fit in this item, then the comments will be found in the ORDER_RES_COMMENT table.
22	RESULT_IN_RANGE_YN	VARCHAR	No
	A Yes/No category value to indicate whether a result has been verified to be within its reference range. This item is set by the interface when the result is sent. A null value is equivalent to a "no" value. May contain organization-specific values: No Category Entries: No Yes
23	REF_NORMAL_VALS	VARCHAR	No
	This is a free-text item which allows you to enter a reference range without tying it to a "low" or "high" value. For example, it could be a string ("negative"), a list of choices ("Yellow, orange"), or a descriptive range ("Less than 20"). The values entered in this range should always represent the "normal" values. This item will be displayed in Results Review as the reference range, superseding any values in the low or high items. It may also be displayed in reports, if the print groups are configured to use it. Multiple responses are permitted (one per line). If the value in this column is a number or structured numeric, the numbers will be stored in M internal format using a period as the decimal separator.
24	LRR_BASED_ORGAN_ID	NUMERIC	No
	Used for storing discrete organisms. This item is used for storing isolated organisms at the component level. There may be cases where an isolated organism does not undergo sensitivity tests and therefore is only stored at the component level. Organisms with sensitivities are also stored in addition to this item.
25	LRR_BASED_ORGAN_ID_NAME	VARCHAR	No
	The name of the organism.
26	COMP_RES_TECHNICIA	VARCHAR	No
	ID of the Resulting Lab Technician.
27	VALUE_NORMALIZED	VARCHAR	No
	Will contain the structured numeric result value in a delimited structured numeric format. Numbers will be in M internal format. The delimited structured numeric value is the user entered structured numeric value converted to a delimited format. Valid structured numeric formats are range, operator followed by number, and number followed by operator the value stored in this item is of the format: operator1_$c(16)_number1_$c(16)_operator2_$c(16)_number2.
28	NUMERIC_PRECISION	NUMERIC	No
	The number of decimal digits to the right of the decimal point.
29	COMP_OBS_INST_TM	DATETIME (Local)	No
	Timestamp to track per non-micro result component when it was collected/observed.
30	COMP_ANL_INST_TM	DATETIME (Local)	No
	Timestamp to track per non-micro result component when it was analyzed in lab.
31	RESULT_VAL_START_LN	INTEGER	No
	For multi-line results holds the starting line number of RESULTS_CMT column from ORDER_RES_COMMENT table, where the result values begin. This column is simply an indicator of the line number(s) where a result is stored.
32	RESULT_VAL_END_LN	INTEGER	No
	For multi-line results holds the ending line number of RESULTS_CMT column from ORDER_RES_COMMENT table, where the result values begin. This column is simply an indicator of the line number(s) where a result is stored.
33	RESULT_CMT_START_LN	INTEGER	No
	For multi-line results holds the starting line number of RESULTS_CMT column from ORDER_RES_COMMENT table, where the result values begin. This column is simply an indicator of the line number(s) where a result is stored.
34	RESULT_CMT_END_LN	INTEGER	No
	For multi-line results holds the ending line number of RESULTS_CMT column from ORDER_RES_COMMENT table, where the result values begin. This column is simply an indicator of the line number(s) where a result is stored.
35	ORD_RAW_VALUE	VARCHAR	No
	Stores the raw value of a numeric result as entered by the user. The value stored here and in column ORD_VALUE will be different in international locales for numeric data if the decimal separator used in that locale is a comma instead of a period. This is because ORD_VALUE will store numeric values in the M internal format.
36	RAW_LOW	VARCHAR	No
	Stores raw value of the minimum value of the result component mentioned in column REFERENCE_LOW. The value stored here and in REFERENCE_LOW will be different in international locales for numeric data if the decimal separator used in that locale is a comma instead of a period. This is because REFERENCE_LOW will store numeric data in M internal format.
37	RAW_HIGH	VARCHAR	No
	Stores raw value of the maximum value of the result component mentioned in column REFERENCE_HIGH. The value stored here and in REFERENCE_HIGH will be different in international locales for numeric data if the decimal separator used in that locale is a comma instead of a period. This is because REFERENCE_HIGH will store numeric data in M internal format.
38	RAW_REF_VALS	VARCHAR	No
	This column stores the raw value of REF_NORMAL_VALS (i.e. the reference normal values of the result component). Since REF_NORMAL_VALS will store numeric data in M internal format, the value stored here and in REF_NORMAL_VALS will be different in international locales if the decimal separator used in that locale is a comma instead of a period.
39	ORGANISM_QUANTITY	VARCHAR	No
	This item is used for storing isolated organisms at the component level. It contains the numeric or qualitative quantity of the organism that was observed.
40	ORGANISM_QUANTITY_UNIT	VARCHAR	No
	This item is used for storing isolated organisms at the component level. It contains the unit associated with the quantity of the organism that was observed.
41	COMPON_LNC_ID_LNC_LONG_NAME	VARCHAR	No
	The more readable format than the fully specified name in Logical Observation Identifiers Names and Codes (LOINC®) code.
42	COMPON_LNC_SRC_C_NAME	VARCHAR	No
	Source of the component Logical Observation Identifiers Names and Codes (LOINC) ID. May contain organization-specific values: No Category Entries: Reported Inferred
43	COMP_SNOMED_SRC_C_NAME	VARCHAR	No
	Source of the Systemized Nomenclature of Medicine – Clinical Terms (SNOMED) code (reported vs inferred). The category values for this column were already listed for column: COMPON_LNC_SRC_C_NAME
44	REF_UNIT_UOM_ID	NUMERIC	No
	Pointer to the record that represents the component's units of measure.
45	REF_UNIT_UOM_ID_UNIT_NAME	VARCHAR	No
	Record name
46	REF_RANGE_TYPE	VARCHAR	No
	Displays the type of the reference range.
47	ORGANISM_SNOMED_CT	VARCHAR	No
	The Systemized Nomenclature of Medicine – Clinical Terms (SNOMED) code for the component's organism.
48	ORGANISM_QUANTITY_SNOMED_CT	VARCHAR	No
	The Systemized Nomenclature of Medicine – Clinical Terms (SNOMED) code for the component's organism quantity.
49	PERFORMING_ORG_INFO_LINE	INTEGER	No
	This is used to indicate the performing organization information for the component. This item stores the line number of the ORD related group which is used to save the performing organization information.
50	COMPON_EXCL_CDS_YN	VARCHAR	No
	To cache if the component has a value or comment that matches a value in Excluded result text (I LSD 768). The category values for this column were already listed for column: RESULT_IN_RANGE_YN
51	RTF_VAL_START_LINE	INTEGER	No
	If the component result value is rich text, this column gives the first line of ORD_RTF_VAL_CMT that the value is stored in.
52	RTF_VAL_END_LINE	INTEGER	No
	If the component result value is rich text, this column gives the last line of ORD_RTF_VAL_CMT that the value is stored in.
53	RTF_CMT_START_LINE	INTEGER	No
	If the component comment is rich text, this column gives the first line of ORD_RTF_VAL_CMT that the component comment is stored in.
54	RTF_CMT_END_LINE	INTEGER	No
	If the component comment is rich text, this column gives the last line of ORD_RTF_VAL_CMT that the component comment is stored in.
55	RSLT_ACCR_FLAG_YN	VARCHAR	No
	This item determines the accreditation status of the corresponding component. If set to Y-Yes, the corresponding component is accredited. If set to N-No, the corresponding component is not accredited. If null, no evaluation was performed on the component to determine if it is accredited or not. The category values for this column were already listed for column: RESULT_IN_RANGE_YN
56	SIGNATURE_START_LN	INTEGER	No
	Gives the first line of I ORD 2090 that signatures for the related component are stored in
57	SIGNATURE_END_LN	INTEGER	No
	Gives the last line of I ORD 2090 that signatures for the related component are stored in
58	RES_INSTR_CONCEPT_IDENT	VARCHAR	No
	Stores the network concept identifier associated with the component's resulting instrument at the time of verification.
59	RESULT_TREND_C_NAME	VARCHAR	No
	Trend status for the common name at the time logged in I ORD 2057 - Result Trend Audit Instant. May contain organization-specific values: No Category Entries: Stable Not Stable
60	RESULT_TREND_UTC_DTTM	DATETIME (UTC)	No
	Instant trend status (I ORD 2056) was set.
61	RESULT_TREND_NAME	VARCHAR	No
	Common name for which trend status (I ORD 2056) was calculated.