| Previous: proficiency | Unanet Data Model | Next: project_account |
| 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) | ||||
| 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 |
| 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 |
| 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') |
| 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 |
| View Name |
| assignment_view |
| expense_budget_view |
| journal_view |