Table: org_access_person

Previous: org_access_parent

Unanet Data Model

Next: org_cost_pool_tree

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	org_access_person_key	decimal(15)
2.		person_key	decimal(15)		person	fk_org_access_person1
3.		role_key	decimal(15)		role	fk_org_access_person2
4.		access_type	decimal(1)
5.		global_access	char(1)	('N')

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
person_key	person	person_key	fk_org_access_person1
role_key	role	role_key	fk_org_access_person2

Referenced from

Table	Column	Foreign Key Name
org_access_hierarchy	org_access_person_key	fk_org_access_hierarchy1
org_access_legal_entity	org_access_person_key	fk_org_access_legal_entity1
org_access_parent	org_access_person_key	fk_org_access_parent1

Check Constraints

Name	Definition
cc_access_type	([access_type]=(5) OR [access_type]=(4) OR [access_type]=(3) OR [access_type]=(2) OR [access_type]=(1) OR [access_type]=(0))
cc_global_access	([global_access]='N' OR [global_access]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_org_access_person	true	org_access_person_key	Asc
idx_org_access_person1	true	person_key	Asc
		role_key
		access_type