Table: approval_history

Previous: approval_group_submitter

Unanet Data Model

Next: assignment_display

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	approval_history_key	decimal(15)
2.		person_time_key	decimal(15)		person_time	fk_approval_history1
3.		person_key	decimal(15)		person	fk_approval_history2
4.		alternate_for_key	decimal(15)		person	fk_approval_history6
5.		action_date	datetime
6.		project_key	decimal(15)		project	fk_approval_history3
7.		comments	varchar(2000)
8.		status	varchar(25)
9.		adjustment_status	varchar(25)
10.		pending_adjustment	char(1)	('N')
11.		role_key	decimal(15)		role	fk_approval_history5
12.		review_required	char(1)	('N')
13.		review_date	datetime
14.		review_comments	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
person_key	person	person_key	fk_approval_history2
alternate_for_key	person	person_key	fk_approval_history6
person_time_key	person_time	person_time_key	fk_approval_history1
project_key	project	project_key	fk_approval_history3
role_key	role	role_key	fk_approval_history5

Check Constraints

Name	Definition
cc_ah_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_ah_pending_adjustment	([pending_adjustment]='N' OR [pending_adjustment]='Y')
cc_ah_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_approval_history	true	approval_history_key	Asc
idx_approval_history1	false	person_time_key	Asc
idx_approval_history2	false	alternate_for_key	Asc
		role_key
idx_approval_history3	false	person_key	Asc
idx_approval_history4	false	project_key	Asc