Table: person_time_day

Previous: person_time_data_tito_history

Unanet Data Model

Next: person_time_day_tito

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	time_day_key	decimal(15)
2.		person_time_key	decimal(15)		person_time	fk_person_time_day1
3.		work_date	datetime
4.		adjusted_number	decimal(15)
5.		modified_person_key	decimal(15)
6.		post_date	datetime
7.		last_update	datetime
8.		pending_adjustment	char(1)	('N')
9.		adjusted_head	char(1)	('N')
10.		pending_head	char(1)	('N')
11.		adjustment_reason	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
person_time_key	person_time	person_time_key	fk_person_time_day1

Referenced from

Table	Column	Foreign Key Name
person_time_day_tito	time_day_key	fk_person_time_day_tito1

Check Constraints

Name	Definition
cc_adjusted_head	([adjusted_head]='Y' OR [adjusted_head]='N')
cc_pending_adjustment	([pending_adjustment]='Y' OR [pending_adjustment]='N')
cc_pending_head	([pending_head]='Y' OR [pending_head]='N')
cc_person_time_day_work_date	([work_date]>='1900-01-01' AND [work_date]<='2099-12-31')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_person_time_day	true	time_day_key	Asc
idx_person_time_day1	true	person_time_key	Asc
		work_date
		adjusted_number