DENTAL_PAT_PHASE

Description: |
This table contains information about dental phasing.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
3 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
4 | CM_CT_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
5 | DENT_PAT_PHASE_C_NAME | VARCHAR | No |
The overall dental phase value of the patient.
May contain organization-specific values: No
Category Entries:
Urgent
Disease Control
Definitive
Maintenance
6 | DENT_PHASE_MOD_USER_ID | VARCHAR | No |
The user who set the patient phase value.
7 | DENT_PHASE_MOD_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | DENTAL_PHASE_END_DATE | DATETIME | No |
The date a dental phase ended.
9 | DENTAL_PHASE_START_DATE | DATETIME | No |
The date a dental phase started.
10 | DENT_PHASE_AUTO_SELECT_FACTORS | VARCHAR | No |
Stores information used to support automatic selection of patient phase.