What is the difference between PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F

PER_ALL_ASSIGNMENTS_M is the core table for assignments. The definition of the PER_ALL_ASSIGNMENTS_F view is as below : SELECT * FROM PER_ALL_ASSIGNMENTS_M paa WHERE EFFECTIVE_LATEST_CHANGE = 'Y'; So if you want all the data use the base table : PER_ALL_ASSIGNMENTS_M If you want the effective latest change only, please use : PER_ALL_ASSIGNMENTS_F

https://paperlessdsc.e-mudhra.com/KycEnrolmentStatus.jsp?x=ZkUyVVVaWWRocGdJV1BiNlZkN1pEQT09

https://paperlessdsc.e-mudhra.com/KycEnrolmentStatus.jsp?x=cFVXOW52OUc4T05rQlFTS3RjUjNYdz09