dbo.CV3EnterpriseVisitData 
Default Table Name  CV3EnterpriseVisitData 
Definition  Contains the enterprise-defined data for a client visit. 

dbo.CV3EnterpriseVisitData 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. 
VisitGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ClientVisit table. 
ClientGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Client table. 
EnterpriseVisitCol1    varchar(255)  YES  PHI: Column 1 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol2    varchar(255)  YES  PHI: Column 2 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol3    varchar(255)  YES  PHI: Column 3 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol4    varchar(255)  YES  PHI: Column 4 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol5    varchar(255)  YES  PHI: Column 5 of the Patient List. Used to check for Visit Scope flag. 
EnterpriseVisitCol6    varchar(255)  YES  PHI: Column 6 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol7    varchar(255)  YES  PHI: Column 7 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol8    varchar(255)  YES  PHI: Column 8 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol9    varchar(255)  YES  PHI: Column 9 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol10    varchar(255)  YES  PHI: Column 10 of the Patient List. Used to check for Visit Scope flag 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
EnterpriseVisitCol11    varchar(255)  YES  PHI: Column 11 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol12    varchar(255)  YES  PHI: Column 12 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol13    varchar(255)  YES  PHI: Column 13 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol14    varchar(255)  YES  PHI: Column 14 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol15    varchar(255)  YES  PHI: Column 15 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol16    varchar(255)  YES  PHI: Column 16 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol17    varchar(255)  YES  PHI: Column 17 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol18    varchar(255)  YES  PHI: Column 18 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol19    varchar(255)  YES  PHI: Column 19 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol20    varchar(255)  YES  PHI: Column 20 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol21    varchar(255)  YES  PHI: Column 21 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol22    varchar(255)  YES  PHI: Column 22 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol23    varchar(255)  YES  PHI: Column 23 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol24    varchar(255)  YES  PHI: Column 24 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol25    varchar(255)  YES  PHI: Column 25 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol26    varchar(255)  YES  PHI: Column 26 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol27    varchar(255)  YES  PHI: Column 27 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol28    varchar(255)  YES  PHI: Column 28 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol29    varchar(255)  YES  PHI: Column 29 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol30    varchar(255)  YES  PHI: Column 30 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol31    varchar(255)  YES  PHI: Column 31 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol32    varchar(255)  YES  PHI: Column 32 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol33    varchar(255)  YES  PHI: Column 33 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol34    varchar(255)  YES  PHI: Column 34 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol35    varchar(255)  YES  PHI: Column 35 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol36    varchar(255)  YES  PHI: Column 36 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol37    varchar(255)  YES  PHI: Column 37 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol38    varchar(255)  YES  PHI: Column 38 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol39    varchar(255)  YES  PHI: Column 39 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol40    varchar(255)  YES  PHI: Column 40 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol41    varchar(255)  YES  PHI: Column 41 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol42    varchar(255)  YES  PHI: Column 42 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol43    varchar(255)  YES  PHI: Column 43 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol44    varchar(255)  YES  PHI: Column 44 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol45    varchar(255)  YES  PHI: Column 45 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol46    varchar(255)  YES  PHI: Column 46 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol47    varchar(255)  YES  PHI: Column 47 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol48    varchar(255)  YES  PHI: Column 48 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol49    varchar(255)  YES  PHI: Column 49 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol50    varchar(255)  YES  PHI: Column 50 of the Patient List. Used to check for Visit Scope flag 
EnterpriseVisitCol51    varchar(255)  YES  PHI: Column 51 of the Patient List  
EnterpriseVisitCol52    varchar(255)  YES  PHI: Column 52 of the Patient List  
EnterpriseVisitCol53    varchar(255)  YES  PHI: Column 53 of the Patient List  
EnterpriseVisitCol54    varchar(255)  YES  PHI: Column 54 of the Patient List  
EnterpriseVisitCol55    varchar(255)  YES  PHI: Column 55 of the Patient List  
EnterpriseVisitCol56    varchar(255)  YES  PHI: Column 56 of the Patient List  
EnterpriseVisitCol57    varchar(255)  YES  PHI: Column 57 of the Patient List  
EnterpriseVisitCol58    varchar(255)  YES  PHI: Column 58 of the Patient List  
EnterpriseVisitCol59    varchar(255)  YES  PHI: Column 59 of the Patient List  
EnterpriseVisitCol60    varchar(255)  YES  PHI: Column 60 of the Patient List  
EnterpriseVisitCol61    varchar(255)  YES  PHI: Column 61 of the Patient List  
EnterpriseVisitCol62    varchar(255)  YES  PHI: Column 62 of the Patient List  
EnterpriseVisitCol63    varchar(255)  YES  PHI: Column 63 of the Patient List  
EnterpriseVisitCol64    varchar(255)  YES  PHI: Column 64 of the Patient List  
EnterpriseVisitCol65    varchar(255)  YES  PHI: Column 65 of the Patient List  
EnterpriseVisitCol66    varchar(255)  YES  PHI: Column 66 of the Patient List  
EnterpriseVisitCol67    varchar(255)  YES  PHI: Column 67 of the Patient List  
EnterpriseVisitCol68    varchar(255)  YES  PHI: Column 68 of the Patient List  
EnterpriseVisitCol69    varchar(255)  YES  PHI: Column 69 of the Patient List  
EnterpriseVisitCol70    varchar(255)  YES  PHI: Column 70 of the Patient List  
EnterpriseVisitCol71    varchar(255)  YES  PHI: Column 71 of the Patient List  
EnterpriseVisitCol72    varchar(255)  YES  PHI: Column 72 of the Patient List  
EnterpriseVisitCol73    varchar(255)  YES  PHI: Column 73 of the Patient List  
EnterpriseVisitCol74    varchar(255)  YES  PHI: Column 74 of the Patient List  
EnterpriseVisitCol75    varchar(255)  YES  PHI: Column 75 of the Patient List  
EnterpriseVisitCol76    varchar(255)  YES  PHI: Column 76 of the Patient List  
EnterpriseVisitCol77    varchar(255)  YES  PHI: Column 77 of the Patient List  
EnterpriseVisitCol78    varchar(255)  YES  PHI: Column 78 of the Patient List  
EnterpriseVisitCol79    varchar(255)  YES  PHI: Column 79 of the Patient List  
EnterpriseVisitCol80    varchar(255)  YES  PHI: Column 80 of the Patient List  
EnterpriseVisitCol81    varchar(255)  YES  PHI: Column 81 of the Patient List  
EnterpriseVisitCol82    varchar(255)  YES  PHI: Column 82 of the Patient List  
EnterpriseVisitCol83    varchar(255)  YES  PHI: Column 83 of the Patient List  
EnterpriseVisitCol84    varchar(255)  YES  PHI: Column 84 of the Patient List  
EnterpriseVisitCol85    varchar(255)  YES  PHI: Column 85 of the Patient List  
EnterpriseVisitCol86    varchar(255)  YES  PHI: Column 86 of the Patient List  
EnterpriseVisitCol87    varchar(255)  YES  PHI: Column 87 of the Patient List  
EnterpriseVisitCol88    varchar(255)  YES  PHI: Column 88 of the Patient List  
EnterpriseVisitCol89    varchar(255)  YES  PHI: Column 89 of the Patient List  
EnterpriseVisitCol90    varchar(255)  YES  PHI: Column 90 of the Patient List  
EnterpriseVisitCol91    varchar(255)  YES  PHI: Column 91 of the Patient List  
EnterpriseVisitCol92    varchar(255)  YES  PHI: Column 92 of the Patient List  
EnterpriseVisitCol93    varchar(255)  YES  PHI: Column 93 of the Patient List  
EnterpriseVisitCol94    varchar(255)  YES  PHI: Column 94 of the Patient List  
EnterpriseVisitCol95    varchar(255)  YES  PHI: Column 95 of the Patient List  
EnterpriseVisitCol96    varchar(255)  YES  PHI: Column 96 of the Patient List  
EnterpriseVisitCol97    varchar(255)  YES  PHI: Column 97 of the Patient List  
EnterpriseVisitCol98    varchar(255)  YES  PHI: Column 98 of the Patient List  
EnterpriseVisitCol99    varchar(255)  YES  PHI: Column 99 of the Patient List  
EnterpriseVisitCol100    varchar(255)  YES  PHI: Column 100 of the Patient List  
EnterpriseVisitCol101    varchar(255)  YES  PHI: Column 101 of the Patient List  
EnterpriseVisitCol102    varchar(255)  YES  PHI: Column 102 of the Patient List  
EnterpriseVisitCol103    varchar(255)  YES  PHI: Column 103 of the Patient List  
EnterpriseVisitCol104    varchar(255)  YES  PHI: Column 104 of the Patient List  
EnterpriseVisitCol105    varchar(255)  YES  PHI: Column 105 of the Patient List  
EnterpriseVisitCol106    varchar(255)  YES  PHI: Column 106 of the Patient List  
EnterpriseVisitCol107    varchar(255)  YES  PHI: Column 107 of the Patient List  
EnterpriseVisitCol108    varchar(255)  YES  PHI: Column 108 of the Patient List  
EnterpriseVisitCol109    varchar(255)  YES  PHI: Column 109 of the Patient List  
EnterpriseVisitCol110    varchar(255)  YES  PHI: Column 110 of the Patient List  
EnterpriseVisitCol111    varchar(255)  YES  PHI: Column 111 of the Patient List  
EnterpriseVisitCol112    varchar(255)  YES  PHI: Column 112 of the Patient List  
EnterpriseVisitCol113    varchar(255)  YES  PHI: Column 113 of the Patient List  
EnterpriseVisitCol114    varchar(255)  YES  PHI: Column 114 of the Patient List  
EnterpriseVisitCol115    varchar(255)  YES  PHI: Column 115 of the Patient List  
EnterpriseVisitCol116    varchar(255)  YES  PHI: Column 116 of the Patient List  
EnterpriseVisitCol117    varchar(255)  YES  PHI: Column 117 of the Patient List  
EnterpriseVisitCol118    varchar(255)  YES  PHI: Column 118 of the Patient List  
EnterpriseVisitCol119    varchar(255)  YES  PHI: Column 119 of the Patient List  
EnterpriseVisitCol120    varchar(255)  YES  PHI: Column 120 of the Patient List  
EnterpriseVisitCol121    varchar(255)  YES  PHI: Column 121 of the Patient List  
EnterpriseVisitCol122    varchar(255)  YES  PHI: Column 122 of the Patient List  
EnterpriseVisitCol123    varchar(255)  YES  PHI: Column 123 of the Patient List  
EnterpriseVisitCol124    varchar(255)  YES  PHI: Column 124 of the Patient List  
EnterpriseVisitCol125    varchar(255)  YES  PHI: Column 125 of the Patient List  
EnterpriseVisitCol126    varchar(255)  YES  PHI: Column 126 of the Patient List  
EnterpriseVisitCol127    varchar(255)  YES  PHI: Column 127 of the Patient List  
EnterpriseVisitCol128    varchar(255)  YES  PHI: Column 128 of the Patient List  
EnterpriseVisitCol129    varchar(255)  YES  PHI: Column 129 of the Patient List  
EnterpriseVisitCol130    varchar(255)  YES  PHI: Column 130 of the Patient List  
EnterpriseVisitCol131    varchar(255)  YES  PHI: Column 131 of the Patient List  
EnterpriseVisitCol132    varchar(255)  YES  PHI: Column 132 of the Patient List  
EnterpriseVisitCol133    varchar(255)  YES  PHI: Column 133 of the Patient List  
EnterpriseVisitCol134    varchar(255)  YES  PHI: Column 134 of the Patient List  
EnterpriseVisitCol135    varchar(255)  YES  PHI: Column 135 of the Patient List  
EnterpriseVisitCol136    varchar(255)  YES  PHI: Column 136 of the Patient List  
EnterpriseVisitCol137    varchar(255)  YES  PHI: Column 137 of the Patient List  
EnterpriseVisitCol138    varchar(255)  YES  PHI: Column 138 of the Patient List  
EnterpriseVisitCol139    varchar(255)  YES  PHI: Column 139 of the Patient List  
EnterpriseVisitCol140    varchar(255)  YES  PHI: Column 140 of the Patient List  
EnterpriseVisitCol141    varchar(255)  YES  PHI: Column 141 of the Patient List  
EnterpriseVisitCol142    varchar(255)  YES  PHI: Column 142 of the Patient List  
EnterpriseVisitCol143    varchar(255)  YES  PHI: Column 143 of the Patient List  
EnterpriseVisitCol144    varchar(255)  YES  PHI: Column 144 of the Patient List  
EnterpriseVisitCol145    varchar(255)  YES  PHI: Column 145 of the Patient List  
EnterpriseVisitCol146    varchar(255)  YES  PHI: Column 146 of the Patient List  
EnterpriseVisitCol147    varchar(255)  YES  PHI: Column 147 of the Patient List  
EnterpriseVisitCol148    varchar(255)  YES  PHI: Column 148 of the Patient List  
EnterpriseVisitCol149    varchar(255)  YES  PHI: Column 149 of the Patient List  
EnterpriseVisitCol150    varchar(255)  YES  PHI: Column 150 of the Patient List  
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3EnterpriseVisitData Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3EnterpriseVisitDataPK  PrimaryKey  GUID