Cadence Flashcards
In order, what are the levels or organizational structure that Epic uses to represent the physical and logical structure of a health care enterprise?
Facility(EAF) > Service Area(EAF) > Location(EAF) > Department(DEP)
Is it possible for a provider to have more than one department? If so, do departments have a list of providers, or do providers have a list of departments, and which tables contains the list?
Yes, providers have a list of departments, and it is extracted to CLARITY_SER_DEPT.
If you needed to report on departments by revenue location, which tables would you use and how would you link them?
The departments revenue location is stored in the REV_LOC_ID column, so you would join CLARITY_DEP to CLARITY_LOC on CLARITY_DEP.REV_LOC_ID = CLARITY_LOC.LOC_ID.
What is the difference between the CUR_PCP_PROV_ID column in the PATIENT table and the data in the PAT_PCP table?
CUR_PCP_PROV_ID lists the patients general PCP at the time of the most recent extract and load process. PCP_PROV_ID will contain all PCP’s current and prior, for all patients.
You have been asked to write a report that lists each patient and their current general PCP. The report should include the patient’s name and the provider’s name. Which tables do you need? How would you link the tables together?
PATIENT, CLARITY_SER link : PATIENT.CUR_PCP_PROV_ID=CLARITY_SER.PROV_ID
During your Epic implementation, patient records were created for testing purposes, and were assigned a patient type of 20 - Test Patient. How would you create a report showing these patients names?
Join PATIENT_TYPE to PATIENT on PATIENT_TYPE.PAT_ID = PATIENT.PAT_ID, and include only those rows from PATIENT_TYPE where PATIENT_TYPE_C=20. Display the column PAT_NAME on your report.
What is the difference between a contact serial number and an appointment serial number?
A contact serial number will be unique for each contact while appointment serial numbers can be shared by multiple contacts, for example a canceled and rescheduled appointment.
Explain the difference among CONTACT_DATE, APPT_MADE_DATE AND APPT_DTTM.
CONTACT_DATE has just the date portion of the contact.
APPT-DTTM contains the date and time of the appointment.
APPT_MADE_DATE contains the date that the patient called to make the appointment, for example.
True of False: In 2012, when a patient is put on the wait list because she is not happy with how far in the future an appointment is, that wait list contact can be linked to the original appointment.
True. In PAT_ENC_WT_LST, the column ORIG_APPT_CSN_ID can be used to link to the PAT_ENC_CSN_ID column in V_SCHED_APPT to get information about the original appointment.
True or False: If a wait list entry is associated with multiple providers in PAT_ENC_WT_LST_DP, then an appointment scheduled from that wait list entry must be scheduled with all of those providers.
False. For example, if a patient is willing to see either one of two providers, there will be a row in PAT_ENC_WT_LST_DP for each of the providers. However, when an appointment is scheduled from the wait list entry, it will be with just one of the providers.
For the appointments scheduled in a slot, how can you tell which are completed?
Link V_AVAILABILITY.PAT_ENC_CSN_ID to F_SCHED_APPT.PAT_ENC_CSN_ID and use APPT_STATUS_C.
True or False: Canceled appointments are removed from the V_AVAILABILITY view.
True, once an appointment is canceled, it will be removed from this view and the total number of appointments scheduled will adjust accordingly.
How can you tell which rows in the V_AVAILABILITY view are for slots and which are for appointments?
Use the APPT_NUMBER column. It will be 0 for slots and greater than 0 for appointments.
What is the difference between CONTACT_DATE and SEARCH_DATE?
The column CONTACT_DATE is similar to CONTACT_DATE_REAL in other tables. It stores the contact date as a decimal. The column SEARCH_DATE is similar to contact date in other tables. It stores the date in a calendar format.
What is the difference between search date and slot time?
Search date is the day that the batch job searched for the Nth next available slot. Slot time is the date and time of the slot found that matches the criteria of the search.
