Table: person_rate

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK person_rate_key decimal(15)      
2.   person_key decimal(15)   person fk_person_rate1
3.   cost_struct_labor_key decimal(15)   cost_struct_labor fk_person_rate3
4.   bill_rate decimal(15,5)      
5.   cost_rate decimal(15,5)      
6.   exempt_status char(1)      
7.   begin_date datetime      
8.   end_date datetime      
Foreign Keys
Column References Foreign Key Name
Table Column
cost_struct_labor_key cost_struct_labor cost_struct_labor_key fk_person_rate3
person_key person person_key fk_person_rate1
Check Constraints
Name Definition
cc_person_exempt_status ([exempt_status]='X' OR [exempt_status]='N' OR [exempt_status]='E')
cc_person_rate_begin_date ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_person_rate_end_date ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_person_rate true person_rate_key Asc
idx_person_rate1 true person_key Asc
    begin_date  
idx_person_rate2 false cost_struct_labor_key Asc
Dependent Views
View Name
assignment_view