Registration Flashcards
In Clarity, what field should be used to identify the patient?
I EPT .1
In Caboodle, what field should be used to define relationships with patients?
Surrogate or Durable Key
What master file stores patient insurance information?
CVG
What master file stores information about the guarantor?
EAR
What is a Payer?
A payer is an insurance company.
What is a plan?
A plan is a set of benefits that the insurance company offers.
What is a subscriber?
The subscriber on a coverage is the person in whose name the insurance is issued.
Which Clarity database object greatly simplifies coverage reports?
V_COVERAGE_PAYOR_PLAN
What is a member on a coverage?
Members are the set of patients who would use a coverage and are stored as EPT records.
In which database object(s) would you find member‐level effective dates?
EligibilityEventFact, COVERAGE_MEMBER_LIST
What is the Caboodle Table and Column name for the current patient MRN?
PatientDim.PrimaryMrn
What is the Caboodle Table and Column name for the patient name?
PatientDim.Name
What is the Caboodle Table and Column name for the guarantor name?
GuarantorDim.Name
What is the Caboodle Table and Column name for the primary payer name?
CoverageDim.PayorName
What is the Caboodle Table and Column name for the Secondary Payer Name?
CoverageDim.PayorName
What Clarity column stores the patient’s name?
PATIENT.PAT_NAME
What Caboodle column stores the patient’s name?
PatientDim.Name
Generally, which field in Caboodle should be used to join or group patients?
PatientDim.DurableKey
What is the granularity of the Caboodle DBO, PatientDim?
One row per patient per date range
What is the granularity of the Clarity DBO, PATIENT?
One row per patient
What is the granularity of the Caboodle DBO, GuarantorDim?
One row per guarantor account per date range
What is the granularity of the Clarity DBO ACCOUNT?
One row per guarantor account
In which database object(s) would you find member‐level effective dates?
EligibilityEventFact, COVERAGE_MEMBER_LIST
What would it mean if MEMBER_EFF_FROM_DATE stored the beginning of last month but MEMBER_EFF_TO_DATE was null?
The coverage is currently active for the member.
What is the granularity of the Clarity DBO, ACCT_COVERAGE?
One row per CVG attached to an EAR or one row per coverage attached to a guarantor.
What is the granularity of the Clarity DBO, PAT_ACCT_CVG?
One row per EAR attached to an EPT or one guarantor account attached to a patient.
What is the granularity of the Caboodle DBO, EncounterFact?
One row per patient encounter
What is the granularity of the Clarity DBO, PAT_ENC?
One row per patient encounter