|
Name |
Type |
Discontinued? |
|
| 1 |
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. |
|
|
| 2 |
LINE |
INTEGER |
No |
|
|
|
| The line number for the information associated with this record. Multiple pieces of information can be associated with this record. |
|
|
| 3 |
VISIT_TYPE_GROUP_C_NAME |
VARCHAR |
No |
|
|
|
| The visit type group category ID associated with this patient. Used in conjunction with the LAST_VISIT_ASN column to find information about the last visit a patient had for a given type of appointment. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Physical |
| Mammogram |
| X-Ray |
| CT |
| MRI |
| Dental Hygiene |
| Periodontal Maintenance |
| Rehab |
| Lab Visit |
| Infusion Visit |
| Provider Visit |
|
|
| 4 |
LAST_VISIT_ASN |
NUMERIC |
No |
|
|
|
| The Appointment Serial Number (ASN) of the most recent visit of a particular group. Use this to link to PAT_ENC.APPT_SERIAL_NO for information about this contact. |
|
|
