DENTAL_VISIT_INFO
Description:
The DENTAL_VISIT_INFO table contains information associated with dental visit records.

Primary Key
Column Name Ordinal Position
REGIMEN_ID 1

Column Information
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