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 |
|
bigint |
NO |
Auto generated unique primary key value. |
PrincipalVisitID |
|
bigint |
YES |
Referred from SCM Database |
FinancialEntityID |
|
int |
YES |
A foreign key to the FinancialEntityID column in the SXARCMFinancialEntity table. |
FinancialClassID |
|
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 |
|
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 |
|
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 |
|
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 |
|
int |
NO |
Primary key |
EpisodeSubTypeID |
|
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 |
|
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 |
|
int |
YES |
A foreign key to the EpisodeSplitConfigurationID column in the SXARCMEpisodeSplitConfiguration table. |
TransactionCodeMasterID |
|
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 |
|
int |
YES |
A foreign key to the LogicalEpisodeID column in the SXARCMLogicalEpisode table. |
IsLegacyNPNREpisode |
|
bit |
NO |
Store Is legacy epiosde or not |
EpisodeFrequencyTypeID |
|
int |
YES |
A foreign key to the EpisodeFrequencyTypeID column in the SXARCMEpisodeFrequencyType table. |