dbo.SXARCMInsurancePlan 
Default Table Name  SXARCMInsurancePlan 
Definition  This table is altered to include the following columns related to Rate Codes. 

dbo.SXARCMInsurancePlan 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. 
InsurancePlanID(PK)    bigint  NO  Auto generated unique primary key value. 
FinancialClassID(FK)    int  YES  A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. 
ClaimFilingIndicatorID(FK)    int  YES  A foreign key to the ClaimFilingIndicatorID column in the SXARCMClaimFilingIndicator table. 
Code    varchar(40)  NO  Insurance Plan Code 
HasExemptFromICD10Reporting    bit  NO  Flag to Identify Insurance Plan Exempt From ICD10 Reporting or not 
UseRateCode    bit  NO  To store the user selection if the Revenue cycle needs to Use Rate Code fucntionality or not 
RateCodeTypeID(FK)    int  YES  A foreign key to the RateCodeTypeID column in the SXARCMRateCodeType table. 
PaymentTypologyID(FK)    int  YES  A foreign key to the PaymentTypologyID column in the SXARCMRRSPARCSSourceOfPaymentTypology table. 
RoundingMethod    int  YES  This column holds rounding method for Anesthesia 
TimeIncrements    int  YES  This column holds time increments for Anesthesia 
RoundingMinutes    int  YES  This column holds number of minutes for rounding for Anesthesia 
EpisodeCombineConfigID(FK)    int  YES  A foreign key to the EpisodeCombineConfigID column in the SXARCMEpisodeCombineConfig table. 
SelfPayFinancialClassID    int  YES  Stores SP financial class 
AmbulanceMileRoundingMethodType    int  YES  Stores enum value of rounding method for ambulance miles. 
PlanICD10EffectiveDate    date  YES  Stores ICD 10 effective date 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsSelfpayInsurance    bit  NO  It stores whether the Insurance Plan is SelfpayInsurance or not. 
IsSuppressInsurancePlanFromClaim    bit  NO  Column contains the value of check box "Suppress Insurance Plan From Claim" 
IsObsUptoEffectiveDateAllow    bit  NO  The value consist of Insurance plan "Allow Observation Charges Up to Effective Date and Time of Inpatient Admission" status  
TimelyFillingDays    int  YES  This column contains timely filling days value.  
PaymentCycleDays    int  YES  This column contains payment cycle days value.  
TimelyFilingThresholdDays    int  YES  This column contains timely filing threshold days value.  
MNCOverrideCodeTranslationMasterID    int  YES  ID of the Code Translation Master which provides the MNC code translation for this insurance plan 

dbo.SXARCMInsurancePlan Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMInsurancePlanPK  PrimaryKey  InsurancePlanID