Hospital Accounts (DBO, Columns)

Question 1

In Clarity, what is the main table for HAR-level data?

Answer 1

HSP_ACCOUNT

Aug. 2021, 5.8

Question 2

Does HSP_ACCOUNT contain HARs generated through both PB and HB?

Answer 2

Yes

Aug. 2021, 5.8

Question 3

In Caboodle, what is the main table for HAR-level data?

Answer 3

BillingAccountFact

Aug. 2021, 5.8

Question 4

List the Clarity and Caboodle tables and columns you can use to identify HARs in bad debt.

Answer 4

1. Clarity
   • Table: HSP_ACCOUNT_3
   • Column: BAD_DEBT_FLAG_YN
2. Caboodle
   • Table: BillingAccountFact
   • Column: ArStatus

(Aug. 2021, 5.14)

Question 5

What is the Clarity table you can use to report on the full history of a HARs self-pay level?

Answer 5

HSP_ACCT_SPLVL_HX

Aug. 2021, 5.15

Question 6

True or False:

Use HSP_ACCT_CVG_LIST for the filing order for all HARs, regardless of whether the HAR is HB, PB, VFO, or SBO.

Answer 6

True

Aug. 2021, 5.15

Question 7

Linking Encounters and Coverages in Professional Billing

List the Caboodle DBOs for the following:

1. Encounter
2. Encounter-HAR / mapping
   3a. SBO PB HAR
   3b. VFO PB Visit HAR
3. Coverage List
4. Coverage

Answer 7

1. Encounter • EncounterFact
2. Encounter-HAR • BillingAccountEncounter, MappingFact
   3a. SBO PB HAR • BillingAccountFact
   3b. VFO PB Visit HAR • BillingAccountFact
3. Coverage List • BillingAccountFact
4. Coverage • CoverageDim

(Aug. 2021, 5.15)

Question 8

Linking Encounters and Coverages in Professional Billing

List the Clarity DBOs for the following:

1. Encounter
2. Encounter-HAR
   3a. SBO PB HAR
   3b. VFO PB Visit HAR
3. Coverage List
4. Coverage

Answer 8

1. Encounter • PAT_ENC
2. Encounter-HAR • HSP_ACCT_PAT_CSN
   3a. SBO PB HAR • HSP_ACCT_SBO
   3b. VFO PB Visit HAR • ARPB_VISITS
3. Coverage List • HSP_ACCT_CVG_LIST
4. Coverage • COVERAGE

(Aug. 2021, 5.15)

Question 9

Linking Encounters and Coverages in Hospital Billing

List the Caboodle DBOs for the following:

1. Encounter
2. Encounter-HAR mapping
3. HB HAR
4. Coverage List
5. Coverage

Answer 9

1. Encounter • EncounterFact
2. Encounter-HAR mapping • BillingAccountEncounterMappingFact
3. HB HAR • BillingAccountFact
4. Coverage List • BillingAccountFact
5. Coverage • CoverageDim

(Aug. 2021, 5.16)

Question 10

Linking Encounters and Coverages in Hospital Billing

List the Clarity DBOs for the following:

1. Encounter
2. Encounter-HAR mapping
3. HB HAR
4. Coverage List
5. Coverage

Answer 10

1. Encounter • PAT_ENC
2. Encounter-HAR mapping • HSP_ACCT_PAT_CSN
3. HB HAR • HSP_ACCOUNT
4. Coverage List • HSP_ACCT_CVG_LIST
5. Coverage • COVERAGE

(Aug. 2021, 5.16)

Question 11

What Clarity table would you use to see a HAR on the transaction level?

Answer 11

ARPB_TX_MODERATE

Aug. 2021, 5.17

Question 12

What Caboodle table and column stores the billing status of PB and HB HARs?

Answer 12

Table: BillingAccountFact
Column: BillStatus

(Aug. 2021, 5.19)

Question 13

What is the Clarity table that stores bucket type?

Answer 13

Table: HSP_BUCKET
Column: BKT_TYPE_HA_C

(Aug. 2021, 5.22)

Question 14

What is the main Clarity table for reporting on HARs?

Answer 14

HSP_ACCOUNT

Aug. 2021, 5.26