capturing the functional primary key to check the row exists