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. 

AbstractVisitDetailID 
Definition  Auto generated unique primary key value. 

ClientVisitGUID 
Definition  Visit ID from AM 

InsZipCode 
Definition  PHI: Zip code of insurance company 

AdmitTypeID 
Definition  Admit type from AM 

IsAdmitThroughER 
Definition  Is visit admit through ER 

AdmitSourceId 
Definition  Admit source From AM 

IsReAdmitWithin30Days 
Definition  This indicates whether the patient was readmitted within 30 days. 

ReAdmissionCount 
Definition  Number of Readmission count 

DischargeLocationGUID 
Definition  Foreign key to CV3DischargeLocation 

DischargeDispositionGUID 
Definition  Foreign key to CV3DischargeDisposition 

DischargeConditionID 
Definition  Foreign key to SXAAMDischargeCondition 

IsAutopsy 
Definition  Is Autopsy done or not 

IsMedicalExaminerAssigned 
Definition  Medical Examiner assigned or not 

PostOPOR 
Definition  Post OP/ OR 

IsUnder48Hrs 
Definition  This indicates whether the visit is within 48 hrs. of previous visit. 

PrimaryORPhysicianID 
Definition  FK to cv3careprovider 

AdmittingDiagnosisCode 
Definition  Admitting diagnosis Code 

NewBornbabyWeight 
Definition  Stores New born baby weight 

MothersMRN 
Definition  PHI: MRN of mother 

AGAR1Min 
Definition  This is a numeric field which is filled in case of new born baby. 

AGAR5MIN 
Definition  This is a numeric field which is filled in case of new born baby. 

AbstractStatusID 
Definition  A foreign key to the AbstractStatusID column in the SXARCMAbstractStatus table. 

AbstractCompletedBY 
Definition  User who has completed the abstract. 

AbstractStateCodeID 
Definition  A foreign key to the AbstractStateCodeID column in the SXARCMAbstractStateCode table. 

AbstractCompletedUTC 
Definition  Abstract Completed Date 

CauseOfDeath 
Definition  PHI: Free text describing cause of death 

ReleaseForBillingUTC 
Definition  Billing Release Date 

AdmitWeight 
Definition  Stores Admit weight 

DischargeWeight 
Definition  Stores Discharge weight 

BirthFacility 
Definition  Foreign key to cv3location for facility 

GestationalWeek 
Definition  Number of Gestational Weeks 

GestationalDay 
Definition  Number of Gestational days 

DayOnVentilator 
Definition  Number of days on ventilator 

DayOnHyperalimentation 
Definition  Number of days in hyperpigmentation 

DayOnECMO 
Definition  Days on ECMO 

AGAR10MIN 
Definition  This is a numeric field which is filled in case of new born baby 

AbstractReleaseBy 
Definition  User who has Released abstract for billing 

AttendPhysicianID 
Definition  Attending Physician 

AdmitPhysicianID 
Definition  Admitting Physician 

ReferringPhysicianID 
Definition  Referring Physician 

ReferringAgencyID 
Definition  Referring Agency 

SurgeonPhysicianID 
Definition  Surgeon Physician 

MappedAdmittingDiagnosisCode 
Definition  Admitting diagnosis Code 

IsCodedICD10 
Definition  Flag to identify that Diagnosis code is for ICD10 or not 

IsOrphanDiagnosisICD10Code 
Definition  Flag indicated that ICD10 code is orphan and we do not have any ICD9 Mapping for it 

CustomTileData 
Definition  PHI: XMl which will contain data mapped with UDDI fields 

AdmittingDiagnosisCode10 
Definition  Store Admitting diagnosis code for ICD10 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsBulkCoded 
Definition  Is Bulk Coded