SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

RepFlags 
Definition  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 

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. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be 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. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

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

GUID 
Definition  Unique primary key value. 

VisitStatus 
Definition  The visit status. Either ADM, PRE, CAN, CLS, or DSC 

InternalVisitStatus 
Definition  The status of the visit. ADM - (Admitting), PRE (Pre-Admitting), LOA (Leave of Absence), PTR (Pending Transfer), DSC (Discharge), PDC (Pending Discharge), CAN (Canceling), PCN (Pending Canceling) or CLS (Closed) 

IsVIP 
Definition  PHI: Indicates if this visit has VIP status. 1 = True; 0 = False 

ChartGUID 
Definition  A foreign key to the GUID column in the CV3Chart table. 

ClientGUID 
Definition  A foreign key to the GUID column in the CV3Client table. 

AdmitDtm 
Definition  PHI: Visit TimeZone - The admission date and time. 

DischargeDtm 
Definition  PHI: Visit TimeZone - The discharge date and time. Will be NULL if visit is not discharged 

CloseDtm 
Definition  PHI: Visit TimeZone - The date and time the visit was closed. 

PlannedDischargeDtm 
Definition  PHI: Visit TimeZone - The planned discharge date and time. 

IDCode 
Definition  PHI: The current Medical Record Number. 

VisitIDCode 
Definition  PHI: The current identifier for the visit. 

TypeCode 
Definition  The visit type. 

CareLevelCode 
Definition  The care level. 

ServiceGUID 
Definition  A foreign key to the GUID column in the CV3Service table. 

VisitTypeCareLevelGUID 
Definition  A foreign key to the GUID column in the CV3VisitTypeCareLevel table. 

ClientDisplayName 
Definition  PHI: The client's most recent name. Denormalized from CV3ClientName 

ProviderDisplayName 
Definition  PHI: The primary care provider's display name. Denormalized from CV3CareProvider 

CurrentLocation 
Definition  The name of the current location. Denormalized from CV3Location 

CurrentLocationGUID 
Definition  The Location Group for current location. Must be a location group. The actual location GUID is stored in CV3ClientVisitLocation table. 

AdmitViaGUID 
Definition  A foreign key to the GUID column in the CV3ClientVisit table. 

NumUnackAlerts 
Definition  The number of unacknowledged alerts. 

AmbulStatusCode 
Definition  A foreign key to the Code column in the CV3AmbulatoryStatus table. 

ApplicSource 
Definition  Identifies which Eclipsys application was used to enter the information. Either CV (Sunrise Clinical Manager), ADT (ADT interface), or LAB (LAB interface) 

NextLocnGrpGUID 
Definition  A foreign key to the GUID column in the CV3Location table. 

NextLocn 
Definition  PHI: The name of next location to which the patient will be transferred. 

TempLocnGUID 
Definition  The current temporary location. 

TemporaryLocation 
Definition  The name of the temporary location. 

DischargeDisposition 
Definition  A foreign key to the Code column in the CV3DischargeDisposition table. 

DischargeLocation 
Definition  A foreign key to the Code column in the CV3DischargeLocation table. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

ArcType 
Definition  This column will indicate the state of the Visit. A value of 0= Is not Archived and records associated with this visit are in the CUR table, 99= Ready to be archived when Master Archive job runs ,[Year] = Year of visit creation and indicates the records associated with this visit are in the ARC table. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

TimeZone 
Definition  Time zone for the visit 

PrivacyStatusGUID 
Definition  Store visit level PrivacyStatus GUID. 

ReadyToMoveStatusType 
Definition  An enumerated type with the following list of possible values: 0 = [NOTREADY],1 = [READY],2 = [DISABLED],