dbo.CV3EnterpriseClientData 
Default Table Name  CV3EnterpriseClientData 
Definition  Contains the enterprise-defined data for the client. 

dbo.CV3EnterpriseClientData 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. 
ClientGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Client table. 
EnterpriseClientCol1    varchar(255)  YES  PHI: Column 1 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol2    varchar(255)  YES  PHI: Column 2 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol3    varchar(255)  YES  PHI: Column 3 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol4    varchar(255)  YES  PHI: Column 4 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol5    varchar(255)  YES  PHI: Column 5 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol6    varchar(255)  YES  PHI: Column 6 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol7    varchar(255)  YES  PHI: Column 7 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol8    varchar(255)  YES  PHI: Column 8 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol9    varchar(255)  YES  PHI: Column 9 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol10    varchar(255)  YES  PHI: Column 10 of the Patient List. Used to check for Client Scope flag 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
EnterpriseClientCol11    varchar(255)  YES  PHI: Column 11 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol12    varchar(255)  YES  PHI: Column 12 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol13    varchar(255)  YES  PHI: Column 13 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol14    varchar(255)  YES  PHI: Column 14 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol15    varchar(255)  YES  PHI: Column 15 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol16    varchar(255)  YES  PHI: Column 16 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol17    varchar(255)  YES  PHI: Column 17 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol18    varchar(255)  YES  PHI: Column 18 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol19    varchar(255)  YES  PHI: Column 19 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol20    varchar(255)  YES  PHI: Column 20 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol21    varchar(255)  YES  PHI: Column 21 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol22    varchar(255)  YES  PHI: Column 22 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol23    varchar(255)  YES  PHI: Column 23 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol24    varchar(255)  YES  PHI: Column 24 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol25    varchar(255)  YES  PHI: Column 25 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol26    varchar(255)  YES  PHI: Column 26 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol27    varchar(255)  YES  PHI: Column 27 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol28    varchar(255)  YES  PHI: Column 28 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol29    varchar(255)  YES  PHI: Column 29 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol30    varchar(255)  YES  PHI: Column 30 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol31    varchar(255)  YES  PHI: Column 31 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol32    varchar(255)  YES  PHI: Column 32 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol33    varchar(255)  YES  PHI: Column 33 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol34    varchar(255)  YES  PHI: Column 34 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol35    varchar(255)  YES  PHI: Column 35 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol36    varchar(255)  YES  PHI: Column 36 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol37    varchar(255)  YES  PHI: Column 37 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol38    varchar(255)  YES  PHI: Column 38 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol39    varchar(255)  YES  PHI: Column 39 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol40    varchar(255)  YES  PHI: Column 40 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol41    varchar(255)  YES  PHI: Column 41 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol42    varchar(255)  YES  PHI: Column 42 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol43    varchar(255)  YES  PHI: Column 43 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol44    varchar(255)  YES  PHI: Column 44 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol45    varchar(255)  YES  PHI: Column 45 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol46    varchar(255)  YES  PHI: Column 46 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol47    varchar(255)  YES  PHI: Column 47 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol48    varchar(255)  YES  PHI: Column 48 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol49    varchar(255)  YES  PHI: Column 49 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol50    varchar(255)  YES  PHI: Column 50 of the Patient List. Used to check for Client Scope flag 
EnterpriseClientCol51    varchar(255)  YES  PHI: Column 51 of the Patient List  
EnterpriseClientCol52    varchar(255)  YES  PHI: Column 52 of the Patient List  
EnterpriseClientCol53    varchar(255)  YES  PHI: Column 53 of the Patient List  
EnterpriseClientCol54    varchar(255)  YES  PHI: Column 54 of the Patient List  
EnterpriseClientCol55    varchar(255)  YES  PHI: Column 55 of the Patient List  
EnterpriseClientCol56    varchar(255)  YES  PHI: Column 56 of the Patient List  
EnterpriseClientCol57    varchar(255)  YES  PHI: Column 57 of the Patient List  
EnterpriseClientCol58    varchar(255)  YES  PHI: Column 58 of the Patient List  
EnterpriseClientCol59    varchar(255)  YES  PHI: Column 59 of the Patient List  
EnterpriseClientCol60    varchar(255)  YES  PHI: Column 60 of the Patient List  
EnterpriseClientCol61    varchar(255)  YES  PHI: Column 61 of the Patient List  
EnterpriseClientCol62    varchar(255)  YES  PHI: Column 62 of the Patient List  
EnterpriseClientCol63    varchar(255)  YES  PHI: Column 63 of the Patient List  
EnterpriseClientCol64    varchar(255)  YES  PHI: Column 64 of the Patient List  
EnterpriseClientCol65    varchar(255)  YES  PHI: Column 65 of the Patient List  
EnterpriseClientCol66    varchar(255)  YES  PHI: Column 66 of the Patient List  
EnterpriseClientCol67    varchar(255)  YES  PHI: Column 67 of the Patient List  
EnterpriseClientCol68    varchar(255)  YES  PHI: Column 68 of the Patient List  
EnterpriseClientCol69    varchar(255)  YES  PHI: Column 69 of the Patient List  
EnterpriseClientCol70    varchar(255)  YES  PHI: Column 70 of the Patient List  
EnterpriseClientCol71    varchar(255)  YES  PHI: Column 71 of the Patient List  
EnterpriseClientCol72    varchar(255)  YES  PHI: Column 72 of the Patient List  
EnterpriseClientCol73    varchar(255)  YES  PHI: Column 73 of the Patient List  
EnterpriseClientCol74    varchar(255)  YES  PHI: Column 74 of the Patient List  
EnterpriseClientCol75    varchar(255)  YES  PHI: Column 75 of the Patient List  
EnterpriseClientCol76    varchar(255)  YES  PHI: Column 76 of the Patient List  
EnterpriseClientCol77    varchar(255)  YES  PHI: Column 77 of the Patient List  
EnterpriseClientCol78    varchar(255)  YES  PHI: Column 78 of the Patient List  
EnterpriseClientCol79    varchar(255)  YES  PHI: Column 79 of the Patient List  
EnterpriseClientCol80    varchar(255)  YES  PHI: Column 80 of the Patient List  
EnterpriseClientCol81    varchar(255)  YES  PHI: Column 81 of the Patient List  
EnterpriseClientCol82    varchar(255)  YES  PHI: Column 82 of the Patient List  
EnterpriseClientCol83    varchar(255)  YES  PHI: Column 83 of the Patient List  
EnterpriseClientCol84    varchar(255)  YES  PHI: Column 84 of the Patient List  
EnterpriseClientCol85    varchar(255)  YES  PHI: Column 85 of the Patient List  
EnterpriseClientCol86    varchar(255)  YES  PHI: Column 86 of the Patient List  
EnterpriseClientCol87    varchar(255)  YES  PHI: Column 87 of the Patient List  
EnterpriseClientCol88    varchar(255)  YES  PHI: Column 88 of the Patient List  
EnterpriseClientCol89    varchar(255)  YES  PHI: Column 89 of the Patient List  
EnterpriseClientCol90    varchar(255)  YES  PHI: Column 90 of the Patient List  
EnterpriseClientCol91    varchar(255)  YES  PHI: Column 91 of the Patient List  
EnterpriseClientCol92    varchar(255)  YES  PHI: Column 92 of the Patient List  
EnterpriseClientCol93    varchar(255)  YES  PHI: Column 93 of the Patient List  
EnterpriseClientCol94    varchar(255)  YES  PHI: Column 94 of the Patient List  
EnterpriseClientCol95    varchar(255)  YES  PHI: Column 95 of the Patient List  
EnterpriseClientCol96    varchar(255)  YES  PHI: Column 96 of the Patient List  
EnterpriseClientCol97    varchar(255)  YES  PHI: Column 97 of the Patient List  
EnterpriseClientCol98    varchar(255)  YES  PHI: Column 98 of the Patient List  
EnterpriseClientCol99    varchar(255)  YES  PHI: Column 99 of the Patient List  
EnterpriseClientCol100    varchar(255)  YES  PHI: Column 100 of the Patient List  
EnterpriseClientCol101    varchar(255)  YES  PHI: Column 101 of the Patient List  
EnterpriseClientCol102    varchar(255)  YES  PHI: Column 102 of the Patient List  
EnterpriseClientCol103    varchar(255)  YES  PHI: Column 103 of the Patient List  
EnterpriseClientCol104    varchar(255)  YES  PHI: Column 104 of the Patient List  
EnterpriseClientCol105    varchar(255)  YES  PHI: Column 105 of the Patient List  
EnterpriseClientCol106    varchar(255)  YES  PHI: Column 106 of the Patient List  
EnterpriseClientCol107    varchar(255)  YES  PHI: Column 107 of the Patient List  
EnterpriseClientCol108    varchar(255)  YES  PHI: Column 108 of the Patient List  
EnterpriseClientCol109    varchar(255)  YES  PHI: Column 109 of the Patient List  
EnterpriseClientCol110    varchar(255)  YES  PHI: Column 110 of the Patient List  
EnterpriseClientCol111    varchar(255)  YES  PHI: Column 111 of the Patient List  
EnterpriseClientCol112    varchar(255)  YES  PHI: Column 112 of the Patient List  
EnterpriseClientCol113    varchar(255)  YES  PHI: Column 113 of the Patient List  
EnterpriseClientCol114    varchar(255)  YES  PHI: Column 114 of the Patient List  
EnterpriseClientCol115    varchar(255)  YES  PHI: Column 115 of the Patient List  
EnterpriseClientCol116    varchar(255)  YES  PHI: Column 116 of the Patient List  
EnterpriseClientCol117    varchar(255)  YES  PHI: Column 117 of the Patient List  
EnterpriseClientCol118    varchar(255)  YES  PHI: Column 118 of the Patient List  
EnterpriseClientCol119    varchar(255)  YES  PHI: Column 119 of the Patient List  
EnterpriseClientCol120    varchar(255)  YES  PHI: Column 120 of the Patient List  
EnterpriseClientCol121    varchar(255)  YES  PHI: Column 121 of the Patient List  
EnterpriseClientCol122    varchar(255)  YES  PHI: Column 122 of the Patient List  
EnterpriseClientCol123    varchar(255)  YES  PHI: Column 123 of the Patient List  
EnterpriseClientCol124    varchar(255)  YES  PHI: Column 124 of the Patient List  
EnterpriseClientCol125    varchar(255)  YES  PHI: Column 125 of the Patient List  
EnterpriseClientCol126    varchar(255)  YES  PHI: Column 126 of the Patient List  
EnterpriseClientCol127    varchar(255)  YES  PHI: Column 127 of the Patient List  
EnterpriseClientCol128    varchar(255)  YES  PHI: Column 128 of the Patient List  
EnterpriseClientCol129    varchar(255)  YES  PHI: Column 129 of the Patient List  
EnterpriseClientCol130    varchar(255)  YES  PHI: Column 130 of the Patient List  
EnterpriseClientCol131    varchar(255)  YES  PHI: Column 131 of the Patient List  
EnterpriseClientCol132    varchar(255)  YES  PHI: Column 132 of the Patient List  
EnterpriseClientCol133    varchar(255)  YES  PHI: Column 133 of the Patient List  
EnterpriseClientCol134    varchar(255)  YES  PHI: Column 134 of the Patient List  
EnterpriseClientCol135    varchar(255)  YES  PHI: Column 135 of the Patient List  
EnterpriseClientCol136    varchar(255)  YES  PHI: Column 136 of the Patient List  
EnterpriseClientCol137    varchar(255)  YES  PHI: Column 137 of the Patient List  
EnterpriseClientCol138    varchar(255)  YES  PHI: Column 138 of the Patient List  
EnterpriseClientCol139    varchar(255)  YES  PHI: Column 139 of the Patient List  
EnterpriseClientCol140    varchar(255)  YES  PHI: Column 140 of the Patient List  
EnterpriseClientCol141    varchar(255)  YES  PHI: Column 141 of the Patient List  
EnterpriseClientCol142    varchar(255)  YES  PHI: Column 142 of the Patient List  
EnterpriseClientCol143    varchar(255)  YES  PHI: Column 143 of the Patient List  
EnterpriseClientCol144    varchar(255)  YES  PHI: Column 144 of the Patient List  
EnterpriseClientCol145    varchar(255)  YES  PHI: Column 145 of the Patient List  
EnterpriseClientCol146    varchar(255)  YES  PHI: Column 146 of the Patient List  
EnterpriseClientCol147    varchar(255)  YES  PHI: Column 147 of the Patient List  
EnterpriseClientCol148    varchar(255)  YES  PHI: Column 148 of the Patient List  
EnterpriseClientCol149    varchar(255)  YES  PHI: Column 149 of the Patient List  
EnterpriseClientCol150    varchar(255)  YES  PHI: Column 150 of the Patient List 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3EnterpriseClientData Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3EnterpriseClientDataPK  PrimaryKey  GUID