This is how to get product EAV attribute ID without querying the database directly:

<?php
$iAttributeID = Mage::getSingleton('eav/config')->getAttribute(Mage_Catalog_Model_Product::ENTITY, self::TARGET_ATTRIBUTE)->getId()