| Previous: person_rate | Unanet Data Model | Next: person_time_data |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | person_time_key | decimal(15) | |||
| 2. | time_period_key | decimal(15) | time_period | fk_person_time4 | ||
| 3. | begin_date | datetime | time_period | fk_person_time4 | ||
| 4. | person_key | decimal(15) | person | fk_person_time2 | ||
| 5. | control_key | decimal(15) | person | fk_person_time1 | ||
| 6. | date_completed | datetime | ||||
| 7. | status | varchar(25) | ||||
| 8. | adjustment_status | varchar(25) | ||||
| 9. | adjustment_date | datetime | ||||
| 10. | dilution_factor | decimal(15,12) | ((1)) | |||
| 11. | dilution_hours | decimal(17,4) | ||||
| 12. | dilution_calc_req | char(1) | ('N') | |||
| 13. | comments | varchar(2000) | ||||
| 14. | historical | char(1) | ('N') | |||
| 15. | dilution_bus_hours | decimal(17,4) | ||||
| 16. | dilution_bus_hours_factor | decimal(15,12) | ((1)) | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| control_key | person | person_key | fk_person_time1 |
| person_key | person | person_key | fk_person_time2 |
| time_period_key | time_period | time_period_key | fk_person_time4 |
| begin_date | begin_date | ||
| Table | Column | Foreign Key Name |
| approval_history | person_time_key | fk_approval_history1 |
| manager_approval_status | person_time_key | fk_manager_approval_status1 |
| person_time_data | person_time_key | fk_person_time_data2 |
| person_time_data_history | person_time_key | fk_person_time_data_history2 |
| person_time_day | person_time_key | fk_person_time_day1 |
| time_cust_approval_status | person_time_key | fk_time_cust_approval_status1 |
| Name | Definition |
| cc_historical | ([historical]='N' OR [historical]='Y') |
| cc_person_time_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_pt_adjustment_status | (([adjustment_status]='APPROVING' OR [adjustment_status]='DISAPPROVED' OR [adjustment_status]='COMPLETED' OR [adjustment_status]='SUBMITTED' OR [adjustment_status]='INUSE') AND ([status]='EXTRACTED' OR [status]='LOCKED') OR [adjustment_status] IS NULL) |
| cc_pt_status | ([status]='LOCKED' OR [status]='EXTRACTED' OR [status]='COMPLETED' OR [status]='DISAPPROVED' OR [status]='APPROVING' OR [status]='SUBMITTED' OR [status]='INUSE') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_person_time | true | person_time_key | Asc |
| idx_person_time1 | true | time_period_key | Asc |
| begin_date | |||
| person_key | |||
| idx_person_time2 | false | control_key | Asc |
| idx_person_time3 | false | status | Asc |
| idx_person_time4 | false | person_key | Asc |
| begin_date |
| View Name |
| journal_view |
| vendor_payment_1099_view |