topic Re: Values removed from domain remain in attribute table for historical records? in Data Management Questions

Values removed from domain remain in attribute table for historical records?

Boomer1187 — Mon, 11 Dec 2023 20:36:53 GMT

Hello!

I have a feature class in an enterprise geodatabase that contains domains with different contractor names. I was wondering, if several of these contractors will retire and I delete them from the domain drop down, will their names show up in the attribute table for historical inspections that they completed? Or does every record/instance that the retired contractor's name shows up dissappear from the feature class/attribute table as well? I want to ensure that all of the retired contractors names will still display when they are removed from the domain.

Thanks!

Re: Values removed from domain remain in attribute table for historical records?

RyanUthoff — Mon, 11 Dec 2023 21:13:44 GMT

Removing values from a domain won't modify your data. However, there are two things to consider.

1. You won't be able re-select them again if you ever needed to use their name (at least not with doing a field calculate within Pro).

2. If your Code is different from the Description in your domain (ex: a code of 5 = John Smith), then it will only display the code once you remove the domain (ex: it will only show the code of 5 as the value instead of the person's name).

Otherwise, it's safe to remove domains. It won't modify the data itself.

Re: Values removed from domain remain in attribute table for historical records?

Bud — Mon, 11 Dec 2023 22:02:38 GMT

You won't be able re-select them again if you ever needed to use their name (at least not with doing a field calculate within Pro).

If wanted, could the user type in the old value as a field calculation/constant, as a workaround if the value is no longer available from the field calculator via clicking from a list?

Re: Values removed from domain remain in attribute table for historical records?

RyanUthoff — Mon, 11 Dec 2023 21:30:53 GMT

Yeah, that's what I meant when I said when doing a field calculate.

Re: Values removed from domain remain in attribute table for historical records?

Boomer1187 — Tue, 12 Dec 2023 17:26:41 GMT

@RyanUthoff Thanks so much for your response - that is good to know! I will keep #2 in mind to ensure that the data isn't modified