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. |