Used to describe someone who is a worthless human being, much like an actual pile of piss that has no value.