Thank you, Hilary. Your suggestion really set me in the right direction for where to look.
It turns out you can achieve the desired effect by selecting the target SSN field, in the control tools box, click default value, click the fx button and then enter this formula:
concat(substring(translate(., "-", ""), 1, 3), ...