| Previous: project_alert_recipient | Unanet Data Model | Next: project_budget_history |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | project_assignment_key | decimal(15) | ((0)) | ||
| 2. | project_key | decimal(15) | project | fk_project_assignment2 | ||
| 3. | person_key | decimal(15) | person | fk_project_assignment1 | ||
| 4. | begin_date | datetime | ('01/01/1900') | |||
| 5. | end_date | datetime | ('12/31/2099') | |||
| 6. | budget_hours | decimal(15,2) | ||||
| 7. | etc_hours | decimal(15,2) | ||||
| 8. | exceed_budget | char(1) | ('N') | |||
| 9. | bill_rate | decimal(15,5) | ||||
| 10. | cost_rate | decimal(15,5) | ||||
| 11. | bill_rate_source | char(1) | ('P') | |||
| 12. | cost_rate_source | char(1) | ('P') | |||
| 13. | bill_customer | decimal(15) | customer | fk_project_assignment3 | ||
| 14. | cost_customer | decimal(15) | customer | fk_project_assignment4 | ||
| 15. | labor_category_key | decimal(15) | labor_category | fk_project_assignment5 | ||
| 16. | cost_struct_labor_key | decimal(15) | cost_struct_labor | fk_project_assignment6 | ||
| 17. | use_wbs_dates | char(1) | ('N') | |||
| 18. | location_key | decimal(15) | location | fk_project_assignment7 | ||
| 19. | user01 | varchar(128) | ||||
| 20. | user02 | varchar(128) | ||||
| 21. | user03 | varchar(128) | ||||
| 22. | user04 | varchar(128) | ||||
| 23. | user05 | varchar(128) | ||||
| 24. | est_date_of_completion | datetime | ||||
| 25. | last_etc_update_date | datetime | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| cost_struct_labor_key | cost_struct_labor | cost_struct_labor_key | fk_project_assignment6 |
| bill_customer | customer | customer_key | fk_project_assignment3 |
| cost_customer | customer | customer_key | fk_project_assignment4 |
| labor_category_key | labor_category | labor_category_key | fk_project_assignment5 |
| location_key | location | location_key | fk_project_assignment7 |
| person_key | person | person_key | fk_project_assignment1 |
| project_key | project | project_key | fk_project_assignment2 |
| Name | Definition |
| cc_pa_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_pa_bill_rate | ([bill_rate] IS NOT NULL AND [bill_rate_source]='O' OR [bill_rate] IS NULL AND ([bill_rate_source]='L' OR [bill_rate_source]='P')) |
| cc_pa_cost_rate | ([cost_rate] IS NOT NULL AND [cost_rate_source]='O' OR [cost_rate] IS NULL AND ([cost_rate_source]='L' OR [cost_rate_source]='P')) |
| cc_pa_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| cc_pa_est_date_of_completion | ([est_date_of_completion]>='1900-01-01' AND [est_date_of_completion]<='2099-12-31') |
| cc_pa_last_etc_update_date | ([last_etc_update_date]>='1900-01-01' AND [last_etc_update_date]<='2099-12-31') |
| cc_project_exceed_budget | ([exceed_budget]='N' OR [exceed_budget]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_project_assignment | true | project_assignment_key | Asc |
| idx_project_assignment2 | true | person_key | Asc |
| project_key | |||
| begin_date | |||
| idx_project_assignment1 | false | person_key | Asc |
| idx_project_assignment3 | false | begin_date | Asc |
| idx_project_assignment4 | false | project_key | Asc |
| View Name |
| assignment_view |