dbo.SXARCMRevenueCycleDetail 
Default Table Name  SXARCMRevenueCycleDetail 
Definition  This table is altered to include the following columns related to Rate Codes. 

dbo.SXARCMRevenueCycleDetail 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. 
RevenueCycleDetailID(PK)    int  NO  Auto generated unique primary key value. 
RevenueCycleSetupID(FK)    int  NO  A foreign key to the RevenueCycleSetupID column in the SXARCMRevenueCycleSetup table. 
ServiceSelectionInfoID(FK)    int  NO  A foreign key to the ServiceSelectionInfoID column in the SXARCMServiceSelectionInfo table. 
ClaimBreakID(FK)    int  NO  A foreign key to the ClaimBreakID column in the SXARCMClaimBreak table. 
ClaimFieldMasterID(FK)    int  NO  A foreign key to the ClaimFieldMasterID column in the SXARCMClaimFieldMaster table. 
BillingCodeAutoConfigID(FK)    int  NO  A foreign key to the BillingCodeGroupId column in the SXARCMBillingCodeGroup table. 
ChargeSummaryConfigID(FK)    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(FK)    int  YES  A foreign key to the HoldReleaseSecondaryClaimOptionID column in the SXARCMHoldReleaseSecondaryClaimOption table. 
PrimaryOutputMediaTypeID(FK)    int  NO  A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. 
SecondaryOutputMediaTypeID(FK)    int  NO  A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. 
RebillOutputMediaTypeID(FK)    int  NO  A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. 
EDITransactionControlID(FK)    int  YES  A foreign key to the EDITransactionControlID column in the SXARCMEDITransactionControl table. 
FinancialClassID(FK)    int  YES  A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. 
ClaimEditGroupMasterID(FK)    int  YES  A foreign key to the ClaimEditGroupMasterID column in the SXARCMClaimEditGroupMaster table. 
LateChargeConfigurationID(FK)    int  YES  A foreign key to the LateChargeConfigurationID column in the SXARCMLateChargeConfiguration table. 
NonPrimaryBillingReleaseOptionID(FK)    int  NO  A foreign key to the NonPrimaryBillingReleaseOptionID column in the SXARCMNonPrimaryBillingReleaseOption table. 
NonPrimaryBillingProcessingOptionID(FK)    int  NO  A foreign key to the NonPrimaryBillingProcessingOptionID column in the SXARCMNonPrimaryBillingProcessingOption table. 
LateChargeOutputMediaTypeID(FK)    int  NO  A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. 
PPSGrouperPricerID(FK)    int  YES  A foreign key to the PPSGrouperPricerID column in the SXARCMPPSGrouperPricer table. 
ReSubmitOutputMediaTypeID(FK)    int  NO  A foreign key to the OutputMediaTypeID column in the SXARCMOutputMediaType table. 
InitialCustomClaimFormatId(FK)    int  YES  A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. 
NonPrimaryCustomClaimFormatId(FK)    int  YES  A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. 
LateChargeCustomClaimFormatId(FK)    int  YES  A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. 
RebilledCustomClaimFormatId(FK)    int  YES  A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. 
ResubmitCustomClaimFormatId(FK)    int  YES  A foreign key to the CustomClaimFormatID column in the SXARCMCustomClaimFormat table. 
ReimbursementMethodID(FK)    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(FK)    int  YES  A foreign key to the RateCodeMethodID column in the SXARCMRateCodeMethod table. 
PatientResponsibilityID(FK)    bigint  YES  A foreign key to the PatientResponsibilityID column in the SXARCMPatientResponsibility table. 
PatientResponsibilityMethodTypeID    int  NO  Integer that maps to an enum type 
ProxyClaimPayerConfigId(FK)    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(FK)    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(FK)    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(FK)    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(FK)    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(FK)    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 

dbo.SXARCMRevenueCycleDetail Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMRevenueCycleDetailPK  PrimaryKey  RevenueCycleDetailID