RES_CMT_DATA_RM

Description:

Stores data for multi line comment item. For a given line data may be spread across multiple lines.

Primary Key

Column Name	Ordinal Position
RESULT_ID	1
GROUP_LINE	2
VALUE_LINE	3

Column Information

	Name	Type	Discontinued?
1	RESULT_ID	VARCHAR	No
	The unique ID of the result record for this row. This column is frequently used to link to the RES_COMPONENTS table or the RES_MICRO_CULTURE table through the RES_CMT_PTR_RM table. For component repeats, link from RES_REPEAT_COMP through the RES_RPT_CMT_PTR_RM table.
2	GROUP_LINE	INTEGER	No
	This contains a link to the RES_CMT_PTR_RM.CMP_MLTLN_USER_CMMT clarity column.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple values that are associated with the result and the component/organism from the RES_CMT_PTR_RM or RES_RPT_CMT_PTR_RM table. This column can be ignored - it is here for completeness.
4	MULTLINE_UC_STG_RAW	VARCHAR	No
	Stores the user comments for a given component. For a category value this would be the ID. Each component can list multiple lines in OVR-51202 (Component Multiline User Comment Pointer) or OVR-53202 (Repeat Component Multiline User Comment Pointer) which are the lines of this item.