Search Results per_all_assignments_f
I'll provide a detailed description of the PER_ALL_ASSIGNMENTS_F table in Oracle E-Business Suite (EBS) Human Resources:
Table Name: PER_ALL_ASSIGNMENTS_F (Assignments Flexfield)
Purpose:
- Stores detailed employment assignment information for employees
- Tracks current and historical assignments across an organization
- Captures employee placement, job, position, and organizational details
Key Columns:
1. ASSIGNMENT_ID (Primary Key)
- Unique identifier for each assignment record
- Used for referencing specific employee assignments
2. PERSON_ID
- Links to the employee in PER_ALL_PEOPLE_F
- Identifies which person the assignment belongs to
3. EFFECTIVE_START_DATE
- Beginning date of assignment validity
- Used for tracking time-based assignment changes
4. EFFECTIVE_END_DATE
- End date of assignment validity
- Helps manage historical and current assignments
5. JOB_ID
- References specific job details
- Links to HR_JOBS table
6. POSITION_ID
- Identifies the specific organizational position
- Links to HR_POSITIONS table
7. ORGANIZATION_ID
- Indicates the organizational unit of assignment
- Links to HR_ORGANIZATION_UNITS table
8. ASSIGNMENT_STATUS_TYPE
- Current status of assignment (Active, Inactive, etc.)
9. EMPLOYMENT_CATEGORY
- Defines employment type (Full-time, Part-time, Contractor)
10. WORK_TERMS_ASSIGNMENT_ID
- Tracks specific work terms and conditions
Important Characteristics:
- Flexfield table (supports custom attributes)
- Date-tracked (tracks historical changes)
- Supports multiple concurrent assignments
- Integrates with payroll, benefits, and other HR modules
Typical Use Cases:
- Employee job history tracking
- Organizational reporting
- Workforce management
- Compensation and benefits administration
Recommendations:
- Use effective-dated queries
- Join with other HR tables for comprehensive information
- Implement proper date range filtering
Sample Query:
```sql
SELECT person_id, assignment_id, job_id, organization_id
FROM per_all_assignments_f
WHERE person_id = :p_person_id
AND SYSDATE BETWEEN effective_start_date AND effective_end_date
```
This table is crucial for maintaining comprehensive employee assignment records in Oracle EBS HR applications.
-
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