I think to help with the substitution we're going to need sample data, and the rules.

I take it sys_user has a column or lookup to another table to show when a person is on holiday and who is covering for them, but without the structures and sample data we will struggle to help any further.