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