Search Results hr_all_organization_units




I'll provide a detailed description of the HR_ALL_ORGANIZATION_UNITS table in Oracle E-Business Suite (EBS) HR module:

Table Name: HR_ALL_ORGANIZATION_UNITS

Purpose:
- Stores information about organizational units within an enterprise
- Represents the hierarchical structure of an organization
- Tracks organizational details across different business units and legal entities

Key Columns:
1. ORGANIZATION_ID (Primary Key)
- Unique identifier for each organization unit
- Used in various HR and related modules

2. NAME
- Official name of the organization unit
- Descriptive text representing the unit's designation

3. BUSINESS_GROUP_ID
- Links the organization unit to a specific business group
- Helps in maintaining organizational boundaries

4. TYPE
- Classifies the organization unit (e.g., Department, Division, Company)
- Defines the nature of the organizational unit

5. LOCATION_ID
- References the physical location of the organization unit
- Links to HR_LOCATIONS table

6. DATE_FROM
- Effective start date of the organization unit
- Tracks when the unit was established or became active

7. DATE_TO
- Effective end date of the organization unit
- Indicates when the unit was dissolved or became inactive

Additional Attributes:
- INTERNAL_EXTERNAL_FLAG
- COST_ALLOCATION_KEYFLEX_ID
- SOFT_CODING_KEYFLEX_ID

Common Use Cases:
- Organizational reporting
- Workforce management
- Cost center tracking
- Hierarchical structure definition

Typical Relationships:
- Linked with PER_ALL_ASSIGNMENTS_F for employee assignments
- Connected to HR_ORGANIZATION_UNITS for hierarchical relationships

Recommendation:
- Ensure data consistency across business groups
- Maintain accurate historical tracking of organizational changes