IIf was in SQL Analysis Services 2000 for MDX queries, but I get an error running an SQL Query with IIF in there.

The new BanStatus column is an integer because it maps to an enum in EF - which has NotBanned = 0, Banned = 1, SilentlyBanned = 2.  The old field was a boolean but that wasn't enough.  For the new datatype it's a full integer (rather than a tinyint/byte/etc) because the underlying type of C# enums is a 32-bit int (and while you can override that in the enum definition, there didn't seem to be much point).