Search results for query: *

I would like to see (for various completed surgery dates) whether a surgeon used the pre-allocated operating room time given to them or not. I have a table called “psallblocks” which has a field called “blockownername” (which is the name of the MD) and “scheduledstart” (which is the applicable...

I designed a report that our nurses run the evening before surgery to print “cards” that show surgery start time, patient initials, surgeon name, name of operating room and admit type. These cards are helpful in identifying patients that need to be transported. The report is grouped by name of...

I’ve got myself in a pickle. I have a report that derives total surgeon hours used per day (and total distinct cases) in the operating room. I am grouping by “surgeonname” and “dayoftheweek”. I am happy to report that output in section GF2 (by day of the week, e.g., Monday, Tuesday ….) for...

I have a report that grouped on surgeon name and weekdaydescription (e.g., Mon, Tue...) to arrive at minutes used per day per surgeon The report derives minutes used per case and sums up the total for each day. I need to build in 10 minutes for each case to account for turnover (to clean) the...

For the sake of this example I have five operating rooms. These rooms are called: OR1 OR2 OR3 OR4 OR5 My output for a given day is grouped by operating room name and is: OR1 Case number 12333 Case number 45666 Case number 78999 OR3 Case number 44444 Case number 55555 OR4 Case number 76767...

Does anyone have a suggestion as to how I might add a comment that I could insert into a report that would show what number case of the day it was for a particular surgeon. On any given day our surgeons may operate in several different locations in the hospital such as ambulatory surgery...

Requesting help with a formula. I am using CR10. We would like to create a report that shows if a surgeon does not have any cases “booked” into their allocated block date two weeks in advance of their allocated block date. For example, if Dr. Doe was allocated block time on 11/1/07 and has...

Our hospital policy requires that Attending Surgeon be in the Operating Room during a timeout (before the case starts) to make sure there is agreement on surgical site, laterality, etc. In case number 147,298 (see below) the Attending Surgeon was documented as being in the room during the...

I am comparing surgical cases done for each surgeon for the time period "1/1/06 to 8/31/06" with cases they have done in the time period "1/1/07 to 8/31/07". I am grouping by surgeon name and use a cross tab report. I understand there are various date grouping options (e.g. by date, by...

Example of Selection Criteria: {@SurgDate} = {?Date} and isnull({pcmprocedure.deletedon}) and {pcmProcedure.primaryProcedure} = "Y" and isnull({pcmcase.deletedon}) and isnull({pcmanesthes.deletedon}) and {pcmCase.status} = 3 and tonumber({vw_pcxPatient.medicalRecordNumber}) in [ 471823 , 967138...

I have a report that displays surgery cases that were scheduled (“datebooked”) AND completed (“datecompleted”) in the same week to identify any cases that were scheduled (and missed) after a report “run” date. The “run” date we are always using is the Friday afternoon of every week. Here is...

Good day everyone: I am using a running total to summarize amount of time an operating room was used during a case. I use this to determine block utilization. That is, if a surgeon was given an operating room for 8 hours on a given day and only used 4 hours, then his/her utilization was 50%...

I am using a group selection formula to find the minimum, or first case of the day, in a operating room. This formula is working correctly. The formula is: pcmOpTime.timePatientInRoom} = minimum ({pcmOpTime.timePatientInRoom}, {pcmORroom.orName}) I am using a formula to calculate variance in...

My objective is to total the number of first cases in a room. Formula to derive first case in a room (in selection formulas, group selection): {pcmOpTime.timePatientInRoom} = minimum ({pcmOpTime.timePatientInRoom}, {pcmORroom.orName}) That formula is working perfectly. Output: surgDate orName...

I wish to calculate variance between “last patient out of an operating room” and the time the operating room is formally staffed to end(which is 19:00 hours). I want to show unused operating room time. There are situations, however, when an OR runs past 7 p.m. I created a formula, let’s call...

Need help with a formula that I am thinking some sort of isnull statement would be applicable. I am using the following formula to label turnover time in a field: if {@TOT} >=0 and {@TOT} <10 then "0 to 9 minutes" else if {@TOT} >9 and {@TOT} <20 then "10 to 19 minutes" else if {@TOT} >19...

For surgical cases at my facility, there is sometimes one surgeon assigned to the case and at other times multiple surgeons are assigned to the case. The names are appearing correctly on a report I have prepared, but in a vertical fashion. For example: Dr. Ben Casey Dr. Marcus Welby If there...

I am using the following formula which is working correctly in the report. Formula: Local DateVar dt:= Date({vw_pcsAllBlocks.scheduledStart}) ; Local NumberVar d ; Local StringVar name ; Local StringVar dy ; Local StringVar suffix ; d:=DateDiff ("ww",DateSerial(Year(dt),Month(dt),1-1) ,dt...

I have Medical Residents that need to see data for cases they have worked on. I can do that. But the Residents also want see who the attending surgeon was on the cases they worked on. I can ask the Resident what MD's they worked with - but I need to see only the MD's that worked with them on...

Each day I have about 15 &quot;patient in operating room&quot; start times for first cases of the day. How do I create a formula or string in Crystal so that I can summarize (show the mean) of the average patient in operating room time for those 15 cases. I can do some manipulations in Excel...