|
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. |
|
|