PERSON_TIME |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| person_time_key | decimal (15,0) | |||
| time_period_key | decimal (15,0) | TIME_PERIOD | fk_person_time4 | |
| begin_date | datetime | TIME_PERIOD | fk_person_time4 | |
| person_key | decimal (15,0) | PERSON | fk_person_time2 | |
| control_key | decimal (15,0) | YES | PERSON | fk_person_time1 |
| date_completed | datetime | YES | ||
| time_key | decimal (15,0) | YES | PERSON_TIME | fk_person_time3 |
| status | varchar (25) | |||
| partial_flag | varchar (1) | |||
| comments | text | YES | ||
References made to PERSON_TIME |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| APPROVAL_HISTORY | person_time_key | fk_approval_history1 |
| MANAGER_APPROVAL_STATUS | person_time_key | fk_manager_approval_status1 |
| PERSON_TIME | time_key | fk_person_time3 |
| PERSON_TIME_DATA | person_time_key | fk_person_time_data2 |
| PERSON_TIME_DATA_HISTORY | person_time_key | fk_person_time_data_history2 |
| TIME_CUST_APPROVAL_STATUS | person_time_key | fk_time_cust_approval_status1 |
Dependent Views |
|
| View Name | |
|---|---|
| MARGIN_VIEW | |
| DETAIL_DATA_VIEW | |
| TIMESHEET_STATUS_VIEW | |
| TIME_DATA_VIEW | |
| TIMESHEET_DATA | |
| TIMESHEET_HOURS_VIEW | |
| TEST | |
| FINANCIAL_DATA_VIEW | |
Check Constraints for PERSON_TIME |
|
| Check Constraint Name | Definition |
|---|---|
| cc_pt_partial_flag | (partial_flag = 'R' or (partial_flag = 'L' or (partial_flag = 'F'))) |
| cc_pt_status | (status = 'LOCKED' or (status = 'EXTRACTED' or (status = 'COMPLETED' or (status = 'DISAPPROVED' or (status = 'APPROVING' or (status = 'SUBMITTED' or (status = 'INUSE'))))))) |
Indexes on PERSON_TIME |
|
| Index Name | Column(s) |
|---|---|
| idx_person_time1 | time_period_key, begin_date, person_key, time_key |
| idx_person_time2 | control_key |
| idx_person_time3 | status |
| pk_person_time | person_time_key |