Royal College of Nursing union says members ‘do not yet feel valued and they are looking for urgent action’