Search Results per_all_assignments_f
The PER_ALL_ASSIGNMENTS_F
table is a fundamental component of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically within the Human Capital Management (HCM) module. It serves as the primary repository for employee assignment data, capturing detailed information about an employee's job, position, organization, and other assignment-related attributes. This table is part of the Oracle HRMS (Human Resource Management System) and is crucial for managing workforce data, including current, historical, and future assignments.
### **Structure and Key Columns**
The PER_ALL_ASSIGNMENTS_F
table is designed with a date-effective structure, meaning it tracks changes over time using EFFECTIVE_START_DATE
and EFFECTIVE_END_DATE
columns. This allows organizations to maintain a historical record of assignments. Key columns include:
- ASSIGNMENT_ID
: A unique identifier for each assignment record.
- PERSON_ID
: Links to the employee in PER_ALL_PEOPLE_F
.
- ASSIGNMENT_TYPE
: Indicates whether the assignment is for an employee ('E'
), applicant ('A'
), or contingent worker ('C'
).
- ORGANIZATION_ID
: References the organization in HR_ALL_ORGANIZATION_UNITS
.
- JOB_ID
: Links to the job definition in PER_JOBS
.
- POSITION_ID
: Associates the assignment with a position in HR_ALL_POSITIONS_F
.
- PRIMARY_FLAG
: Indicates whether the assignment is the employee's primary role ('Y'
or 'N'
).
- ASSIGNMENT_STATUS_TYPE_ID
: Defines the status (e.g., active, terminated) via PER_ASSIGNMENT_STATUS_TYPES
.
### **Functional Significance**
The table plays a pivotal role in Oracle EBS HCM by:
1. **Workforce Management**: Tracks employee assignments, including job changes, promotions, and department transfers.
2. **Payroll Processing**: Provides critical data for payroll calculations, such as salary basis, grade, and location.
3. **Reporting & Analytics**: Supports HR reporting on headcount, turnover, and organizational hierarchy.
4. **Integration**: Feeds data to other modules like Payroll (PAY_ALL_PAYROLLS_F
), Benefits (BEN_ASSIGNMENT_F
), and Time & Labor.
### **Technical Considerations**
- **Date-Effectiveness**: Queries must account for EFFECTIVE_START_DATE
and EFFECTIVE_END_DATE
to retrieve accurate data for a given period.
- **Indexing**: Commonly indexed columns include PERSON_ID
, ASSIGNMENT_ID
, and PRIMARY_FLAG
for performance optimization.
- **Foreign Keys**: Relationships with tables like PER_ALL_PEOPLE_F
, HR_ALL_ORGANIZATION_UNITS
, and PER_JOBS
ensure referential integrity.
### **Common Use Cases**
1. **Employee Assignment History**: Retrieving an employee's job changes over time.
2. **Headcount Analysis**: Counting active employees by organization or job.
3. **Termination Processing**: Updating ASSIGNMENT_STATUS_TYPE_ID
when an employee leaves.
### **Example Query**
```sql
SELECT
p.full_name,
a.assignment_number,
o.name AS organization,
j.name AS job
FROM
per_all_assignments_f a
JOIN
per_all_people_f p ON a.person_id = p.person_id
JOIN
hr_all_organization_units o ON a.organization_id = o.organization_id
JOIN
per_jobs j ON a.job_id = j.job_id
WHERE
SYSDATE BETWEEN a.effective_start_date AND a.effective_end_date
AND a.primary_flag = 'Y';
```
### **Conclusion**
The PER_ALL_ASSIGNMENTS_F
table is a cornerstone of Oracle EBS HCM, enabling comprehensive workforce management. Its date-effective design, extensive relationships, and critical role in HR processes make it indispensable for organizations leveraging Oracle EBS 12.1.1 or 12.2.2. Proper understanding and utilization of this table are essential for HR analytics, payroll, and integration with other modules.
-
Table: PER_ALL_ASSIGNMENTS_F
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_ALL_ASSIGNMENTS_F, object_name:PER_ALL_ASSIGNMENTS_F, status:VALID, product: PER - Human Resources , description: Employee and applicant assignment details. , implementation_dba_data: HR.PER_ALL_ASSIGNMENTS_F ,
-
Table: PER_ALL_ASSIGNMENTS_F
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_ALL_ASSIGNMENTS_F, object_name:PER_ALL_ASSIGNMENTS_F, status:VALID, product: PER - Human Resources , description: Employee and applicant assignment details. , implementation_dba_data: HR.PER_ALL_ASSIGNMENTS_F ,
-
APPS.BEN_EXT_PERSON dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_BATCH_LINK_PROCESS_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_US_ITERATIVE_VALUES dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.HXT_TIM_COL_UTIL dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.IRC_APS_BUS dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PER_DIF_STMT_REPORT dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PQH_GL_POSTING dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.HR_HEAD_COUNT_SUMMARY dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.HR_GENERAL2 dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PER_NEW_HIRE_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.AME_SUPERVISORY_HANDLER dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PER_PJU_BUS dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PQP_ALIEN_EXPAT_WF_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.HR_CONTINGENT_WORKER_API dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.HXT_UTIL dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_PAYACT_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.HXC_PREFERENCE_EVALUATION dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_KW_SOE dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_CC_PROCESS_UTILS dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PER_CA_EMP_EQUITY_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAYUSUNB_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_HR_OTC_RETRIEVAL_INTERFACE dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.HR_AU_ROUTES dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_JP_PAYSLIP_ARCHIVE dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PER_GB_TAX_BEN_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_SA_GENERAL dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PJI_PMV_ENGINE dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_NL_BAL_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.BEN_BENBATCH_PERSONS dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_PURGE_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_ZA_UIF_REFUND_MARCH_2008 dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_CALC_HOURS_WORKED dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.BEN_TCS_COMPENSATION dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.BEN_CWB_SINGLE_PER_PROCESS_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.BEN_EXT_ENRT dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PER_PERRPFP3_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PER_DISPLAY_ACCRUAL_BALANCE dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_EVENTS_WRAPPER dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.HR_PTO_VIEWS dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PQH_PQIPED5_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PQP_FTE_UTILITIES dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_PSD_BUS dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_NL_CBS_FILE dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_ES_CALC_SS_EARNINGS dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PAY_DK_BAL_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1
-
APPS.PQP_PERASGADD_RIW dependencies on PER_ALL_ASSIGNMENTS_F
12.1.1