dbo.SXACCIDLClientImplant 
Default Table Name  SXACCIDLClientImplant 
Definition  To store client Implant Details 

dbo.SXACCIDLClientImplant 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. 
ClientImplantID(PK)    bigint  NO  Auto generated unique primary key value. 
ClientGUID    HVCIDdt  NO  Store patient ID. 
ClientVisitGUID    HVCIDdt  NO  Store visit ID of patient. 
ChartGUID    HVCIDdt  YES  Store Chart GUID. 
UserGUID    HVCIDdt  YES  Implant Entered User GUID 
ImplantDeviceName    varchar(255)  YES  Implant Device Name 
CategoryID    bigint  YES  Category ID, e.g. Body Site Category 
CategoryUserDictValXrefID    bigint  YES  Category and user dictionary value xref ID, e.g. Body Site Location 
Laterality    smallint  YES  Laterality, e.g. Left, Right, Bilateral, n/a 
Quantity    int  YES  Quantity 
InfoSource    varchar(30)  YES  Implant Info source 
ImplantStatusType    int  YES  Status of Implant, e.g. 1 - Implanted, 2 - Removed or 3 - Entered in Error. 
ImplantDateDTM    datetime  YES  Implant Date e.g 1/1/2016 00:00 
ImplantYearNum    smallint  YES  Implant Year 
ImplantMonthNum    smallint  YES  Implant Month 
ImplantDayNum    smallint  YES  Implant Date 
ImplantReasonGUID    HVCIDdt  YES  Reason for Implant i.e. health issue GUID. 
RemovalDateDTM    datetime  YES  Implant Removal Date e.g 1/1/2016 00:00 
RemovalYearNum    smallint  YES  Implant removal year 
RemovalMonthNum    smallint  YES  Implant removal month 
RemovalDayNum    smallint  YES  Implant removal date 
RemovalReason    varchar(60)  YES  Implant Removal reason from Coded Reason Dictionary 
Comments    varchar(2000)  YES  User Comments 
GMDNCode    varchar(5)  YES  Global Medical Device Nomenclature Code 
CDSUniqueGUID    HVCIDdt  YES  CDS Unique GUID 
CaseID    bigint  YES  Related Case ID from Surgery. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
BodySiteLocationFT    varchar(2000)  YES  Stores Body site location, entered as Free Text for Suggested Body Site Category. 
HL7UID    varchar(75)  YES  Unique ID of the HL7 Inbound message 

dbo.SXACCIDLClientImplant Primary and Unique Keys 
Key Name  Key Type  Keys 
SXACCIDLClientImplantPK  PrimaryKey  ClientImplantID