I fully understand the performance implications, however, in larger complex systems where many codes are used (via a reference table), multiple (> 4) joins are required in the view.  A...

Article was OK but here are some general thoughts:

1) If you can use the complete name for a table, use it.  There's no need to abbreviate, it just creates more...