Table: task_budget_snapshot

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK task_budget_snapshot_key decimal(15)      
2.   project_key decimal(15)   project fk_task_budget_snapshot1
3.   task_key decimal(15)   task fk_task_budget_snapshot2
4.   eff_thru_date datetime      
5.   orig_start_date datetime      
6.   orig_end_date datetime      
7.   rev_start_date datetime      
8.   rev_end_date datetime      
9.   completed_date datetime      
10.   hours_budget decimal(15,2)      
11.   hours_etc decimal(15,2)      
12.   hours_est_tot decimal(15,2)      
13.   exp_bill_budget decimal(15,2)      
14.   exp_cost_budget decimal(15,2)      
15.   exp_cost_burden_budget decimal(15,2)      
16.   exp_bill_etc decimal(15,2)      
17.   exp_cost_etc decimal(15,2)      
18.   exp_bill_est_tot decimal(15,2)      
19.   exp_cost_est_tot decimal(15,2)      
20.   labor_bill_budget decimal(15,2)      
21.   labor_cost_budget decimal(15,2)      
22.   labor_cost_burden_budget decimal(15,2)      
23.   labor_bill_etc decimal(15,2)      
24.   labor_cost_etc decimal(15,2)      
25.   labor_bill_est_tot decimal(15,2)      
26.   labor_cost_est_tot decimal(15,2)      
27.   percent_complete decimal(6,3)      
Foreign Keys
Column References Foreign Key Name
Table Column
project_key project project_key fk_task_budget_snapshot1
task_key task task_key fk_task_budget_snapshot2
Check Constraints
Name Definition
cc_tbs_completed_date ([completed_date]>='1900-01-01' AND [completed_date]<='2099-12-31')
cc_tbs_eff_thru_date ([eff_thru_date]>='1900-01-01' AND [eff_thru_date]<='2099-12-31')
cc_tbs_orig_end_date ([orig_end_date]>='1900-01-01' AND [orig_end_date]<='2099-12-31')
cc_tbs_orig_start_date ([orig_start_date]>='1900-01-01' AND [orig_start_date]<='2099-12-31')
cc_tbs_rev_end_date ([rev_end_date]>='1900-01-01' AND [rev_end_date]<='2099-12-31')
cc_tbs_rev_start_date ([rev_start_date]>='1900-01-01' AND [rev_start_date]<='2099-12-31')
Indices
Index Name Unique Column Name Asc Or Desc
pk_task_budget_snapshot true task_budget_snapshot_key Asc
idx_task_budget_snapshot2 true project_key Asc
    task_key  
    eff_thru_date  
idx_task_budget_snapshot1 false project_key Asc
idx_task_budget_snapshot3 false task_key Asc