RE: [PHP-DB] Re: Hold System

2004-07-15 Thread Justin Palmer
Hi, Thank you, Peter and all. This has been of great help. Regards, Justin Palmer -Original Message- From: Peter Westergaard [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 6:48 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Hold System > In the example of Bob, M

Re: [PHP-DB] Re: Hold System

2004-07-15 Thread Peter Westergaard
> In the example of Bob, Mary and Barbara that I gave in my last post. If > Bob cancels his hold and I reset date_held for mary to the current date, > so that she has adiquite time to place her student. If I do that this > will put Barbara into the #1 position because she has now put a hold > bef

RE: [PHP-DB] Re: Hold System

2004-07-14 Thread Justin Palmer
Westergaard [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 2:02 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Hold System Ah, now I think I understand. Thank you. > 2. A Coordinator can only hold a student while in the #1 position for > a certain amount of time. (I don't

RE: [PHP-DB] Re: Hold System

2004-07-14 Thread Justin Palmer
ssage- From: Peter Westergaard [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 1:17 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Hold System I guess I'm still not grasping... Who creates the temporary "I'm-trying-to-place-you" link between coordinator and stu

Re: [PHP-DB] Re: Hold System

2004-07-14 Thread Peter Westergaard
Ah, now I think I understand. Thank you. > 2. A Coordinator can only hold a student while in the #1 position for a > certain amount of time. (I don't have a problem with calculating the > time.The problems are: > A. What do I do with the record once there hold has expired? > B. Also what do I do

RE: [PHP-DB] Re: Hold System

2004-07-14 Thread Justin Palmer
Hi, A 'hold' is a time period in which a Coordinator has to place the specific student with a Host Family. Coordinators can hold a specific student for up to 48 hours. At which time the student must be placed with a host family with in that time period. Or the coordinator has canceled the hold w

RE: [PHP-DB] Re: Hold System

2004-07-14 Thread Justin Palmer
the rest worked out. I just don't feel right about this hold table. Justin Palmer -Original Message- From: Ed Lazor [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 14, 2004 12:42 PM To: 'Peter Westergaard'; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: Hold System Hol

Re: [PHP-DB] Re: Hold System

2004-07-14 Thread Peter Westergaard
I guess I'm still not grasping... Who creates the temporary "I'm-trying-to-place-you" link between coordinator and student? The system automatically, or the coordinator manually? What is a "#1 position"? How does a student get there? Who or what places them there? How do they leave that posit

RE: [PHP-DB] Re: Hold System

2004-07-14 Thread Ed Lazor
Hold refers to the period of time when a student is waiting to be matched with a host family. - You have three groups: students, coordinators, and host families. - Coordinators match students with host families. - Students go through different stages of processing. The goals are to: - provide e