There are two places in the warehouse that use a key from DIM_CAMPAIGNPRIORITY, in both places we are provided with a CAMPAIGNSUBPRIORITYSYSTEMID to do the lookup. There is not a way to associate a campaign priority to a transaction without using a campaign subpriority. Given this, the warehouse campaign priority dimension only contains values that can be used by the fact tables.