TR_CONSTITUENT_INSERT_GENDERCODE

         create trigger [dbo].[TR_CONSTITUENT_INSERT_GENDERCODE] on [dbo].[CONSTITUENT] after insert not for replication
         as 
         begin
           update dbo.CONSTITUENT
           set
             CONSTITUENT.GENDERCODE = isnull(GENDERCODEDEFAULTMAPPING.DEFAULTREASONCODE,3)
           from inserted
             inner join dbo.CONSTITUENT on inserted.ID = CONSTITUENT.ID
             left join dbo.GENDERCODEDEFAULTMAPPING on inserted.GENDERCODEID = GENDERCODEDEFAULTMAPPING.GENDERCODEID
             where inserted.GENDERCODEID is not null and CONSTITUENT.ISORGANIZATION=0 and CONSTITUENT.ISGROUP=0
         end