RES_CMT_PTR_RM

Description:

For a given line this holds all the pointers to the table that stores the multi line comment data.

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.
2	GROUP_LINE	INTEGER	No
	This is the component line number from the RES_COMPONENTS table. Use the RESULT_ID to link the RES_COMPONENTS table to this table in addition to the GROUP_LINE.
3	VALUE_LINE	INTEGER	No
	The line number of one of the multiple comments that are associated with the component/organism and the result from the RES_CMT_DATA_RM table. This column can be ignored - it is here for completeness.
4	CMP_MLTLN_USER_CMMT	NUMERIC	No
	Stores a list of lines in OVR-52202 which store data for this line in the component related group. To link tables RES_CMT_PTR_RM to RES_CMT_DATA_RM link the following two sets of columns: - RES_CMT_PTR_RM.RESULT_ID to RES_CMT_DATA_RM.RESULT_ID, and - RES_CMT_PTR_RM.CMP_MLTLN_USER_CMMT to RES_CMT_DATA_RM.GROUP_LINE