2 Key Difference Between PER_ALL_ASSIGNMENTS_M And ...

Home » 2 Key Difference between PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F in HCM Cloud Fusion Apps Tech 2 Key Difference between PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F in HCM Cloud 6218 Views SaveSavedRemoved 0

PER_ALL_ASSIGNMENTS_M is the core base table used to store assignment records of employee.

• It stores two levels of the 3-Tier Model: Employment aka Placement Terms (Level 2) and Assignments (Level 3).
• The assignment type is used to differentiate between these two levels
• Differentiate among employee, contingent worker, applicants, and benefits assignments.
• This is date-tracked and allows multiple changes in a day.
• Primary key of this table is ASSIGNMENT_ID

PER_ALL_ASSIGNMENTS_M is a TABLE

PER_ALL_ASSIGNMENTS_F is a view based on PER_ALL_ASSIGNMENTS_M table. This view only shows person assignments whose latest change is effective.

SELECT * FROM PER_ALL_ASSIGNMENTS_M paa WHERE EFFECTIVE_LATEST_CHANGE = 'Y'; So the answer to question, when to use PER_ALL_ASSIGNMENTS_M table is that if you want all the data use the base table. And, If you want the effective latest change only use PER_ALL_ASSIGNMENTS_F

If there are changes to employee assignment in a day you will see multiple records in the PER_ALL_ASSIGNMENTS_M table.

If there are no changes you will see the same data in PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_F table and view respectively.

per_all_assignments_m_ is another table which is the audit table. It stores the history of changes to assignment objects when auditing is enabled. (as a convention all table ending with _ are audit tables)

SQL query to fetch Employee in fusion hcm

The assignment table is joined to per_all_people_f the master table for employee records and org tables as per below sample query.

SELECT perf.person_number, hruf.name businessunit FROM hr_org_unit_classifications_f hrc, hr_all_organization_units_f hrall, hr_organization_units_f_tl hruf, per_all_assignments_m pasm, per_all_people_f perf WHERE hrall.organization_id = hrc.organization_id AND hrall.organization_id = hruf.organization_id AND hrall.effective_start_date BETWEEN hrc.effective_start_date AND hrc.effective_end_date AND hruf.language = 'US' AND hruf.effective_start_date = hrall.effective_start_date AND hruf.effective_end_date = hrall.effective_end_date AND SYSDATE BETWEEN hruf.effective_start_date AND hruf.effective_end_date AND hruf.organization_id = pasm.business_unit_id AND pasm.person_id = perf.person_id AND pasm.assignment_type = 'E' AND pasm.effective_latest_change = 'Y' AND SYSDATE BETWEEN pasm.effective_start_date AND pasm.effective_end_date AND perf.person_number = NVL (:personnumber, perf.person_number)

FAQs

What is difference between PER_ALL_ASSIGNMENTS_M and PER_ALL_ASSIGNMENTS_V table?

_M is a base Table while _F is a View

What to use PER_ALL_ASSIGNMENTS_F?

When you are looking for assignments with effective changes only.

Suggested reading HCM Cloud ATOM Feeds

References : Oracle doc on HCM Tables

SaveSavedRemoved 0 Previous

How to Customize Standard BI Publisher Report

Next

How To Download BI Publisher Desktop for Fusion SaaS

wpsadmin Related Articles Added to wishlistRemoved from wishlist 0

How to clear cache in Oracle Fusion Bi Publisher and Analytics

Added to wishlistRemoved from wishlist 0

How to Enable Business Event in Oracle Fusion

Added to wishlistRemoved from wishlist 0

DOO_HEADERS_ALL Table in Oracle Fusion and Linking objects

Added to wishlistRemoved from wishlist 0

PER_ALL_ASSIGNMENTS_M in Oracle Fusion HCM

Recent Posts

• 50+ Oracle Integration Cloud OIC Interview Questions
• How to clear cache in Oracle Fusion Bi Publisher and Analytics
• How to Enable Business Event in Oracle Fusion
• Date Comparison in OIC: Oracle
• DOO_HEADERS_ALL Table in Oracle Fusion and Linking objects

SUBSCRIBESubscribe to Our List!No spam ever, unsubscribe anytime

Thank you!

We will contact you soon.

About wpsbutton

wpsbutton is a Blog on Cloud Computing PaaS SaaS and Cloud Security. Focus of the blog is on Oracle Fusion SaaS, Oracle Integration Cloud , VBCS, PCS , Fusion Apps Tech and Ebusiness Suite.

Contact Us | Privacy Policy

Affiliate Disclosure: Some of the links may be affiliates links which may earn us a commission without any extra cost to you. As an Amazon Associate, we may earn from qualifying purchases.

Disclaimer

All the articles and views are of the author and do not necessarily be of Oracle or any other Cloud provider. All Logos and trademarks belong to respective owners. All articles are for educational purposes only.

Copyright © 2025 All Rights Reserved

Quick Links

Write Guest Posts

Advertise with Us

Categories

• Cloud and Information Security (10)
• Fusion Apps Tech (59)
• Interview Questions (17)
• Misc (1)
• Oracle EBS (26)
• Oracle Integration Cloud (34)
• Oracle VBCS (3)
• Process Cloud (3)
• router login (4)
• Technologies (15)
• Trainings (2)

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Refresh Powered By Click to Copy Log In Username Password Lost Password? Remember me Login

Compare items

• Total (0)

Compare 0

Shopping cart