dbo.CV3FRPContract 
Default Table Name  CV3FRPContract 
Definition  Specific agreement between a Financially Responsible Party and a client. 

dbo.CV3FRPContract 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. 
TypeCode    varchar(30)  YES  Not used. 
StartDate    datetime  YES  Enterprise TimeZone - The start date of the contract. 
EndDate    datetime  YES  Enterprise TimeZone - The end date of the contract. 
PolicyNum    varchar(50)  YES  PHI: The policy number. 
GroupNum    varchar(30)  YES  The group number. 
CertificateNum    varchar(30)  YES  The certificate number. 
PlanNum    varchar(30)  YES  PHI: The plan number. 
Comments    varchar(60)  YES  PHI: Descriptive text regarding the subscriber. 
RelationshipCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3Relationship table. 
AddrLine1    varchar(50)  YES  PHI: The first line of the subscriber's address. 
AddrLine2    varchar(50)  YES  PHI: The second line of the subscriber's address. 
AddrLine3    varchar(50)  YES  PHI: The third line of the subscriber's address. 
City    varchar(35)  YES  PHI: The subscriber's city. 
CountryCode    varchar(30)  YES  PHI: The subscriber's country. 
CountryDvsnCode(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3CountryDivision table. 
PostalCode    varchar(15)  YES  PHI: The subscriber's postal or Zip code. 
Name    varchar(40)  YES  PHI: The subscriber's name. 
HomePhoneNumber    varchar(40)  YES  PHI: The subscriber's home phone number. Format is 555-555 
BusinessPhoneNumber    varchar(40)  YES  PHI: The subscriber's business phone number. Format is 555-555 
AltPhoneNumber    varchar(40)  YES  PHI: The subscriber's alternate phone number. 
HomeAreaCode    varchar(10)  YES  PHI: The subscriber's home area code. 
BusinessAreaCode    varchar(10)  YES  PHI: The subscriber's business area code. 
AltAreaCode    varchar(10)  YES  PHI: The subscriber's alternate area code. 
IsSameAddress    bit  NO  Indicates if the subscriber's address is the same as the client's address. 1 = True; 0 = False 
IsCurrent    bit  NO  Indicates if the policy is current. 1 = True; 0 = False 
SSNum    varchar(20)  YES  PHI: The subscriber's Social Security number. 
EligibilityCode    varchar(20)  YES  PHI: The subscriber's eligibility code. 
ClientGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Client table. 
ClientVisitGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ClientVisit table. 
FRPGUID    HVCIDdt  YES  A foreign key to the GUID column in the CV3FRP table. 
Status    varchar(10)  YES  The status of the contract. 
ApplicSource    char(5)  YES  Identifies which Eclipsys application was used to enter the information. Either CV (Sunrise Clinical Manager), ADT (ADT interface), or LAB (LAB interface) 
EntryFormGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrderEntryForm table. 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
ResidenceCode    varchar(30)  YES  PHI: County or Residence code of the Insured Person 
HomePhoneExtension    varchar(20)  YES  PHI: Home phone extension of the Insured Person 
BusinessPhoneExtention    varchar(20)  YES  PHI: Business phone extension of the Insured Person 
AltPhoneExtension    varchar(20)  YES  PHI: Extension of the Alternate phone for the insured person 
SequenceNum    tinyint  YES  Order the insurance have on the screen 
InsuredPersonGUID    HVCIDdt  YES  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    datetime  YES  Enterprise TimeZone - Denotes date/time policy of reactivation 
AuthorizationNum    varchar(40)  YES  PHI: Denotes Authorization Number for this insurance 
NameOnInsuranceCard    varchar(50)  YES  PHI: Denotes the name on the insurance card 
Copayment    smallmoney  YES  PHI: Denotes insurance copay amount for services 
PharmacyPlanID    int  YES  PHI: Denotes the Pharmacy Plan ID 
LastNameOnInsCard    varchar(35)  YES  PHI: Store the Last name of the Insured Person as it appears on the Insurance Card 
FirstNameOnInsCard    varchar(35)  YES  PHI: Store the First name of the Insured Person as it appears on the Insurance Card 
MiddleNameOnInsCard    varchar(35)  YES  PHI: Store the Middle name of the Insured Person as it appears on the Insurance Card 
InsuranceCardBirthDate    date  YES  Insurance Card Birth Date 
GenderOnInsCard    varchar(20)  YES  To save Gender of patient mentioned on card.
 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3FRPContract Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3FRPContractPK  PrimaryKey  GUID