Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
ORGANIZATIONID	3	ORGANIZATION
LKLOCATIONSTATUSID	5	LKLOCATIONSTATUS
LKLOCATIONOPERATIONALSTATUSID	6	LKLOCATIONOPERATIONALSTATUS
LKLOCATIONMODEID	9	LKLOCATIONMODE
PARENTLOCATIONID	10	LOCATION
LKLOCATIONPHYSICALTYPEID	11	LKLOCATIONPHYSICALTYPE
LKLOCATIONROLETYPEID	12	LKLOCATIONROLETYPE
ADDRESSID	17	ADDRESS
LKSYSTIMEZONEID	18	LKSYSTIMEZONE
DEPARTMENTCODEID	24	CHARGEITEMDEFINITIONDEPARTMENTCODE

	Name	Type
1	LOCATIONID	INT
	Description: The unique Id for the Location table

	Name	Type
2	HIERARCHY	HIERARCHYID
	Description: Hierarchy is the hierarchyid for the record

	Name	Type
3	ORGANIZATIONID	INT
	Description: OrganizationId is a foreign key to the Organization table

	Name	Type
4	UUID	UNIQUEIDENTIFIER
	Description: The unique identifier of the location

	Name	Type
5	LKLOCATIONSTATUSID	INT
	Description: LkLocationStatusId is a foreign key to the LkLocationStatus table

	Name	Type
6	LKLOCATIONOPERATIONALSTATUSID	INT
	Description: LkLocationOperationalStatusId is a foreign key to the LkLocationOperationalStatus table

	Name	Type
7	LOCATION	NVARCHAR
	Description: The name for the location

	Name	Type
8	DESCRIPTION	NVARCHAR
	Description: Detailed Description

	Name	Type
9	LKLOCATIONMODEID	INT
	Description: LkLocationModeId is a foreign key to the LkLocationMode table

	Name	Type
10	PARENTLOCATIONID	INT
	Description: ParentLocationId is a foreign key to the Location table

	Name	Type
11	LKLOCATIONPHYSICALTYPEID	INT
	Description: LkLocationPhysicalTypeId is a foreign key to the LkLocationPhysicalType table

	Name	Type
12	LKLOCATIONROLETYPEID	INT
	Description: LkLocationRoleTypeId is a foreign key to the LkLocationRoleType table

	Name	Type
13	CREATED	DATETIMEOFFSET
	Description: Record created time

	Name	Type
15	LASTMODIFIED	DATETIMEOFFSET
	Description: Record Last Modified time

	Name	Type
17	ADDRESSID	INT
	Description: AddressId is a foreign key to the Address table

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

	Name	Type
19	ADJUSTFORDST	BIT
	Description: Flag to adjust for daylight savings time

	Name	Type
20	STARTDATE	DATETIME2
	Description: The start date of the location

	Name	Type
21	ENDDATE	DATETIME2
	Description: The end date of the location

	Name	Type
22	PHONEEMAIL	NVARCHAR
	Description: The phone or email of the location

	Name	Type
23	ROOMBEDINDEX	INT
	Description: The index where the room and bed are conjoined in the location column

	Name	Type
24	DEPARTMENTCODEID	INT
	Description: DepartmentCodeId is a foreign key to the ChargeItemDefinitionDepartmentCode table

	Name	Type
25	MAXCAPACITY	INT
	Description: Max Patient Capacity