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. 

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

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

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

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

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

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

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

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

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

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

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

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

EnterpriseClientCol51 
Definition  PHI: Column 51 of the Patient List  

EnterpriseClientCol52 
Definition  PHI: Column 52 of the Patient List  

EnterpriseClientCol53 
Definition  PHI: Column 53 of the Patient List  

EnterpriseClientCol54 
Definition  PHI: Column 54 of the Patient List  

EnterpriseClientCol55 
Definition  PHI: Column 55 of the Patient List  

EnterpriseClientCol56 
Definition  PHI: Column 56 of the Patient List  

EnterpriseClientCol57 
Definition  PHI: Column 57 of the Patient List  

EnterpriseClientCol58 
Definition  PHI: Column 58 of the Patient List  

EnterpriseClientCol59 
Definition  PHI: Column 59 of the Patient List  

EnterpriseClientCol60 
Definition  PHI: Column 60 of the Patient List  

EnterpriseClientCol61 
Definition  PHI: Column 61 of the Patient List  

EnterpriseClientCol62 
Definition  PHI: Column 62 of the Patient List  

EnterpriseClientCol63 
Definition  PHI: Column 63 of the Patient List  

EnterpriseClientCol64 
Definition  PHI: Column 64 of the Patient List  

EnterpriseClientCol65 
Definition  PHI: Column 65 of the Patient List  

EnterpriseClientCol66 
Definition  PHI: Column 66 of the Patient List  

EnterpriseClientCol67 
Definition  PHI: Column 67 of the Patient List  

EnterpriseClientCol68 
Definition  PHI: Column 68 of the Patient List  

EnterpriseClientCol69 
Definition  PHI: Column 69 of the Patient List  

EnterpriseClientCol70 
Definition  PHI: Column 70 of the Patient List  

EnterpriseClientCol71 
Definition  PHI: Column 71 of the Patient List  

EnterpriseClientCol72 
Definition  PHI: Column 72 of the Patient List  

EnterpriseClientCol73 
Definition  PHI: Column 73 of the Patient List  

EnterpriseClientCol74 
Definition  PHI: Column 74 of the Patient List  

EnterpriseClientCol75 
Definition  PHI: Column 75 of the Patient List  

EnterpriseClientCol76 
Definition  PHI: Column 76 of the Patient List  

EnterpriseClientCol77 
Definition  PHI: Column 77 of the Patient List  

EnterpriseClientCol78 
Definition  PHI: Column 78 of the Patient List  

EnterpriseClientCol79 
Definition  PHI: Column 79 of the Patient List  

EnterpriseClientCol80 
Definition  PHI: Column 80 of the Patient List  

EnterpriseClientCol81 
Definition  PHI: Column 81 of the Patient List  

EnterpriseClientCol82 
Definition  PHI: Column 82 of the Patient List  

EnterpriseClientCol83 
Definition  PHI: Column 83 of the Patient List  

EnterpriseClientCol84 
Definition  PHI: Column 84 of the Patient List  

EnterpriseClientCol85 
Definition  PHI: Column 85 of the Patient List  

EnterpriseClientCol86 
Definition  PHI: Column 86 of the Patient List  

EnterpriseClientCol87 
Definition  PHI: Column 87 of the Patient List  

EnterpriseClientCol88 
Definition  PHI: Column 88 of the Patient List  

EnterpriseClientCol89 
Definition  PHI: Column 89 of the Patient List  

EnterpriseClientCol90 
Definition  PHI: Column 90 of the Patient List  

EnterpriseClientCol91 
Definition  PHI: Column 91 of the Patient List  

EnterpriseClientCol92 
Definition  PHI: Column 92 of the Patient List  

EnterpriseClientCol93 
Definition  PHI: Column 93 of the Patient List  

EnterpriseClientCol94 
Definition  PHI: Column 94 of the Patient List  

EnterpriseClientCol95 
Definition  PHI: Column 95 of the Patient List  

EnterpriseClientCol96 
Definition  PHI: Column 96 of the Patient List  

EnterpriseClientCol97 
Definition  PHI: Column 97 of the Patient List  

EnterpriseClientCol98 
Definition  PHI: Column 98 of the Patient List  

EnterpriseClientCol99 
Definition  PHI: Column 99 of the Patient List  

EnterpriseClientCol100 
Definition  PHI: Column 100 of the Patient List  

EnterpriseClientCol101 
Definition  PHI: Column 101 of the Patient List  

EnterpriseClientCol102 
Definition  PHI: Column 102 of the Patient List  

EnterpriseClientCol103 
Definition  PHI: Column 103 of the Patient List  

EnterpriseClientCol104 
Definition  PHI: Column 104 of the Patient List  

EnterpriseClientCol105 
Definition  PHI: Column 105 of the Patient List  

EnterpriseClientCol106 
Definition  PHI: Column 106 of the Patient List  

EnterpriseClientCol107 
Definition  PHI: Column 107 of the Patient List  

EnterpriseClientCol108 
Definition  PHI: Column 108 of the Patient List  

EnterpriseClientCol109 
Definition  PHI: Column 109 of the Patient List  

EnterpriseClientCol110 
Definition  PHI: Column 110 of the Patient List  

EnterpriseClientCol111 
Definition  PHI: Column 111 of the Patient List  

EnterpriseClientCol112 
Definition  PHI: Column 112 of the Patient List  

EnterpriseClientCol113 
Definition  PHI: Column 113 of the Patient List  

EnterpriseClientCol114 
Definition  PHI: Column 114 of the Patient List  

EnterpriseClientCol115 
Definition  PHI: Column 115 of the Patient List  

EnterpriseClientCol116 
Definition  PHI: Column 116 of the Patient List  

EnterpriseClientCol117 
Definition  PHI: Column 117 of the Patient List  

EnterpriseClientCol118 
Definition  PHI: Column 118 of the Patient List  

EnterpriseClientCol119 
Definition  PHI: Column 119 of the Patient List  

EnterpriseClientCol120 
Definition  PHI: Column 120 of the Patient List  

EnterpriseClientCol121 
Definition  PHI: Column 121 of the Patient List  

EnterpriseClientCol122 
Definition  PHI: Column 122 of the Patient List  

EnterpriseClientCol123 
Definition  PHI: Column 123 of the Patient List  

EnterpriseClientCol124 
Definition  PHI: Column 124 of the Patient List  

EnterpriseClientCol125 
Definition  PHI: Column 125 of the Patient List  

EnterpriseClientCol126 
Definition  PHI: Column 126 of the Patient List  

EnterpriseClientCol127 
Definition  PHI: Column 127 of the Patient List  

EnterpriseClientCol128 
Definition  PHI: Column 128 of the Patient List  

EnterpriseClientCol129 
Definition  PHI: Column 129 of the Patient List  

EnterpriseClientCol130 
Definition  PHI: Column 130 of the Patient List  

EnterpriseClientCol131 
Definition  PHI: Column 131 of the Patient List  

EnterpriseClientCol132 
Definition  PHI: Column 132 of the Patient List  

EnterpriseClientCol133 
Definition  PHI: Column 133 of the Patient List  

EnterpriseClientCol134 
Definition  PHI: Column 134 of the Patient List  

EnterpriseClientCol135 
Definition  PHI: Column 135 of the Patient List  

EnterpriseClientCol136 
Definition  PHI: Column 136 of the Patient List  

EnterpriseClientCol137 
Definition  PHI: Column 137 of the Patient List  

EnterpriseClientCol138 
Definition  PHI: Column 138 of the Patient List  

EnterpriseClientCol139 
Definition  PHI: Column 139 of the Patient List  

EnterpriseClientCol140 
Definition  PHI: Column 140 of the Patient List  

EnterpriseClientCol141 
Definition  PHI: Column 141 of the Patient List  

EnterpriseClientCol142 
Definition  PHI: Column 142 of the Patient List  

EnterpriseClientCol143 
Definition  PHI: Column 143 of the Patient List  

EnterpriseClientCol144 
Definition  PHI: Column 144 of the Patient List  

EnterpriseClientCol145 
Definition  PHI: Column 145 of the Patient List  

EnterpriseClientCol146 
Definition  PHI: Column 146 of the Patient List  

EnterpriseClientCol147 
Definition  PHI: Column 147 of the Patient List  

EnterpriseClientCol148 
Definition  PHI: Column 148 of the Patient List  

EnterpriseClientCol149 
Definition  PHI: Column 149 of the Patient List  

EnterpriseClientCol150 
Definition  PHI: Column 150 of the Patient List 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.