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