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