Skip to Content
0
Sep 27, 2005 at 08:10 PM

Data Modelling Question

33 Views

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