Table: person_time_data

Columns
  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))    
Foreign Keys
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
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
task_key task task_key fk_person_time_data5
Referenced from
Table Column Foreign Key Name
cost_plus_post_detail time_data_key fk_cost_plus_post_detail2
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
Check Constraints
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')
Indices
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_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  
Dependent Views
View Name
journal_view