|
Name |
Type |
Discontinued? |
|
1 |
RECORD_ID |
VARCHAR |
No |
|
|
|
The unique ID of the line record. |
|
|
2 |
PREOP_APPT_UID |
VARCHAR |
No |
|
|
|
The unique ID of the pre-op appointment. |
|
|
3 |
PREOP_APPT_VT_ID_PRC_NAME |
VARCHAR |
No |
|
|
|
The name of the visit type. |
|
|
4 |
PREOP_APPT_PROC_ID |
VARCHAR |
No |
|
|
|
The procedure ID of the pre-op appointment. |
|
|
5 |
PREOP_APPT_PROC_ID_PROC_NAME |
VARCHAR |
No |
|
|
|
The name of the surgical procedure record. |
|
|
6 |
PREOP_APPT_PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
7 |
PREOP_APPT_DEPT_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
The external name of the department record. This is often used in patient correspondence such as reminder letters. |
|
|