Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
ORGANIZATIONID	2	ORGANIZATION
LKLOCATIONSTATUSID	4	LKLOCATIONSTATUS
LKLOCATIONOPERATIONALSTATUSID	5	LKLOCATIONOPERATIONALSTATUS
LKLOCATIONMODEID	8	LKLOCATIONMODE
PARENTLOCATIONID	9	LOCATION
LKLOCATIONPHYSICALTYPEID	10	LKLOCATIONPHYSICALTYPE
LKLOCATIONROLETYPEID	11	LKLOCATIONROLETYPE
ADDRESSID	16	ADDRESS
LKSYSTIMEZONEID	17	LKSYSTIMEZONE
DEPARTMENTCODEID	23	CHARGEITEMDEFINITIONDEPARTMENTCODE

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

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

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

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

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

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

	Name	Type
7	DESCRIPTION	NVARCHAR
	Description: Detailed Description

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

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

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

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

	Name	Type
12	CREATED	DATETIMEOFFSET
	Description: Record created time

	Name	Type
14	LASTMODIFIED	DATETIMEOFFSET
	Description: Record Last Modified time

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

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

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

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

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

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

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

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