In this particular case we have taken the one 6 digit department number and subdivided it into three 2 digit categories, called funding, program and location. A fourth category called division adds a fifth digit to the 4 digit account code. It is like having a five segment GL account number. Departmental masks are critical to the financial reports as they allow us to report on a category or combinations of categories. The adselect function allows us to pick out the division. The traditional Adagio department would only exist if we were reporting on a specific funding/program/location combination.

-----------
Don Wise
Westboro