This is a great idea! The closest thing to it is the attribute assistant add-in. However this only works on desktop and the web editing environments. Also managing the desktop add-in and Mxd's for 50+ workstations is not the easiest administration, storing this in the geodataase as a data type makes sense.