Rules auto-generation is not be taking into account missing data codes when it determines the type of a database field to use for a REDCap field. For example, if a missing data code value of "UNK" is possible, then a database field that currently is generated as an integer, will not be able to correctly store the "UNK" value.
The problem with fixing this, though, is that then for fields that users don't plan to enter missing data codes, will not have the most descriptive type in the database (e.g., it will be varchar(255) instead of integer).
Rules auto-generation is not be taking into account missing data codes when it determines the type of a database field to use for a REDCap field. For example, if a missing data code value of "UNK" is possible, then a database field that currently is generated as an integer, will not be able to correctly store the "UNK" value.
The problem with fixing this, though, is that then for fields that users don't plan to enter missing data codes, will not have the most descriptive type in the database (e.g., it will be varchar(255) instead of integer).