TR_PDCOMPOSITESEGMENT_INS

                CREATE trigger [dbo].[TR_PDCOMPOSITESEGMENT_INS] on [dbo].[PDCOMPOSITESEGMENT]
                for insert
                as
                set nocount on
                declare @ChangeAgentID uniqueidentifier

                declare @CHANGEDATE datetime = getdate()

                select top 1 @ChangeAgentID = ADDEDBYID from inserted where ADDEDBYID is not null order by DATEADDED

                if exists(select * from inserted)
                    begin
                        -- Assume this is a custom composite segement, 

                        --  a trigger in PDCOMPOSITESEGMENTTABLELIST handles determining if it is builtin based on the segments used

                        insert into dbo.PDACCOUNTTABLESAVAILABLEFORSEGMENT(ID, TABLEID, TABLENAME, FRIENDLYTABLENAME, DESCRIPTIONCOLUMNNAME, ISCODETABLE, SEGMENTTYPECODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                            select ID, ID, NAME, NAME, NAME, 3, 2, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE from inserted             
                    end