MMartin1 (5/6/2015)
I assume the tables are used directly instead of a view. Later, you could possibly add a view that combines date and time columns as one value. Any future uses of this information would utilise the view instead of the table at the least. I have seen where dates and times are stored as integers, they can come from a old mainframe system that had no concept of datetime. Just to make a note on the inconsistent data type you are seeing with <Time>, I also assume these are not staging tables either, correct?
These are not staging tables from what I know