Column Name	Ordinal Position

Column Name	Ordinal Position	Referenced Table
LKDEVICESTATUSID	3	LKDEVICESTATUS
PARENTDEVICEID	19	DEVICE

	Name	Type
1	DEVICEID	INT
	Description: The unique Id for the Device table

	Name	Type
2	UUID	UNIQUEIDENTIFIER
	Description: Unique identifier used to reference the account Might or might not be intended for human use (e.g. credit card number)

	Name	Type
3	LKDEVICESTATUSID	INT
	Description: LkDeviceStatusId is a foreign key to the LkDeviceStatus table

	Name	Type
4	DISTINCTIDENTIFIER	NVARCHAR
	Description: Unique Device Identifier (UDI) Barcode string for this device

	Name	Type
5	MANUFACTURER	NVARCHAR
	Description: Manufacturer Name

	Name	Type
6	MANUFACTUREDATE	DATETIME2
	Description: Manufacturer Date

	Name	Type
7	EXPIRATIONDATE	DATETIME2
	Description: Expiration Date

	Name	Type
8	LOTNUMBER	NVARCHAR
	Description: Lot Number

	Name	Type
9	SERIALNUMBER	NVARCHAR
	Description: Serial Number

	Name	Type
10	MODELNUMBER	NVARCHAR
	Description: Model Number

	Name	Type
11	PARTNUMBER	NVARCHAR
	Description: Part Number

	Name	Type
12	TYPESYSTEM	NVARCHAR
	Description: The kind or type of device?s classification code coding system

	Name	Type
13	TYPECODE	NVARCHAR
	Description: The kind or type of device?s classification code

	Name	Type
14	TYPEDESCRIPTION	NVARCHAR
	Description: The kind or type of device?s classification code description

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

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

	Name	Type
17	LOCATIONID	INT
	Description: LocationId is a foreign key to the Location table

	Name	Type
18	URL	NVARCHAR
	Description: Network address to contact device

	Name	Type
19	PARENTDEVICEID	INT
	Description: ParentDeviceId is a foreign key to the Device table

	Name	Type
20	FHIRLASTMODIFIED	DATETIME2
	Description: Last Modified Date and Time