Build 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  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 
Definition  Optimistic lock identifier using rowversion datatype. 

EpisodeID 
Definition  Auto generated unique primary key value. 

PrincipalVisitID 
Definition  Referred from SCM Database 

FinancialEntityID 
Definition  A foreign key to the FinancialEntityID column in the SXARCMFinancialEntity table. 

FinancialClassID 
Definition  A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. 

StatusChangeUTC 
Definition  Date when Episode status changed 

FinancialClassHistory 
Definition  Stores details of previous financial class along with the date when it was changed 

EpisodeCreationRuleID 
Definition  A foreign key to the EpisodeCreationRuleID column in the SXARCMEpisodeCreationRule table. 

IsManual 
Definition  Flag for check whether this episode Created manually or System Generated 

EpisodeStatusId 
Definition  A foreign key to the EpisodeStatusId column in the SXARCMEpisodeStatus table. 

AbstractType 
Definition  Various statuses are None, Pre Receivable, Pending Receivable, Active Receivable,Zero Balance, Other Account Receivable. 

StatusHistory 
Definition  This stores all the pervious statuses and date when it was changed. 

FinancialClassChangeReasonID 
Definition  FK Key Reference to SXARCMFinancialClassChangeReason table 

EpisodeName 
Definition  Episode Name 

IsNonReceivable 
Definition  Flag to check is non patient episode or not 

LocationID 
Definition  Enterprise / Facility / Location ID from the CV3Location table in AM 

ReceivableAssetUID 
Definition  Receivable Asset UID(FK to SXARCMReceivableAssetUID) 

EpisodeCreationConfigurationID 
Definition  A foreign key to the EpisodeCreationConfigurationID column in the SXARCMEpisodeCreationConfiguration table. 

IsPrincipalVisitOverriden 
Definition  Flag to identify Principal Visit Overridden or not. 

OverridenVisitTypeID 
Definition  Overridden Visit Type ID(Referring from CV3VisitType) 

EpisodeYear 
Definition  Primary key 

EpisodeSubTypeID 
Definition  A foreign key to the EpisodeSubTypeID column in the SXARCMEpisodeSubType table. 

Balance 
Definition  To store the total balance of episode 

TotalCharges 
Definition  To store the total charges of episode 

TotalPayments 
Definition  To store the total payments of episode 

EpisodeCombineType 
Definition  Stored the Episode Combine Type 

IsEpisodeReviewCompleted 
Definition  stores value if episode review is done after combining episodes 

TotalAdjustments 
Definition  To store the total adjustments of episode 

LastPaymentAmount 
Definition  To store the last payment amount of episode 

EpisodeCombineConfigDetailID 
Definition  A foreign key to the EpisodeCombineConfigDetailID column in the SXARCMEpisodeCombineConfigDetail table. 

FromDate 
Definition  Stores Episode From Date 

ThroughDate 
Definition  Stores Episode Through Date 

IntervalThroughDate 
Definition  Stores Episode Interval Through Date 

LastPaymentDate 
Definition  Stores Last payment date for payment 

FinancialClassLastChangeDateUTC 
Definition  The date-time of the last change made to the episode financial class. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsRebillRequested 
Definition  Flag is used for activating Rebill process or not. 

RenderingProviderID 
Definition  This columns indicates the RenderingProviderID linked to Episode for which the Episode was created using rule 

IsEpisodeRecastReviewNeeded 
Definition  Column contains the Episode Recast Review Needed Flag 

IsEpisodeRecastReviewed 
Definition  Column contains the Episode Recast Review Reviewed Flag 

EpisodeGroupType 
Definition  Stores episode's group type 

IsRetired 
Definition  Stores episode is retired. 

EpisodeSplitConfigurationID 
Definition  A foreign key to the EpisodeSplitConfigurationID column in the SXARCMEpisodeSplitConfiguration table. 

TransactionCodeMasterID 
Definition  A foreign key to the TransactionCodeMasterID column in the SXARCMTransactionCodeMaster table. 

ProspectiveCombineCategory 
Definition  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 
Definition  A foreign key to the LogicalEpisodeID column in the SXARCMLogicalEpisode table. 

IsLegacyNPNREpisode 
Definition  Store Is legacy epiosde or not 

EpisodeFrequencyTypeID 
Definition  A foreign key to the EpisodeFrequencyTypeID column in the SXARCMEpisodeFrequencyType table.