create view time_data_view (customer_key, customer_name, project_key, project_code,
manager_key, open_edit, task_key, task_name, task_number, project_type_key, project_type, billable, person_key,
last_name, first_name, user_name, quantity, bill_rate, cost_date, primary_key)
as
select c.customer_key,
c.customer_name,
pr.project_key,
pr.project_code,
pr.manager_key,
pr.open_edit,
ptd.task_key,
t.task_name,
t.task_number,
prt.project_type_key,
prt.project_type,
prt.billable,
p.person_key,
p.last_name,
p.first_name,
p.username,
ptd.quantity,
ptd.bill_rate,
ptd.work_date,
ptd.time_data_key
from person_time_data ptd,
project_type prt,
person_time pt,
person p,
task t,
project pr,
customer c
where prt.project_type_key = ptd.project_type_key
and pt.person_time_key = ptd.person_time_key
and p.person_key = pt.person_key
and t.task_key =* ptd.task_key
and pr.project_key = ptd.project_key
and c.customer_key= pr.customer_key
|