|
Name |
Type |
Discontinued? |
|
1 |
TX_ID |
NUMERIC |
No |
|
|
|
A transaction's unique internal identification number. A patient's record can include charges, payments, or adjustments and the patient's account balance will reflect these transactions. |
|
|
2 |
POST_DATE |
DATETIME |
No |
|
|
|
The date when a transaction is entered into the billing system. This differs from the service date, which is the date when the service was performed. |
|
|
3 |
SERVICE_DATE |
DATETIME |
No |
|
|
|
The date a medical service is performed. |
|
|
4 |
TX_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The type of this transaction: Charge, payment or adjustment. |
May contain organization-specific values: No |
Category Entries: |
Charge |
Payment |
Adjustment |
AP Claim Tx |
AP Claim Refund Tx |
AP Claim DRG Tx |
Pharmacy Claim Tx |
|
|
5 |
ACCOUNT_ID |
NUMERIC |
No |
|
|
|
The internal ID of the record that maintains the patient's transactions. A patient may use more than one account and an account may contain more than one patient. |
|
|
6 |
DEBIT_CREDIT_FLAG_NAME |
VARCHAR |
No |
|
|
|
This column contains a 1 if the transaction is a debit and a -1 if the transaction is a credit. A charge is always a debit, a payment is always a credit, and an adjustment can be either a debit or a credit. |
May contain organization-specific values: No |
Category Entries: |
Debit |
Credit |
|
|
7 |
SERV_PROVIDER_ID |
VARCHAR |
No |
|
|
|
The internal identifier of the provider who performed the medical services on the patient. |
|
|
8 |
BILLING_PROV_ID |
VARCHAR |
No |
|
|
|
The billing provider associated with the transaction. |
|
|
9 |
DEPARTMENT_ID |
NUMERIC |
No |
|
|
|
The department ID of the department associated with the transaction. |
|
|
10 |
POS_ID |
NUMERIC |
No |
|
|
|
The place of service ID of the place of service associated with the transaction |
|
|
11 |
LOC_ID |
NUMERIC |
No |
|
|
|
The location ID of the location associated with the transaction. |
|
|
12 |
SERVICE_AREA_ID |
NUMERIC |
No |
|
|
|
The service area ID of the service area associated with the transaction. |
|
|
13 |
MODIFIER_ONE |
VARCHAR |
No |
|
|
|
The first procedure modifier associated with this transaction. This is the external modifier, as it would be printed on the claim. |
|
|
14 |
MODIFIER_TWO |
VARCHAR |
No |
|
|
|
The second procedure modifier associated with this transaction. This is the external modifier, as it would be printed on the claim. |
|
|
15 |
MODIFIER_THREE |
VARCHAR |
No |
|
|
|
The third procedure modifier associated with this transaction. This is the external modifier, as it would be printed on the claim. |
|
|
16 |
MODIFIER_FOUR |
VARCHAR |
No |
|
|
|
The fourth procedure modifier associated with this transaction. This is the external modifier, as it would be printed on the claim. |
|
|
17 |
PRIMARY_DX_ID |
NUMERIC |
No |
|
|
|
The primary diagnosis ID associated with the transaction. |
|
|
18 |
DX_TWO_ID |
NUMERIC |
No |
|
|
|
The second diagnosis ID associated with the transaction. |
|
|
19 |
DX_THREE_ID |
NUMERIC |
No |
|
|
|
The third diagnosis ID associated with the transaction. |
|
|
20 |
DX_FOUR_ID |
NUMERIC |
No |
|
|
|
The fourth diagnosis ID associated with the transaction. |
|
|
21 |
DX_FIVE_ID |
NUMERIC |
No |
|
|
|
The fifth diagnosis ID associated with the transaction. |
|
|
22 |
DX_SIX_ID |
NUMERIC |
No |
|
|
|
The sixth diagnosis ID associated with the transaction. |
|
|
23 |
PROCEDURE_QUANTITY |
NUMERIC |
No |
|
|
|
The quantity as entered in Charge Entry for the procedure of this transaction (TX_ID). If the row has a DETAIL_TYPE value of 10-13, this column displays a negative value. If the row has a DETAIL_TYPE value of 20-33, 43-45, 50, or 51, this column displays a zero. |
|
|
24 |
AMOUNT |
NUMERIC |
No |
|
|
|
The original amount of this transaction. |
|
|
25 |
OUTSTANDING_AMT |
NUMERIC |
No |
|
|
|
The outstanding amount of the transaction. |
|
|
26 |
INSURANCE_AMT |
NUMERIC |
No |
|
|
|
The insurance portion of the transaction. |
|
|
27 |
PATIENT_AMT |
NUMERIC |
No |
|
|
|
The patient or self-pay portion of the transaction. |
|
|
28 |
VOID_DATE |
DATETIME |
No |
|
|
|
If this transaction is voided, this column will have the date in which this transaction is voided. |
|
|
29 |
LAST_ACTION_DATE |
DATETIME |
No |
|
|
|
This column contains the most recent date when an action is performed on this transaction. |
|
|
30 |
PROV_SPECIALTY_C_NAME |
VARCHAR |
No |
|
|
|
This column contains the provider specialty of the provider associated with the transaction. The procedure category of the charge on the transaction may affect what specialty is recorded here and in the "Encounter Specialty" displayed in Hyperspace. |
May contain organization-specific values: Yes |
|
|
31 |
PROC_ID |
NUMERIC |
No |
|
|
|
The Procedure ID of the procedure associated with the transaction. |
|
|
32 |
TOTAL_MATCH_AMT |
NUMERIC |
No |
|
|
|
This column contains the total amount matched to the transaction, including adjustments. |
|
|
33 |
TOTAL_MTCH_INS_AMT |
NUMERIC |
No |
|
|
|
This column contains the total insurance amount matched to the transaction, including adjustments. |
|
|
34 |
TOTAL_MTCH_ADJ |
NUMERIC |
No |
|
|
|
This column contains the total adjustment amount matched to the transaction. |
|
|
35 |
TOTAL_MTCH_INS_ADJ |
NUMERIC |
No |
|
|
|
This column contains the total insurance adjustment amount matched to the transaction. |
|
|
36 |
REPOST_ETR_ID |
NUMERIC |
No |
|
|
|
This is the repost source transaction. |
|
|
37 |
REPOST_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The repost type category ID for the transaction. |
May contain organization-specific values: No |
Category Entries: |
Repost |
Correction |
|
|
38 |
DISCOUNT_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The discount type category ID for the transaction. |
May contain organization-specific values: Yes |
Category Entries: |
None |
Percentage |
Fee Schedule |
Extension |
|
|
39 |
PAT_ENC_CSN_ID |
NUMERIC |
No |
|
|
|
The Contact Serial Number for the patient encounter with which this transaction is associated. This number is unique across all patients and encounters in your system. |
|
|
40 |
ENC_FORM_NUM |
VARCHAR |
No |
|
|
|
The encounter form number corresponding to the charge transaction. If you are not using encounter forms, a negative number is stored in this item. |
|
|
41 |
BEN_SELF_PAY_AMT |
NUMERIC |
No |
|
|
|
Stores the adjudicated self-pay amount calculated by the benefits engine |
|
|
42 |
BEN_ADJ_COPAY_AMT |
NUMERIC |
No |
|
|
|
Stores the copay part of the adjudicated self-pay amount calculated by the benefits engine |
|
|
43 |
BEN_ADJ_COINS_AMT |
NUMERIC |
No |
|
|
|
Stores the coinsurance part of the adjudicated self-pay amount calculated by the benefits engine |
|
|
44 |
VISIT_NUMBER |
VARCHAR |
No |
|
|
|
This item stores the visit number for this transaction. |
|
|
45 |
REFERRAL_ID |
NUMERIC |
No |
|
|
|
This item stores the Referral (RFL) ID for this transaction. |
|
|
46 |
ORIGINAL_EPM_ID |
NUMERIC |
No |
|
|
|
This item stores the original payor (EPM) ID for this transaction. |
|
|
47 |
ORIGINAL_FC_C_NAME |
VARCHAR |
No |
|
|
|
This item stores the original financial class for this transaction. |
May contain organization-specific values: Yes |
Category Entries: |
Commercial |
Medicare |
Medicaid |
Self-Pay |
Worker's Comp |
Tricare |
Champva |
Group Health Plan |
FECA Black Lung |
Blue Shield |
Medigap |
Other |
DK Regional |
Client |
Received Self-Pay |
Sent to Consolidated Self-Pay Service Area |
|
|
48 |
ORIGINAL_CVG_ID |
NUMERIC |
No |
|
|
|
This item stores the original coverage (CVG) ID for this transaction. |
|
|
49 |
PAYOR_ID |
NUMERIC |
No |
|
|
|
This item stores the current payor (EPM) ID for this transaction. |
|
|
50 |
COVERAGE_ID |
NUMERIC |
No |
|
|
|
This item stores the current coverage (CVG) ID for this transaction. |
|
|
51 |
ASGN_YN |
VARCHAR |
No |
|
|
|
This item stores the assignment flag for a coverage. This item is set to Yes if the charge is currently assigned to the payor in the PAYOR_ID column. |
May contain organization-specific values: No |
Category Entries: |
Yes |
No |
|
|
52 |
FACILITY_ID |
NUMERIC |
No |
|
|
|
This item stores the facility (EAF) ID for this transaction. |
|
|
53 |
PAYMENT_SOURCE_C_NAME |
VARCHAR |
No |
|
|
|
This item stores the payment source for credit transactions. This is a list of possible sources including Cash, Check, Credit Card, etc. |
May contain organization-specific values: Yes |
Category Entries: |
Cash |
Check |
Credit Card |
EOB |
Voucher |
Bank Account |
Trust Account |
|
|
54 |
USER_ID |
VARCHAR |
No |
|
|
|
This item stores the user who posted the transaction. |
|
|
55 |
USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
56 |
NOT_BILL_INS_YN |
VARCHAR |
No |
|
|
|
Indicates whether the transaction is marked for do not bill insurance. |
May contain organization-specific values: No |
Category Entries: |
No |
Yes |
|
|
57 |
CHG_ROUTER_SRC_ID |
VARCHAR |
No |
|
|
|
This item stores the universal charge line (UCL) ID for this transaction. |
|
|
58 |
RECEIVE_DATE |
DATETIME |
No |
|
|
|
This item stores the charge entry batch receive date. |
|
|
59 |
CE_CODED_DATE |
DATETIME |
No |
|
|
|
The date this charge session was coded, from charge entry. |
|
|
60 |
PANEL_ID |
NUMERIC |
No |
|
|
|
The ID of the panel procedure that generated this transaction. |
|
|
61 |
BILL_AREA_ID |
NUMERIC |
No |
|
|
|
Networked to BIL: the Bill Area for this transaction. |
|
|
62 |
BILL_AREA_ID_BILL_AREA_NAME |
VARCHAR |
No |
|
|
|
The record name of this bill area, financial subdivision, or financial division. |
|
|
63 |
CREDIT_SRC_MODULE_C_NAME |
VARCHAR |
No |
|
|
|
The module that creates a payment or credit adjustment |
May contain organization-specific values: No |
Category Entries: |
Account Maintenance |
Payment Posting |
Adjustment Posting |
Collection (text) |
Collection Workqueue |
Charge Entry |
Retroadjudication |
Small Balance Write-off in Bills |
Transfer |
Transaction Import |
Claim Processing |
MyChart Web |
Electronic Remittance |
Claim Bundling Utility |
Real Time Charge Interface |
Secondary Write-off |
Dental Treatment Plan |
Transaction Maintenance Utilities |
Follow-up workqueue User |
Check-in/Check-out |
Charge Homing |
Release of Information |
Enterprise Payment Posting |
Reimbursement Recalculation Utility |
Charge Correction |
Charge Repost |
Claim Edit Workqueue |
Patient Refund |
HB Integrity Checks |
Welcome |
PB Extract Framework |
SBO Collection Actions |
Nightly Processing |
Web Service |
Auto Pay Payment Plan |
Pharmacy |
Payment Collection |
Financial Assistance |
Credit Workqueue System |
Credit Workqueue User |
Follow-up Workqueue System |
Self-Pay Discount |
Adjustment Review Workqueue |
Charge Router Void |
Charge Router Repost |
Rescheduling Repost |
Prepay Discount Adjustment |
Bundled Payment Distribution |
Account Workqueue |
Claim run Accept |
Change Guarantor |
MyChart Mobile |
Guest Pay |
Visit Auto Pay |
Dental Upgrade Adjustment |
Promotion Discount |
Discretionary Discount |
Non-Primary Not Allowed Adjustment |
Estimate |
Adjustment Review WQ Decline |
Two-Way SMS |
Shadow Charging |
Reeval Reimbursement (User) |
Override Reimbursement (User) |
Same-Instance Consolidated Balances |
Estimate Variance Write-Off |
|
|
64 |
UPDATE_DATE |
DATETIME (Local) |
No |
|
|
|
The date that this row was last updated. |
|
|
65 |
CLAIM_DATE |
DATETIME |
No |
|
|
|
The most recent date that this transaction has been on an accepted claim run. |
|
|
66 |
IPP_INV_NUMBER |
VARCHAR |
No |
|
|
|
This item stores the original invoice number that user posts to in GUI payment posting or remittance. |
|
|
67 |
IPP_INV_ID |
NUMERIC |
No |
|
|
|
This item stores the original invoice ID that user posts to in graphical user interface (GUI) payment posting or remittance. |
|
|