Hi, No points to be found here, just looking to strike up conversations.
I need to create a new characteristic say "Survey Status". When creating this would the best way be to create a 2 length NUMC or say a 6 length character field that would be a more meaningful code in a pull down?
I think it is better to use the NUMC that whay the SID will be the same number and less joins are required somewhere down the line. Can anyone comment more on the pros or cons of either way?
Examples
01 - Survey in Preparation
02 - Survey is Open
03 - Survey is Active
03 - Survey is Closed
or
PREP - Survey in Preparation
OPEN - Survey is Open
ACTIVE - Survey is Active
CLOSED - Survey is Closed