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. |
RevenueCycleDetailID |
|
int |
NO |
Auto generated unique primary key value. |
RevenueCycleSetupID |
|
int |
NO |
A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. |
ServiceSelectionInfoID |
|
int |
NO |
A foreign key to the ServiceSelectionInfoID column in the SXARCMServiceSelectionInfo table. |
ClaimBreakID |
|
int |
NO |
A foreign key to the ClaimBreakID column in the SXARCMClaimBreak table. |
ClaimFieldMasterID |
|
int |
NO |
A foreign key to the ClaimFieldMasterID column in the SXARCMClaimFieldMaster table. |
BillingCodeAutoConfigID |
|
int |
NO |
A foreign key to the BillingCodeGroupId column in the SXARCMBillingCodeGroup table. |
ChargeSummaryConfigID |
|
int |
NO |
A foreign key to the ChargeSummaryConfigID column in the SXARCMChargeSummaryConfig table. |
IsSecondaryClaimSentElectronically |
|
bit |
NO |
Flag to identify Secondary Claim Sent Electronically or not |
HoldReleaseSecondaryClaimOptionID |
|
int |
YES |
A foreign key to the HoldReleaseSecondaryClaimOptionID column in the SXARCMHoldReleaseSecondaryClaimOption table. |
PrimaryOutputMediaTypeID |
|
int |
NO |
A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. |
SecondaryOutputMediaTypeID |
|
int |
NO |
A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. |
RebillOutputMediaTypeID |
|
int |
NO |
A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. |
EDITransactionControlID |
|
int |
YES |
A foreign key to the EDITransactionControlID column in the SXARCMEDITransactionControl table. |
FinancialClassID |
|
int |
YES |
A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. |
ClaimEditGroupMasterID |
|
int |
YES |
A foreign key to the ClaimEditGroupMasterID column in the SXARCMClaimEditGroupMaster table. |
LateChargeConfigurationID |
|
int |
YES |
A foreign key to the LateChargeConfigurationID column in the SXARCMLateChargeConfiguration table. |
NonPrimaryBillingReleaseOptionID |
|
int |
NO |
A foreign key to the NonPrimaryBillingReleaseOptionID column in the SXARCMNonPrimaryBillingReleaseOption table. |
NonPrimaryBillingProcessingOptionID |
|
int |
NO |
A foreign key to the NonPrimaryBillingProcessingOptionID column in the SXARCMNonPrimaryBillingProcessingOption table. |
LateChargeOutputMediaTypeID |
|
int |
NO |
A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. |
PPSGrouperPricerID |
|
int |
YES |
A foreign key to the PPSGrouperPricerID column in the SXARCMPPSGrouperPricer table. |
ReSubmitOutputMediaTypeID |
|
int |
NO |
A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. |
InitialCustomClaimFormatId |
|
int |
YES |
A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. |
NonPrimaryCustomClaimFormatId |
|
int |
YES |
A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. |
LateChargeCustomClaimFormatId |
|
int |
YES |
A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. |
RebilledCustomClaimFormatId |
|
int |
YES |
A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. |
ResubmitCustomClaimFormatId |
|
int |
YES |
A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. |
ReimbursementMethodID |
|
int |
YES |
A foreign key to the ReimbursementMethodID column in the SXARCMEReimbursementMethod table. |
IsAdjustmentCodeEnabled |
|
bit |
NO |
Stores value whether Adj Code enbled or not |
RatecodeMethodID |
|
int |
YES |
A foreign key to the RateCodeMethodID column in the SXARCMRateCodeMethod table. |
PatientResponsibilityID |
|
bigint |
YES |
A foreign key to the PatientResponsibilityID column in the SXARCMPatientResponsibility table. |
PatientResponsibilityMethodTypeID |
|
int |
NO |
Integer that maps to an enum type |
ProxyClaimPayerConfigId |
|
int |
YES |
A foreign key to the ProxyClaimPayerConfigId column in the SXARCMProxyClaimPayerConfiguration table. |
IsSendVoidClaimOnRebill |
|
bit |
NO |
Stored the flaf for Coid claim on Rebill |
MaxClaimLines |
|
int |
YES |
maximum number of claim lines that this insurance allows for a claim |
CodeTranslationMasterID |
|
int |
YES |
A foreign key to the CodeTranslationMasterID column in the SXARCMCodeTranslationMaster table. |
MedicarePlanType |
|
int |
YES |
Medicare plan type |
IsHoldPrimaryClaim |
|
bit |
NO |
Flag to Hold Primary Claims |
IsUseBillUnits |
|
bit |
NO |
Flag to identify to use billing units calculation Method |
DenialConfigID |
|
int |
YES |
A foreign key to the DenialConfigID column in the SXARCMDenialConfig table. |
HIPPSLineRevenueCode |
|
varchar(10) |
YES |
Used to store the HIPPS Line Revenue code |
TotalLineRevenueCode |
|
varchar(10) |
YES |
Used to store the Total Line Revenue code |
AlternateClaimPayerName |
|
varchar(23) |
YES |
PHI: represents alternate payer name |
EffectiveDate |
|
date |
NO |
Stores effective date |
IsUseSpecialPaperFormat |
|
bit |
NO |
Store special format for value codes is selected or not |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
LabPanelConfigID |
|
int |
YES |
A foreign key to the LabPanelConfigID column in the SXARCMLabPanelConfig table. |
IsProcessTaxRuleforClaim |
|
bit |
NO |
It stores whether process tax rule for claim. |
IsAdjustClaimTaxOnER |
|
bit |
NO |
It stores whether Adjust claim tax on ER. |
ContributingTypeID |
|
int |
YES |
A foreign key to the ContributingTypeID column in the SXARCMContributingType table. |
IsAutoTransferPRWhenSingleInsurance |
|
bit |
NO |
Boolean that decides if accelerated billing should be used |
GlobalBillingConfigID |
|
int |
YES |
A foreign key to the GlobalBillingConfigID column in the SXARCMGlobalBillingConfig table. |
IsReleaseNonPrimZeroBalanceClaim |
|
bit |
NO |
This column store information as true (1) if release non primary having Zero Balance claim amount |
IsSupressAdjWhenZeroER |
|
bit |
NO |
Checkbox to suppress adjustment taken at billing |
IsFollowHigherPriorityPayerFacilityCode |
|
bit |
NO |
Specifies whether the claim is following prior payer claim's facility code or not |
IsFollowHigherPriorityPayerChargeSummarization |
|
bit |
NO |
Specifies whether the claim is following prior payer claim's charge summarization configuration or not |
IsFollowHigherPriorityPayerCodeTranslation |
|
bit |
NO |
Specifies whether the claim is following prior payer claim's code translation configuration or not |
IsFollowHigherPriorityPayerLabPanel |
|
bit |
NO |
Specifies whether the claim is following prior payer claim's lab panel configuration or not |
IsSequestAdjustmentCodeEnabled |
|
bit |
NO |
checkbox to save if Sequestration adjustment is configured or not |