Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
PATIENTID	2	PATIENT
ENCOUNTERID	3	ENCOUNTER
LKSYSTIMEZONEID	4	LKSYSTIMEZONE
REQUESTINGPRACTITIONERID	8	PRACTITIONER

	Name	Type
1	SCHEDULESESSIONID	INT
	Description: The unique Id for the ScheduleSession table

	Name	Type
2	PATIENTID	INT
	Description: PatientId is a foreign key to the Patient table

	Name	Type
3	ENCOUNTERID	INT
	Description: EncounterId is a foreign key to the Encounter table

	Name	Type
4	LKSYSTIMEZONEID	INT
	Description: LkSysTimeZoneId is a foreign key to the LkSysTimeZone table

	Name	Type
5	PREFERREDDATE	DATETIME2
	Description: Preferred date for a session if display VA fields is turned on

	Name	Type
6	CALLER	NVARCHAR
	Description: The person who called the appointment in to be scheduled

	Name	Type
7	ISCONFLICTOVERRIDE	BIT
	Description: Signifies if the session was scheduled with a conflict override

	Name	Type
8	REQUESTINGPRACTITIONERID	INT
	Description: RequestingPractitionerId is a foreign key to the Practitioner table

	Name	Type
9	OVERRIDEREQUESTINGPHYSNAME	NVARCHAR
	Description: Requesting Physician name if overriding

	Name	Type
10	ENCOUNTERVAAPPOINTMENTTYPEID	INT
	Description: VA's defined appointment type

	Name	Type
11	CONSULTINGREQUIRED	BIT
	Description: VA consulting required

	Name	Type
12	ENCOUNTERVACONSULTID	INT
	Description: VA's defined encounter consult type