dbo.SXAMMBilledTransaction |
Default Table Name | SXAMMBilledTransaction |
Definition | The Billed Transaction and Billed Transaction Detail tables contain the Audit History for the Billing Interface. This data represents the parameters used to generate the data in the Bill Charge Header and Bill Charge Detail tables below.
Financial Transaction Billed Audit Trail Financial Transaction consists of one Billed Transaction and 1 or more Billed Transaction Details. There is one Billed Transaction for each Bill Charge Header There is one Billed Transaction Detail for each Bill Charge Detail. If there was an Error returned by Determine Price, the Billing Interface will still create a Billed Transaction and the associated Billed Transaction Detail records, but will not create corresponding Bill Charge Header and Bill Charge Detail rows. Billed Transaction Billed Transaction identifies Patient and Order related information used to generate a Financial Transaction. This information is maintained for audit purposes, and used to derive the data that populates the PID segment in the Financial Transaction sent to the Financial System. Billed Transaction Detail Billed Transaction Detail identifies Drug, Cost, and Price information used to generate a Financial Transaction. This information is maintained for audit purposes, and used to derive the data that populates the FT1 segment in the Financial Transaction sent to the Financial System. Billed Transaction Billed Transaction identifies Patient and Order related information used to generate a Financial Transaction. This information is maintained for audit purposes, and used to derive the data that populates the PID segment in the Financial Transaction sent to the Financial System. Billed Transaction Detail Billed Transaction Detail identifies Drug, Cost, and Price information used to generate a Financial Transaction. This information is maintained for audit purposes, and used to derive the data that populates the FT1 segment in the Financial Transaction sent to the Financial System. |
dbo.SXAMMBilledTransaction Columns |
ColumnName | Domain | Datatype | NULL | Definition |
SiteID | smallint | NO | Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. | |
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. | |
TouchedWhen | datetime | NO | The date and time that the row was last updated and will be 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. | |
CreatedWhen | datetime | NO | The date and time that the row was created and will be based on the Enterprise time zone. | |
BilledTransactionID![]() |
bigint | NO | Auto generated unique primary key value. | |
OrderID![]() |
bigint | NO | A foreign key to the OrderID column in the SXAMMOrder table. | |
ParentBilledTransactionID![]() |
bigint | YES | A foreign key to the BilledTransactionID column in the SXAMMBilledTransaction table. | |
BillingProcessType | int | NO | An enumerated type with the following list of possible values: 0 = [Viewing Billing Transactions],1 = [Charge / Credit process],2 = [SCM Administration Module],3 = [Cart Fill],4 = [IVPB],5 = [LVP],6 = [ADM],7 = [Quick Charge],8 = [Dose Send],9 = [Take Home Meds],10 = [Robot Modified],11 = [Modified],12 = [Transfer Dose], | |
BillingTransactionType | int | NO | An enumerated type with the following list of possible values: 0 = [Charge],1 = [Credit],2 = [Quick Charge], | |
BillDtm | datetime | NO | Visit TimeZone - Identifies the Date and Time that Billing was triggered.The Billing Interface populates this with the current date and time.This is also used to populate in the Transaction Posting Date field in each Bill Charge Detail record, which will be sent in the FT1 transaction segment of the Financial Transaction. | |
CalculationStatusType | int | NO | An enumerated type with the following list of possible values: 0 = [OK],1 = [Error], | |
CalculationDetails | varchar(max) | YES | This entity contains a detailed explanation of how the Charge Calculation was determined. It will contain the exact steps that were done to calculate the charge being processed to the patient - will include markup, dispensing fees etc... applied to the base price of the drug.This entity contains the formatted text displayed within the Price Popup window. The data stored in this attribute will most likely be in XML format. | |
RouteCode | varchar(30) | NO | Identifies the Route of Administration for the Drug(s) being billed. Points to CV3Route | |
IsMultiIngredient | bit | NO | Identifies whether the charges are for multi-ingredient. | |
TotalPrice | numeric(11, 3) | YES | Identifies the Total Price for the Financial Transaction. | |
AdjustmentCodedReasonCode | varchar(30) | YES | Identifies the coded reason selected by the User for the online creation of a Charge or Credit Transactions from View Billing Transactions process, or the Debit Credit Process. Must be a valid code from CV3CodedReason table. Required if Bill Process Type is 'View Billing Transactions', or 'Debit Credit Process'. |
|
AdjustmentReasonText | varchar(520) | YES | Identifies the optional free text entered by the User, for the online creation of a Charge or Credit Transactions from View Billing Transactions process, or the Credit / Debit Screen. May be populated if Bill Process Type is 'View Billing Transactions', or 'Credit / Debit screen'. ,The calling process passes this in to the Billing Process. |
|
UnitLocationGUID | HVCIDdt | NO | Identifies the Unit Location of the Patient. Points to CV3Location | |
PharmacyID | int | YES | A foreign key to the PharmacyID column in the SXAMMPharmacy table. | |
OrderTaskOccurrenceGUID | HVCIDdt | YES | Identifies the Order Task Occurrence. ,Only populated when billing was called from SXA Mark as Done. |
|
MSrepl_tran_version | uniqueidentifier | NO | Optimistic lock identifier. | |
IsQuickCharge | bit | YES | Flag to indicate that the order is for a quick charge | |
OutpatientOrderDispenseID![]() |
int | YES | A foreign key to the OutpatientOrderDispenseID column in the SXAMMOutpatientOrderDispense table. | |
MSReplrowguid | uniqueidentifier | NO | Unique GUID used to support merge replication. |
dbo.SXAMMBilledTransaction Primary and Unique Keys |
Key Name | Key Type | Keys |
SXAMMBilledTransactionPK | PrimaryKey | BilledTransactionID |