Table: time_period_setup

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	time_period_key	decimal(15)
2.		period_name	varchar(20)
3.		code	char(1)
4.		begin_date1	datetime
5.		begin_date2	datetime
6.		enabled	char(1)
7.		hours_in_period	decimal(17,4)
8.		allow_user_adjustments	char(1)	('N')
9.		description	varchar(100)
10.		max_future_period	decimal(15)
11.		cut_off_date	datetime	('12/31/2099')

Referenced from
Table	Column	Foreign Key Name
person	time_period_key	fk_person4
time_period	time_period_key	fk_time_period1

Check Constraints
Name	Definition
cc_tps_allow_user_adjustments	([allow_user_adjustments]='N' OR [allow_user_adjustments]='Y')
cc_tps_begin_date1	([begin_date1]>='1900-01-01' AND [begin_date1]<='2099-12-31')
cc_tps_begin_date2	([begin_date2]>='1900-01-01' AND [begin_date2]<='2099-12-31')
cc_tps_cut_off_date	([cut_off_date]>='1900-01-01' AND [cut_off_date]<='2099-12-31')
cc_tps_enabled	([enabled]='N' OR [enabled]='Y')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_time_period_setup	true	time_period_key	Asc
idx_time_period_setup1	true	period_name	Asc