Table: purchase_requisition_approval

Previous: purchase_requisition

Unanet Data Model

Next: qrtz_blob_triggers

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	pr_approval_key	decimal(15)
2.		pr_key	decimal(15)		purchase_requisition	fk_pr_approval1
3.		performed_by	decimal(15)		person	fk_pr_approval2
4.		performed_for	decimal(15)		person	fk_pr_approval3
5.		project_key	decimal(15)		project	fk_pr_approval4
6.		role_key	decimal(15)		role	fk_pr_approval5
7.		status	varchar(25)
8.		status_timestamp	datetime
9.		comments	varchar(2000)
10.		review_required	char(1)	('N')
11.		review_timestamp	datetime
12.		review_comments	varchar(2000)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
performed_by	person	person_key	fk_pr_approval2
performed_for	person	person_key	fk_pr_approval3
project_key	project	project_key	fk_pr_approval4
pr_key	purchase_requisition	pr_key	fk_pr_approval1
role_key	role	role_key	fk_pr_approval5

Check Constraints

Name	Definition
cc_pra_review_required	([review_required]='N' OR [review_required]='Y')
cc_pra_review_ts	([review_timestamp]>='1900-01-01' AND [review_timestamp]<='2099-12-31')
cc_pra_status	([status]='CANCELED' OR [status]='CLOSED' OR [status]='OPEN' OR [status]='APPROVED' OR [status]='DISAPPROVED' OR [status]='APPROVING' OR [status]='SUBMITTED' OR [status]='INUSE')
cc_pra_status_ts	([status_timestamp]>='1900-01-01' AND [status_timestamp]<='2099-12-31')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_pr_approval	true	pr_approval_key	Asc