what is relationship between per_people_f and per_all_assignments f?
I'm troubleshooting a problem with an employee record in HR. My question is specifically - should there be a corresponding record in per_people_f and per_assignments_f for each person_id?
The examples below are for an employee with one record in per_people_f and 3 records in per_all_assignments_f; and an employee who has the same number of records in both tables.
Is this normal or an anomoly? Thanks.
PER_PEOPLE_F | |||||||
PERSON_ID | EFFECTIVE_START_DATE | EFFECTIVE_END_DATE | BUSINESS_GROUP_ID | PERSON_TYPE_ID | START_DATE | CURRENT_EMPLOYEE_FLAG | |
1111 | 11/4/1985 | 12/31/4712 | 101 | 1120 (Employee) | 11/4/1985 | Y |