PERSON_TIME_DATA |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| time_data_key | decimal (15,0) | |||
| person_time_key | decimal (15,0) | PERSON_TIME | fk_person_time_data2 | |
| project_key | decimal (15,0) | PROJECT | fk_person_time_data3 | |
| task_key | decimal (15,0) | YES | TASK | fk_person_time_data5 |
| work_date | datetime | |||
| quantity | decimal (15,2) | |||
| bill_customer | decimal (15,0) | YES | CUSTOMER | fk_person_time_data6 |
| pay_code_key | decimal (15,0) | PAY_CODE | fk_person_time_data1 | |
| bill_rate | decimal (15,4) | YES | ||
| cost_rate | decimal (15,4) | YES | ||
| project_type_key | decimal (15,0) | PROJECT_TYPE | fk_person_time_data4 | |
| comments | text | YES | ||
| cost_customer | decimal (15,0) | YES | CUSTOMER | fk_person_time_data7 |
| modified_person_key | decimal (15,0) | YES | ||
| adjusted_number | decimal (15,0) | YES | ||
| post_date | datetime | YES | ||
| last_update | datetime | YES | ||
| batch_key | decimal (15,0) | YES | ||
References made to PERSON_TIME_DATA |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| PERSON_TIME_DATA_HISTORY | time_data_key | fk_person_time_data_history6 |
Dependent Views |
|
| View Name | |
|---|---|
| MARGIN_VIEW | |
| DETAIL_DATA_VIEW | |
| TIME_DATA_VIEW | |
| TIMESHEET_DATA | |
| TIMESHEET_HOURS_VIEW | |
| TEST | |
| FINANCIAL_DATA_VIEW | |
Indexes on PERSON_TIME_DATA |
|
| Index Name | Column(s) |
|---|---|
| idx_person_time_data_gwb1 | project_key, task_key |
| idx_person_time_data1 | person_time_key, work_date, project_key, task_key, project_type_key, pay_code_key, adjusted_number |
| idx_person_time_data2 | project_key, person_time_key |
| idx_person_time_data3 | batch_key |
| idx_person_time_data4 | adjusted_number |
| pk_person_time_data | time_data_key |