crud for vacancy