If you need to include description and the valid column you would just need to add it into values list:
insert into table (ssn,empid,race,description,valid)
WHEN 'deputy' THEN 'Y'
WHEN 'civilian' THEN 'N'
It shouldn't hurt anything to do that. Valid is a column in the same table right?
Hope to help,