select preference_type_id from user_preference_types where short_name= :preference_type