Build 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  Optimistic lock identifier using rowversion datatype. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

ClientImplantID 
Definition  Auto generated unique primary key value. 

ClientGUID 
Definition  Store patient ID. 

ClientVisitGUID 
Definition  Store visit ID of patient. 

ChartGUID 
Definition  Store Chart GUID. 

UserGUID 
Definition  Implant Entered User GUID 

ImplantDeviceName 
Definition  Implant Device Name 

CategoryID 
Definition  Category ID, e.g. Body Site Category 

CategoryUserDictValXrefID 
Definition  Category and user dictionary value xref ID, e.g. Body Site Location 

Laterality 
Definition  Laterality, e.g. Left, Right, Bilateral, n/a 

Quantity 
Definition  Quantity 

InfoSource 
Definition  Implant Info source 

ImplantStatusType 
Definition  Status of Implant, e.g. 1 - Implanted, 2 - Removed or 3 - Entered in Error. 

ImplantDateDTM 
Definition  Implant Date e.g 1/1/2016 00:00 

ImplantYearNum 
Definition  Implant Year 

ImplantMonthNum 
Definition  Implant Month 

ImplantDayNum 
Definition  Implant Date 

ImplantReasonGUID 
Definition  Reason for Implant i.e. health issue GUID. 

RemovalDateDTM 
Definition  Implant Removal Date e.g 1/1/2016 00:00 

RemovalYearNum 
Definition  Implant removal year 

RemovalMonthNum 
Definition  Implant removal month 

RemovalDayNum 
Definition  Implant removal date 

RemovalReason 
Definition  Implant Removal reason from Coded Reason Dictionary 

Comments 
Definition  User Comments 

GMDNCode 
Definition  Global Medical Device Nomenclature Code 

CDSUniqueGUID 
Definition  CDS Unique GUID 

CaseID 
Definition  Related Case ID from Surgery. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

BodySiteLocationFT 
Definition  Stores Body site location, entered as Free Text for Suggested Body Site Category. 

HL7UID 
Definition  Unique ID of the HL7 Inbound message