DOCS_RCVD_RES_TEXT

Description: |
The DOCS_RCVD_RES_TEXT table contains textual information about a result.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
DOCUMENT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOCUMENT_ID | NUMERIC | No |
Stores the Received Document record ID.
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | RES_TEXT_KEY_CMP | VARCHAR | No |
The key which links the result text with the order.
4 | RES_TEXT_COMPILED | VARCHAR | No |
A line of text for the result.
5 | RES_TEXT_CAT_CMP_C_NAME | VARCHAR | No |
The internal category identifying what kind of textual information is recorded in this line.
May contain organization-specific values: No
Category Entries:
Component Text
Result Impression
Result Narrative
Other Result Text
Result Transcription
Addendum
Result Comment
Procedure Note
Specimen Comment
Resulting Agency Comment
Image Note
Pathologist Signature
6 | RES_TEXT_SUBID_CMP | VARCHAR | No |
A key used to identify different entries for multiple results of the same type. Lines may match the same result key but will have different sub IDs to identify them as different records.