| Previous: person_time_data | Unanet Data Model | Next: person_time_data_tito |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | time_data_key | decimal(15) | person_time_data | fk_person_time_data_history6 | |
| 2. | PK | modified_date | datetime | |||
| 3. | person_time_key | decimal(15) | person_time | fk_person_time_data_history2 | ||
| 4. | project_key | decimal(15) | project | fk_person_time_data_history3 | ||
| 5. | task_key | decimal(15) | task | fk_person_time_data_history5 | ||
| 6. | work_date | datetime | ||||
| 7. | quantity | decimal(15,2) | ||||
| 8. | pay_code_key | decimal(15) | pay_code | fk_person_time_data_history1 | ||
| 9. | project_type_key | decimal(15) | project_type | fk_person_time_data_history4 | ||
| 10. | labor_category_key | decimal(15) | labor_category | fk_person_time_data_history7 | ||
| 11. | location_key | decimal(15) | location | fk_person_time_data_history8 | ||
| 12. | comments | varchar(2000) | ||||
| 13. | modified_comments | varchar(2000) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| labor_category_key | labor_category | labor_category_key | fk_person_time_data_history7 |
| location_key | location | location_key | fk_person_time_data_history8 |
| pay_code_key | pay_code | pay_code_key | fk_person_time_data_history1 |
| person_time_key | person_time | person_time_key | fk_person_time_data_history2 |
| time_data_key | person_time_data | time_data_key | fk_person_time_data_history6 |
| project_key | project | project_key | fk_person_time_data_history3 |
| project_type_key | project_type | project_type_key | fk_person_time_data_history4 |
| task_key | task | task_key | fk_person_time_data_history5 |
| Table | Column | Foreign Key Name |
| person_time_data_tito_history | time_data_key | fk_per_time_data_tito_history2 |
| modified_date |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_person_time_data_history | true | time_data_key | Asc |
| modified_date | |||
| idx_person_time_data_history1 | false | person_time_key | Asc |
| idx_person_time_data_history2 | false | project_key | Asc |
| idx_person_time_data_history3 | false | task_key | Asc |