dbo.SXARCMEpisode 
Default Table Name  SXARCMEpisode 
Definition  This is a container that is used to group transactions base on rule. It also contains episode specific details. It stores current status and date when this status was assigned and status history. 

dbo.SXARCMEpisode 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. 
EpisodeID(PK)    bigint  NO  Auto generated unique primary key value. 
PrincipalVisitID    bigint  YES  Referred from SCM Database 
FinancialEntityID(FK)    int  YES  A foreign key to the FinancialEntityID column in the SXARCMFinancialEntity table. 
FinancialClassID(FK)    int  YES  A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. 
StatusChangeUTC    datetimeoffset(3)  YES  Date when Episode status changed 
FinancialClassHistory    xml  YES  Stores details of previous financial class along with the date when it was changed 
EpisodeCreationRuleID(FK)    bigint  YES  A foreign key to the EpisodeCreationRuleID column in the SXARCMEpisodeCreationRule table. 
IsManual    bit  YES  Flag for check whether this episode Created manually or System Generated 
EpisodeStatusId(FK)    int  YES  A foreign key to the EpisodeStatusId column in the SXARCMEpisodeStatus table. 
AbstractType    int  NO  Various statuses are None, Pre Receivable, Pending Receivable, Active Receivable,Zero Balance, Other Account Receivable. 
StatusHistory    xml  YES  This stores all the pervious statuses and date when it was changed. 
FinancialClassChangeReasonID    int  YES  FK Key Reference to SXARCMFinancialClassChangeReason table 
EpisodeName    varchar(50)  YES  Episode Name 
IsNonReceivable    bit  NO  Flag to check is non patient episode or not 
LocationID    HVCIDdt  YES  Enterprise / Facility / Location ID from the CV3Location table in AM 
ReceivableAssetUID    bigint  YES  Receivable Asset UID(FK to SXARCMReceivableAssetUID) 
EpisodeCreationConfigurationID(FK)    int  YES  A foreign key to the EpisodeCreationConfigurationID column in the SXARCMEpisodeCreationConfiguration table. 
IsPrincipalVisitOverriden    bit  NO  Flag to identify Principal Visit Overridden or not. 
OverridenVisitTypeID    bigint  YES  Overridden Visit Type ID(Referring from CV3VisitType) 
EpisodeYear(PK)    int  NO  Primary key 
EpisodeSubTypeID(FK)    int  YES  A foreign key to the EpisodeSubTypeID column in the SXARCMEpisodeSubType table. 
Balance    numeric(23, 4)  YES  To store the total balance of episode 
TotalCharges    SXACurrencyDt  NO  To store the total charges of episode 
TotalPayments    SXACurrencyDt  NO  To store the total payments of episode 
EpisodeCombineType    int  YES  Stored the Episode Combine Type 
IsEpisodeReviewCompleted    bit  YES  stores value if episode review is done after combining episodes 
TotalAdjustments    SXACurrencyDt  NO  To store the total adjustments of episode 
LastPaymentAmount    SXACurrencyDt  NO  To store the last payment amount of episode 
EpisodeCombineConfigDetailID(FK)    int  YES  A foreign key to the EpisodeCombineConfigDetailID column in the SXARCMEpisodeCombineConfigDetail table. 
FromDate    date  NO  Stores Episode From Date 
ThroughDate    date  YES  Stores Episode Through Date 
IntervalThroughDate    date  YES  Stores Episode Interval Through Date 
LastPaymentDate    date  YES  Stores Last payment date for payment 
FinancialClassLastChangeDateUTC    datetimeoffset(3)  YES  The date-time of the last change made to the episode financial class. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsRebillRequested    bit  NO  Flag is used for activating Rebill process or not. 
RenderingProviderID    HVCIDdt  YES  This columns indicates the RenderingProviderID linked to Episode for which the Episode was created using rule 
IsEpisodeRecastReviewNeeded    bit  NO  Column contains the Episode Recast Review Needed Flag 
IsEpisodeRecastReviewed    bit  NO  Column contains the Episode Recast Review Reviewed Flag 
EpisodeGroupType    int  YES  Stores episode's group type 
IsRetired    bit  NO  Stores episode is retired. 
EpisodeSplitConfigurationID(FK)    int  YES  A foreign key to the EpisodeSplitConfigurationID column in the SXARCMEpisodeSplitConfiguration table. 
TransactionCodeMasterID(FK)    int  YES  A foreign key to the TransactionCodeMasterID column in the SXARCMTransactionCodeMaster table. 
ProspectiveCombineCategory    tinyint  YES  Stores the calculative value indicating future combine type of Episode.
ProspectiveCombineCategory this column will store number like 1,2,3 which indicates IO, OO, MB respectively and will add those using UI. 
LogicalEpisodeID(FK)    int  YES  A foreign key to the LogicalEpisodeID column in the SXARCMLogicalEpisode table. 
IsLegacyNPNREpisode    bit  NO  Store Is legacy epiosde or not 
EpisodeFrequencyTypeID(FK)    int  YES  A foreign key to the EpisodeFrequencyTypeID column in the SXARCMEpisodeFrequencyType table. 

dbo.SXARCMEpisode Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMEpisodePK  PrimaryKey  EpisodeID, EpisodeYear