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