How do I calculate PropertyUseGroup?

In ATTOM Cloud we have a field called PropertyUseMuni that provides a localized definition of the intended use of the property.

Our bulk file layouts also include additional fields

PropertyUseStandardized - standardizes the intended use of the property to a consistent set of values
PropertyUseGroup - Groups those standard uses into categories.

Within ATTOM Cloud, it is possible to establish these values using the DimPropertyType table

PropertyUseStandardized = AttomCode
PropertyUseGroup = MajorCategory

Example:

SELECT Top 100
       PF.[Attom ID] AS [Attom ID]
       ,PF.PropertyUseMuni AS PropertyUseMuni
       ,PT.MajorCategory AS PropertyUseGroup
       ,PT.Attomcode AS PropertyUseStandardized

FROM adw.PropertyFeature PF
LEFT JOIN adw.DimPropertyType PT ON PF.PropertyTypeKey = PT.PropertyTypeKey