MED_ACCESS_LTK_HISTORY
Description:
History of med access tasks.

Primary Key
Column Name Ordinal Position
ACTIVITY_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ACTIVITY_ID VARCHAR No
The unique identifier (.1 item) for the task record.
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 MEDAC_LTK_STS_C_NAME VARCHAR No
A list of statuses the task has gone through.
May contain organization-specific values: No
Category Entries:
Not Started
Ready To Start
In Progress
Waiting
Done
Not Needed
4 MA_HX_LTK_USER_ID VARCHAR No
The new responsible user at the time the change was made.
5 MA_HX_LTK_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 MA_HX_LTK_IB_POOL_ID NUMERIC No
The new responsible pool at the time the change was made.
7 MA_HX_LTK_IB_POOL_ID_REGISTRY_NAME VARCHAR No
The name of the In Basket registry in the HIP master file.
8 MA_HX_LTK_INST_UTC_DTTM DATETIME (UTC) No
A timestamp for when the change was made.
9 MA_HX_LTK_EDIT_USER_ID VARCHAR No
The user who made the change.
10 MA_HX_LTK_EDIT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
11 MA_HX_MEDAC_LTK_WAITRSN_C_NAME VARCHAR No
The reason the task's status was set to waiting.
May contain organization-specific values: No
Category Entries:
Other
Payer
Patient
Provider