As a FoRG I've had some interesting calls with the Data Catalog team. The RedGate Data Catalog will pick up these values from the database as well as supporting many more out-of-the-box and useful properties.
In my organisation we colour categorise data and determine an action with regard to export to other systems
- RED = PII, GDPR sensitive
- AMBER = Not PII as an individual piece but sensitive. In aggregate could quickly expose an individual
- BLUE = Reference data, config data, not sensitive in any way
- GREEN = Open source data
The challenge we have is how to make this visible to data consumers. I think it would be great if RedGate SQLDoc had the capability to hook into RedGate Data Catalog to supplement the the usual table/view column definitions with relevant metadata from the catalog.