I'm trying to figure out where the salvage data for Lead Pipe is kept. I've been looking through so many records but I'm no closer to figuring this out. I want to change it from 'Steel' to 'Lead'. Anyone know where to find it?

Assuming you mean co_mod_melee_LeadPipe_ExtraHeavyHead [COBJ:00187818], it's under Constructable Object. The available materials (i.e. Lead) are under Components.

http://www.nexusmods.com/fallout4/mods/2524/?

Since I'm pretty sure that's what you're trying to do ^^

P.S. Weapons saluaging is a bit trickier than common misc items.