Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_F

Summary:

Foreign key relationship between HRC_SEM_EDUCATIONS and PER_ALL_PEOPLE_F

Content (please ensure you mask any confidential information):

I am extracting data from the HRC_SEM_EDUCATIONS table using a BIP report.

In most tables the PERSONID is an 18 digit number. However, it seems in some HR tables (table names prefixed as "HRC_") the field contains a 6 digit number instead of an 18 digit number.

For example in this query: SELECT * from HRC_SEM_EDUCATIONS;

PERSON_ID is a foreign key to HRC_SEM_PERSONS

but I don't see any foreign key relation between HRC_SEM_PERSONS and PER_ALL_PEOPLE_F. The PERSON_IDs are different.