|
Name |
Type |
Discontinued? |
|
1 |
REGIMEN_ID |
NUMERIC |
No |
|
|
|
The unique ID of the visit record for this row. |
|
|
2 |
VISIT_TREATMENT_ID |
NUMERIC |
No |
|
|
|
The unique ID of the treatment that contains a visit. |
|
|
3 |
VISIT_SPACING_DAYS |
INTEGER |
No |
|
|
|
The requested number of days between scheduled visits. |
|
|
4 |
VISIT_SCHE_INSTRUCT |
VARCHAR |
No |
|
|
|
The scheduling instructions for a visit. |
|
|
5 |
VISIT_APPT_LENGTH |
INTEGER |
No |
|
|
|
The requested appointment length for a visit. |
|
|
6 |
VISIT_APPOINTMENT |
NUMERIC |
No |
|
|
|
The unique contact serial number (CSN) for the appointment that is linked to a visit. |
|
|
7 |
VISIT_ORDER_NUMBER |
INTEGER |
No |
|
|
|
The relative order of a visit within the containing treatment. |
|
|
8 |
DENT_SCHED_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
Indicates the scheduling status of a visit |
May contain organization-specific values: No |
Category Entries: |
Needs Scheduling |
Scheduled |
Modified |
Canceled |
Completed |
Referred |
Declined |
|
|
9 |
DENT_REQ_DATE |
DATETIME |
No |
|
|
|
Date requested by provider to schedule visit |
|
|
10 |
DENT_VISIT_TYPE_ID_PRC_NAME |
VARCHAR |
No |
|
|
|
The name of the visit type. |
|
|
11 |
DENT_VISIT_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. |
|
|
12 |
DENT_VISIT_DEPT_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
The external name of the department record. This is often used in patient correspondence such as reminder letters. |
|
|
13 |
DENT_VIS_PROVTYPE_C_NAME |
VARCHAR |
No |
|
|
|
Requested provider type for dental visit |
May contain organization-specific values: Yes |
Category Entries: |
Resource |
Physician |
|
|
14 |
DENT_VIS_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
Status of dental visit |
May contain organization-specific values: No |
Category Entries: |
Active |
Removed |
|
|
15 |
VISIT_NAME |
VARCHAR |
No |
|
|
|
The name of the dental visit. |
|
|
16 |
PAT_ID |
VARCHAR |
No |
|
|
|
The patient (EPT) ID for the patient that the dental visit is associated with |
|
|
17 |
REFERRAL_ORDER_ID |
NUMERIC |
No |
|
|
|
Linked referral order (ORD) for a dental visit. |
|
|
18 |
APPT_REQUEST_ID |
NUMERIC |
No |
|
|
|
Stores the ID of the linked appointment request. |
|
|
19 |
READY_FOR_SCHED_YN |
VARCHAR |
No |
|
|
|
Stores whether this visit should appear in scheduling workflows. |
May contain organization-specific values: No |
Category Entries: |
No |
Yes |
|
|