Multiple holiday tables

[JJacobs313]

I have taken over for someone, and I am trying to avoid the issues from the past with Holidays, and get it sorted out now. I noticed a lot of places have multiple holiday tables in their vectors:

07 goto step 20 if holiday in table 1
08 goto step 20 if holiday in table 4

So table one includes Christmas Eve, table 4 is Closed Early Christmas Eve 12:00 to 18:00. I do not see how this would even work. It seems to me that because of table 1, it would bypass line 8 (table 4) on Christmas Eve.

Just wondering if I am seeing this correctly.

 

[lopes1211]

table 1 is probably company wide (maybe 3pm on xmas eve)

table 4 is probably departmental when that manager calls and says they want to close at noon. It would give them a way to make on-the-fly changes for that 1 dept without affecting the entire companies holiday table and closings.

In that example at 1pm, step 07 is not in the table so step 08 would then be processed.

-CL

 

[JJacobs313]

Well in table 1, there are no times set, and is in every vector. I guess what I am not understanding is that, the vector is going down the line, hits line 7 07 goto step 20 if holiday in table 1. It is then going to step 20, it doesn't even hit line 08 then for the early closing time.

Holiday 1
Number: 1 Name: Standard Holidays 2013

______START_______ _______END________
Month Day Hour Min Month Day Hour Min Description
01 01 01 01 New Year's Day
05 27 05 27 Memorial Day
07 04 07 04 4th of July
09 02 09 02 Labor Day
11 28 11 28 Thanksgiving
12 25 12 25 Christmas
12 24 12 24 Christmas Eve

Holiday 4

Number: 4 Name: Half Christmas Eve

______START_______ _______END________
Month Day Hour Min Month Day Hour Min Description
12 24 12 00 12 24 18 00 Closed Early

 

[joesena]

You are correct, with the example you provided, the calls will go to step 20 all day on Christmas Eve. What is your intended result?

 

[JJacobs313]

Well, this was how the person I took over for had everything, and every year there are complaints that calls aren't rolling over at noon, etc. I have made a spreadsheet of all the clinics I have and their holiday hours. My intended result is to just have the clinics have the correct holiday hours. I don't see much of a problem as long as I create some new holiday hours. I was just noticing that quite a few had multiple holiday tables, and it just didn't make sense, as I didn't think they would override each other. The main days are Black Friday and Christmas Eve, some places are open, some are closed, some are open until noon. I think as long as I redo the holiday tables to reflect this, and insert the correct one, not multiples into the vectors I should be good. I just hate to waste a holiday table on one clinic here and there. I think what was causing the issue was that there were multiple tables assigned to vectors, but they just don't work that way.

 

[joesena]

It sounds like you have a bunch of separate call flows that do the same thing (or similar to the same thing)? If so, and you have vector variables, you can just have one call flow and use variables to accomplish similar. For example:

01 wait-time 2 secs hearing ringback
02 # Check Open/Closed status of office (stored in V1)
03 goto step 8 if service-hours not-in table V1
04 goto step 8 if holiday in table V1
05 # This office is open; send call to their hunt group
06 queue-to skill 1st pri l
07 # This office is closed; play VM for that office (stored in V2)
08 messaging skill 99 for extension V2
09 stop

Then your VDNs would be something like this:
((page 1 Name*: Dr Office 1
Destination: Vector Number 123

VDN of Origin Annc. Extension*:
1st Skill*: 101
(page 3
VDN VARIABLES*
Var Description Assignment
V1 Open/Holidays 11
V2 VM Box 2101


Now you can have a separate Holiday table and Service Hour table for each office (even if most are the same), and if Office A wants to close at 12PM and Office B wants to close at 1PM, you can do that no problem.

 

[joesena]

lol: make sure you put something else between step 6 and step 7 (like wait 300 seconds hearing music or something) otherwise your calls will never ring a live phone. That's what I get for quickly throwing that together