Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
ObjectID | int | NOT NULL | Object Identifier of this record. This field is a primary key for the associated table. |
InstanceHFCID | smallint | NOT NULL | Healthcare Foundation Class(HFC) Identifier of the object.HFCID of this object is 4502. The value specified in the ObjectID field and in this field enables unique identification of an object instance across the application. |
RecordId | int | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
Description | varchar(1) | NULL | Not Valued in this table. Column exists as part of persistence framework implementation. |
IsVersioned | bit | NOT NULL | Whether the table data is Versioned or not. |
| | | Allowable Values: |
| | | 0 - No version data captured. |
| | | 1 - Version changes available in _Ver table. |
| | | Once this field is set to 1, you cannot reset it to 0. If value is 1 , the current row represents the latest state , and all version data will be present in another table with the name HChargeHold_Ver. |
| | | Note: The presence of this field in tables depends on the configuration at the time of table design. |
CreatedUserId | int | NULL | Object ID of the logged in user who created this record. |
| | | This field is linked to HSUser table to get details about the user. For more information see description of HSUser table |
CreationTime | smalldatetime | NULL | Date and time when the record is created. |
Type | tinyint | NOT NULL | Type of the Charge Record |
| | | Allowable Values |
| | | 0 - Charge |
| | | 1 - Credit |
ChargeCode | varchar(32) | NULL | CDM(Charge Description Master Code) number passed on the Soarian_Billing event |
Department | varchar(10) | NULL | Department where service was requested/performed |
Diagnosis | varchar(30) | NULL | Diagnosis code(ICD) of patient's problem for which the Charge record was created |
Quantity | smallint | NULL | quantity to apply to Charge/Credit |
Price | float(53) | NULL | price override |
ChargeDate | smalldatetime | NULL | Date/time the charge took place |
ServiceDate | smalldatetime | NULL | Date/time the service took place |
ChargeEnteredDTimeMins | smalldatetime | NULL | The datetime at which the charge was entered into system. |
ServiceDescription | varchar(64) | NULL | Description of the service |
ServiceDescriptionOverride | varchar(64) | NULL | Service description override |
Modifier1 | varchar(20) | NULL | CPT(Current Procedure Terminology) modifier 1 |
Modifier2 | varchar(20) | NULL | CPT Modifier 2 |
Modifier3 | varchar(20) | NULL | CPT Modifier 3 |
Modifier4 | varchar(20) | NULL | CPT Modifier 4 |
PatientOID | int | NOT NULL | ObjectId of the patient(HPatient) |
VisitOID | int | NULL | ObjectId for the patient's visit(HPatientVisit) |
OrderOID | int | NULL | ObjectId of HOrder(if charge is linked to an order ) |
ServiceDetailOID | int | NULL | ObjectId of HserviceDetail |
EnteredByUserOID | int | NULL | User objectId who entered the Charge/Credit |
ProvidedByStaffOID | int | NULL | ObjectId of the staff who provided service |
ABN_code | tinyint | NULL | ABN(Advanced Beneficiary Notice) code passed on the Soarian_Billing event |
| | | Allowable Values: |
| | | 0 - Service is not subject to medical necessity procedures |
| | | 1 - Service is subject to medical necessity procedures |
| | | 2 - Patient has been informed of responsibility and agrees to pay for service |
| | | 3 - Patient has been informed of responsibility and asks that the payer be billed |
| | | 4 - Advanced Beneficiary Notice has not been signed |
CPT_code | varchar(20) | NULL | CPT(Current Procedure Terminology) code |
RequestedByStaffOID | int | NULL | ObjectId of requestor staff |
BillDetailOID | int | NULL | Identifier to Billing Configuration used when creating the Charge / Credit. |
OccOID | bigint | NULL | ObjectId of HOccurrenceOrder. Note: Not all environments / databases will have the datatype of BIGINT. Some will remain with the INT datatype. |
ComponentBillingIndicator | tinyint | NOT NULL | Indicator that a service requires component billing for the professional and/or technical components |
| | | Allowable Values |
| | | 0 - Total Price - No specific billing component(TP) |
| | | 1 - Technical component(TF) |
| | | 2 - Professional component(PF) |
| | | 3 - Technical And Professional component(TFPF) |
PDMCode | varchar(32) | NULL | Professional Component Master Code(aka PDM#) - to be sent to the billing system receiving the professional component charges |
SupervisedByStaffOID | int | NULL | ObjectId of supervised by staff |
ChargeSource | varchar(10) | NOT NULL | The source of the charge(MC - Manual Charge, ORD - Orders, SPW - ServiceProviderWorkspace, etc.) . Usually to identify from which part of the system the charge was created |
IsTempVisit | smallint | NOT NULL | Indicates if this charge was raised for Temporary visit which is not identifiable by the billing systems |
| | | Allowable Values |
| | | 0 - No |
| | | 1 - Yes , setting this flag on the charge record with prevent HL7_P03 transaction to be raised for this record |
ServiceEndDate | smalldatetime | NULL | The date/time service ended for time charges |
Duration | smallint | NULL | Duration of the service for time charges |
TimeChargeIndicator | smallint | NOT NULL | Indicator to determine if it is a time based charge or not |
| | | Allowable values |
| | | 0 - Not Time based charge |
| | | 1 - Is Time based charge |
ChgHoldCreditOID | int | NULL | ObjectId of charge from Hold table that was credited |
ChgAuditCreditOID | int | NULL | ObjectId of charge from Audit table that was credited |
AllowManualCredit | Char(1) | NULL | Indicates if a manual credit is allowed. This is only applicable for row which represents a Charge(ie Type = 0 ) |
| | | Allowable Values |
| | | Y - for a charge row which allows manual credit |
| | | N - for a charge row which doesn't allow manual credit |
| | | C - for a credit row(Type = 1) |
RequestorUnitAbbr | Varchar(10) | NULL | Abbreviation of the unit requesting the charge |
ChargeSourceObjId | int | NULL | A unique context for the charge source(such as assessment id) |
ChargeSourceLinkId | varchar(500) | NULL | A unique identifier for the charge(such as observation oid) within context of ChargeSourceObjId |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|