ORDER_RES_FOLLOWUP

Description: |
Table for lab follow-up tasks.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FINDING_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FINDING_ID | NUMERIC | No |
The unique ID of the Result Finding record.
2 | LAB_STATUS_C_NAME | VARCHAR | No |
The status category number for the lab follow-up task.
May contain organization-specific values: No
Category Entries:
Completed
Open
3 | LAB_ASSIGNED_EMP_ID | VARCHAR | No |
The unique ID of the user who is assigned responsibility for the follow-up task.
4 | LAB_ASSIGNED_EMP_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | LAB_SPECIMEN_ID | VARCHAR | No |
The unique ID of the specimen that is associated with this follow-up task.
6 | LAB_TEST_ID_TEST_NAME | VARCHAR | No |
The name of the test record.
7 | LAB_ORDER_ID | NUMERIC | No |
The unique ID of the order that is associated with the comm log follow-up task.
8 | LAB_ADD_INSTANT | DATETIME (Local) | No |
The instant when the follow-up task was added or reopened.
9 | LAB_REQUISITION_ID | NUMERIC | No |
The unique ID of the requisition that is associated with this follow-up task.
10 | LAB_TYPE_REQ_FOLL_C_NAME | VARCHAR | No |
The follow-up type category number for the lab requisition follow-up task.
May contain organization-specific values: Yes
Category Entries:
General Follow-up
Missing Items
Duplicate Entry
Reconcile Duplicate Entry
Missing Collection Items
Submitter Changed
Changed Recipient
QC Review
Held Interfaced Results
Patient Merged or Contact Moved
Unknown Submitter
Unmapped Location-Specific Provider ID
Comm Log
Critical Result Communication
Intra-op Result Communication
11 | LAB_ADDING_EMP_ID | VARCHAR | No |
The unique ID of the user who is responsible for adding the follow-up task to the list.
12 | LAB_ADDING_EMP_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
13 | LAB_REMOVE_EMP_ID | VARCHAR | No |
The unique ID of the user who is responsible for removing the follow-up task from the list.
14 | LAB_REMOVE_EMP_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
15 | LAB_REQ_MISSING_ITM | VARCHAR | No |
List of missing required requisition items.
16 | LAB_REC_MISSING_ITM | VARCHAR | No |
List of missing recommended requisition items.
17 | RESULT_TYPE_C_NAME | VARCHAR | No |
The result type category number for the lab follow-up task.
May contain organization-specific values: No
Category Entries:
Endoscopy Finding
Sensitivity Comments
BLOOD - Single Division
Joint Exam
Tympanogram Result
Audiogram Result
Speech Audiometry
Acoustic Reflex
Auditory Brainstem Response
Auditory Evoked Potentials
Newborn Hearing Screening
Lab Follow-Up
Lab Comm Log
Lab Requisition
RIS General Breast Problem
RIS Mammo Mass
RIS Mammo Calcification
RIS Mammo Architectural Distortion
RIS Mammo Asymmetric Density
RIS Mammo Misc
RIS Mammo Result
RIS Mammo Recommendations
Pathology Result
Lesion
RIS Result Finding Follow-up
RIS General Recommendations
Finding
Screening Program Pathology
Screening Program Recommendation
RIS Unverified Result Finding Follow Up
RIS Unverified General Recommendation
Unverified Screening Program Recommendation
Observation
Observation Instance
Dermatology Finding
Cataract Lens Calculation
Anatomy
Dental Finding
Dental Procedure
Soft Tissue Finding
Soft Tissue Group Finding
Orthodontics Appliance
18 | LAB_DUE_TM | DATETIME (Local) | No |
The current due time for this lab follow-up task.
19 | LAB_START_TM | DATETIME (Local) | No |
The current start time for this lab follow-up task.
20 | LAB_REQ_GRP_ID | NUMERIC | No |
The unique ID of the requisition grouper that is associated with this follow-up task.
21 | LAB_REMOVE_TM | DATETIME (Local) | No |
The time the follow-up task was removed from the work list.
22 | LAB_ACTION_DT | DATETIME | No |
The date the next action will be executed for this follow-up record.
23 | LAB_ACTION_ID | NUMERIC | No |
The unique ID of the follow-up action record that will be triggered at the next action date.
24 | LAB_ACTION_ID_RECORD_NAME | VARCHAR | No |
The name of the node record.
25 | ASSOC_LABORATORY_ID_LAB_NAME | VARCHAR | No |
The name of the lab record.
26 | LAB_FU_SUBM_ID | NUMERIC | No |
The unique ID of the submitter that is associated with this follow-up task record.
27 | LAB_FU_SUBM_ID_RECORD_NAME | VARCHAR | No |
The name of the submitter record.
28 | LAB_RMV_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
Indicates the UTC instant a task was removed from the work list.
29 | LAB_DUE_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
Lab follow-up task due instant in UTC
30 | LAB_START_INST_UTC_DTTM | DATETIME (UTC) | No |
Lab follow-up task start instant in UTC
31 | LAB_ADD_INSTANT_UTC_DTTM | DATETIME (UTC) | No |
Indicates the UTC instant a task was added to the work list, either initially or when a previously closed task was re-opened.
32 | TEST_LINE | INTEGER | No |
The test line on the specimen that the follow-up is associated with. This column can be used with the LAB_SPECIMEN_ID column to join to the SPEC_TEST_REL table.