database prepared, vacation still missing