OpTime Flashcards
T or F The SER masterfile is short for Surgical Epic Resources and only contains records for surgeons?
False
Schedulable EPIC Resources include surgeons, surgical and anesthesia staff, surgical and anesthesia equipment, instruments, and operating rooms.
The Snapboard is an OpTime application report in hyperspace that shows 3 things what are they.
- OR schedule for a given day
- scheduled surgical cases
- unscheduled surgical cases
and the rooms they will be assigned to.
What is a SER record in Optime
Each operating room which can be found in the top half of the snapboard is a record in SER.
Operating rooms (SER’s) are grouped together in different surgical (OpTime) locations What masterfile represents a location record?
EAF
T or F OpTime EAFs (location) can be marked as part of a particular department or service area?
True
even though OpTime facility structure can stand completely on its own with any connections to EAF or DEP records set up by other applications, many facilities will want to integrate OpTime into their larger system.
T or F A single department can have many OpTime surgical locations?
True
T or F An OpTime surgical location can be attached to many department locations
False
An OpTime surgical location can only be attached to one department. (Surgical theaters can be specialized, allowing worflows to be configured differently and more granular reporting on how these specialized areas are reporting.
The SER masterfile contains one record for ___________, and can be found in what table?
anything that can have a schedule, and can be found in the CLARITY_SER table
Each CLARITY_SER can potentially act as multiple resource types (TorF) What table would you link to to find type specific definitions for a given record?
T
OR_SER_SURG_RECTYPE table
T or F Operating Rooms are a scheduable resource and will have a row in Clarity_SER?
True
Outside of a row identifying an operating room in CLARITY_SER, Where will operating room specific information be found
OR_SER_ROOM
Operating rooms will generally be associated with?
What table contains information about surgeons and operating rooms?
The surgical Location where they are located.
OR_SER_SURG_SRVC
What can OR_SER_SURG_SRVC table be used for?
Reporting about surgeons and operating rooms (locations) Each row contains an operating room and can be used to determine the location an OR is linked to.
It can also be used for reporting on surgeon authorizations.
What is contained in the OGP masterfile
Surgeon groups which consist almost entirely of an ID, a name, and a list of the member of surgeons. Used for scheduling or blocking of rooms. See OR_GRP or OR_GRP_SURGEON
T or F CLARITY_SER stores the type of surgical resources a SER record is?
False. Because a single SER record can act as multiple resource types, and is a single response table cannot hold the surgical resource types, must link to OR_SER_SURG_RECTYP a multiple response table to find stored type or type of surgical resource a SER record is
That table can you use to determine the surgical location associated with an OR
OR_SER_SURG_SRVC
What are the two types of ORP records (surgical procedures)
Base Procedures
Preference Cards
What is a Base Procedure?
The core definition of a procedure; what is needed in order to perform the procedure, how long it will take, who should be in the OR, when the procedure will take place.
What is a Preference card?
A preference card contains all the information that is often the same each time a procedure is done by a particular surgeon, service, or in a specific location
Preference cards are sometimes called
procedure modifiers because they serve only to modify the requirements of base procedures and cannot be used on their own.
How many preference cards will be applied for any single scheduled procedure?
One.
All surgical procedures including base procedures and preference cards can be found in what table?
OR_PROC and preference card values take preference over base procedures
What category in OR_PROC.REC_TYP_C in all rows for preference cards will this category value be?
“1”
What is the relationship between cases and procedures? How is that relationship reflected in Clarity?
Procedure records store the standard needs of a procedure, such as staff, supplies, and length. These procedure records are then added to a case and the procedure information will copy to the case. An end-user can modify this information to the needs of the specific case once it is in the case, so that it differs from what appears in the procedure record. A case’s procedures are listed in the OR_CASE_ALL_PROC table.
Using Clarity tables, how can you associate a procedure with a particular surgeon in a case?
In a case, you may have more than one “panel,” or combination of a particular primary surgeon and service. For each panel, you will have surgeons and procedures. Each panel will also always have a primary surgeon, indicated by the value of 1 in the ROLE_C column in
OR_CASE_ALL_SURG. Once you know the primary surgeon for a panel, you can associate that panel with procedures via the PANEL column in the OR_CASE_ALL_PROC table.
What is the difference between the RESCHED_TO_DATE and
CASE_DTTM columns in the CASE_SCHEDULE_CHANGE view?
CASE_DTTM contains the date and time the procedure was scheduled for, while RESCHED_TO_DATE indicates the date to which the case is rescheduled.
Would you use CLARITY_EAP for reporting on OpTime procedures?
No, CLARITY_EAP pulls records from the EAP master file, while OpTime procedures are stored in the ORP master file. The Clarity table for ORP is OR_PROC.
How do base procedures and preference cards relate to one another, and how does that relationship exist in Clarity?
Base procedures are the most generic record of what a procedure needs to be performed. Preference cards are built as modifiers to base procedures to tweak the procedure to reflect the specific preferences of a
particular service, surgeon, or location. A preference card’s modifiers can be found in OR_PROC_MOD_EAF_INDEX,
OR_PROC_MOD_ORP_INDEX, OR_PROC_MOD_SER_INDEX and
OR_PROC_MOD_SVC_INDEX.
How are supplies created “on the fly” differentiated from permanent SUP records?
It will be marked as a temporary record, found in
OR_SPLY.TEMP_RECORD_YN.
Which columns would you need to add to your report in order to see the total number of supplies that were opened during the course of a surgery? Where are these fields documented? What column indicates how many should be opened in preparation for surgery but does not reflect the actual number?
In order to see the total number of supplies that were opened during the course of a surgery, you would need to add the SUPPLIES_USED and SUPPLIES_WASTED columns. These two fields are documented in the
log, which represents what actually happened in surgery. The NUM_NEEDED_OPEN column indicates how many should be opened in preparation for surgery but does not reflect the actual number.
What is the main difference between a case and a log? When would you use OR_CASE vs. OR_LOG?
You would use OR_CASE to report on how a surgery was planned. You would use OR_LOG to report on what actually occurred during the surgery.
What pieces of information would you find in the log documentation of staff or equipment that you would not find in the case?
The individual SER record of the staff member or piece of equipment.
How do you know an implant was created from a supply record?
OR_IMP.INVENTORY_ITEM_ID will link to the SUP record the implant was created from in OR_SPLY
How could you differentiate a thin log from a surgical log?
The CASE_ID column will not be populated for a thin log.
What is the difference between a case tracking event and a timing event?
Timing events are standard events from the AACD for surgeries that allow reports to avoid parameters to define the category value for the event.
True or False. You should use the column
PAT_OR_ADM_LINK.OR_CASELOG_ID to link to a case only if a log has already been created from it.
False. The column PAT_OR_ADM_LINK.OR_CASE_LOG_ID should not
be used as a foreign key.
Who should you work with to set the properties in V_LOG_BASED?
The OpTime project team should supply the values that should be used for the properties, and your ETL Administrator should set the values in the
Clarity Compass.