| Previous: plan_set_name | Unanet Data Model | Next: post_history |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | planned_time_key | decimal(15) | |||
| 2. | person_key | decimal(15) | person | fk_planned_time1 | ||
| 3. | project_key | decimal(15) | project | fk_planned_time2 | ||
| 4. | task_key | decimal(15) | task | fk_planned_time3 | ||
| 5. | labor_category_key | decimal(15) | labor_category | fk_planned_time4 | ||
| 6. | cost_struct_labor_key | decimal(15) | cost_struct_labor | fk_planned_time5 | ||
| 7. | begin_date | datetime | ||||
| 8. | end_date | datetime | ||||
| 9. | planned_hours | decimal(15,2) | ||||
| 10. | bill_rate | decimal(15,5) | ||||
| 11. | cost_rate | decimal(15,5) | ||||
| 12. | bill_rate_source | char(1) | ('P') | |||
| 13. | cost_rate_source | char(1) | ('P') | |||
| 14. | block_out | char(1) | ('N') | |||
| 15. | use_wbs_dates | char(1) | ('N') | |||
| 16. | location_key | decimal(15) | location | fk_planned_time6 | ||
| 17. | resource_request_key | decimal(15) | resource_request | fk_planned_time7 | ||
| 18. | plan_set_key | decimal(15) | plan_set | fk_planned_time8 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| cost_struct_labor_key | cost_struct_labor | cost_struct_labor_key | fk_planned_time5 |
| labor_category_key | labor_category | labor_category_key | fk_planned_time4 |
| location_key | location | location_key | fk_planned_time6 |
| person_key | person | person_key | fk_planned_time1 |
| plan_set_key | plan_set | plan_set_key | fk_planned_time8 |
| project_key | project | project_key | fk_planned_time2 |
| resource_request_key | resource_request | resource_request_key | fk_planned_time7 |
| task_key | task | task_key | fk_planned_time3 |
| Name | Definition |
| cc_block_out | ([block_out]='N' OR [block_out]='Y') |
| cc_date_range | ([begin_date]<=[end_date]) |
| cc_planned_time_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_planned_time_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| cc_pt_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_pt_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')) |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_planned_time | true | planned_time_key | Asc |
| idx_planned_time1 | false | person_key | Asc |
| idx_planned_time2 | false | project_key | Asc |
| idx_planned_time3 | false | task_key | Asc |
| idx_planned_time4 | false | begin_date | Asc |
| end_date | |||
| idx_planned_time5 | false | person_key | Asc |
| begin_date | |||
| end_date | |||
| idx_planned_time6 | false | plan_set_key | Asc |
| idx_planned_time7 | false | person_key | Asc |
| project_key | |||
| plan_set_key | |||
| idx_planned_time8 | false | person_key | Asc |
| block_out | |||
| begin_date | |||
| end_date |