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