Wow! I wanna work at your place! 2 weeks paid leave when you're welcoming a new pet into your home! 
Most places of work wouldn't do this. I know a woman who was raised by her grandmother, as her birth mother died when she was 18 months old. (She and her grandfather officially adopted her at 2 and a half years old. So she was their daughter in the eyes of the law.) She knew her grandmother as 'mum' and that's what she always called her.
She started a job at a local workplace and quite a few people she knew worked there. 7 years after starting there, her grandmother (who she knew as mum) died. The workplace at the time offered 5 days compassionate leave for the death of a parent, sibling, child, or spouse. (I you had worked there for more than 2 years.)
The manager at the time refused her the compassionate leave time off because the woman was biologically her grandmother. She ended up having to request leave, and he refused it because of the short notice, and said he couldn't cover her, as too many people were off on holiday.
She was devastated. She just didn't come in anyway the next day, and her husband contacted head office to complain about him. She got a message from the area manager (above said dickhead manager) and he said she can have the full week off with pay, and he was sorry for the manager's behaviour, and he will be 'having words.'
Baffling actually, because if it had been her 'birth mother' he would have had to have let her have the time off then, so would still have had the 'staffing issue!'
The manager of the place was such a dickhead to her when she came back, that she ended up finding another job. Vile bastard. I left not long after her - 6 months later.
.