Table: pr_pm_approval_status

Previous: pr_labor_line_descriptor

Unanet Data Model

Next: pr_summary_attachment_ref

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	pr_key	decimal(15)		purchase_requisition	fk_pr_pm_approval_status1
2.	PK	project_key	decimal(15)		project	fk_pr_pm_approval_status2
3.		pm_approves_before_mgr	char(1)
4.		approved	char(1)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
project_key	project	project_key	fk_pr_pm_approval_status2
pr_key	purchase_requisition	pr_key	fk_pr_pm_approval_status1

Check Constraints

Name	Definition
cc_prpas_approved	([approved]='N' OR [approved]='Y')
cc_prpas_pm_appr_before_mgr	([pm_approves_before_mgr]='N' OR [pm_approves_before_mgr]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_pr_pm_approval_status	true	pr_key	Asc
		project_key
idx_pr_pm_approval_status1	false	project_key	Asc