prepared view for administration> employees and promotions