DOCS_RCVD_RES_INFO

Description: |
The DOCS_RCVD_RES_INFO table contains information about compiled received results such as result time, procedure, status and specimen type.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOCUMENT_ID | NUMERIC | No |
The unique ID of received documents.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | RESULT_INST_CMP_DTTM | DATETIME (Local) | No |
The instant when the result was collected or resulted.
4 | RES_PROC_NAME_CMP | VARCHAR | No |
The free text name of the procedure.
5 | RES_PROC_CMP_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
6 | RESULT_ENC_ID_CMP | VARCHAR | No |
The unique ID of the encounter during which the order took place.
7 | RESULT_KEY_CMP | VARCHAR | No |
The unique key that links other result information to this order.
8 | RES_STATUS_CMP_C_NAME | VARCHAR | No |
The result status category ID for the received information.
May contain organization-specific values: No
Category Entries:
Aborted
Active
Cancelled
Completed
Held
New
Suspended
Nullified
Obsolete
9 | RES_ABN_CMP | VARCHAR | No |
The value that indicates whether this result was flagged as abnormal or normal.
10 | RSLT_SPECIMEN | VARCHAR | No |
Information about the specimen source/type as sent by the outside organization.
11 | RSLT_UNSUCC_FLG_COMP_C_NAME | VARCHAR | No |
Indicates whether a result was deemed an unsuccessful attempt
May contain organization-specific values: No
Category Entries:
Unsuccessful Attempt
Documented on Wrong Patient
12 | RSLT_UNSUCC_INST_COMP_UTC_DTTM | DATETIME (UTC) | No |
The instant the result unsuccessful flag was set