dbo.SXARCMAbstractVisitDetail 
Default Table Name  SXARCMAbstractVisitDetail 
Definition  Stores Abstract Visit Details 

dbo.SXARCMAbstractVisitDetail 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. 
AbstractVisitDetailID(PK)    bigint  NO  Auto generated unique primary key value. 
ClientVisitGUID(FK)    HVCIDdt  NO  Visit ID from AM 
InsZipCode    varchar(10)  YES  PHI: Zip code of insurance company 
AdmitTypeID    int  YES  Admit type from AM 
IsAdmitThroughER    bit  NO  Is visit admit through ER 
AdmitSourceId    int  YES  Admit source From AM 
IsReAdmitWithin30Days    bit  NO  This indicates whether the patient was readmitted within 30 days. 
ReAdmissionCount    int  NO  Number of Readmission count 
DischargeLocationGUID    numeric(16, 0)  YES  Foreign key to CV3DischargeLocation 
DischargeDispositionGUID    numeric(16, 0)  YES  Foreign key to CV3DischargeDisposition 
DischargeConditionID    int  YES  Foreign key to SXAAMDischargeCondition 
IsAutopsy    bit  NO  Is Autopsy done or not 
IsMedicalExaminerAssigned    bit  NO  Medical Examiner assigned or not 
PostOPOR    varchar(2)  YES  Post OP/ OR 
IsUnder48Hrs    bit  NO  This indicates whether the visit is within 48 hrs. of previous visit. 
PrimaryORPhysicianID    HVCIDdt  YES  FK to cv3careprovider 
AdmittingDiagnosisCode    varchar(20)  YES  Admitting diagnosis Code 
NewBornbabyWeight    numeric(10, 4)  YES  Stores New born baby weight 
MothersMRN    varchar(10)  YES  PHI: MRN of mother 
AGAR1Min    int  YES  This is a numeric field which is filled in case of new born baby. 
AGAR5MIN    int  YES  This is a numeric field which is filled in case of new born baby. 
AbstractStatusID(FK)    int  YES  A foreign key to the AbstractStatusID column in the SXARCMAbstractStatus table. 
AbstractCompletedBY    varchar(50)  YES  User who has completed the abstract. 
AbstractStateCodeID(FK)    int  YES  A foreign key to the AbstractStateCodeID column in the SXARCMAbstractStateCode table. 
AbstractCompletedUTC    datetimeoffset(3)  YES  Abstract Completed Date 
CauseOfDeath    varchar(50)  YES  PHI: Free text describing cause of death 
ReleaseForBillingUTC    datetimeoffset(3)  YES  Billing Release Date 
AdmitWeight    numeric(10, 4)  YES  Stores Admit weight 
DischargeWeight    numeric(10, 4)  YES  Stores Discharge weight 
BirthFacility    HVCIDdt  YES  Foreign key to cv3location for facility 
GestationalWeek    int  YES  Number of Gestational Weeks 
GestationalDay    int  YES  Number of Gestational days 
DayOnVentilator    int  YES  Number of days on ventilator 
DayOnHyperalimentation    int  YES  Number of days in hyperpigmentation 
DayOnECMO    int  YES  Days on ECMO 
AGAR10MIN    int  YES  This is a numeric field which is filled in case of new born baby 
AbstractReleaseBy    varchar(50)  YES  User who has Released abstract for billing 
AttendPhysicianID    bigint  YES  Attending Physician 
AdmitPhysicianID    bigint  YES  Admitting Physician 
ReferringPhysicianID    bigint  YES  Referring Physician 
ReferringAgencyID    numeric(16, 0)  YES  Referring Agency 
SurgeonPhysicianID    HVCIDdt  YES  Surgeon Physician 
MappedAdmittingDiagnosisCode    varchar(20)  YES  Admitting diagnosis Code 
IsCodedICD10    bit  NO  Flag to identify that Diagnosis code is for ICD10 or not 
IsOrphanDiagnosisICD10Code    bit  NO  Flag indicated that ICD10 code is orphan and we do not have any ICD9 Mapping for it 
CustomTileData    xml  YES  PHI: XMl which will contain data mapped with UDDI fields 
AdmittingDiagnosisCode10    varchar(20)  YES  Store Admitting diagnosis code for ICD10 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsBulkCoded    bit  YES  Is Bulk Coded 

dbo.SXARCMAbstractVisitDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMAbstractVisitDetailPK  PrimaryKey  AbstractVisitDetailID