Search Results per_all_people_f




Here's a detailed description of the PER_ALL_PEOPLE_F table in Oracle E-Business Suite (EBS) Human Resources module:

Table Name: PER_ALL_PEOPLE_F (People Foundation Table)

Purpose:
- Stores core personal information for all individuals in the system
- Tracks employee, contingent worker, applicant, and other person records
- Supports multiple effective-dated records

Key Columns:
1. PERSON_ID (Primary Key)
- Unique identifier for each individual
- Used across multiple HR and other EBS modules

2. EFFECTIVE_START_DATE
- Beginning of the effective period for the record
- Allows tracking historical changes

3. EFFECTIVE_END_DATE
- End of the effective period for the record
- Supports historical and future-dated information

Typical Columns Include:
- FIRST_NAME
- LAST_NAME
- MIDDLE_NAME
- FULL_NAME
- DATE_OF_BIRTH
- GENDER
- MARITAL_STATUS
- NATIONAL_IDENTIFIER (SSN/National ID)
- EMAIL_ADDRESS
- BUSINESS_GROUP_ID
- LEGISLATIVE_DATA_GROUP_ID

Key Characteristics:
- Flexible: Supports multiple record types
- Effective-Dated: Tracks changes over time
- Widely used across Oracle E-Business Suite modules

Typical Joins:
- PER_ASSIGNMENTS_F
- HR_ALL_ORGANIZATION_UNITS
- PER_PEOPLE_EXTRA_INFO