dbo.CV3ClientVisit 
Default Table Name  CV3ClientVisit 
Definition  A single contact or visit to a location in the Care Enterprise. 

dbo.CV3ClientVisit Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  YES  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
RepFlags    tinyint  YES  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 
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)  YES  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    datetime  YES  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  YES  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    datetime  YES  The date and time that the row was created and will be based on the Enterprise time zone. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
GUID(PK)    HVCIDdt  NO  Unique primary key value. 
VisitStatus    char(3)  YES  The visit status. Either ADM, PRE, CAN, CLS, or DSC 
InternalVisitStatus    char(3)  YES  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    bit  NO  PHI: Indicates if this visit has VIP status. 1 = True; 0 = False 
ChartGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Chart table. 
ClientGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Client table. 
AdmitDtm    datetime  YES  PHI: Visit TimeZone - The admission date and time. 
DischargeDtm    datetime  YES  PHI: Visit TimeZone - The discharge date and time. Will be NULL if visit is not discharged 
CloseDtm    datetime  YES  PHI: Visit TimeZone - The date and time the visit was closed. 
PlannedDischargeDtm    datetime  YES  PHI: Visit TimeZone - The planned discharge date and time. 
IDCode    char(20)  YES  PHI: The current Medical Record Number. 
VisitIDCode    char(20)  YES  PHI: The current identifier for the visit. 
TypeCode    char(15)  YES  The visit type. 
CareLevelCode    char(15)  YES  The care level. 
ServiceGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Service table. 
VisitTypeCareLevelGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3VisitTypeCareLevel table. 
ClientDisplayName    varchar(50)  YES  PHI: The client's most recent name. Denormalized from CV3ClientName 
ProviderDisplayName    varchar(50)  YES  PHI: The primary care provider's display name. Denormalized from CV3CareProvider 
CurrentLocation    varchar(50)  YES  The name of the current location. Denormalized from CV3Location 
CurrentLocationGUID    HVCIDdt  YES  The Location Group for current location. Must be a location group. The actual location GUID is stored in CV3ClientVisitLocation table. 
AdmitViaGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ClientVisit table. 
NumUnackAlerts    int  NO  The number of unacknowledged alerts. 
AmbulStatusCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3AmbulatoryStatus table. 
ApplicSource    char(5)  YES  Identifies which Eclipsys application was used to enter the information. Either CV (Sunrise Clinical Manager), ADT (ADT interface), or LAB (LAB interface) 
NextLocnGrpGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Location table. 
NextLocn    varchar(50)  YES  PHI: The name of next location to which the patient will be transferred. 
TempLocnGUID    HVCIDdt  YES  The current temporary location. 
TemporaryLocation    varchar(50)  YES  The name of the temporary location. 
DischargeDisposition(FK)    varchar(75)  YES  A foreign key to the Code column in the CV3DischargeDisposition table. 
DischargeLocation(FK)    varchar(75)  YES  A foreign key to the Code column in the CV3DischargeLocation table. 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
ArcType    int  NO  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    uniqueidentifier  NO  Unique GUID used to support merge replication. 
TimeZone    varchar(100)  YES  Time zone for the visit 
PrivacyStatusGUID    HVCIDdt  YES  Store visit level PrivacyStatus GUID. 
ReadyToMoveStatusType    int  NO  An enumerated type with the following list of possible values: 0 = [NOTREADY],1 = [READY],2 = [DISABLED], 

dbo.CV3ClientVisit Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3ClientVisitPK  PrimaryKey  GUID