Transactions: Hospital Billing Flashcards
For HB hospital accounts, is most data tracked at the bucket level or transaction level?
Bucket level
Aug. 2021, 4.4
The majority of transaction information stored in the Hospital Transactions (HTR) master file is extracted to what Clarity table?
HSP_TRANSACTIONS
Aug. 2021, 4.4
What is the granularity of HSP_TRANSACTIONS?
One row for each Hospital Billing transaction.
Aug. 2021, 4.4
When would a hospital account be flagged as bad debt?
When guarantors are unable to pay for their services.
This means we don’t expect them to pay anymore and want to remove the amount from our AR.
(Aug. 2021, 4.7)
Why would HSP_TRANSACTIONS.BAD_DEBT_FLAG_YN be set to yes?
If a guarantor manages to pay something after the account has been flagged as bad debt.
(Aug. 2021, 4.7)
How would a hospital transaction be corrected?
They are reversed, canceling the original transaction, and then reposted with the corrected information. The original, the reversal, and the repost are distinct HTR records.
(Aug. 2021, 4.7)
In HB, what are inactive transactions?
The reversal and the original transaction when they cancel each other out.
(Aug. 2021, 4.7)
What is a transaction considered when it has not been reversed and is itself not a reversal?
It is considered active.
Aug. 2021, 4.7
What is the Clarity table that lists all of the inactive transactions in the system along with the day that they became inactive, and whether they were a reversal or were reversed?
F_ARHB_INACTIVE_TX
Aug. 2021, 4.7
How would you report on inactive transactions?
Left outer join HSP_TRANSACTIONS to F_ARHB_INACTIVE_TX and select records where F_ARHB_INACTIVE_TX.TX_ID is null.
(Aug. 2021, 4.7)
