DOCS_RCVD_RES_SENS
Description:
The DOCS_RCVD_RES_SENS table contains information about compiled results susceptibility.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
This item stores the Received Document record ID.
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 RES_SENS_KEY_CMP VARCHAR No
The key which links the result susceptibility with the order.
4 RES_SENS_ORG_N_CMP VARCHAR No
The free text name of the susceptibility organism.
5 RES_SENS_ORG_CMP_ID NUMERIC No
The internal ID of the organism to which this susceptibility was mapped.
6 RES_SENS_ORG_CMP_ID_NAME VARCHAR No
The name of the organism.
7 RES_SENS_ORG_SUBID VARCHAR No
A unique ID to differentiate multiple tests on the same organism.
8 RES_SENS_ORG_CMT VARCHAR No
The comment for a result organism (populated if a single-line value).
9 RES_SENS_ORG_CMT_SL INTEGER No
The start line for the result organism's comment (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
10 RES_SENS_ORG_CMT_EL INTEGER No
The end line for the result organism's comment (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
11 RES_SENS_ANT_NM_CMP VARCHAR No
The free text name of the antibiotic used.
12 RES_SENS_ANTIB_ID_C_NAME VARCHAR No
The internal category of the antibiotic to which this susceptibility was mapped.
May contain organization-specific values: Yes
13 RES_SENS_SUS_NM_CMP VARCHAR No
The free text name of the susceptibility result.
14 RES_SENS_SUSC_ID_C_NAME VARCHAR No
The internal category of the antibiotic to which this susceptibility was mapped.
May contain organization-specific values: Yes
15 RES_SENS_VALUE_SL INTEGER No
The start line for the result susceptibility value (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
16 RES_SENS_VALUE_EL INTEGER No
The end line for the result susceptibility value (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
17 RES_SENS_CMT_CMP VARCHAR No
The free text comment for this susceptibility.
18 RES_SENS_COMMENT_SL INTEGER No
The start line for the result susceptibility comment (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
19 RES_SENS_COMMENT_EL INTEGER No
The end line for the result susceptibility comment (populated if a multi-line value). The line maps to a line in the DOCS_RCVD_RES_TEXT table.
20 RES_SENS_MTH_NM_CMP VARCHAR No
The free text name of the method used to assess the susceptibility.
21 RES_SEN_MTHD_CMP_ID_PROC_NAME VARCHAR No
The name of each procedure.
22 RES_SENS_SUP_FLAG_YN VARCHAR No
Whether the antibiotic result is hidden from end users when viewed within the patient's chart. Its intended use is to suppress results for broad spectrum or second line agents when the lab system believes there is a viable first line treatment reported.
May contain organization-specific values: No
Category Entries:
No
Yes
23 RES_SENS_ANLYS_UTC_DTTM DATETIME (UTC) No
Timestamp to track per micro result component when it was analyzed in lab.