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. 

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

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

EnterpriseVisitCol1 
Definition  PHI: Column 1 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol2 
Definition  PHI: Column 2 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol3 
Definition  PHI: Column 3 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol4 
Definition  PHI: Column 4 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol5 
Definition  PHI: Column 5 of the Patient List. Used to check for Visit Scope flag. 

EnterpriseVisitCol6 
Definition  PHI: Column 6 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol7 
Definition  PHI: Column 7 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol8 
Definition  PHI: Column 8 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol9 
Definition  PHI: Column 9 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol10 
Definition  PHI: Column 10 of the Patient List. Used to check for Visit Scope flag 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

EnterpriseVisitCol11 
Definition  PHI: Column 11 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol12 
Definition  PHI: Column 12 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol13 
Definition  PHI: Column 13 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol14 
Definition  PHI: Column 14 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol15 
Definition  PHI: Column 15 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol16 
Definition  PHI: Column 16 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol17 
Definition  PHI: Column 17 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol18 
Definition  PHI: Column 18 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol19 
Definition  PHI: Column 19 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol20 
Definition  PHI: Column 20 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol21 
Definition  PHI: Column 21 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol22 
Definition  PHI: Column 22 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol23 
Definition  PHI: Column 23 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol24 
Definition  PHI: Column 24 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol25 
Definition  PHI: Column 25 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol26 
Definition  PHI: Column 26 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol27 
Definition  PHI: Column 27 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol28 
Definition  PHI: Column 28 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol29 
Definition  PHI: Column 29 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol30 
Definition  PHI: Column 30 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol31 
Definition  PHI: Column 31 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol32 
Definition  PHI: Column 32 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol33 
Definition  PHI: Column 33 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol34 
Definition  PHI: Column 34 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol35 
Definition  PHI: Column 35 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol36 
Definition  PHI: Column 36 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol37 
Definition  PHI: Column 37 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol38 
Definition  PHI: Column 38 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol39 
Definition  PHI: Column 39 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol40 
Definition  PHI: Column 40 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol41 
Definition  PHI: Column 41 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol42 
Definition  PHI: Column 42 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol43 
Definition  PHI: Column 43 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol44 
Definition  PHI: Column 44 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol45 
Definition  PHI: Column 45 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol46 
Definition  PHI: Column 46 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol47 
Definition  PHI: Column 47 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol48 
Definition  PHI: Column 48 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol49 
Definition  PHI: Column 49 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol50 
Definition  PHI: Column 50 of the Patient List. Used to check for Visit Scope flag 

EnterpriseVisitCol51 
Definition  PHI: Column 51 of the Patient List  

EnterpriseVisitCol52 
Definition  PHI: Column 52 of the Patient List  

EnterpriseVisitCol53 
Definition  PHI: Column 53 of the Patient List  

EnterpriseVisitCol54 
Definition  PHI: Column 54 of the Patient List  

EnterpriseVisitCol55 
Definition  PHI: Column 55 of the Patient List  

EnterpriseVisitCol56 
Definition  PHI: Column 56 of the Patient List  

EnterpriseVisitCol57 
Definition  PHI: Column 57 of the Patient List  

EnterpriseVisitCol58 
Definition  PHI: Column 58 of the Patient List  

EnterpriseVisitCol59 
Definition  PHI: Column 59 of the Patient List  

EnterpriseVisitCol60 
Definition  PHI: Column 60 of the Patient List  

EnterpriseVisitCol61 
Definition  PHI: Column 61 of the Patient List  

EnterpriseVisitCol62 
Definition  PHI: Column 62 of the Patient List  

EnterpriseVisitCol63 
Definition  PHI: Column 63 of the Patient List  

EnterpriseVisitCol64 
Definition  PHI: Column 64 of the Patient List  

EnterpriseVisitCol65 
Definition  PHI: Column 65 of the Patient List  

EnterpriseVisitCol66 
Definition  PHI: Column 66 of the Patient List  

EnterpriseVisitCol67 
Definition  PHI: Column 67 of the Patient List  

EnterpriseVisitCol68 
Definition  PHI: Column 68 of the Patient List  

EnterpriseVisitCol69 
Definition  PHI: Column 69 of the Patient List  

EnterpriseVisitCol70 
Definition  PHI: Column 70 of the Patient List  

EnterpriseVisitCol71 
Definition  PHI: Column 71 of the Patient List  

EnterpriseVisitCol72 
Definition  PHI: Column 72 of the Patient List  

EnterpriseVisitCol73 
Definition  PHI: Column 73 of the Patient List  

EnterpriseVisitCol74 
Definition  PHI: Column 74 of the Patient List  

EnterpriseVisitCol75 
Definition  PHI: Column 75 of the Patient List  

EnterpriseVisitCol76 
Definition  PHI: Column 76 of the Patient List  

EnterpriseVisitCol77 
Definition  PHI: Column 77 of the Patient List  

EnterpriseVisitCol78 
Definition  PHI: Column 78 of the Patient List  

EnterpriseVisitCol79 
Definition  PHI: Column 79 of the Patient List  

EnterpriseVisitCol80 
Definition  PHI: Column 80 of the Patient List  

EnterpriseVisitCol81 
Definition  PHI: Column 81 of the Patient List  

EnterpriseVisitCol82 
Definition  PHI: Column 82 of the Patient List  

EnterpriseVisitCol83 
Definition  PHI: Column 83 of the Patient List  

EnterpriseVisitCol84 
Definition  PHI: Column 84 of the Patient List  

EnterpriseVisitCol85 
Definition  PHI: Column 85 of the Patient List  

EnterpriseVisitCol86 
Definition  PHI: Column 86 of the Patient List  

EnterpriseVisitCol87 
Definition  PHI: Column 87 of the Patient List  

EnterpriseVisitCol88 
Definition  PHI: Column 88 of the Patient List  

EnterpriseVisitCol89 
Definition  PHI: Column 89 of the Patient List  

EnterpriseVisitCol90 
Definition  PHI: Column 90 of the Patient List  

EnterpriseVisitCol91 
Definition  PHI: Column 91 of the Patient List  

EnterpriseVisitCol92 
Definition  PHI: Column 92 of the Patient List  

EnterpriseVisitCol93 
Definition  PHI: Column 93 of the Patient List  

EnterpriseVisitCol94 
Definition  PHI: Column 94 of the Patient List  

EnterpriseVisitCol95 
Definition  PHI: Column 95 of the Patient List  

EnterpriseVisitCol96 
Definition  PHI: Column 96 of the Patient List  

EnterpriseVisitCol97 
Definition  PHI: Column 97 of the Patient List  

EnterpriseVisitCol98 
Definition  PHI: Column 98 of the Patient List  

EnterpriseVisitCol99 
Definition  PHI: Column 99 of the Patient List  

EnterpriseVisitCol100 
Definition  PHI: Column 100 of the Patient List  

EnterpriseVisitCol101 
Definition  PHI: Column 101 of the Patient List  

EnterpriseVisitCol102 
Definition  PHI: Column 102 of the Patient List  

EnterpriseVisitCol103 
Definition  PHI: Column 103 of the Patient List  

EnterpriseVisitCol104 
Definition  PHI: Column 104 of the Patient List  

EnterpriseVisitCol105 
Definition  PHI: Column 105 of the Patient List  

EnterpriseVisitCol106 
Definition  PHI: Column 106 of the Patient List  

EnterpriseVisitCol107 
Definition  PHI: Column 107 of the Patient List  

EnterpriseVisitCol108 
Definition  PHI: Column 108 of the Patient List  

EnterpriseVisitCol109 
Definition  PHI: Column 109 of the Patient List  

EnterpriseVisitCol110 
Definition  PHI: Column 110 of the Patient List  

EnterpriseVisitCol111 
Definition  PHI: Column 111 of the Patient List  

EnterpriseVisitCol112 
Definition  PHI: Column 112 of the Patient List  

EnterpriseVisitCol113 
Definition  PHI: Column 113 of the Patient List  

EnterpriseVisitCol114 
Definition  PHI: Column 114 of the Patient List  

EnterpriseVisitCol115 
Definition  PHI: Column 115 of the Patient List  

EnterpriseVisitCol116 
Definition  PHI: Column 116 of the Patient List  

EnterpriseVisitCol117 
Definition  PHI: Column 117 of the Patient List  

EnterpriseVisitCol118 
Definition  PHI: Column 118 of the Patient List  

EnterpriseVisitCol119 
Definition  PHI: Column 119 of the Patient List  

EnterpriseVisitCol120 
Definition  PHI: Column 120 of the Patient List  

EnterpriseVisitCol121 
Definition  PHI: Column 121 of the Patient List  

EnterpriseVisitCol122 
Definition  PHI: Column 122 of the Patient List  

EnterpriseVisitCol123 
Definition  PHI: Column 123 of the Patient List  

EnterpriseVisitCol124 
Definition  PHI: Column 124 of the Patient List  

EnterpriseVisitCol125 
Definition  PHI: Column 125 of the Patient List  

EnterpriseVisitCol126 
Definition  PHI: Column 126 of the Patient List  

EnterpriseVisitCol127 
Definition  PHI: Column 127 of the Patient List  

EnterpriseVisitCol128 
Definition  PHI: Column 128 of the Patient List  

EnterpriseVisitCol129 
Definition  PHI: Column 129 of the Patient List  

EnterpriseVisitCol130 
Definition  PHI: Column 130 of the Patient List  

EnterpriseVisitCol131 
Definition  PHI: Column 131 of the Patient List  

EnterpriseVisitCol132 
Definition  PHI: Column 132 of the Patient List  

EnterpriseVisitCol133 
Definition  PHI: Column 133 of the Patient List  

EnterpriseVisitCol134 
Definition  PHI: Column 134 of the Patient List  

EnterpriseVisitCol135 
Definition  PHI: Column 135 of the Patient List  

EnterpriseVisitCol136 
Definition  PHI: Column 136 of the Patient List  

EnterpriseVisitCol137 
Definition  PHI: Column 137 of the Patient List  

EnterpriseVisitCol138 
Definition  PHI: Column 138 of the Patient List  

EnterpriseVisitCol139 
Definition  PHI: Column 139 of the Patient List  

EnterpriseVisitCol140 
Definition  PHI: Column 140 of the Patient List  

EnterpriseVisitCol141 
Definition  PHI: Column 141 of the Patient List  

EnterpriseVisitCol142 
Definition  PHI: Column 142 of the Patient List  

EnterpriseVisitCol143 
Definition  PHI: Column 143 of the Patient List  

EnterpriseVisitCol144 
Definition  PHI: Column 144 of the Patient List  

EnterpriseVisitCol145 
Definition  PHI: Column 145 of the Patient List  

EnterpriseVisitCol146 
Definition  PHI: Column 146 of the Patient List  

EnterpriseVisitCol147 
Definition  PHI: Column 147 of the Patient List  

EnterpriseVisitCol148 
Definition  PHI: Column 148 of the Patient List  

EnterpriseVisitCol149 
Definition  PHI: Column 149 of the Patient List  

EnterpriseVisitCol150 
Definition  PHI: Column 150 of the Patient List  

MSReplrowguid 
Definition  Unique GUID used to support merge replication.