Working With Rails

Hi I’m a newbie and need some help
Sorry this is so long,

i’m getting an error of uninitialized Constant Hierarchy::HierarchyBusinessFunctionTypeCostCenteAccount

I’m trying to achieve the equivalent of:-

select u.user_name, hbtcca.hierarchy_id, cost_centre_account_id from hierarchy_business_function_type_cost_centre_accounts hbtcca
inner join business_function_types bft on hbtcca.business_function_type_id = bft.id
inner join hierarchies h on hbtcca.hierarchy_id = h.id
inner join users u on h.controller = u.id
where bft.controlling_business_stream = 1 and u.id = 6

User table

user <

id integer,
user_name

User model

has_many :hierarchies_as_controller, :class_name => ‘Hierarchy’, :foreign_key => ‘controller’
has_many :hierarchies_as_reviewer, :class_name => ‘Hierarchy’, :foreign_key => ‘reviewer’
has_many :hierarchies_as_director, :class_name => ‘Hierarchy’, :foreign_key => ‘director’

Hierarchies table

id integer,
controller integer,
reviewer integer,
director integer

Hierarchies model

class Hierarchy < ActiveRecord::Base
belongs_to :reviewer, :class_name => ‘User’, :foreign_key => ‘reviewer’
belongs_to :director, :class_name => ‘User’, :foreign_key => ‘director’
belongs_to :controller, :class_name => ‘User’, :foreign_key => ‘controller’
has_many :hierarchy_business_function_type_cost_centre_accounts

Hierarchy_business_function_type_cost_centre_accounts (hbftcca) table

id,
business_function_type_id
cost_centre_account_id
hierarchy_id

hbftcca model

belongs_to :hierarchy
belongs_to :cost_centre_account
belongs_to :business_function_type

business_function_types table
id int,
business_function_type_description, string
controlling_business_function, boolean