TR_PDCOMPOSITESEGMENT_INS (Trigger)

                        
                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