|
Name |
Type |
Discontinued? |
|
1 |
OR_CASE_ID |
VARCHAR |
No |
|
|
|
The unique ID of the case record. |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The number of the line of the pre-op and post-op appointment that need to be scheduled. |
|
|
3 |
UNIQUE_ID |
VARCHAR |
No |
|
|
|
The unique ID of the appointment that has been scheduled. |
|
|
4 |
APPT_PRC_ID_PRC_NAME |
VARCHAR |
No |
|
|
|
The name of the visit type. |
|
|
5 |
OR_PROC_ID |
VARCHAR |
No |
|
|
|
The unique ID of the related surgical procedure for which the appointment needs to be scheduled. |
|
|
6 |
OR_PROC_ID_PROC_NAME |
VARCHAR |
No |
|
|
|
The name of the surgical procedure record. |
|
|
7 |
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. |
|
|
8 |
DEPT_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
The external name of the department record. This is often used in patient correspondence such as reminder letters. |
|
|
9 |
ASN |
NUMERIC |
No |
|
|
|
The unique appointment serial number associated with the appointment that is scheduled. |
|
|