dbo.SXACCIDLDeviceDetails 
Default Table Name  SXACCIDLDeviceDetails 
Definition  To store Device Details 

dbo.SXACCIDLDeviceDetails Columns 
ColumnName  Domain  Datatype  NULL  Definition 
Build    int  NO  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 
TouchedBy    varchar(50)  NO  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
TouchedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
CreatedBy    varchar(50)  NO  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 
CreatedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
DeviceDetailsID(PK)    bigint  NO  Auto generated unique primary key value. 
ClientImplantID    bigint  NO  Client Implant ID 
UDI    varchar(255)  NO  Unique device Identifier (GS1 / HIBCC / ICCBBA format) 
UDIType    varchar(20)  YES  Device type (GS1 / HIBCC / ICCBBA) 
DeviceID    varchar(255)  YES  Device ID 
SerialNumber    varchar(255)  YES  Serial Number of device 
DIN    varchar(50)  YES  Donation Identification Number (ICCBBA) 
GMDNImplantDeviceName    varchar(255)  YES  GMDN Implant device Name 
LotAndBatch    varchar(255)  YES  Lot and Batch of device 
UnitofUse    varchar(20)  YES  Unit of Use 
DeviceDescription    varchar(2000)  YES  Device description 
SNOMEDCode    varchar(20)  YES  SNOMED CTR code 
SNOMEDDescription    varchar(255)  YES  SNOMED CTR description 
CompanyName    varchar(255)  YES  Device company name 
Brand    varchar(255)  YES  Device Brand 
ModelVersion    varchar(255)  YES  Device Model and Vesion 
CatalogNumber    varchar(255)  YES  Device Catalog Number 
ManufactureYearNum    smallint  YES  Device Manufacture Year 
ManufactureMonthNum    smallint  YES  Device Manufacture Month 
ManufactureDayNum    smallint  YES  Device Manufacture Date 
ExpirationYearNum    smallint  YES  Device Expiration Year 
ExpirationMonthNum    smallint  YES  Device Expiration Month 
ExpirationDayNum    smallint  YES  Device Expiration Date 
TissueBasedProduct    bit  YES  Human Tissue-Based Product (HCT/P) 
ContainsLatex    bit  YES  Contains Latex 
MRISafetyStatus    varchar(60)  YES  MRI Safety info on label, e.g. MR Safe, MR Unsafe, MR Conditional, etc. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXACCIDLDeviceDetails Primary and Unique Keys 
Key Name  Key Type  Keys 
SXACCIDLDeviceDetailsPK  PrimaryKey  DeviceDetailsID