Table: person_time

Columns
  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))    
Foreign Keys
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  
Referenced from
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
Check Constraints
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')
Indices
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  
Dependent Views
View Name
journal_view