tech tips: Banner–Room Queries with SLIAEVN

When checking room availability for an event, or series of events, you will use the Banner form SLIAEVN. Like most Banner forms,  has a Key Block. Unlike most Banner forms, SLIAEVN’s Key Block has some eccentricities you’ll want to be aware of, to avoid frustration and get the most from using the form.

Setting a Start Time that is after the End Time:
The Scenario – You run a Query for room availability from 1400-1600 (2:00-4:00pm) on 03/04/2011 in building SAIL. You decide to run another Query with all the same criteria but at a later time of day, let’s say 1700-1900 (5:00-7:00pm). You Rollback to the Key Block, and start to modify your criteria by changing the Start Time from 1400 to 1700. At that point, Banner throws up an error and won’t let you proceed.

The problem – Banner will allow you to enter a Start Time (1700) that is later than the End Time (1600), but it will cause an error and prevent you from proceeding, including setting the End Time later.

The solution – You will need to reset the Start Time (1700) to something earlier than the End Time (1600). Then you can set the End Time to the new later time (1900). After that, you can set the Start Time to the new later time (1700).

The Building field in the Key Block is cleared:
The Scenario – You run a Query for room availability from 1400-1600 on 03/04/2011 in building SAIL. You Rollback to the Key Block to run another Query with all the same criteria but on a different day. You enter the new day and execute the Query, but this time the results are for every building on the South Campus.

The problem – When you Rollback to the Key Block on SLIAEVN, all criteria fields are left the same except Building, which is automatically cleared.

The solution – Be sure to re-enter the appropriate code in the Building field before executing the new Query.

Clicking back into the Key Block:
The scenario – You have already run one Query for room availability and are ready to run another. Without thinking, you click in the Key Block and start entering new criteria, rather than using the Rollback function. When you execute your new Query, the results have not changed from the previous Query.

The problem – Unlike most Banner forms, which force you to use the Rollback function to go back to the Key Block, SLIAEVN will allow you to click in the Key Block after a Query has been executed, but this does not clear the form of the existing Query results.

The solution – Always remember to use the Rollback button to return to the Key Block, so the existing Query results will be cleared and the form will be ready to present all new Query results.

For more information:
If you would like further training on how to use SLIAEVN to search for room availability, be sure to check Avatar (http://sanjacinto.avatarlms.com) for upcoming Student Queries training sessions offered by Training & Professional Development.

Ready to reserve a room?
If you have already checked room availability, and would like to reserve the room for your use, please contact the appropriate person for your campus, so they can enter the reservation for you.
•    North Campus: Charlotte Jackson – charlotte.jackson@sjcd.edu – ext. 7526
•    Central Campus: Julie Blacksmith – julie.blacksmith@sjcd.edu – ext. 1811
•    South Campus: Carol Long – carol.long@sjcd.edu – ext. 4618
The individuals listed above can enter a reservation for a non-classroom (conference room, etc.). You will need to speak to the DOM for the appropriate department to reserve a classroom.