Table: project

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK project_key decimal(15)      
2.   customer_key decimal(15)   customer fk_project1
3.   owning_customer_key decimal(15)   customer fk_project6
4.   project_code varchar(30)      
5.   account_number varchar(128)      
6.   title varchar(2000)      
7.   purpose varchar(2000)      
8.   manager_approval char(1)      
9.   expense_manager_approval char(1)      
10.   pay_code_key decimal(15)   pay_code fk_project5
11.   project_type_key decimal(15)   project_type fk_project3
12.   project_status_key decimal(15)   project_status fk_project4
13.   billing_type_key decimal(15)   billing_type fk_project7
14.   posting_group_key decimal(15)   posting_group fk_project11
15.   cost_struct_key decimal(15)   cost_struct fk_project8
16.   orig_start_date datetime      
17.   orig_end_date datetime      
18.   rev_start_date datetime      
19.   rev_end_date datetime      
20.   completed_date datetime      
21.   total_value decimal(15,2)      
22.   funded_value decimal(15,2)      
23.   hours_budget decimal(15,2)      
24.   hours_etc decimal(15,2)      
25.   hours_est_tot decimal(15,2)      
26.   exp_bill_budget decimal(15,2)      
27.   exp_cost_budget decimal(15,2)      
28.   exp_cost_burden_budget decimal(15,2)      
29.   exp_bill_etc decimal(15,2)      
30.   exp_cost_etc decimal(15,2)      
31.   exp_bill_est_tot decimal(15,2)      
32.   exp_cost_est_tot decimal(15,2)      
33.   labor_bill_budget decimal(15,2)      
34.   labor_cost_budget decimal(15,2)      
35.   labor_cost_burden_budget decimal(15,2)      
36.   labor_bill_etc decimal(15,2)      
37.   labor_cost_etc decimal(15,2)      
38.   labor_bill_est_tot decimal(15,2)      
39.   labor_cost_est_tot decimal(15,2)      
40.   assignment_flag char(1)      
41.   expense_assignment_flag char(1)      
42.   time_assignment_flag char(1) ('Y')    
43.   task_level_assignment char(1) ('N')    
44.   allow_self_plan char(1) ('C')    
45.   self_assign_plans char(1) ('N')    
46.   er_task_required char(1)      
47.   ts_task_required char(1)      
48.   future_charge char(1)      
49.   tito_required char(1) ('N')    
50.   created datetime      
51.   probability_percent decimal(3) ((100))    
52.   percent_complete decimal(6,3)      
53.   bill_rate_source char(1) ('P')    
54.   cost_rate_source char(1) ('P')    
55.   use_labor_category char(1) ('O')    
56.   enforce_wbs_dates char(1) ('N')    
57.   leave_balance char(1) ('N')    
58.   customer_approves_first char(1) ('N')    
59.   customer_time_approval char(1) ('N')    
60.   customer_expense_approval char(1) ('N')    
61.   pct_complete_rule char(1) ('H')    
62.   project_color varchar(16) ('green')    
63.   viewer_open char(1) ('Y')    
64.   pm_open char(1) ('Y')    
65.   rm_open char(1) ('Y')    
66.   resource_requestor_open char(1) ('Y')    
67.   resource_assigner_open char(1) ('Y')    
68.   billing_manager_open char(1) ('Y')    
69.   billing_viewer_open char(1) ('Y')    
70.   proj_require_time_comments char(1)      
71.   location_required char(1) ('N')    
72.   location_key decimal(15)   location fk_project10
73.   limit_bill_to_funded char(1) ('N')    
74.   limit_rev_to_funded char(1) ('N')    
75.   user01 varchar(128)      
76.   user02 varchar(128)      
77.   user03 varchar(128)      
78.   user04 varchar(128)      
79.   user05 varchar(128)      
80.   user06 varchar(128)      
81.   user07 varchar(128)      
82.   user08 varchar(128)      
83.   user09 varchar(128)      
84.   user10 varchar(128)      
Foreign Keys
Column References Foreign Key Name
Table Column
billing_type_key billing_type billing_type_key fk_project7
cost_struct_key cost_struct cost_struct_key fk_project8
customer_key customer customer_key fk_project1
owning_customer_key customer customer_key fk_project6
location_key location location_key fk_project10
pay_code_key pay_code pay_code_key fk_project5
posting_group_key posting_group posting_group_key fk_project11
project_status_key project_status project_status_key fk_project4
project_type_key project_type project_type_key fk_project3
Referenced from
Table Column Foreign Key Name
approval_history project_key fk_approval_history3
assignment_display project_key fk_assignment_display1
cost_plus_post_detail project_key fk_cost_plus_post_detail1
customer_assignment project_key fk_customer_assignment2
exp_cust_approval_status project_key fk_exp_cust_approval_status2
expense_data_allocation project_key fk_expense_data_allocation2
expense_history project_key fk_expense_history4
expense_plan project_key fk_expense_plan1
expense_pm_approval_status project_key fk_expense_pm_approval_status2
expense_project_allocation project_key fk_expense_project_allocation2
expense_project_budget project_key fk_expense_project_budget1
expense_task_budget project_key fk_expense_task_budget1
fee_cap_adjustment project_key fk_fee_cap_adjustment1
fin_document_detail_project project_key fk_fin_doc_detail_project1
fixed_price project_key fk_fixed_price1
funding_cap_adjustment project_key fk_funding_cap_adjustment1
general_ledger project_key fk_general_ledger4
holiday project_key fk_holiday1
invcd_project project_key fk_invcd_project2
invoice project_key fk_invoice1
journal_cost_plus_detail project_key fk_journal_cost_plus_detail3
journal_document_expense project_key fk_journal_document_expense3
journal_expense project_key fk_journal_expense3
journal_fee_cap_adjustment project_key fk_journal_fee_cap_adjust3
journal_fixed_price project_key fk_journal_fixed_price3
journal_funding_cap_adjustment project_key fk_journal_funding_cap_adj3
journal_onetime_charge project_key fk_journal_onetime_charge3
journal_prebilled_labor project_key fk_journal_prebilled_labor3
journal_time project_key fk_journal_time3
labor_category_assignment project_key fk_labor_category_assignment2
manager_approval_status project_key fk_manager_approval_status2
onetime_charge project_key fk_onetime_charge1
person project_key fk_person7
person_accrual project_key fk_person_accrual3
person_accrual_plan project_key fk_person_accrual_plan3
person_time_data project_key fk_person_time_data3
person_time_data_history project_key fk_person_time_data_history3
plan_set project_key fk_plan_set2
planned_time project_key fk_planned_time2
prebilled_labor project_key fk_prebilled_labor1
project_account project_key fk_project_account2
project_alert project_key fk_project_alert1
project_alert_prefs project_key fk_project_alert_prefs1
project_assignment project_key fk_project_assignment2
project_budget_history project_key fk_project_budget_history2
project_budget_snapshot project_key fk_project_budget_snapshot1
project_controller project_key fk_project_controller1
project_criteria_set project_key fk_project_criteria_set2
project_expense_type project_key fk_project_expense_type1
project_fee project_key fk_project_fee1
project_invoice project_key fk_project_invoice1
project_invoice_addl_fmt project_key fk_project_invoice_addl_fmt1
project_invoice_contributor contr_project_key fk_project_invoice_contr2
project_invoice_contributor lead_project_key fk_project_invoice_contr1
project_location project_key fk_project_location1
project_note project_key fk_project_note1
project_pay_code project_key fk_project_pay_code1
project_post_history project_key fk_project_post_history1
resource_request project_key fk_resource_request3
task project_key fk_task2
task_alert project_key fk_task_alert1
task_assignment project_key fk_task_assignment2
task_budget_history project_key fk_task_budget_history2
task_budget_snapshot project_key fk_task_budget_snapshot1
time_cust_approval_status project_key fk_time_cust_approval_status2
Check Constraints
Name Definition
cc_enforce_wbs_dates ([enforce_wbs_dates]='N' OR [enforce_wbs_dates]='Y')
cc_leave_balance ([leave_balance]='N' OR [leave_balance]='Y')
cc_limit_bill_to_funded ([limit_bill_to_funded]='N' OR [limit_bill_to_funded]='Y')
cc_limit_rev_to_funded ([limit_rev_to_funded]='N' OR [limit_rev_to_funded]='Y')
cc_pjt_assignment_flag ([assignment_flag]='N' OR [assignment_flag]='Y')
cc_pjt_bill_rate_source ([bill_rate_source]='L' OR [bill_rate_source]='P')
cc_pjt_bm_open ([billing_manager_open]='N' OR [billing_manager_open]='Y')
cc_pjt_bv_open ([billing_viewer_open]='N' OR [billing_viewer_open]='Y')
cc_pjt_cost_rate_source ([cost_rate_source]='L' OR [cost_rate_source]='P')
cc_pjt_cust_appr_first ([customer_approves_first]='N' OR [customer_approves_first]='Y')
cc_pjt_cust_exp_appr ([customer_expense_approval]='N' OR [customer_expense_approval]='Y')
cc_pjt_cust_time_appr ([customer_time_approval]='N' OR [customer_time_approval]='Y')
cc_pjt_expense_pm_approval ([expense_manager_approval]='N' OR [expense_manager_approval]='Y')
cc_pjt_loc_reqd ([location_required]='N' OR [location_required]='Y')
cc_pjt_manager_approval ([manager_approval]='N' OR [manager_approval]='Y')
cc_pjt_pct_complete_rule ([pct_complete_rule]='T' OR [pct_complete_rule]='L' OR [pct_complete_rule]='H')
cc_pjt_pm_open ([pm_open]='N' OR [pm_open]='Y')
cc_pjt_ra_open ([resource_assigner_open]='N' OR [resource_assigner_open]='Y')
cc_pjt_rm_open ([rm_open]='N' OR [rm_open]='Y')
cc_pjt_rr_open ([resource_requestor_open]='N' OR [resource_requestor_open]='Y')
cc_pjt_time_assignment_flag ([time_assignment_flag]='N' OR [time_assignment_flag]='Y')
cc_pjt_use_labor_category ([use_labor_category]='O' OR [use_labor_category]='N' OR [use_labor_category]='Y')
cc_pjt_viewer_open ([viewer_open]='N' OR [viewer_open]='Y')
cc_prj_er_task_required (([er_task_required]='N' OR [er_task_required]='Y') AND [er_task_required] IS NOT NULL)
cc_prj_ts_task_required (([ts_task_required]='N' OR [ts_task_required]='Y') AND [ts_task_required] IS NOT NULL)
cc_project_color ([project_color]='red' OR [project_color]='yellow' OR [project_color]='green')
cc_project_completed_date ([completed_date]>='1900-01-01' AND [completed_date]<='2099-12-31')
cc_project_orig_end_date ([orig_end_date]>='1900-01-01' AND [orig_end_date]<='2099-12-31')
cc_project_orig_start_date ([orig_start_date]>='1900-01-01' AND [orig_start_date]<='2099-12-31')
cc_project_rev_end_date ([rev_end_date]>='1900-01-01' AND [rev_end_date]<='2099-12-31')
cc_project_rev_start_date ([rev_start_date]>='1900-01-01' AND [rev_start_date]<='2099-12-31')
cc_project_task_level ([task_level_assignment]='Y' AND [er_task_required]='Y' AND [ts_task_required]='Y' OR [task_level_assignment]='N')
cc_project_tito_required ([tito_required]='U' OR [tito_required]='Y' OR [tito_required]='N')
cc_self_plan ([allow_self_plan]='O' OR [allow_self_plan]='C' OR [allow_self_plan]='A')
Indices
Index Name Unique Column Name Asc Or Desc
pk_project true project_key Asc
idx_project1 true customer_key Asc
    project_code  
idx_project2 false project_status_key Asc
idx_project3 false assignment_flag Asc
Dependent Views
View Name
assignment_view
expense_budget_view
journal_view