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 NUMERIC No
The internal ID of the procedure that was used to assess the susceptibility.