adding reference/lookups for id/name conversions