PAT_LAST_VISIT

Description:

This stores the appointment serial numbers for the last time a patient was seen for a given visit type group.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	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.