dbo.SXARCMEpisodeCombineConfigDetail 
Default Table Name  SXARCMEpisodeCombineConfigDetail 
Definition  Saves Epsipode combine configuration related details like which combine type to be configured e.g. either is is of Mother Baby, 72 hour rule or Multiple outpatient visits on same day etc. 

dbo.SXARCMEpisodeCombineConfigDetail 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. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
EpisodeCombineConfigDetailID(PK)    int  NO  Auto generated unique primary key value. 
EpisodeCombineConfigID(FK)    int  NO  A foreign key to the EpisodeCombineConfigID column in the SXARCMEpisodeCombineConfig table. 
EffectiveDate    date  NO  Saves Effective date of the configuration 
PreAdmissionTimeFrameDayThresHold    int  NO  Threshold day value 
IsCombineAllOutpatientServices    bit  NO  flag to save if its all outpatient services 
IsCombineOutpatientDiagnosticServices    bit  NO  flag to save if outpatient diagnostic services 
IsCombineOPNonDiagnosticOnIPAdmitDate    bit  NO  flag to save if combine outpatient diagnostic services 
IsReviewNeededPreAdmissionTime    bit  NO  flag to save whether review needed for episode 
IsReviewNeededMotherBaby    bit  NO  flag to save whether review needed for episode 
IsCombineMultiVisitsSameDayWhenRevCodes    bit  NO  flag to save whether combine multiple visits same day 
IsNotCombineMultiVisitsSameDay    bit  NO  Flag to save if not combine multiple visits on same day 
IsReviewNeededMultipleVisitsSameDay    bit  NO  flag to save whether review needed for episode 
IsCombineMotherBaby    bit  NO  Flag to save whether mother baby needs to combine 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsCombinePreAdmissionTimeDiagnosis    bit  NO  If true, diagnosis codes from inpatient visits are transferred to the combined episode when performing episode combine. 
IsCombineMotherBabyDiagnosis    bit  NO  If true, diagnosis codes from the babies' visit is transferred to the combined episode when performing episode combine for mother baby visits. 
IsCombineMultiVisitsSameDayDiagnosis    bit  NO  If true, diagnosis codes from the same day multiple outpatient visits are transferred to the combined episode when performing episode combine for same-day visits. 
IsCombineAmbulatoryVisitsSameDay    bit  NO  Stores to include Ambulatory Visit in Same Day OP Visits episode combine group configuration. 
IsCombineAmbulatoryVisitsPriorToIP    bit  NO  Stores to include Ambulatory Visit in Prior To Inpatient Visit episode combine group configuration. 

dbo.SXARCMEpisodeCombineConfigDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMEpisodeCombineConfigDetailPK  PrimaryKey  EpisodeCombineConfigDetailID