fixed a divide by zero problem with mem counts
added special prof criteria for writing
added explicit data types
reverted to OPENQUERY, data type issues with static table
static refresh for TEAM tracker
made attendance warning criteria more specific
added hw promo status and days to 90