VT_SCHEDCODES
Description:
This table holds visit type schedule codes.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
2 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
4 VT_SCHED_CODES VARCHAR No
A unique ID for a visit type's scheduling codes.
5 VT_SCHED_CODES_SCHED_CODE_NAME VARCHAR No
The name of the scheduling code.