Can you show us how these number flow into the fields you provided? Also what those fields are supposed to mean could help.
I read them as iRegular_Account_Limit is the maximum accounts the user can be assigned. iDelinquent_Account_Limit is the maximum # of delinquent accounts a user can have at any one time. I am not sure how I read the overflow count.
When I have a problem with how a concept is supposed to work, I get out a flip chart (tablet of paper about 30inches by 48inches in size) and start diagramming the logic. A large dry-erase board works wonders also.
>Hi everybody,
>
>I'm writing a procedure which distributes work between employees. I have a pool of unassigned accounts which I'm assigning to the users. Each user has the following fields in his/her profile:
>
>iregular_account_limit
>iqueue_overflow_count
>idelinquent_account_limit
>
>If the user didn't work his/her accounts, they become delinquent.
>
>I would try to explain the problem in example:
>The new user Joe has 50 accounts for his Daily queue as a regular count limit and 10 for overflow. My program assigns him 50 accounts for Monday, 50 for Tuesday, 50 for Wednesday, 50 for Thursday and 50 for Friday.
>
>Now, on Monday he worked up 30 accounts, and re-scheduled 10 for the next week’s Monday. So, he now has 10 delinquent accounts. On Tuesday he had the same situation, e.g. he resolved 30 accounts, re-scheduled 10 and 10 scheduled on the following Tuesday. And so he did the rest of the week. So, at the end of Friday he has 50 delinquent accounts.
>
>Now, how is my program supposed to work? How I’m supposed to assign him accounts for the next week?
Mark McCasland
Midlothian, TX USA