ORDER_SENSITIVITY

Description: |
The ORDER_SENSITIVITY table contains information on the sensitivity of orders placed in clinical system.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_PROC_ID | 1 |
ORD_DATE_REAL | 2 |
LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_PROC_ID | NUMERIC | No |
The unique ID of the procedure order record.
2 | LINE | INTEGER | No |
The line number of the sensitivity data recorded within each procedure record.
3 | ORD_DATE_REAL | FLOAT | No |
This is a numeric representation of the date each order was placed in your system. The integer portion of the number specifies the date the order was placed. The digits after the decimal point indicate multiple orders on one day.
4 | ORD_END_DATE_REAL | FLOAT | No |
This is a numeric representation of the end date for each order in your system. The integer portion of the number specifies the date the order was placed. The digits after the decimal point indicate multiple orders on one day.
5 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
6 | RESULT_DATE | DATETIME | No |
The date the technician ran the tests for each order
7 | ORGANISM_ID | NUMERIC | No |
The ID of the organism that was cultured and tested for susceptibility.
8 | ORGANISM_ID_NAME | VARCHAR | No |
The name of the organism.
9 | ANTIBIOTIC_C_NAME | VARCHAR | No |
The category value of each antibiotic that was tested on each organism culture.
May contain organization-specific values: Yes
10 | SUSCEPT_C_NAME | VARCHAR | No |
The category value associated with the susceptibility of the organism culture to the antibiotic. These correspond to standard HL7 susceptibilities: 1-Resistant, 2-Moderately sensitive, 3-Intermediate, and so on.
May contain organization-specific values: Yes
11 | SENSITIVITY_VALUE | VARCHAR | No |
This item is not populated by the EMR. It may be populated with the sensitivity value from an interface.
12 | LAB_STATUS_C_NAME | VARCHAR | No |
The category value associated with the status of each result, such as 1-In Progress, 2-Preliminary, 3-Final, 4-Edited.
May contain organization-specific values: No
Category Entries:
In process
Preliminary result
Final result
Edited
Edited Result - FINAL
13 | SENS_ORGANISM_SID | VARCHAR | No |
This item will hold the sub ids for each organism helping the application to create a unique data structure for the display of microbiology results. The unique data structure will use this item in conjunction with organism name or id as one of the key subscripts thus preventing errors with the display. E.g. Salmonella typhi (Strain Ty2) and Salmonella typhi (Strain CT18) may have the same name (Salmonella typhi) but will have different sub ids depending on the external system sending the data. In order to display both of the above, a unique sub id is required.
14 | SENS_COM_ORG_RES_ID | NUMERIC | No |
This item stores the RES (Results master file) record id which stores comments related to the organisms. The item is related to the organisms stored in item ORD 2220 and the line number of this item will match directly to the organism line number.
15 | SENS_OBS_INST_TM | DATETIME (Local) | No |
Timestamp to track per micro result component when it was collected/observed.
16 | SENS_ANL_INST_TM | DATETIME (Local) | No |
Timestamp to track per micro result component when it was analyzed in lab.
17 | SENS_START_LN | INTEGER | No |
This columns contains the start line of ORD-2290 (extracted in SENS_LONG_VAL) where the long sensitivity value will begin.
18 | SENS_END_LN | INTEGER | No |
This column contains the end line of ORD-2290(extracted in SENS_LONG_VAL) where the long sensitivity value will terminate.
19 | SENS_COMM | VARCHAR | No |
This column contains a short sensitivity note for ORD-2290 (extracted in SENS_LONG_VAL).
20 | SENS_COMM_START_LN | INTEGER | No |
This column contains the start line in ORD-2290(extracted in SENS_LONG_VAL) of a long sensitivity comment.
21 | SENS_COMM_END_LN | INTEGER | No |
This column contains the end line in ORD-2290(extracted in SENS_LONG_VAL) of a long sensitivity comment.
22 | SENSITIVITY_UNITS | VARCHAR | No |
Indicates units applied for antibiotics on a sensitivity test.
23 | SENS_STATUS_C_NAME | VARCHAR | No |
Indicates the status of a sensitivity test.
May contain organization-specific values: No
Category Entries:
Preliminary
Final
Corrected
Incomplete
24 | ANTIBIO_LNC_ID_LNC_LONG_NAME | VARCHAR | No |
The more readable format than the fully specified name in Logical Observation Identifiers Names and Codes (LOINC®) code.
25 | METHOD_LNC_ID_LNC_LONG_NAME | VARCHAR | No |
The more readable format than the fully specified name in Logical Observation Identifiers Names and Codes (LOINC®) code.
26 | SENS_REF_RANGE | VARCHAR | No |
Indicates the reference range for antibiotics on a sensitivity test.
27 | HIDE_ANTIBIOTIC_YN | VARCHAR | No |
Indicates whether the antibiotic result is hidden from a user when viewed from within the patient’s chart.
May contain organization-specific values: No
Category Entries:
No
Yes
28 | SENS_UNIT_UOM_ID | NUMERIC | No |
Pointer to the UOM (units of measure master file) record that represents the sensitivity's unit.
29 | SENS_UNIT_UOM_ID_UNIT_NAME | VARCHAR | No |
Record name
30 | SENS_METHOD_ID_PROC_NAME | VARCHAR | No |
The name of each procedure.
31 | RESULTING_LAB_ID | NUMERIC | No |
The unique identifier of the resulting agency which is responsible for an antibiotic sensitivity.
32 | RESULTING_LAB_ID_LLB_NAME | VARCHAR | No |
Interface laboratory name.
33 | SENS_ACCR_STAT_YN | VARCHAR | No |
This item determines the accreditation status of the corresponding antibiotic. If set to Y-Yes, the corresponding antibiotic is accredited. If set to N-No, the corresponding antibiotic is not accredited. If null, no evaluation was performed on the antibiotic to determine if it is accredited or not.
The category values for this column were already listed for column: HIDE_ANTIBIOTIC_YN
34 | SENS_INSTR_CONCEPT_IDENT | VARCHAR | No |
Stores the network concept identifier associated with the sensitivity's resulting instrument at the time of verification.
35 | LAB_SENS_KEY_IDENT | VARCHAR | No |
Stores a unique test key representing the lab susceptibility test associated with this sensitivity result.