No problem...good luck! --Josh
-----Original Message----- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 1:36 PM To: CF-Talk Subject: RE: Dates and the like Thanks Josh, looks like this tag can definitely be of use in this project. I am having a requirements meeting witht he 2 big guys tomorrow, just kinda wanted to get some feedback so I can figure out what to tell them. *sigh*... Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 9/16/2002 3:35:03 PM >>> Sounds like you need to have a requirements meeting... 8^) What is the question exactly? Not sure how to help... If you want a good date/time picker (to set the appointments) you're welcome to use my tag: http://exciteworks.com/ec/tags.cfm just look at <cf_popDateTime> and you can see how it works and download the code. Josh Trefethen http://exciteworks.com -----Original Message----- From: Candace Cottrell [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 12:54 PM To: CF-Talk Subject: RE: Dates and the like The time frames aren't always 8-a-8p. They also arent even standardized. So I could have the same guy in Oncology on call for 3 months. Some divisions do their schedules this way. Others split up a day. There are a bunch of if's here. :) The guy I'm doing this for is the VP of Medical Affairs, he's the one who all the docs report to. So if he says we can standardize, we standardize. It has to be better than what we have here now. Basically it's a free-for-all and each division makes their own calendar, list, or whatever. Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 9/16/2002 2:43:09 PM >>> You can definetly capture that info with the schema you laid out. The big calendar would probably hinder you as you could not put in the names of every doctor in a single cell/day. A little one might be good for quick access to a day for the reports though. I think your biggest problem will be to validate the forms people enter which shouldn't be too hard. Also pay close attention to how all the various schedules work. Requirements gathering will be key here. I wouldn't be surprised to hear that nurses can schedule different shift types than doctors and what not. DRE -----Original Message----- From: Dina Hess [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 12:37 PM To: CF-Talk Subject: Re: Dates and the like Sounds like a fun little project. Are the on-call timeframes always 8am-8pm? ----- Original Message ----- From: "Candace Cottrell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, September 16, 2002 1:28 PM Subject: RE: Dates and the like > Dre, I need to be able to tie their contact info with the schedule. > Basically, if I ama nurse in the ER and I need to know who is on call in > dentistry, I would go to the intranet, pull up this app, select > dentistry, and whoever is oncall's name and contact info would show up. > I liked the calendar display, but it really isnt necessary. > > There will need to be reporting for the scedules. Basically, I'll need > to make it so the division (or the hospital operator) can have this > printed out to either give a copy to the docs or to have in the > switchboard area. > > So I guess I'm really dealing with three elements: > > 1) Who's on call now > 2)A Start date for a doc > 3) An end date for a doc > > Does this make sense? > > Thanks for the db tip. I guess that would be kind of "jargony". > > > Candace K. Cottrell, Web Developer > The Children's Medical Center > One Children's Plaza > Dayton, OH 45404 > 937-641-4293 > http://www.childrensdayton.org > > > [EMAIL PROTECTED] > > >>> [EMAIL PROTECTED] 9/16/2002 2:14:01 PM >>> > Candace, What functionality are you trying to capture besides just > calendar > display? Does it have to watch for conflicts or maintain a certain > amount > of doctors on call for each div at a certain time or prevent them from > working 80 hours straight or maintain reports on them? On the prefab > software side, sometimes it can be difficult to add functionality to > something already made- it could be a totally different db schema that > doesn't match your requirements or pure spaghetti code. DRE > > Ps, you might want to change the db table to doctors. Docs can be a > bit > misleading. > > -----Original Message----- > From: Candace Cottrell [mailto:[EMAIL PROTECTED]] > Sent: Monday, September 16, 2002 11:52 AM > To: CF-Talk > Subject: Re: Dates and the like > > > You're right. Knowing me, it'll take me a while :) > > Candace K. Cottrell, Web Developer > The Children's Medical Center > One Children's Plaza > Dayton, OH 45404 > 937-641-4293 > http://www.childrensdayton.org > > > [EMAIL PROTECTED] > > >>> [EMAIL PROTECTED] 9/16/2002 1:50:51 PM >>> > At 10:03 AM 9/16/02, you wrote: > >Has anyone ever had to build a calendar/scheduleing application? I > found > >one that does virtually everything I need, but the boss says the > price > >is a little high. (Powered Calendar - > >http://www.dkanos.com/cfm_powered/) > > For what it's worth... I think your boss is penny wise and pound > foolish... > How many hours will it take before you to eat up the $600 price tag? > > But then again... I've been wrong before. > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

