ORDER_RES_COMP_CMT

Description: |
This table contains result component value comments for orders that are populated by the Incoming Results Interface. These result component value comments are not populated through Enter/Edit Results. The data in this table is only populated if the result component value normally stored in the Value_Internal (I ORD 2010) item (ORDER_RESULTS.ORD_VALUE or ORDER_RESULTS.ORD_NUM_VALUE) is too long to be stored in that item.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |
CONTACT_DATE_REAL | 2 |
LINE_COMP | 3 |
LINE_COMMENT | 4 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The order ID for this order/procedure.
2 | CONTACT_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
3 | LINE_COMP | INTEGER | No |
The line count associated with the result component. This line number will match with the LINE column in the ORDER_RESULTS table. It is probable that this table will not have all the lines from the ORDER_RESULTS table since this table only contains data for the components that do not have data in item that stores the result component in the Order record.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | COMPONENT_ID | NUMERIC | No |
The unique ID of each result component for each result. Additional data about result components can be found in the CLARITY_COMPONENT table.
6 | COMPONENT_ID_NAME | VARCHAR | No |
The name of the component.
7 | LINE_COMMENT | INTEGER | No |
The line count associated with each line of the result component comments. There can be multiple lines of comments, therefore each line has a line number.
8 | CM_CT_OWNER_ID | VARCHAR | No |
The contact owner deployment of this record; used in Community Model record sharing.
9 | RESULTS_COMP_CMT | VARCHAR | No |
The result component value comments for this order record which are populated by the Incoming Results Interface. These result comments are NOT populated by Enter/Edit Results. This column is populated when the result component values that are normally stored in the result component in the Order record (ORDER_RESULTS.ORD_VALUE or ORDER_RESULTS.ORD_NUM_VALUE) are too long to be stored in the result component in the Order record.