Difference between per_all_assignments_f and per_all_assignments_m

It is quite common for people to use per_all_assignments_f and per_all_assignments_m while creating data models. However, very few are aware of the difference between them.

Both tables are date-effective. The key difference is that per_all_assignments_m can hold multiple transactions made on the same effective date, whereas per_all_assignments_f holds only the latest transaction for that particular date.

For example, if Employee A has two changes effective on 01-Apr-2025:

1. Manager Change

2. Job Change

In per_all_assignments_f, you will only find the Job Change (the latest record). In per_all_assignments_m, you will find both changes.