HIM Flashcards
In order, what are the levels of organizational structure that EPIC uses to represent the physical and logical structure of a health care enterprise?
- Facility
- Service Area
- Location
- Department
How many Chronicles master files are used to store facility, service areas, locations, and departments, and what are they?
Two master files are used. Facility, service areas, and locations are all stored in the EAF master file, though they are extracted to different tables. Departments are stored in the DEP master file.
If you need to report on departments by location, what column would you use to join the relevant Clarity Tables?
The departments location is stored in the REV_LOC_ID column, so you would join from CLARITY_DEP.REV_LOC_ID to CLARITY_LOC.LOC_ID
True or False. All records in the ACCOUNT table are ROI requesters.
False. Some of the records in ACCOUNT are ROI requesters but some of the rows are other types of accounts, such as guarantor accounts.
Which column would you use to report on the amount of each refund made by your release clerks?
ROI_AUDIT_TRAIL.AUDIT_AMOUNT
Which column would you use to report on the reason a release was canceled?
ROI_DETAILS.ROI_HOLD_RSN_C
Which column should be used to select rows based on an episodes status?
CT_EPISODE.EPISODE_STAT_C
What do the values in CT_EPISODE.EPISODE_DLQ_YN mean and what condition must exist in order to trust its contents?
The values indicate whether any deficiencies attached to this episode went delinquent. It should be trusted only if the episode is closed.
How would you link a chart episode with the primary encounter associated with the episode?
CT_EPISODE.PRIMARY_CSN to PAT_ENC_HSP.PAT_ENC_CSN_ID
You have been asked to write a report that includes information about chart episodes for hospital encounters. In addition to CT_EPISODE and PAT_ENC_HSP, which table is needed to link a chart episode with all of the associated encounters?
CT_EPISODE_CSN
True or False. To report on delinquency rates by location, you can use the LOC_ID column in CLARITY_DEF.
FALSE. Location is not a required item when creating a deficiency definition. A single deficiency definition can be used by multiple locations.
What fields are used to link deficiency instance records to the records for the assigned parties?
- DFI_DETAILS.DFI_ID is used to link to CT_DEF_MULT_STAFF.DFI_ID.
- CT_DEF_MULT_STAFF.ASGN_PROV_ID is used to link to CLARITY_SER.
- CT_DEF_MULT_STAFF.ASGN_POOL_ID is used to link to CLARITY_HIP.
If two actions occured at the same time down to the second, how can we distinguish which action happened first?
The earlier action will have a smaller value in the LINE column.
Why are the DFI_AUDIT_TRAIL and F_DT_ASGN_STAT tables better for historical reporting on assigned staff then the CT_DEF_MULT_STAFF table?
The CT_DEF_MULT_STAFF table clears out information as the assigned party changes, so it only shows information as of the last Clarity extract.
What two actions cause the PRIV_AUD_SUSLINE column to be populated in PROV_PRIV_AUD_TRL?
Restore and Delete
You are running a daily report that shows you how many delinquent deficiencies a provider has yet to address. You see a number of providers who have delinquent deficiencies that are not being taken care of. What table can you use to incorporate whether or not the providers were in the office on a particular day?
OOC_DETAILS
Why would you use the HSP_ACCT_DX_LIST table in a report?
To report on the coded final diagnoses on a hospital account.
Which table would you use to see all DRG codes entered on a hospital account?
HSP_ACCT_MULT_DRGS
Why is having a LINE value of 1 significant for a record in the HSP_ACCT_PX_LIST table?
This indicates the procedure is the primary procedure on the account.
If an account has two rows where the status history was set to Complete, what does that usually represent?
A manager has gone in to review the coder’s work.
What is one example of a DNB?
The most important DNB check is when programming point 41465-Coding Status Complete Check is added. This is set for accounts that have been discharged but not billed and coding has not been finished within a sufficient number of days after discharge.
How is each new CDI review stored in Chronicles and in Clarity?
As a new contact in the COD master file and a new row in COD_CONTACT_INFO.
What column distinguishes Coding queries from CDI querires?
CODING_CLA_NOTES.QUERY_WORKFLOW_C
True or False. Each service area can have multiple locations?
True.