dbo.SXARCMProxyClaimPayerConfiguration 
Default Table Name  SXARCMProxyClaimPayerConfiguration 
Definition  This table is created to contain the Proxy Claim Payer Configuration ID to be selected in the Proxy Claim Payer configuration. 

dbo.SXARCMProxyClaimPayerConfiguration 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. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
ProxyClaimPayerConfigId(PK)    int  NO  Auto generated unique primary key value. 
InsuranceCarrierID    int  NO  To Store the Insurance Carrier ID 
ProxyPayerName    varchar(25)  NO  PHI: To Store the name of Proxy Payer Name 
Abbreviation    varchar(5)  NO  Used for the Abbreviation 
Description    varchar(100)  YES  To store the detailed information 
ProxyPayerTypeId(FK)    int  NO  A foreign key to the ProxyPayerTypeID column in the SXARCMProxyPayerType table. 
FinancialClassID(FK)    int  NO  A foreign key to the FinancialClassID column in the SXARCMFinancialClass table. 
Address1    varchar(50)  NO  PHI: To Store the Address1 Details 
Address2    varchar(50)  YES  PHI: To Store the Address2 Details 
City    varchar(25)  NO  PHI: To Store the City Information 
State    varchar(30)  NO  PHI: To Store the State Information 
Zip    varchar(10)  NO  PHI: Used for the ZIP Information 
Country    varchar(30)  YES  PHI: To Save the Country Information 
Contact    varchar(85)  YES  PHI: To Store the Contact Details 
Email    varchar(50)  YES  PHI: Used to store the Email Address 
Phone    varchar(10)  YES  PHI: Used to Store the Phone Number 
Extension    varchar(10)  YES  PHI: Used to Save the Extension Number 
Fax    varchar(10)  YES  PHI: To Store the FAX Number Details 
EDITransactionControlID(FK)    int  NO  A foreign key to the EDITransactionControlID column in the SXARCMEDITransactionControl table. 
ReimbursementMethodID(FK)    int  YES  A foreign key to the ReimbursementMethodID column in the SXARCMEReimbursementMethod table. 
IsRelProxyClaimIfOriginalRemittanceReceivedChecked    bit  NO  To hold proxy claim until original claim remittance is received or not 
IsCreateClaimWithDiffAmountChecked    bit  NO  Specifies claim required with differential amount. 
IsRateCodeUsed    bit  NO  Specifies whether rate code will be used 
ThirdPartyCodeID(FK)    int  YES  A foreign key to the ThirdPartyCodeID column in the SXARCMThirdPartyCode table. 
ClaimFilingIndicatorID(FK)    int  YES  A foreign key to the ClaimFilingIndicatorID column in the SXARCMClaimFilingIndicator table. 
ClaimFrequencyCodeID(FK)    int  YES  A foreign key to the ClaimFrequencyCodeID column in the SXARCMClaimFrequencyCode table. 
IsIncludeHICSelected    bit  NO  Indicates if HIC to be included in the shadow claim or not 
ICDCodingVersion    int  NO  Added new column to store ICD version for proxy claim 
IsAllowERAdjustmentSelected    bit  NO  Added new column to store boolean value to indicate allow Tranfer ER amount or not 
ConditionalCode1    varchar(2)  YES  To Store the conditional code required for Inpatient rehabilation facility proxy claim 
ConditionalCode2    varchar(2)  YES  To Store the conditional code required for Inpatient rehabilation facility proxy claim 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
ShouldNotProcessRemittance    bit  NO  Flag to specify if remittance needs to be processed 
PlanCode    varchar(45)  YES  Value contains PlanCode 

dbo.SXARCMProxyClaimPayerConfiguration Primary and Unique Keys 
Key Name  Key Type  Keys 
SXARCMProxyClaimPayerConfigurationPK  PrimaryKey  ProxyClaimPayerConfigId