| Previous: task_alert_recipient | Unanet Data Model | Next: task_budget_history |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | task_assignment_key | decimal(15) | ((0)) | ||
| 2. | project_key | decimal(15) | project | fk_task_assignment2 | ||
| 3. | person_key | decimal(15) | person | fk_task_assignment1 | ||
| 4. | task_key | decimal(15) | task | fk_task_assignment6 | ||
| 5. | begin_date | datetime | ('01/01/1900') | |||
| 6. | end_date | datetime | ('12/31/2099') | |||
| 7. | budget_hours | decimal(15,2) | ||||
| 8. | etc_hours | decimal(15,2) | ||||
| 9. | exceed_budget | char(1) | ('N') | |||
| 10. | labor_category_key | decimal(15) | labor_category | fk_task_assignment5 | ||
| 11. | cost_struct_labor_key | decimal(15) | cost_struct_labor | fk_task_assignment7 | ||
| 12. | bill_rate | decimal(15,5) | ||||
| 13. | cost_rate | decimal(15,5) | ||||
| 14. | bill_rate_source | char(1) | ('P') | |||
| 15. | cost_rate_source | char(1) | ('P') | |||
| 16. | bill_customer | decimal(15) | customer | fk_task_assignment3 | ||
| 17. | cost_customer | decimal(15) | customer | fk_task_assignment4 | ||
| 18. | use_wbs_dates | char(1) | ('N') | |||
| 19. | location_key | decimal(15) | location | fk_task_assignment8 | ||
| 20. | user01 | varchar(128) | ||||
| 21. | user02 | varchar(128) | ||||
| 22. | user03 | varchar(128) | ||||
| 23. | user04 | varchar(128) | ||||
| 24. | user05 | varchar(128) | ||||
| 25. | est_date_of_completion | datetime | ||||
| 26. | last_etc_update_date | datetime | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| cost_struct_labor_key | cost_struct_labor | cost_struct_labor_key | fk_task_assignment7 |
| bill_customer | customer | customer_key | fk_task_assignment3 |
| cost_customer | customer | customer_key | fk_task_assignment4 |
| labor_category_key | labor_category | labor_category_key | fk_task_assignment5 |
| location_key | location | location_key | fk_task_assignment8 |
| person_key | person | person_key | fk_task_assignment1 |
| project_key | project | project_key | fk_task_assignment2 |
| task_key | task | task_key | fk_task_assignment6 |
| Name | Definition |
| cc_ta_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_ta_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_ta_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_ta_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| cc_ta_est_date_of_completion | ([est_date_of_completion]>='1900-01-01' AND [est_date_of_completion]<='2099-12-31') |
| cc_ta_last_etc_update_date | ([last_etc_update_date]>='1900-01-01' AND [last_etc_update_date]<='2099-12-31') |
| cc_task_exceed_budget | ([exceed_budget]='N' OR [exceed_budget]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_task_assignment | true | task_assignment_key | Asc |
| idx_task_assignment2 | true | person_key | Asc |
| project_key | |||
| task_key | |||
| begin_date | |||
| idx_task_assignment1 | false | person_key | Asc |
| idx_task_assignment3 | false | begin_date | Asc |
| idx_task_assignment4 | false | project_key | Asc |
| idx_task_assignment5 | false | task_key | Asc |
| View Name |
| assignment_view |