Table: org_access_person

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]=(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