stored procedures and triggers implemented for calculating source gang
name