TR_FACULTYSTATUSCODE_INSERT_BBNCCODETABLEIDMAP

create trigger TR_FACULTYSTATUSCODE_INSERT_BBNCCODETABLEIDMAP on dbo.FACULTYSTATUSCODE after insert not for replication as begin insert into dbo.BBNCCODETABLEIDMAP (CODETABLECATALOGID, TABLEENTRYID) select '42c86aee-74ec-40ec-bc65-0755599ac072', ID from inserted end