What is PER_ALL_PEOPLE_F in Oracle HCM?

PER_ALL_PEOPLE_F is the main table storing person records in Oracle HCM Cloud. It contains employee personal information including names, dates, and person types.

How do I find Oracle Fusion table columns?

Use HCM Tables search to instantly find columns across all Oracle Fusion tables. Search by column name like PERSON_ID or ASSIGNMENT_ID to see which tables contain that field.

What Oracle HCM tables are available?

Oracle HCM Cloud includes 35,000+ tables covering Core HR (PER_*), Payroll (PAY_*), Benefits (BEN_*), Talent Management, Recruiting, and more.

35,000+ Tables indexed

Oracle Cloud Tables

Instantly search Oracle Fusion Cloud schema documentation

HCM • Financials • SCM • CX Sales • Common Features

Try PER_ALL_PEOPLE_F or PERSON_ID

—

Tables

—

Views

—

Columns

—

Modules

Why use this instead of Oracle Docs?

Instant Search

Search across all tables and columns instantly. No navigating through nested dropdowns.

Column Search

Find which tables contain a specific column. Essential for building reports and integrations.

Cross-Module

Search across HCM, Financials, SCM, and more in one unified interface.

Fast & Clean

No bloated pages. Just the schema info you need, beautifully presented.

Popular Tables

PER_ALL_PEOPLE_F PER_ALL_ASSIGNMENTS_F PER_ADDRESSES_F HR_LOCATIONS_ALL PAY_PAYROLL_ACTIONS PAY_RUN_RESULTS_F HZ_PARTIES HZ_CUST_ACCOUNTS

Browse by Module

Join Path Finder

Enter two table names to find the JOIN columns between them.

↔

Results

☕

Find this useful?

This tool is free forever. If it saved you time, consider buying me a coffee.

Support This Project

Pay what you want • $1.50 minimum