You can query DICT_COLUMNS table.
Here you will get description for columns of the dictionary tables/views.

Sanjay