SiteID |
Definition | Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. |
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. |
TouchedWhen |
Definition | The date and time that the row was last updated and will be 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. |
CreatedWhen |
Definition | The date and time that the row was created and will be based on the Enterprise time zone. |
SXAAMBSBillChargeDetailId |
Definition | Auto generated unique primary key value. |
SXAAMBSBillChargeHeaderId |
Definition | A foreign key to the SXAAMBSBillChargeHeaderId column in the SXAAMBSBillChargeHeader table. |
TransactionType |
Definition | Transaction Type |
DateOfService |
Definition | visit TimeZone - DOS |
TransactionCode |
Definition | Trans code |
LocationCode |
Definition | Location Code |
VisitClass |
Definition | Type of visit according to the billing classification |
DiagnosisCodeList |
Definition | "^" delimited ICD code list .Up to 25 ICD codes |
PerformedByCode |
Definition | Code for the performer |
OrderedByCode |
Definition | Ordered by code |
HCPCSCode |
Definition | Procedure HCPCS code |
CodeModifier |
Definition | Code Modifier |
Quantity |
Definition | int |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
LocationGUID |
Definition | Reference to GUID in CV3Location table. This identifies the location where the SuperBill charge(s) took place. |
OrderedByProviderGUID |
Definition | Reference to GUID in CV3User table. Identifies the user who entered the SuperBill charge(s). |
PerformedByProviderGUID |
Definition | Reference to GUID in CV3CareProvider table. Identifies the Care Provider who performed the SuperBill charge(s). |
ReferredByCode |
Definition | Referring Provider Billing Code |
NDC |
Definition | National Drug Code |
NDCQuantity |
Definition | The billable quantity |
NDCLabel |
Definition | Drug name and strength |
NDCConversionFactor |
Definition | The Conversion Factor translates the value of one NCPDP Standard billing unit for a particular NDC to the corresponding units for a particular HCPCS Code. |
NDCUnitOfMeasure |
Definition | NDC unit of measure |
ReferredByProviderGUID |
Definition | Referring Provider, link to the CV3Careprovider.GUID |
BillingProviderGUID |
Definition | Billing Provider GUID, link to the CV3Careprovider.GUID |
BillingProviderCode |
Definition | Billing Provider Identification Code |
DiagnosisCodeSetList |
Definition | The codeset for DiagnosisCodelist |
HCPCSCodeSet |
Definition | The codeset for HCPCSCode |
CodeSetModifier |
Definition | The codeset for Modifier |
UserNPICode |
Definition | User NPI Code |
AttendingByCode |
Definition | To save attending provider code |
AttendingByProviderGUID |
Definition | To save attending provider GUID |
DiagnosisCodeSetListXML |
Definition | It saves diagnosis code set XML with their mapping codes |
HCPCSDescription |
Definition | It saves superBill procedure description |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |