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. |
ClaimID |
Definition | Auto generated unique primary key value. |
EpisodeID |
Definition | A foreign key to the EpisodeID column in the SXARCMEpisode table. |
CarrierID |
Definition | Insurance plan |
ClaimNumber |
Definition | PHI: Claim Number Information |
BillingRequestID |
Definition | A foreign key to the BillingRequestID column in the SXARCMBillingRequest table. |
WorksheetID |
Definition | A foreign key to the WorksheetID column in the SXARCMWorksheet table. |
InsurancePlanID |
Definition | A foreign key to the InsurancePlanID column in the SXARCMInsurancePlan table. |
ClaimBreakID |
Definition | A foreign key to the ClaimBreakID column in the SXARCMClaimBreak table. |
ClaimBreakGroupkey |
Definition | It will store the claim group name; it’s basically a key which is generated based on claim break option and transaction value. |
RebillForBillRequestID |
Definition | This represents the bill request against which this re-bill request is generated. |
IsEditCheckPassed |
Definition | This indicates whether all the edit checks have passed and this claim has gone though edit checking. |
IsMarkForRelease |
Definition | This indicates that whether claim is ready for release. |
ReleasedUTC |
Definition | This indicates the date when this claim was released |
RevenueCycleDetailID |
Definition | A foreign key to the RevenueCycleDetailID column in the SXARCMRevenueCycleDetail table. |
RevenueCycleSetupID |
Definition | A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. |
IsBilled |
Definition | flag to identify is claim billed |
BilledUTC |
Definition | Billed date time |
EpisodeYear |
Definition | Primary key |
QueuedForProductionUTC |
Definition | Claim Queued Production date time |
WorkSheetYear |
Definition | A foreign key to the WorkSheetYear column in the SXARCMWorksheet table. |
PolicyReference |
Definition | Claim Policy Reference Number |
RateCode |
Definition | Store Rate Code value |
VoidClaimReasonID |
Definition | A foreign key to the FinancialClassChangeReasonID column in the SXARCMChangeReason table. |
DocumentControlNumber |
Definition | PHI: Stores DocumentControlNumber entered by user |
VoidConditionCode |
Definition | Void condition Code |
RebillFrequencyCode |
Definition | The rebilling frequency code specified by user |
EDITransactionControlID |
Definition | A foreign key to the EDITransactionControlID column in the SXARCMEDITransactionControl table. |
PolicyNumber |
Definition | PHI: It stores Insurance Policy Number at the time of Claim Generation. |
RevenueCycleInvoiceDetailID |
Definition | A foreign key to the RevenueCycleInvoiceDetailID column in the SXARCMRevenueCycleInvoiceDetail table. |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |
ActualBilledAmount |
Definition | It stores claim amount based on claim lines for a claim |
AttendingProviderID |
Definition | Attending Provider's ID associated with the claim, set by claim break, based on attending provider history |
SubmittedDate |
Definition | Store Date of claim Submitted at Third party vendor |
OrderingProviderID |
Definition | This column will be used to save the Ordering provider Id in case of claim break on ordering provider. |
IsClaimReleaseNotAllowed |
Definition | Stores flag for claim to be released or not |
TimelyFilingDate |
Definition | This column contains timely filing date of claim. |
PaymentCycleDate |
Definition | This column contains payment cycle date of claim. |