Skip to main content
OracleOps AI
← All tables
Oracle Fusion/HCM/Global HR

PER_PERSON_NAMES_F

Person names — date-effective, one row per name type (GLOBAL, LEGAL, etc.).

Key Columns

PERSON_NAME_IDPERSON_IDNAME_TYPEFIRST_NAMELAST_NAMEEFFECTIVE_START_DATE

Parent Table

PER_ALL_PEOPLE_F

Person records — one date-effective row set per person, holding person number and identifiers.

Used In

Global HR

Notes

NAME_TYPE = 'GLOBAL' is the display name used across HCM.

Related

Fusion HCM person and employment data model

A worker is a person (PER_ALL_PEOPLE_F) with names (PER_PERSON_NAMES_F), one or more work relationships (PER_PERIODS_OF_SERVICE) and assignments (PER_ALL_ASSIGNMENTS_M) that carry job, grade, position, department and manager. Most rows are date-effective and need a TRUNC(SYSDATE) BETWEEN filter.

Ask Oracle AI about PER_PERSON_NAMES_F