| Previous: person_time | Unanet Data Model | Next: person_time_data_history |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | time_data_key | decimal(15) | |||
| 2. | person_time_key | decimal(15) | person_time | fk_person_time_data2 | ||
| 3. | project_key | decimal(15) | project | fk_person_time_data3 | ||
| 4. | task_key | decimal(15) | task | fk_person_time_data5 | ||
| 5. | work_date | datetime | ||||
| 6. | quantity | decimal(15,2) | ||||
| 7. | eff_quantity | decimal(25,12) | ||||
| 8. | bill_customer | decimal(15) | customer | fk_person_time_data6 | ||
| 9. | cost_customer | decimal(15) | customer | fk_person_time_data7 | ||
| 10. | pay_code_key | decimal(15) | pay_code | fk_person_time_data1 | ||
| 11. | bill_rate | decimal(15,5) | ||||
| 12. | cost_rate | decimal(15,5) | ||||
| 13. | eff_bill_rate | decimal(15,5) | ||||
| 14. | eff_cost_rate | decimal(15,5) | ||||
| 15. | project_type_key | decimal(15) | project_type | fk_person_time_data4 | ||
| 16. | modified_person_key | decimal(15) | ||||
| 17. | adjusted_number | decimal(15) | ||||
| 18. | pending_adjustment | char(1) | ('N') | |||
| 19. | adjusted_head | char(1) | ('Y') | |||
| 20. | pending_head | char(1) | ('Y') | |||
| 21. | post_date | datetime | ||||
| 22. | last_update | datetime | ||||
| 23. | batch_key | decimal(15) | ||||
| 24. | labor_category_key | decimal(15) | labor_category | fk_person_time_data8 | ||
| 25. | cost_struct_labor_key | decimal(15) | cost_struct_labor | fk_person_time_data9 | ||
| 26. | comments | varchar(2000) | ||||
| 27. | adjustment_reason | varchar(2000) | ||||
| 28. | location_key | decimal(15) | location | fk_person_time_data10 | ||
| 29. | post_history_key | decimal(15) | post_history | fk_person_time_data11 | ||
| 30. | invoice_key | decimal(15) | invoice | fk_person_time_data12 | ||
| 31. | cost_post_history_key | decimal(15) | post_history | fk_person_time_data13 | ||
| 32. | additional_pay | decimal(15,5) | ((0)) | |||
| 33. | vendor_invoice_key | decimal(15) | vendor_invoice | fk_person_time_data14 | ||
| 34. | po_key | decimal(15) | purchase_order | fk_person_time_data15 | ||
| 35. | po_labor_line_descriptor_key | decimal(15) | po_labor_line_descriptor | fk_person_time_data16 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| cost_struct_labor_key | cost_struct_labor | cost_struct_labor_key | fk_person_time_data9 |
| bill_customer | customer | customer_key | fk_person_time_data6 |
| cost_customer | customer | customer_key | fk_person_time_data7 |
| invoice_key | invoice | invoice_key | fk_person_time_data12 |
| labor_category_key | labor_category | labor_category_key | fk_person_time_data8 |
| location_key | location | location_key | fk_person_time_data10 |
| pay_code_key | pay_code | pay_code_key | fk_person_time_data1 |
| person_time_key | person_time | person_time_key | fk_person_time_data2 |
| po_labor_line_descriptor_key | po_labor_line_descriptor | po_labor_line_descriptor_key | fk_person_time_data16 |
| post_history_key | post_history | post_history_key | fk_person_time_data11 |
| cost_post_history_key | post_history | post_history_key | fk_person_time_data13 |
| project_key | project | project_key | fk_person_time_data3 |
| project_type_key | project_type | project_type_key | fk_person_time_data4 |
| po_key | purchase_order | po_key | fk_person_time_data15 |
| task_key | task | task_key | fk_person_time_data5 |
| vendor_invoice_key | vendor_invoice | fin_document_key | fk_person_time_data14 |
| Table | Column | Foreign Key Name |
| cost_plus_post_detail | time_data_key | fk_cost_plus_post_detail3 |
| invcd_time | time_data_key | fk_invcd_time2 |
| journal_time | time_data_key | fk_journal_time1 |
| person_time_data_history | time_data_key | fk_person_time_data_history6 |
| person_time_data_tito | time_data_key | fk_person_time_data_tito1 |
| vi_included_time | time_data_key | fk_vi_included_time2 |
| Name | Definition |
| cc_person_time_data_work_date | ([work_date]>='1900-01-01' AND [work_date]<='2099-12-31') |
| cc_ptd_adjusted_head | ([adjusted_head]='N' OR [adjusted_head]='Y') |
| cc_ptd_pending_adjustment | ([pending_adjustment]='N' OR [pending_adjustment]='Y') |
| cc_ptd_pending_head | ([pending_head]='N' OR [pending_head]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_person_time_data | true | time_data_key | Asc |
| idx_person_time_data1 | true | person_time_key | Asc |
| work_date | |||
| project_key | |||
| task_key | |||
| labor_category_key | |||
| location_key | |||
| project_type_key | |||
| pay_code_key | |||
| adjusted_number | |||
| idx_person_time_data10 | false | post_history_key | Asc |
| idx_person_time_data11 | false | cost_post_history_key | Asc |
| idx_person_time_data12 | false | project_type_key | Asc |
| idx_person_time_data13 | false | task_key | Asc |
| idx_person_time_data14 | false | vendor_invoice_key | Asc |
| idx_person_time_data15 | false | po_key | Asc |
| idx_person_time_data16 | false | po_labor_line_descriptor_key | Asc |
| idx_person_time_data2 | false | project_key | Asc |
| person_time_key | |||
| idx_person_time_data3 | false | batch_key | Asc |
| idx_person_time_data4 | false | adjusted_number | Asc |
| idx_person_time_data5 | false | work_date | Asc |
| idx_person_time_data6 | false | post_date | Asc |
| idx_person_time_data7 | false | labor_category_key | Asc |
| idx_person_time_data8 | false | invoice_key | Asc |
| idx_person_time_data9 | false | project_key | Asc |
| work_date |
| View Name |
| journal_view |
| vendor_payment_1099_view |