RES_VAL_PTR_RM

Description: |
For a given component this holds all the pointers to the table that stores the multi line 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 values that is associated with the component and the result from the RES_VAL_DATA_RM table. This column can be ignored - it is here for completeness.
4 | CMP_MULTILINE_VALUE | NUMERIC | No |
Stores a list of lines in OVR-52201 which stores data for this line in the component related group. To link tables RES_VAL_PTR_RM to RES_VAL_DATA_RM link the following two sets of columns: - RES_VAL_PTR_RM.RESULT_ID to RES_VAL_DATA_RM.RESULT_ID, and - RES_VAL_PTR_RM.CMP_MULTILINE_VALUE to RES_VAL_DATA_RM.GROUP_LINE