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. 

TypeCode 
Definition  Not used. 

StartDate 
Definition  Enterprise TimeZone - The start date of the contract. 

EndDate 
Definition  Enterprise TimeZone - The end date of the contract. 

PolicyNum 
Definition  PHI: The policy number. 

GroupNum 
Definition  The group number. 

CertificateNum 
Definition  The certificate number. 

PlanNum 
Definition  PHI: The plan number. 

Comments 
Definition  PHI: Descriptive text regarding the subscriber. 

RelationshipCode 
Definition  A foreign key to the Code column in the CV3Relationship table. 

AddrLine1 
Definition  PHI: The first line of the subscriber's address. 

AddrLine2 
Definition  PHI: The second line of the subscriber's address. 

AddrLine3 
Definition  PHI: The third line of the subscriber's address. 

City 
Definition  PHI: The subscriber's city. 

CountryCode 
Definition  PHI: The subscriber's country. 

CountryDvsnCode 
Definition  A foreign key to the Code column in the CV3CountryDivision table. 

PostalCode 
Definition  PHI: The subscriber's postal or Zip code. 

Name 
Definition  PHI: The subscriber's name. 

HomePhoneNumber 
Definition  PHI: The subscriber's home phone number. Format is 555-555 

BusinessPhoneNumber 
Definition  PHI: The subscriber's business phone number. Format is 555-555 

AltPhoneNumber 
Definition  PHI: The subscriber's alternate phone number. 

HomeAreaCode 
Definition  PHI: The subscriber's home area code. 

BusinessAreaCode 
Definition  PHI: The subscriber's business area code. 

AltAreaCode 
Definition  PHI: The subscriber's alternate area code. 

IsSameAddress 
Definition  Indicates if the subscriber's address is the same as the client's address. 1 = True; 0 = False 

IsCurrent 
Definition  Indicates if the policy is current. 1 = True; 0 = False 

SSNum 
Definition  PHI: The subscriber's Social Security number. 

EligibilityCode 
Definition  PHI: The subscriber's eligibility code. 

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

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

FRPGUID 
Definition  A foreign key to the GUID column in the CV3FRP table. 

Status 
Definition  The status of the contract. 

ApplicSource 
Definition  Identifies which Eclipsys application was used to enter the information. Either CV (Sunrise Clinical Manager), ADT (ADT interface), or LAB (LAB interface) 

EntryFormGUID 
Definition  A foreign key to the GUID column in the CV3OrderEntryForm table. 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

ResidenceCode 
Definition  PHI: County or Residence code of the Insured Person 

HomePhoneExtension 
Definition  PHI: Home phone extension of the Insured Person 

BusinessPhoneExtention 
Definition  PHI: Business phone extension of the Insured Person 

AltPhoneExtension 
Definition  PHI: Extension of the Alternate phone for the insured person 

SequenceNum 
Definition  Order the insurance have on the screen 

InsuredPersonGUID 
Definition  Link to CV3Client.GUIID. This field identifies the Client that is the Insured Person for this Insurance Policy. When the Insured Person is the Patient, the Patient's ClientGUID will be used. If the Insured Person is free-texted in either as the result of being migrated from SCM or an incoming HL7 message, then this field will be NULL and the Insured Person details will be described by the fields in this table. 

ReactivationDate 
Definition  Enterprise TimeZone - Denotes date/time policy of reactivation 

AuthorizationNum 
Definition  PHI: Denotes Authorization Number for this insurance 

NameOnInsuranceCard 
Definition  PHI: Denotes the name on the insurance card 

Copayment 
Definition  PHI: Denotes insurance copay amount for services 

PharmacyPlanID 
Definition  PHI: Denotes the Pharmacy Plan ID 

LastNameOnInsCard 
Definition  PHI: Store the Last name of the Insured Person as it appears on the Insurance Card 

FirstNameOnInsCard 
Definition  PHI: Store the First name of the Insured Person as it appears on the Insurance Card 

MiddleNameOnInsCard 
Definition  PHI: Store the Middle name of the Insured Person as it appears on the Insurance Card 

InsuranceCardBirthDate 
Definition  Insurance Card Birth Date 

GenderOnInsCard 
Definition  To save Gender of patient mentioned on card.
 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.