Introduction (DBO, Columns)

Question 1

PB Guarantor:
Master File = ?
Clarity Table = ?

Answer 1

• Master file: EAR (Epic Accounts Receivable)
• Clarity Table: ACCOUNT

(Aug. 2021, 1.15)

Question 2

What is the Clarity table and column for a guarantor’s PB balances?

Answer 2

• Table: ACCOUNT
• Column: TOTAL_BALANCE

(Aug. 2021, 1.15)

Question 3

What is the Clarity table and column for a guarantor’s Hospital Billing balances?

Answer 3

Table: HSP_ACCOUNT
Column: HB_BALANCE

(Aug. 2021, 1.15)

Question 4

What Clarity table stores basic patient demographic information?

Answer 4

PATIENT - contains a row for every patient

Aug. 2021, 1.18

Question 5

What Caboodle table stores basic patient demographic information?

Answer 5

PatientDim - contains a row for every patient update

Aug. 2021, 1.18

Question 6

What Clarity table(s) store clinical details about encounters?

Answer 6

• PAT_ENC
• PAT_ENC_HSP

(Aug. 2021, 1.18)

Question 7

What Caboodle table(s) store clinical details about encounters?

Answer 7

• EncounterFact
• VisitFact

(Aug. 2021, 1.18)

Question 8

What Clarity table contains guarantor information?

Answer 8

ACCOUNT

Aug. 2021, 1.18

Question 9

What Caboodle table contains guarantor information?

Answer 9

GuarantorDim

Aug. 2021, 1.18

Question 10

Name the Clarity table(s) that provide the relationships between guarantors and the patients they are responsible for.

Answer 10

Table: ACCT_GUAR_PAT_INFO
Granularity: one row for each patient-guarantor relationship

(Aug. 2021, 1.18)

Question 11

How would you determine the guarantor balance in Caboodle?

Answer 11

You would aggregate the balance from the guarantor’s associated hospital accounts in BillingAccountFact.

(Aug. 2021, 1.19)

Question 12

Do guarantor balances appear in GuarantorDim?

Answer 12

No.

Aug. 2021, 1.19

Question 13

In what Clarity table do guarantor accounts appear?

Answer 13

ACCOUNT

Aug. 2021, 1.19

Question 14

What are the main Clarity database objects for coverage?

Answer 14

• COVERAGE
• V_COVERAGE_PAYOR_PLAN

(Aug. 2021, 1.19)

Question 15

What is the main Caboodle database object for coverage?

Answer 15

• CoverageDim

Aug. 2021, 1.19

Question 16

List the Clarity tables for the following Coverage database objects:
• Coverage
      • Subscriber
      • Payer
      • Plan
      • Members

Answer 16

• Coverage - COVERAGE
  * Subscriber - COVERAGE
  * Payer - CLARITY_EPM
  * Plan - CLARITY_EPP
  * Members - PATIENT

(Aug. 2021, 1.20)

Question 17

List the Caboodle tables for the following Coverage database objects:
• Coverage
      • Subscriber
      • Payer
      • Plan
      • Members

Answer 17

• Coverage - CoverageDim
  * Subscriber - CoverageDim
  * Payer - CoverageDim
  * Plan - CoverageDim
  * Members - PatientDim

(Aug. 2021, 1.20)

Question 18

List the master files for the following Coverage database objects:
• Coverage
      • Subscriber
      • Payer
      • Plan
      • Members

Answer 18

• Coverage - CVG
  * Subscriber - CVG
  * Payer - EPM
  * Plan - EPP
  * Members - EPT

(Aug. 2021, 1.20)

Question 19

List the Clarity and Caboodle tables that track coverage for members:

Answer 19

Clarity: COVERAGE_MEMBER_LIST

Caboodle: EligibilityEventFact
• Only to be use when reporting on managed care coverages through Tapestry

(Aug. 2021, 1.20)

Question 20

List the Clarity and Caboodle tables that store a list of the coverages:

Answer 20

1. Clarity: HSP_ACCT_CVG_LIST
   • Contains one row for every coverage on the hospital account
   • The LINE column represents the filing order
2. Caboodle: BillingAccountFact
   • Contains columns for the first 5 coverages on the hospital account

(Aug. 2021, 1.20)