DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.HR_ALL_ORGANIZATION_UNITS

Object Details
Object Name: HR_ALL_ORGANIZATION_UNITS
Object Type: TABLE
Owner: HR
FND Design Data: TableAS.HR_ALL_ORGANIZATION_UNITS
TablePER.HR_ALL_ORGANIZATION_UNITS
Subobject Name:
Status: VALID


HR_ALL_ORGANIZATION_UNITS holds the definitions that identify business
groups and the organization units within a single business group.
Additional information about classifications and information types for
each organization is held in HR_ORGANIZATION_INFORMATION.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: HR_ORGANIZATION_UNITS_PK
  1. ColumnORGANIZATION_ID
Unique Key: HR_ORGANIZATION_UNITS_UK2
  1. ColumnNAME
  2. ColumnBUSINESS_GROUP_ID
Indexes
Index Type Uniqueness Tablespace Column
HR_ORGANIZATION_UNITS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
HR_ORGANIZATION_UNITS_UK2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnNAME
ColumnBUSINESS_GROUP_ID
SYS_IL0000043628C00044$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
HR_ORGANIZATION_UNITS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
HR_ORGANIZATION_UNITS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_ALLOCATION_KEYFLEX_ID
HR_ORGANIZATION_UNITS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_ID
HR_ORGANIZATION_UNITS_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOFT_CODING_KEYFLEX_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK1 TableHR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATION_UNITS BUSINESS_GROUP_ID
HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK4 TableHR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATION_UNITS SOFT_CODING_KEYFLEX_ID
HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK3 TableHR_LOCATIONS_ALL HR_ALL_ORGANIZATION_UNITS LOCATION_ID
HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK2 TablePAY_COST_ALLOCATION_KEYFLEX HR_ALL_ORGANIZATION_UNITS COST_ALLOCATION_KEYFLEX_ID
TableBEN_BENEFIT_CONTRIBUTIONS_F BEN_BENEFIT_CONTRIBUTIONS_FK1 HR_ALL_ORGANIZATION_UNITS BEN_BENEFIT_CONTRIBUTIONS_F BUSINESS_GROUP_ID
TableGHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK1 HR_ALL_ORGANIZATION_UNITS GHR_MASS_REALIGNMENT OLD_ORGANIZATION_ID
TableGHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK2 HR_ALL_ORGANIZATION_UNITS GHR_MASS_REALIGNMENT NEW_ORGANIZATION_ID
TableGHR_MASS_REALIGNMENT GHR_MASS_REALIGNMENT_FK8 HR_ALL_ORGANIZATION_UNITS GHR_MASS_REALIGNMENT TARGET_POSITION_ORG_ID
TableGHR_MASS_SALARIES GHR_MASS_SALARIES_FK2 HR_ALL_ORGANIZATION_UNITS GHR_MASS_SALARIES ORGANIZATION_ID
TableGHR_MASS_TRANSFERS GHR_MASS_TRANSFERS_FK1 HR_ALL_ORGANIZATION_UNITS GHR_MASS_TRANSFERS OLD_ORGANIZATION_ID
TableGHR_PA_REQUESTS GHR_PA_REQUESTS_FK8 HR_ALL_ORGANIZATION_UNITS GHR_PA_REQUESTS TO_ORGANIZATION_ID
TableHR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK4 HR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATION_UNITS SOFT_CODING_KEYFLEX_ID
TableHR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_UNITS_FK1 HR_ALL_ORGANIZATION_UNITS HR_ALL_ORGANIZATION_UNITS BUSINESS_GROUP_ID
TableHR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK8 HR_ALL_ORGANIZATION_UNITS HR_ALL_POSITIONS_F BUSINESS_GROUP_ID
TableHR_ALL_POSITIONS_F HR_ALL_POSITIONS_F_FK9 HR_ALL_ORGANIZATION_UNITS HR_ALL_POSITIONS_F ORGANIZATION_ID
TableHR_ASSIGNMENT_SETS HR_ASSIGNMENT_SETS_FK1 HR_ALL_ORGANIZATION_UNITS HR_ASSIGNMENT_SETS BUSINESS_GROUP_ID
TableHR_ORGANIZATION_INFORMATION HR_ORGANIZATION_INFORMATIO_FK2 HR_ALL_ORGANIZATION_UNITS HR_ORGANIZATION_INFORMATION ORGANIZATION_ID
TableHR_QUESTIONNAIRES HR_QUESTIONNAIRES_FK HR_ALL_ORGANIZATION_UNITS HR_QUESTIONNAIRES BUSINESS_GROUP_ID
TableHR_QUEST_ANSWERS HR_QUEST_ANSWERS_FK2 HR_ALL_ORGANIZATION_UNITS HR_QUEST_ANSWERS BUSINESS_GROUP_ID
TableHR_TIPS HR_TIPS_FK1 HR_ALL_ORGANIZATION_UNITS HR_TIPS BUSINESS_GROUP_ID
TablePAY_ACCRUAL_BANDS PAY_ACCRUAL_BANDS_FK1 HR_ALL_ORGANIZATION_UNITS PAY_ACCRUAL_BANDS BUSINESS_GROUP_ID
TablePAY_ACCRUAL_PLANS PAY_ACCRUAL_PLANS_FK1 HR_ALL_ORGANIZATION_UNITS PAY_ACCRUAL_PLANS BUSINESS_GROUP_ID
TablePAY_ALL_PAYROLLS_F PAY_PAYROLLS_F_FK8 HR_ALL_ORGANIZATION_UNITS PAY_ALL_PAYROLLS_F ORGANIZATION_ID
TablePAY_ALL_PAYROLLS_F PAY_PAYROLLS_F_FK2 HR_ALL_ORGANIZATION_UNITS PAY_ALL_PAYROLLS_F BUSINESS_GROUP_ID
TablePAY_CONSOLIDATION_SETS PAY_CONSOLIDATION_SETS_FK1 HR_ALL_ORGANIZATION_UNITS PAY_CONSOLIDATION_SETS BUSINESS_GROUP_ID
TablePAY_COST_ALLOCATIONS_F PAY_COST_ALLOCATIONS_F_FK1 HR_ALL_ORGANIZATION_UNITS PAY_COST_ALLOCATIONS_F BUSINESS_GROUP_ID
TablePAY_ELEMENT_LINKS_F PAY_ELEMENT_LINKS_F_FK11 HR_ALL_ORGANIZATION_UNITS PAY_ELEMENT_LINKS_F BUSINESS_GROUP_ID
TablePAY_ELEMENT_LINKS_F PAY_ELEMENT_LINKS_F_FK6 HR_ALL_ORGANIZATION_UNITS PAY_ELEMENT_LINKS_F ORGANIZATION_ID
TablePAY_ELE_PAYROLL_FREQ_RULES PAY_ELE_PAYROLL_FREQ_RULES_FK1 HR_ALL_ORGANIZATION_UNITS PAY_ELE_PAYROLL_FREQ_RULES BUSINESS_GROUP_ID
TablePAY_FREQ_RULE_PERIODS PAY_FREQ_RULE_PERIODS_FK1 HR_ALL_ORGANIZATION_UNITS PAY_FREQ_RULE_PERIODS BUSINESS_GROUP_ID
TablePAY_GRADE_RULES_F PAY_GRADE_RULES_F_FK1 HR_ALL_ORGANIZATION_UNITS PAY_GRADE_RULES_F BUSINESS_GROUP_ID
TablePAY_JOB_WC_CODE_USAGES PAY_JOB_WC_CODE_USAGES_FK1 HR_ALL_ORGANIZATION_UNITS PAY_JOB_WC_CODE_USAGES BUSINESS_GROUP_ID
TablePAY_NET_CALCULATION_RULES PAY_NET_CALCULATION_RULES_FK2 HR_ALL_ORGANIZATION_UNITS PAY_NET_CALCULATION_RULES BUSINESS_GROUP_ID
TablePAY_ORG_PAYMENT_METHODS_F PAY_ORG_PAYMENT_METHODS_F_FK1 HR_ALL_ORGANIZATION_UNITS PAY_ORG_PAYMENT_METHODS_F BUSINESS_GROUP_ID
TablePAY_PAYROLL_ACTIONS PAY_PAYROLL_ACTIONS_FK1 HR_ALL_ORGANIZATION_UNITS PAY_PAYROLL_ACTIONS BUSINESS_GROUP_ID
TablePAY_PERSONAL_PAYMENT_METHODS_F PAY_PERSONAL_PAYMENT_METHO_FK1 HR_ALL_ORGANIZATION_UNITS PAY_PERSONAL_PAYMENT_METHODS_F BUSINESS_GROUP_ID
TablePAY_RATES PAY_RATES_FK1 HR_ALL_ORGANIZATION_UNITS PAY_RATES BUSINESS_GROUP_ID
TablePAY_SECURITY_PAYROLLS PAY_SECURITY_PAYROLLS_FK1 HR_ALL_ORGANIZATION_UNITS PAY_SECURITY_PAYROLLS BUSINESS_GROUP_ID
TablePAY_US_EMP_CITY_TAX_RULES_F PAY_US_EMP_CITY_TAX_RULES_FK2 HR_ALL_ORGANIZATION_UNITS PAY_US_EMP_CITY_TAX_RULES_F BUSINESS_GROUP_ID
TablePAY_US_EMP_COUNTY_TAX_RULES_F PAY_US_EMP_COUNTY_TAX_RULE_FK2 HR_ALL_ORGANIZATION_UNITS PAY_US_EMP_COUNTY_TAX_RULES_F BUSINESS_GROUP_ID
TablePAY_US_EMP_FED_TAX_RULES_F PAY_US_EMP_FED_TAX_RULES_FK2 HR_ALL_ORGANIZATION_UNITS PAY_US_EMP_FED_TAX_RULES_F BUSINESS_GROUP_ID
TablePAY_US_EMP_STATE_TAX_RULES_F PAY_US_EMP_STATE_TAX_RULES_FK2 HR_ALL_ORGANIZATION_UNITS PAY_US_EMP_STATE_TAX_RULES_F BUSINESS_GROUP_ID
TablePAY_WCI_ACCOUNTS PAY_WCI_ACCOUNTS_FK1 HR_ALL_ORGANIZATION_UNITS PAY_WCI_ACCOUNTS BUSINESS_GROUP_ID
TablePAY_WCI_OCCUPATIONS PAY_WCI_OCCUPATIONS_FK3 HR_ALL_ORGANIZATION_UNITS PAY_WCI_OCCUPATIONS BUSINESS_GROUP_ID
TablePAY_WCI_RATES PAY_WCI_RATES_FK2 HR_ALL_ORGANIZATION_UNITS PAY_WCI_RATES BUSINESS_GROUP_ID
TablePAY_WC_FUNDS PAY_WC_FUNDS_FK1 HR_ALL_ORGANIZATION_UNITS PAY_WC_FUNDS BUSINESS_GROUP_ID
TablePAY_WC_FUNDS PAY_WC_FUNDS_FK2 HR_ALL_ORGANIZATION_UNITS PAY_WC_FUNDS CARRIER_ID
TablePAY_WC_RATES PAY_WC_RATES_FK1 HR_ALL_ORGANIZATION_UNITS PAY_WC_RATES BUSINESS_GROUP_ID
TablePER_ABSENCE_ATTENDANCES PER_ABSENCE_ATTENDANCES_FK1 HR_ALL_ORGANIZATION_UNITS PER_ABSENCE_ATTENDANCES BUSINESS_GROUP_ID
TablePER_ABSENCE_ATTENDANCE_TYPES PER_ABSENCE_ATTENDANCE_TYP_FK1 HR_ALL_ORGANIZATION_UNITS PER_ABSENCE_ATTENDANCE_TYPES BUSINESS_GROUP_ID
TablePER_ABS_ATTENDANCE_REASONS PER_ABS_ATTENDANCE_REASONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_ABS_ATTENDANCE_REASONS BUSINESS_GROUP_ID
TablePER_ADDRESSES PER_ADDRESSES_FK1 HR_ALL_ORGANIZATION_UNITS PER_ADDRESSES BUSINESS_GROUP_ID
TablePER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK14 HR_ALL_ORGANIZATION_UNITS PER_ALL_ASSIGNMENTS_F SOURCE_ORGANIZATION_ID
TablePER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK1 HR_ALL_ORGANIZATION_UNITS PER_ALL_ASSIGNMENTS_F BUSINESS_GROUP_ID
TablePER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK15 HR_ALL_ORGANIZATION_UNITS PER_ALL_ASSIGNMENTS_F ORGANIZATION_ID
TablePER_ALL_ASSIGNMENTS_F PER_ASSIGNMENTS_F_FK20 HR_ALL_ORGANIZATION_UNITS PER_ALL_ASSIGNMENTS_F ESTABLISHMENT_ID
TablePER_ALL_PEOPLE_F PER_PEOPLE_F_FK1 HR_ALL_ORGANIZATION_UNITS PER_ALL_PEOPLE_F BUSINESS_GROUP_ID
TablePER_ALL_POSITIONS PER_POSITIONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_ALL_POSITIONS BUSINESS_GROUP_ID
TablePER_ALL_POSITIONS PER_POSITIONS_FK3 HR_ALL_ORGANIZATION_UNITS PER_ALL_POSITIONS ORGANIZATION_ID
TablePER_ALL_VACANCIES PER_VACANCIES_FK1 HR_ALL_ORGANIZATION_UNITS PER_ALL_VACANCIES BUSINESS_GROUP_ID
TablePER_ALL_VACANCIES PER_VACANCIES_FK5 HR_ALL_ORGANIZATION_UNITS PER_ALL_VACANCIES ORGANIZATION_ID
TablePER_APPLICATIONS PER_APPLICATIONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_APPLICATIONS BUSINESS_GROUP_ID
TablePER_APPRAISALS PER_APPRAISALS_FK1 HR_ALL_ORGANIZATION_UNITS PER_APPRAISALS BUSINESS_GROUP_ID
TablePER_APPRAISAL_TEMPLATES PER_APPRAISAL_TEMPLATES_FK1 HR_ALL_ORGANIZATION_UNITS PER_APPRAISAL_TEMPLATES BUSINESS_GROUP_ID
TablePER_ASSESSMENTS PER_ASSESSMENTS_FK2 HR_ALL_ORGANIZATION_UNITS PER_ASSESSMENTS BUSINESS_GROUP_ID
TablePER_ASSESSMENT_TYPES PER_ASSESSMENT_TYPES_FK1 HR_ALL_ORGANIZATION_UNITS PER_ASSESSMENT_TYPES BUSINESS_GROUP_ID
TablePER_ASSIGNMENT_BUDGET_VALUES_F PER_ASSIGNMENT_BUDGET_VALU_FK1 HR_ALL_ORGANIZATION_UNITS PER_ASSIGNMENT_BUDGET_VALUES_F BUSINESS_GROUP_ID
TablePER_BF_BALANCE_AMOUNTS PER_BF_BALANCE_AMOUNTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_BF_BALANCE_AMOUNTS BUSINESS_GROUP_ID
TablePER_BF_BALANCE_TYPES PER_BF_BALANCE_TYPES_FK1 HR_ALL_ORGANIZATION_UNITS PER_BF_BALANCE_TYPES BUSINESS_GROUP_ID
TablePER_BF_PAYMENT_DETAILS PER_BF_PAYMENT_DETAILS_FK1 HR_ALL_ORGANIZATION_UNITS PER_BF_PAYMENT_DETAILS BUSINESS_GROUP_ID
TablePER_BF_PAYROLL_RUNS PER_BF_PAYROLL_RUNS_FK1 HR_ALL_ORGANIZATION_UNITS PER_BF_PAYROLL_RUNS BUSINESS_GROUP_ID
TablePER_BOOKINGS PER_BOOKINGS_FK1 HR_ALL_ORGANIZATION_UNITS PER_BOOKINGS BUSINESS_GROUP_ID
TablePER_BUDGETS PER_BUDGETS_FK1 HR_ALL_ORGANIZATION_UNITS PER_BUDGETS BUSINESS_GROUP_ID
TablePER_BUDGET_ELEMENTS PER_BUDGET_ELEMENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_BUDGET_ELEMENTS BUSINESS_GROUP_ID
TablePER_BUDGET_ELEMENTS PER_BUDGET_ELEMENTS_FK5 HR_ALL_ORGANIZATION_UNITS PER_BUDGET_ELEMENTS ORGANIZATION_ID
TablePER_BUDGET_VALUES PER_BUDGET_VALUES_FK1 HR_ALL_ORGANIZATION_UNITS PER_BUDGET_VALUES BUSINESS_GROUP_ID
TablePER_BUDGET_VERSIONS PER_BUDGET_VERSIONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_BUDGET_VERSIONS BUSINESS_GROUP_ID
TablePER_CAREER_PATHS PER_CAREER_PATHS_FK1 HR_ALL_ORGANIZATION_UNITS PER_CAREER_PATHS BUSINESS_GROUP_ID
TablePER_CAREER_PATH_ELEMENTS PER_CAREER_PATH_ELEMENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_CAREER_PATH_ELEMENTS BUSINESS_GROUP_ID
TablePER_COBRA_COVERAGE_BENEFITS_F PER_COBRA_COVERAGE_BENEFIT_FK1 HR_ALL_ORGANIZATION_UNITS PER_COBRA_COVERAGE_BENEFITS_F BUSINESS_GROUP_ID
TablePER_COBRA_COVERAGE_STATUSES PER_COBRA_COVERAGE_STATUSE_FK1 HR_ALL_ORGANIZATION_UNITS PER_COBRA_COVERAGE_STATUSES BUSINESS_GROUP_ID
TablePER_COBRA_COV_ENROLLMENTS PER_COBRA_COV_ENROLLMENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_COBRA_COV_ENROLLMENTS BUSINESS_GROUP_ID
TablePER_COLLECTIVE_AGREEMENTS PER_COLLECTIVE_AGREEMENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_COLLECTIVE_AGREEMENTS EMPLOYER_ORGANIZATION_ID
TablePER_COLLECTIVE_AGREEMENTS PER_COLLECTIVE_AGREEMENTS_FK3 HR_ALL_ORGANIZATION_UNITS PER_COLLECTIVE_AGREEMENTS BUSINESS_GROUP_ID
TablePER_COLLECTIVE_AGREEMENTS PER_COLLECTIVE_AGREEMENTS_FK2 HR_ALL_ORGANIZATION_UNITS PER_COLLECTIVE_AGREEMENTS BARGAINING_ORGANIZATION_ID
TablePER_COMPETENCES PER_COMPETENCES_FK1 HR_ALL_ORGANIZATION_UNITS PER_COMPETENCES BUSINESS_GROUP_ID
TablePER_COMPETENCE_ELEMENTS PER_COMPETENCE_ELEMENTS_FK2 HR_ALL_ORGANIZATION_UNITS PER_COMPETENCE_ELEMENTS BUSINESS_GROUP_ID
TablePER_COMPETENCE_ELEMENTS PER_COMPETENCE_ELEMENTS_FK20 HR_ALL_ORGANIZATION_UNITS PER_COMPETENCE_ELEMENTS ENTERPRISE_ID
TablePER_COMPETENCE_ELEMENTS PER_COMPETENCE_ELEMENTS_FK10 HR_ALL_ORGANIZATION_UNITS PER_COMPETENCE_ELEMENTS ORGANIZATION_ID
TablePER_CONTACT_RELATIONSHIPS PER_CONTACT_RELATIONSHIPS_FK1 HR_ALL_ORGANIZATION_UNITS PER_CONTACT_RELATIONSHIPS BUSINESS_GROUP_ID
TablePER_CONTRACTS_F PER_CONTRACTS_F_FK1 HR_ALL_ORGANIZATION_UNITS PER_CONTRACTS_F BUSINESS_GROUP_ID
TablePER_DEPLOYMENT_FACTORS PER_DEPLOYMENT_FACTORS_FK3 HR_ALL_ORGANIZATION_UNITS PER_DEPLOYMENT_FACTORS BUSINESS_GROUP_ID
TablePER_DISABILITIES_F PER_DISABILITIES_F_FK3 HR_ALL_ORGANIZATION_UNITS PER_DISABILITIES_F ORGANIZATION_ID
TablePER_ELECTIONS PER_ELECTIONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_ELECTIONS BUSINESS_GROUP_ID
TablePER_ELECTIONS PER_ELECTIONS_FK2 HR_ALL_ORGANIZATION_UNITS PER_ELECTIONS REP_BODY_ID
TablePER_ELECTION_CANDIDATES PER_ELECTION_CANDIDATES_FK1 HR_ALL_ORGANIZATION_UNITS PER_ELECTION_CANDIDATES BUSINESS_GROUP_ID
TablePER_ELECTION_CONSTITUENCYS PER_ELECTION_CONSTITUENCYS_FK3 HR_ALL_ORGANIZATION_UNITS PER_ELECTION_CONSTITUENCYS CONSTITUENCY_ID
TablePER_ESTABLISHMENT_ATTENDANCES PER_ESTABLISHMENT_ATTEND_FK2 HR_ALL_ORGANIZATION_UNITS PER_ESTABLISHMENT_ATTENDANCES BUSINESS_GROUP_ID
TablePER_EVENTS PER_EVENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_EVENTS BUSINESS_GROUP_ID
TablePER_EVENTS PER_EVENTS_FK4 HR_ALL_ORGANIZATION_UNITS PER_EVENTS ORGANIZATION_RUN_BY_ID
TablePER_GRADES PER_GRADES_FK1 HR_ALL_ORGANIZATION_UNITS PER_GRADES BUSINESS_GROUP_ID
TablePER_GRADE_SPINES_F PER_GRADE_SPINES_F_FK1 HR_ALL_ORGANIZATION_UNITS PER_GRADE_SPINES_F BUSINESS_GROUP_ID
TablePER_JOBS PER_JOBS_FK1 HR_ALL_ORGANIZATION_UNITS PER_JOBS BUSINESS_GROUP_ID
TablePER_JOB_EVALUATIONS PER_JOB_EVALUATIONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_JOB_EVALUATIONS BUSINESS_GROUP_ID
TablePER_JOB_GROUPS PER_JOB_GROUPS_FK1 HR_ALL_ORGANIZATION_UNITS PER_JOB_GROUPS BUSINESS_GROUP_ID
TablePER_JOB_REQUIREMENTS PER_JOB_REQUIREMENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_JOB_REQUIREMENTS BUSINESS_GROUP_ID
TablePER_LETTER_GEN_STATUSES PER_LETTER_GEN_STATUSES_FK1 HR_ALL_ORGANIZATION_UNITS PER_LETTER_GEN_STATUSES BUSINESS_GROUP_ID
TablePER_LETTER_REQUESTS PER_LETTER_REQUESTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_LETTER_REQUESTS BUSINESS_GROUP_ID
TablePER_LETTER_REQUEST_LINES PER_LETTER_REQUEST_LINES_FK1 HR_ALL_ORGANIZATION_UNITS PER_LETTER_REQUEST_LINES BUSINESS_GROUP_ID
TablePER_LETTER_TYPES PER_LETTER_TYPES_FK1 HR_ALL_ORGANIZATION_UNITS PER_LETTER_TYPES BUSINESS_GROUP_ID
TablePER_MASS_MOVES PER_MASS_MOVES_FK1 HR_ALL_ORGANIZATION_UNITS PER_MASS_MOVES BUSINESS_GROUP_ID
TablePER_MEDICAL_ASSESSMENTS PER_MEDICAL_ASSESSMENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_MEDICAL_ASSESSMENTS ORGANIZATION_ID
TablePER_NUMBER_GENERATION_CONTROLS PER_NUMBER_GENERATION_CONT_FK1 HR_ALL_ORGANIZATION_UNITS PER_NUMBER_GENERATION_CONTROLS BUSINESS_GROUP_ID
TablePER_OBJECTIVES PER_OBJECTIVES_FK1 HR_ALL_ORGANIZATION_UNITS PER_OBJECTIVES BUSINESS_GROUP_ID
TablePER_ORGANIZATION_LIST PER_ORGANIZATION_LIST_FK1 HR_ALL_ORGANIZATION_UNITS PER_ORGANIZATION_LIST ORGANIZATION_ID
TablePER_ORGANIZATION_STRUCTURES PER_ORGANIZATION_STRUCTURE_FK1 HR_ALL_ORGANIZATION_UNITS PER_ORGANIZATION_STRUCTURES BUSINESS_GROUP_ID
TablePER_ORG_STRUCTURE_ELEMENTS PER_ORG_STRUCTURE_ELEMENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_ORG_STRUCTURE_ELEMENTS BUSINESS_GROUP_ID
TablePER_ORG_STRUCTURE_ELEMENTS PER_ORG_STRUCTURE_ELEMENTS_FK4 HR_ALL_ORGANIZATION_UNITS PER_ORG_STRUCTURE_ELEMENTS ORGANIZATION_ID_CHILD
TablePER_ORG_STRUCTURE_ELEMENTS PER_ORG_STRUCTURE_ELEMENTS_FK2 HR_ALL_ORGANIZATION_UNITS PER_ORG_STRUCTURE_ELEMENTS ORGANIZATION_ID_PARENT
TablePER_ORG_STRUCTURE_VERSIONS PER_ORG_STRUCTURE_VERSIONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_ORG_STRUCTURE_VERSIONS BUSINESS_GROUP_ID
TablePER_PARENT_SPINES PER_PARENT_SPINES_FK1 HR_ALL_ORGANIZATION_UNITS PER_PARENT_SPINES BUSINESS_GROUP_ID
TablePER_PARTICIPANTS PER_PARTICPANTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_PARTICIPANTS BUSINESS_GROUP_ID
TablePER_PAY_BASES PER_PAY_BASES_FK3 HR_ALL_ORGANIZATION_UNITS PER_PAY_BASES BUSINESS_GROUP_ID
TablePER_PAY_PROPOSALS PER_PAY_PROPOSALS_FK3 HR_ALL_ORGANIZATION_UNITS PER_PAY_PROPOSALS BUSINESS_GROUP_ID
TablePER_PAY_PROPOSAL_COMPONENTS PER_PAY_PROPOSAL_COMPONENT_FK2 HR_ALL_ORGANIZATION_UNITS PER_PAY_PROPOSAL_COMPONENTS BUSINESS_GROUP_ID
TablePER_PERIODS_OF_SERVICE PER_PERIODS_OF_SERVICE_FK1 HR_ALL_ORGANIZATION_UNITS PER_PERIODS_OF_SERVICE BUSINESS_GROUP_ID
TablePER_PERSON_ANALYSES PER_PERSON_ANALYSES_FK1 HR_ALL_ORGANIZATION_UNITS PER_PERSON_ANALYSES BUSINESS_GROUP_ID
TablePER_POSITION_STRUCTURES PER_POSITION_STRUCTURES_FK1 HR_ALL_ORGANIZATION_UNITS PER_POSITION_STRUCTURES BUSINESS_GROUP_ID
TablePER_POS_STRUCTURE_ELEMENTS PER_POS_STRUCTURE_ELEMENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_POS_STRUCTURE_ELEMENTS BUSINESS_GROUP_ID
TablePER_POS_STRUCTURE_VERSIONS PER_POS_STRUCTURE_VERSIONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_POS_STRUCTURE_VERSIONS BUSINESS_GROUP_ID
TablePER_QUALIFICATIONS PER_QUALIFICATIONS_FK3 HR_ALL_ORGANIZATION_UNITS PER_QUALIFICATIONS BUSINESS_GROUP_ID
TablePER_RATING_LEVELS PER_RATING_LEVELS_FK2 HR_ALL_ORGANIZATION_UNITS PER_RATING_LEVELS BUSINESS_GROUP_ID
TablePER_RATING_SCALES PER_RATING_SCALES_FK1 HR_ALL_ORGANIZATION_UNITS PER_RATING_SCALES BUSINESS_GROUP_ID
TablePER_RECRUITMENT_ACTIVITIES PER_RECRUITMENT_ACTIVITIES_FK1 HR_ALL_ORGANIZATION_UNITS PER_RECRUITMENT_ACTIVITIES BUSINESS_GROUP_ID
TablePER_RECRUITMENT_ACTIVITIES PER_RECRUITMENT_ACTIVITIES_FK3 HR_ALL_ORGANIZATION_UNITS PER_RECRUITMENT_ACTIVITIES RUN_BY_ORGANIZATION_ID
TablePER_RECRUITMENT_ACTIVITY_FOR PER_RECRUITMENT_ACTIVITY_F_FK1 HR_ALL_ORGANIZATION_UNITS PER_RECRUITMENT_ACTIVITY_FOR BUSINESS_GROUP_ID
TablePER_REQUISITIONS PER_REQUISITIONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_REQUISITIONS BUSINESS_GROUP_ID
TablePER_ROLES PER_ROLES_FK1 HR_ALL_ORGANIZATION_UNITS PER_ROLES ORGANIZATION_ID
TablePER_SALARY_SURVEY_MAPPINGS PER_SURVEY_MAPPINGS_FK4 HR_ALL_ORGANIZATION_UNITS PER_SALARY_SURVEY_MAPPINGS BUSINESS_GROUP_ID
TablePER_SALARY_SURVEY_MAPPINGS PER_SURVEY_MAPPINGS_FK5 HR_ALL_ORGANIZATION_UNITS PER_SALARY_SURVEY_MAPPINGS COMPANY_ORGANIZATION_ID
TablePER_SCHED_COBRA_PAYMENTS PER_SCHED_COBRA_PAYMENTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_SCHED_COBRA_PAYMENTS BUSINESS_GROUP_ID
TablePER_SECONDARY_ASS_STATUSES PER_SECONDARY_ASS_STATUSES_FK1 HR_ALL_ORGANIZATION_UNITS PER_SECONDARY_ASS_STATUSES BUSINESS_GROUP_ID
TablePER_SECURITY_ORGANIZATIONS PER_SECURITY_ORGANIZATIONS_FK1 HR_ALL_ORGANIZATION_UNITS PER_SECURITY_ORGANIZATIONS ORGANIZATION_ID
TablePER_SECURITY_PROFILES PER_SECURITY_PROFILES_FK3 HR_ALL_ORGANIZATION_UNITS PER_SECURITY_PROFILES ORGANIZATION_ID
TablePER_SECURITY_PROFILES PER_SECURITY_PROFILES_FK1 HR_ALL_ORGANIZATION_UNITS PER_SECURITY_PROFILES BUSINESS_GROUP_ID
TablePER_SEC_PROFILE_ASSIGNMENTS PER_SEC_PROFILE_ASSIGNMENT_FK2 HR_ALL_ORGANIZATION_UNITS PER_SEC_PROFILE_ASSIGNMENTS BUSINESS_GROUP_ID
TablePER_SPECIAL_INFO_TYPES PER_SPECIAL_INFO_TYPES_FK1 HR_ALL_ORGANIZATION_UNITS PER_SPECIAL_INFO_TYPES BUSINESS_GROUP_ID
TablePER_SPINAL_POINTS PER_SPINAL_POINTS_FK1 HR_ALL_ORGANIZATION_UNITS PER_SPINAL_POINTS BUSINESS_GROUP_ID
TablePER_SPINAL_POINT_PLACEMENTS_F PER_SPINAL_POINT_PLACEMENT_FK1 HR_ALL_ORGANIZATION_UNITS PER_SPINAL_POINT_PLACEMENTS_F BUSINESS_GROUP_ID
TablePER_SPINAL_POINT_STEPS_F PER_SPINAL_POINT_STEPS_F_FK1 HR_ALL_ORGANIZATION_UNITS PER_SPINAL_POINT_STEPS_F BUSINESS_GROUP_ID
TablePER_SUCCESSION_PLANNING PER_SUCCESSION_PLANNING_FK2 HR_ALL_ORGANIZATION_UNITS PER_SUCCESSION_PLANNING BUSINESS_GROUP_ID
TablePER_VALID_GRADES PER_VALID_GRADES_FK1 HR_ALL_ORGANIZATION_UNITS PER_VALID_GRADES BUSINESS_GROUP_ID
TablePQH_BUDGET_DETAILS PQH_BUDGET_DETAILS_FK2 HR_ALL_ORGANIZATION_UNITS PQH_BUDGET_DETAILS ORGANIZATION_ID
TablePQH_COPY_ENTITY_TXNS PQH_COPY_ENTITY_TXNS_FK4 HR_ALL_ORGANIZATION_UNITS PQH_COPY_ENTITY_TXNS CONTEXT_BUSINESS_GROUP_ID
TablePQH_DFLT_BUDGET_SETS PQH_DFLT_BUDGET_SETS_FK1 HR_ALL_ORGANIZATION_UNITS PQH_DFLT_BUDGET_SETS BUSINESS_GROUP_ID
TablePQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK8 HR_ALL_ORGANIZATION_UNITS PQH_POSITION_TRANSACTIONS BUSINESS_GROUP_ID
TablePQH_POSITION_TRANSACTIONS PQH_POSITION_TRANSACTIONS_FK9 HR_ALL_ORGANIZATION_UNITS PQH_POSITION_TRANSACTIONS ORGANIZATION_ID
TablePQH_ROLES PQH_ROLES_FK1 HR_ALL_ORGANIZATION_UNITS PQH_ROLES BUSINESS_GROUP_ID
TablePQH_TXN_JOB_REQUIREMENTS PQH_TXN_JOB_REQUIREMENTS_FK3 HR_ALL_ORGANIZATION_UNITS PQH_TXN_JOB_REQUIREMENTS BUSINESS_GROUP_ID
TablePQH_WORKSHEET_DETAILS PQH_WORKSHEET_DETAILS_FK2 HR_ALL_ORGANIZATION_UNITS PQH_WORKSHEET_DETAILS ORGANIZATION_ID
Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER (15) Yes System-generated primary key column.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
COST_ALLOCATION_KEYFLEX_ID NUMBER (9)
Foreign key to PAY_COST_ALLOCATION_KEYFLEX.
LOCATION_ID NUMBER (15)
Foreign key to HR_LOCATIONS. Default work site location for all assignments to this organization.
SOFT_CODING_KEYFLEX_ID NUMBER (15)
Column obsolete
DATE_FROM DATE
Yes Start date of the organization.
NAME VARCHAR2 (240) Yes Name of the organization.
DATE_TO DATE

End date of the organization.
INTERNAL_EXTERNAL_FLAG VARCHAR2 (30)
Identifies whether the organization is treated as an employment unit within the business group.
INTERNAL_ADDRESS_LINE VARCHAR2 (80)
Internal address line.
TYPE VARCHAR2 (30)
User-defined organization types, for example Region, Division, Department.
REQUEST_ID NUMBER (15)
Standard Who column.
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column.
PROGRAM_ID NUMBER (15)
Standard Who column.
PROGRAM_UPDATE_DATE DATE

Standard Who column.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
LAST_UPDATE_DATE DATE

Standard Who column.
LAST_UPDATED_BY NUMBER (15)
Standard Who column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column.
CREATED_BY NUMBER (15)
Standard Who column.
CREATION_DATE DATE

Standard Who column.
OBJECT_VERSION_NUMBER NUMBER (9)
System-generated version of row. Increments by one with each update.
PARTY_ID NUMBER (15)
Foreign key to HZ_PARTIES. Not currently used, reserved for future use.
COMMENTS CLOB (4000)
General remark.
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      LOCATION_ID
,      SOFT_CODING_KEYFLEX_ID
,      DATE_FROM
,      NAME
,      DATE_TO
,      INTERNAL_EXTERNAL_FLAG
,      INTERNAL_ADDRESS_LINE
,      TYPE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      PARTY_ID
,      COMMENTS
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
FROM HR.HR_ALL_ORGANIZATION_UNITS;

Dependencies

[top of page]

HR.HR_ALL_ORGANIZATION_UNITS does not reference any database object

HR.HR_ALL_ORGANIZATION_UNITS is referenced by following:

SchemaHR
ViewHR_ALL_ORGANIZATION_UNITS#