RATES_VIEW |
||
| Column Name | Data Type | Nulls |
|---|---|---|
| project_key | decimal (15,0) | |
| person_key | decimal (15,0) | |
| project_code | varchar (30) | |
| project_customer_code | varchar (25) | |
| assigned_customer_code | varchar (25) | YES |
| person_bill_rate | decimal (15,2) | YES |
| person_cost_rate | decimal (15,2) | YES |
| project_bill_rate | decimal (15,4) | YES |
| project_cost_rate | decimal (15,4) | YES |
| person_code | varchar (5) | YES |
| last_name | varchar (50) | YES |
| middle_initial | varchar (1) | YES |
| first_name | varchar (50) | YES |
| suffix | varchar (10) | YES |
| active | varchar (1) | |
Tables Used |
| PROJECT_ASSIGNMENT |
| CUSTOMER |
| PERSON |
| PROJECT |
SQL*Server Create Statement: |
CREATE VIEW rates_view AS
select pjt.project_key,
p.person_key,
pjt.project_code,
c.customer_code as project_customer_code,
c2.customer_code as assigned_customer_code,
p.bill_rate as person_bill_rate,
p.cost_rate as person_cost_rate,
pa.bill_rate as project_bill_rate,
pa.cost_rate as project_cost_rate,
p.person_code,
p.last_name,
p.middle_initial,
p.first_name,
p.suffix,
p.active
from project pjt,
project_assignment pa,
person p,
customer c,
customer c2
where pjt.project_key = pa.project_key AND pa.person_key = p.person_key AND
pjt.customer_key = c.customer_key AND pa.bill_customer *= c2.customer_key
|