Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
PATIENTDECEASEDID	10	PATIENTDECEASED
LKMARITALSTATUSID	11	LKMARITALSTATUS
LKCONFIDENTIALTYPEID	12	LKREGCONFIDENTIALTYPE
LKRELIGIONID	17	LKRELIGION
CITIZENOFLKCOUNTRYID	18	LKCOUNTRY
PREFERREDREMINDERLKLANGUAGEID	20	LKLANGUAGE
LKVETERANSTATUSID	22	LKVETERANSTATUS
LKBIRTHSEXID	27	LKBIRTHSEX
LKSEXUALORIENTATIONID	30	LKSEXUALORIENTATION
BIRTHDATELKSYSTIMEZONEID	36	LKSYSTIMEZONE

	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	PREFERREDNAME	NVARCHAR
	Description: Preferred name of Patient

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

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

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

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

	Name	Type
14	LKORGANIZATIONID	INT
	Description: To be deprecated

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

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

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

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

	Name	Type
19	RISKMANAGEMENTID	INT
	Description: Risk Management Identification Number

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

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

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

	Name	Type
23	ORGANDONOR	BIT
	Description: Organ donor patient

	Name	Type
24	CLERGYVISITSALLOWED	BIT
	Description: Clergy Visits Allowed

	Name	Type
25	INSTITUTIONADDRESS	BIT
	Description: Institution Address

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

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

	Name	Type
28	BIRTHDATE	DATE
	Description: Date of Birth

	Name	Type
29	GENDERIDENTITYDESCRIPTION	NVARCHAR
	Description: Gender identification

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

	Name	Type
31	SEXUALORIENTATIONDESCRIPTION	NVARCHAR
	Description: Sexual orientation

	Name	Type
33	CREATED	DATETIMEOFFSET
	Description: Record created time

	Name	Type
35	LASTMODIFIED	DATETIMEOFFSET
	Description: Record Last Modified time

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

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

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

	Name	Type
39	HEALTHINFORMATIONEXCHANGEOPTIN	BIT
	Description: HealthInformationExchangeOptIn flag for the patient's record