dbo.SXARCMStatementVisitInsuranceInfo 
Default Table Name  SXARCMStatementVisitInsuranceInfo 
Definition  Stores Statement visit insurance data 

dbo.SXARCMStatementVisitInsuranceInfo Columns 
ColumnName  Domain  Datatype  NULL  Definition 
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)  NO  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. 
TouchedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
CreatedBy    varchar(50)  NO  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. 
CreatedWhenUTC    datetimeoffset(3)  NO  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
StatementVisitInsuranceInfoId(PK)    bigint  NO  Auto generated unique primary key value. 
StatementArtifactID(FK)    bigint  NO  A foreign key to the StatementArtifactID column in the SXARCMStatementArtifact table. 
VisitId    HVCIDdt  NO  Contains the Visit Id 
GUID    HVCIDdt  NO  Unique primary key value. 
PolicyNum    varchar(30)  YES  PHI: Contains the Policy Number of Insurance 
GroupNum    varchar(30)  YES  PHI: Contains the Group Number 
PlanNum    varchar(30)  YES  PHI: Contains the Plan Number 
AddrLine1    varchar(50)  YES  PHI: Contains the Address Line1 
AddrLine2    varchar(50)  YES  PHI: Contains the Address Line2 
AddrLine3    varchar(50)  YES  PHI: Contains the Address Line3 
Name    varchar(40)  YES  PHI: Contains the Name of Insurance 
BusinessPhoneNumber    varchar(40)  YES  PHI: Contains the Business Phone Number 
EligibilityCode    varchar(20)  YES  Contains the Eligibility Code 
ClientGUID    HVCIDdt  NO  Contains the Client unique ID 
ClientVisitGUID    HVCIDdt  NO  Contains the ClientVisit unique ID 
FRPGUID    HVCIDdt  NO  Contains the FRP Unique ID 
NameOnInsuranceCard    varchar(50)  YES  PHI: Contains the Name On Insurance Card 
AuthorizationNum    varchar(40)  YES  PHI: Contains the Authorization Number 
Copayment    varchar(50)  YES  Contains the Copayment detail 
PharmacyPlanID    bigint  YES  Contains the Pharmacy Plan ID 
WorkSheetYear(FK)    int  NO  A foreign key to the WorkSheetYear column in the SXARCMStatementArtifact table. 
SequenceNum    tinyint  YES  Sequence number of the insurance 
StartDate    date  YES  PHI: Stores Visit Insurance start date 
EndDate    date  YES  PHI: Stores Visit Insurance end date 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXARCMStatementVisitInsuranceInfo Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMStatementVisitInsuranceInfoPK  PrimaryKey  StatementVisitInsuranceInfoId