Is there a list what datatype corresponds to the system_type_id in Sys.columns

Yes you can look in sys.types for such a list or use the type_name function to look up an individual type_id.