Table: leave_request

Previous: labor_invc_sect_fmt

Unanet Data Model

Next: leave_request_approval

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	leave_request_key	decimal(15)
2.		person_key	decimal(15)		person	fk_leave_request1
3.		begin_date	datetime
4.		end_date	datetime
5.		hours	decimal(15,2)
6.		non_work_days_ind	char(1)	('N')
7.		controller	decimal(15)
8.		status	varchar(25)
9.		status_timestamp	datetime
10.		comments	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
person_key	person	person_key	fk_leave_request1

Referenced from

Table	Column	Foreign Key Name
leave_request_approval	leave_request_key	fk_leave_request_approval1

Check Constraints

Name	Definition
cc_leave_request_begin_date	([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31')
cc_leave_request_end_date	([end_date]>='1900-01-01' AND [end_date]<='2099-12-31')
cc_leave_request_status	([status]='LOCKED' OR [status]='CANCELED' OR [status]='APPROVING' OR [status]='DISAPPROVED' OR [status]='COMPLETED' OR [status]='SUBMITTED' OR [status]='INUSE')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_leave_request	true	leave_request_key	Asc
idx_leave_request1	false	person_key	Asc
		begin_date