|
Name |
Type |
Discontinued? |
|
| 1 |
TX_ID |
NUMERIC |
No |
|
|
|
| This column stores the unique identifier for the hospital billing transaction. |
|
|
| 2 |
CONTEST_RSN_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the contested reason. This is set only for charges. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Account Has Contested Charges |
| Patient Not Seen |
| Bankruptcy |
| Legal |
| Deceased |
| Not Informed Service Not Covered |
| Service Not Provided |
| Insurance Appeal |
| Patient Grievance |
| Other |
|
|
| 3 |
CONTEST_RESOLUTION_RSN_C_NAME |
VARCHAR |
No |
|
|
|
| Stores the contested resolution reason. This is set only for charges. |
| May contain organization-specific values: Yes |
| Category Entries: |
| Transfer |
| All Charges Resolved |
| Contested in Error |
| Confirmed Billed Correctly |
| Patient No Longer Contesting |
| Insurance Issue Resolved |
| Problem Fixed |
|
|
| 4 |
REVERSAL_RSN_C_NAME |
VARCHAR |
No |
|
|
|
| Holds the reversal reason. This is set for all transaction types. |
| May contain organization-specific values: Yes |
| Category Entries: |
| CCI Edit |
| No Supporting Documentation |
| Service Not Performed |
| Self-Pay Reconciliation Across Systems |
| Payment Received |
| Returned Mail |
| Other |
| Duplicate |
| Posted in Error |
| Wrong Code |
| Give Back |
|
|
| 5 |
TAX_RATE_DEF_CSN |
NUMERIC |
No |
|
|
|
| This column stores the tax rate definition contact serial number (CSN) used in the tax calculation. |
|
|
| 6 |
IS_PRE_SERVICE_PMT_YN |
VARCHAR |
No |
|
|
|
| Indicates whether or not this is a pre-service payment, such as a co-pay. This item is only populated for self-pay payments A payment is considered pre-service if it is a visit pre-pay or co-pay payment (such as during check-in). |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 7 |
FIRST_HTR_TX_ID |
NUMERIC |
No |
|
|
|
| This column stores the unique identifier for the first hospital billing transaction in a chain of transactions. Note that this chain will include transactions from both hospital billing and professional billing, so this item will return the very first transaction. For a given transaction, either column HSP_TRANSACTIONS_3.FIRST_HTR_ID, or column HSP_TRANSACTIONS_3.FIRST_ETR_ID will be populated. This is different from column HSP_TRANSACTIONS_2.FIRST_TX_ID, which only chains back to the point that the transaction was transferred from professional billing. |
|
|
| 8 |
FIRST_ETR_TX_ID |
NUMERIC |
No |
|
|
|
| This column stores the unique identifier for the first professional billing transaction (ETR record) in a chain of transactions. Note that this chain will include transactions from both hospital billing and professional billing, so this item will return the very first transaction. For a given transaction, either column HSP_TRANSACTIONS_3.FIRST_HTR_ID, or column HSP_TRANSACTIONS_3.FIRST_ETR_ID will be populated. This is different from column HSP_TRANSACTIONS_2.FIRST_TX_ID, which only chains back to the point that the transaction was transferred from professional billing. |
|
|
| 9 |
NO_PAY_CLAIM_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| If this charge was posted to drive no-pay claims to be generated, this charge is intended to file and bill immediately. These claims will have different types/purposes. This item defines the type of claim that should be generated for the bucket that hold this charge. |
| May contain organization-specific values: No |
| Category Entries: |
| SNF No-Pay Claim |
| SNF Exhaust Claim |
| HH No-Pay RAP |
| HH Notice of Admission |
|
|
| 10 |
ORIG_PMT_SPLIT_TX_ID |
NUMERIC |
No |
|
|
|
| This column stores the original unique identifier for the hospital billing transaction when payments are distributed or split. |
|
|
| 11 |
SVC_AUTH_ID |
NUMERIC |
No |
|
|
|
| This item stores the social care service decision level authorization record associated with this charge. |
|
|
| 12 |
POSTING_DEPARTMENT_ID_EXTERNAL_NAME |
VARCHAR |
No |
|
|
|
| The external name of the department record. This is often used in patient correspondence such as reminder letters. |
|
|
| 13 |
TAX_EFFECTIVE_DATE |
DATETIME |
No |
|
|
|
| This column stores the date used in the hospital billing system definitions that determine when this tax line went into effect. |
|
|
| 14 |
TAXABLE_AMOUNT |
NUMERIC |
No |
|
|
|
| This item stores the amount that the tax is applied to |
|
|
| 15 |
TAX_PERCENT |
NUMERIC |
No |
|
|
|
| Percent used to calculate the tax amount |
|
|
| 16 |
TAX_AMOUNT |
NUMERIC |
No |
|
|
|
| This item stores the amount used for the tax |
|
|
| 17 |
DIGITAL_WALLET_C_NAME |
VARCHAR |
No |
|
|
|
| Holds the digital wallet used for an electronic payment. Stored on payments made from a digital wallet and on reversals. This item is not stored on refund transactions. |
| May contain organization-specific values: No |
| Category Entries: |
| Apple Pay |
| Google Pay |
|
|
| 18 |
ADV_BILL_DB_TX_ID |
NUMERIC |
No |
|
|
|
| This column stores the unique identifier for the hospital billing transaction for this advance bill debit transfer adjustment. |
|
|
| 19 |
ADV_BILL_ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| This column stores the unique identifier for the estimate used in posting this advance bill adjustment. |
|
|
| 20 |
IS_ADV_BILL_TRANS_YN |
VARCHAR |
No |
|
|
|
| Indicates if this transaction an advance bill transfer system adjustment. Includes both credit and debit adjustments. |
| The category values for this column were already listed for column: IS_PRE_SERVICE_PMT_YN |
|
|
| 21 |
SAVED_PMT_DIGITAL_WALLET_C_NAME |
VARCHAR |
No |
|
|
|
| Holds the digital wallet of the saved payment method used to make the payment |
| The category values for this column were already listed for column: DIGITAL_WALLET_C_NAME |
|
|
| 22 |
RESEARCH_ENROLL_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the research study association linked to this transaction. |
|
|
| 23 |
CLAIM_PRINT_ID |
NUMERIC |
No |
|
|
|
| The payment's claim print ID with a matching invoice number. |
|
|
| 24 |
INS_WRITE_OFF_AMT |
NUMERIC |
No |
|
|
|
| This item stores the insurance write off amount from the payment based on remittance codes that are mapped to an insurance write-off action. |
|
|
| 25 |
IS_SCANNED_CHECK_YN |
VARCHAR |
No |
|
|
|
| Indicates if a transaction was made using a scanned check. |
| The category values for this column were already listed for column: IS_PRE_SERVICE_PMT_YN |
|
|
| 26 |
E_PMT_RECEIPT_MSG |
VARCHAR |
No |
|
|
|
| Saves the receipt message received from the gateway for an electronic payment transaction. |
|
|
| 27 |
PAT_PMT_COLL_WKFL_C_NAME |
VARCHAR |
No |
|
|
|
| This column contains the workflow category ID performed to collect a patient payment from the point of view of the user. For example, MyChart eCheck-in vs. MyChart One-Touch. |
| May contain organization-specific values: No |
| Category Entries: |
| Staff Collected |
| MyChart Billing |
| MyChart One-Touch |
| MyChart Pay as Guest |
| MyChart Visit Payment |
| MyChart eCheck-in |
| Welcome Balance Payment |
| Welcome Check-in |
| Two-Way SMS |
| Payment Posting |
| Lockbox |
| Release of Information |
| Willow Ambulatory |
| Web Service |
|
|
| 28 |
MYC_SIGNIN_METHOD_C_NAME |
VARCHAR |
No |
|
|
|
| This column denotes how the patient or guarantor logged in to MyChart to either post the payment or create an agreement that will post a payment via Auto Pay. Only populated for agreements made via MyChart. |
| May contain organization-specific values: No |
| Category Entries: |
| Password Sign-in |
| Demographics Sign-in |
| No Sign-in |
|
|
| 29 |
POSTING_MYPT_ID |
VARCHAR |
No |
|
|
|
| This column contains either the MyChart account that created the agreement that resulted in the self-pay payment (if applicable) or the MyChart account that posted the self-pay payment. |
|
|
| 30 |
POSTING_MYC_STATUS_C_NAME |
VARCHAR |
No |
|
|
|
| This column contains either the status of the MyChart account that created the agreement that resulted in the self-pay payment (if applicable) or the status of the MyChart account that posted the self-pay payment. An active MyChart account status is defined as whether a MyChart user could log into the account with a user name and password. Accounts that are not yet active, deactivated, or are proxy accounts are considered inactive. |
| May contain organization-specific values: Yes |
| Category Entries: |
| ACTIVE |
| INACTIVE |
|
|
| 31 |
EB_TX_SOURCE_C_NAME |
VARCHAR |
No |
|
|
|
| This column stores the enterprise posting module for the transaction. This is calculated based on the hospital billing transaction source for the transaction. For reversals, the module will always match the module of the reversed parent transaction. |
| May contain organization-specific values: No |
| Category Entries: |
| Payment Plan Auto Pay |
| Enterprise Payment Posting |
| HB Payment Posting |
| PB Payment Posting |
| Electronic Remittance |
| PB Charge Entry Fast Pay |
| POS Quick Pay |
| Welcome |
| MyChart Web |
| PB Release of Information |
| Transaction Import |
| Web Service |
| Payment Collection |
| Willow Ambulatory |
| Distribution |
| Transfer from PB |
| Transfer from HB |
| MyChart Mobile |
| Guest Pay |
| Account Maintenance Refund |
| Patient Refund |
| Back-End Refund |
| Visit Auto Pay |
| Trust Recurring Payment |
| Premium Billing Auto Pay |
| Premium Billing One Time Payment |
| Premium Billing Payment Posting |
| Two-Way SMS |
| External Agency Payment |
| Multi-Instance Consolidated Balances |
|
|
| 32 |
LINKED_PARENT_TX_ID |
NUMERIC |
No |
|
|
|
| Stores the parent HTR ID in a linked child HTR. |
|
|
| 33 |
RELATED_ETR_TX_ID |
NUMERIC |
No |
|
|
|
| Applies only if you have enabled Consolidated Self-Pay Balances functionality. Stores the professional transaction ID of the related transaction. This will only be populated on transactions that were mirrored from professional billing. |
|
|
| 34 |
PMT_PLAN_AGRMT_SCHED_PMT_ID |
NUMERIC |
No |
|
|
|
| The unique ID of the transaction's target guarantor's active payment plan agreement record at the time of filing. |
|
|
| 35 |
IS_EST_PRE_SERVICE_PLAN_PMT_YN |
VARCHAR |
No |
|
|
|
| Indicates whether this payment was made on an estimated balance on a payment plan at time of filing ('Y'). 'N' or NULL indicates that the transaction is not a payment, the payment is not on a balance on a payment plan, or the balance was not estimated at the time of filing. |
| The category values for this column were already listed for column: IS_PRE_SERVICE_PMT_YN |
|
|
| 36 |
IS_PRE_SERVICE_PLAN_PMT_YN |
VARCHAR |
No |
|
|
|
| Indicates whether this payment was made toward a hospital account on a payment plan that was added by an estimate ('Y'). 'N' or NULL indicates that the transaction is not a payment or the payment was not made toward a hospital account on a payment plan that was added by an estimate. |
| The category values for this column were already listed for column: IS_PRE_SERVICE_PMT_YN |
|
|
| 37 |
EST_VARIANCE_WO_ESTIMATE_ID |
NUMERIC |
No |
|
|
|
| If this transaction is part of an automatic estimate variance write-off, this item stores the estimate that this is a write off towards. |
|
|
| 38 |
AR_CLASSIFICATION_C_NAME |
VARCHAR |
No |
|
|
|
| This column stores the AR classification of this transaction. |
| May contain organization-specific values: No |
| Category Entries: |
| Active AR |
| External AR |
| Bad Debt |
| Outsourced |
| Received Self-Pay Active AR |
| Received Self-Pay External AR |
| Received Self-Pay Bad Debt |
|
|
| 39 |
DISCOUNT_FIN_ASST_TRACKER_ID |
NUMERIC |
No |
|
|
|
| The unique identifier of the financial assistance tracker that generated this discount transaction. |
|
|
| 40 |
DISCOUNT_DAILY_PAY_AMT |
NUMERIC |
No |
|
|
|
| This item stores the daily pay amount applied to the self-pay balance. |
|
|
| 41 |
DISCOUNT_NUM_OF_DAYS |
INTEGER |
No |
|
|
|
| This item stores the number of billable days a patient is responsible for. |
|
|
