Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
PATIENTDECEASEDID	9	PATIENTDECEASED
LKMARITALSTATUSID	10	LKMARITALSTATUS
LKRELIGIONID	16	LKRELIGION
CITIZENOFLKCOUNTRYID	17	LKCOUNTRY
LKBIRTHSEXID	26	LKBIRTHSEX
LKSEXUALORIENTATIONID	29	LKSEXUALORIENTATION

	Name	Type
1	PATIENTID	INT
	Description: The unique Id for the Patient table

	Name	Type
2	UUID	UNIQUEIDENTIFIER
	Description: The universally unique Id for the record

	Name	Type
3	ACTIVE	BIT
	Description: Active indicates whether the patient's record is in active use

	Name	Type
4	PREFIXNAME	NVARCHAR
	Description: Name prefix, example: Mr.

	Name	Type
5	FIRSTNAME	NVARCHAR
	Description: First Name

	Name	Type
6	MIDDLENAME	NVARCHAR
	Description: Middle Name

	Name	Type
7	LASTNAME	NVARCHAR
	Description: Last Name

	Name	Type
8	SUFFIXNAME	NVARCHAR
	Description: Name suffix, example: Jr

	Name	Type
9	PATIENTDECEASEDID	INT
	Description: PatientDeceasedId is a foreign key to the PatientDeceased table

	Name	Type
10	LKMARITALSTATUSID	INT
	Description: LkMaritalStatusId is a foreign key to the LkMaritalStatus table

	Name	Type
11	LKCONFIDENTIALTYPEID	INT
	Description: LkConfidentialTypeId is a foreign key to the LkRegConfidentialType table

	Name	Type
12	VIP	BIT
	Description: Indicates if patient is a VIP

	Name	Type
13	LKORGANIZATIONID	INT
	Description: To be deprecated

	Name	Type
14	MULTIPLEBIRTHORDER	TINYINT
	Description: Indicates actual birth order in a multiple birth

	Name	Type
15	MULTIPLEBIRTHFLAG	BIT
	Description: Whether patient is part of a multiple birth

	Name	Type
16	LKRELIGIONID	INT
	Description: LkReligionId is a foreign key to the LkReligion table

	Name	Type
17	CITIZENOFLKCOUNTRYID	INT
	Description: CitizenOfLkCountryId is a foreign key to the LkCountry table

	Name	Type
18	RISKMANAGEMENTID	INT
	Description: Risk Management Identification Number

	Name	Type
19	PREFERREDREMINDERLKLANGUAGEID	INT
	Description: PreferredReminderLkLanguageId is a foreign key to the Language table

	Name	Type
20	PRINTEDREMINDERS	BIT
	Description: Opt In To Receiving Printed Reminders?

	Name	Type
21	LKVETERANSTATUSID	INT
	Description: LkVeteranStatusId is a foreign key to the LkVeteranStatus table

	Name	Type
22	ORGANDONOR	BIT
	Description: Organ donor patient

	Name	Type
23	CLERGYVISITSALLOWED	BIT
	Description: Clergy Visits Allowed

	Name	Type
24	INSTITUTIONADDRESS	BIT
	Description: Institution Address

	Name	Type
25	MOTHERMAIDEN	NVARCHAR
	Description: Mother's maiden name

	Name	Type
26	LKBIRTHSEXID	INT
	Description: LkBirthSexId is a foreign key to the LkBirthSex table

	Name	Type
27	BIRTHDATE	DATE
	Description: Date of Birth

	Name	Type
28	GENDERIDENTITYDESCRIPTION	NVARCHAR
	Description: Gender identification

	Name	Type
29	LKSEXUALORIENTATIONID	INT
	Description: LkSexualOrientationId is a foreign key to the LkSexualOrientation table

	Name	Type
30	SEXUALORIENTATIONDESCRIPTION	NVARCHAR
	Description: Sexual orientation

	Name	Type
32	CREATED	DATETIMEOFFSET
	Description: Record created time

	Name	Type
34	LASTMODIFIED	DATETIMEOFFSET
	Description: Record Last Modified time

	Name	Type
35	BIRTHDATELKSYSTIMEZONEID	INT
	Description: BirthDateLkSysTimeZoneId is a foreign key to the LkSysTimeZone table

	Name	Type
36	BIRTHDATETIME	DATETIMEOFFSET
	Description: The time the record was documented

	Name	Type
37	ISLINKED	BIT
	Description: Flag that indicates if patient record is tied to another patient record