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
Comm Log
Critical 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
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
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.