Oracle HCM Cloud Core HR Workforce Structures Table Relationships

Entity Relationship Diagram ERD for Global Human Resources Module Workforce Structures in Oracle HCM Cloud. It provides details on which table maps to which table and the inter relationships between them for most of the business objects.

For more details check out my blog @ http://fusionhcmknowledgebase.com/

1. HR_ALL_POSITIONS_F PER_LOCATIONS
PER_LOCATION_DETAILS_F
PER_LOCATION_DETAILS_F_TL
PER_LOCATION_EXTRA_INFO_F
PER_LOCATION_LEG_F
HR_LOCATIONS
HR_LOCATIONS_ALL
HR_LOCATIONS_ALL_F
HR_LOCATIONS_ALL_F_VL
HR_LOCATIONS_ALL_TL
HR_LOCATIONS_ALL_VL
HR_LOCATIONS_ALL_X
HR_LOCATION_EXTRA_INFO
PER_LOC_EIT_CATEGORY
PER_LOC_ADDRESS_USAGES_F
Location Views
Location Address Usages
Location EIT Category Info
Location Legislative Info
Location EFF Info
Location Translation
Location Details
CORE HR WORK STRUCTURES T ABLE RELATIONSHIPS
Location Details
Location Translation
Location EFF Info
PER_LOCATION_EXTRA_INFO_F
Location Legislative Info
Position Translation
HR_ALL_POSITIONS_F_TL
Position Hierarchy
PER_POSITION_HIERARCHY_F
Position EFF Info
PER_POSITION_EXTRA_INFO_F
Position Grades
HR_ALL_POSITIONS
HR_ALL_POSITIONS_F_VL
HR_ALL_POSITIONS_X
PER_POSITION_EXTRA_INFO
PER_POSITION_SECURED_LIST_V
PER_POS_HIERARCHY_F_V
PER_POS_TREE_NODE_V
Position Views
PER_POS_EIT_CATEGORY
Position Legislative Info
PER_VALID_GRADES_F
PER_POSITION_LEG_F
Position EIT Category Info
PER_JOBS_F
PositionsLocations
Jobs
PER_JOBS
PER_JOBS_F_V
PER_JOBS_F_VL
PER_JOBS_X
PER_JOB_EVALUATIONS_V
PER_JOB_EXTRA_INFO
PER_JOB_SECURED_LIST_V
PER_JOB_FAMILY_F
PER_JOB_FAMILY_F_TL
PER_JOBS_EIT_CATEGORY
PER_JOB_LEG_F
PER_JOB_EXTRA_INFO_F
PER_JOB_EVALUATIONS
PER_JOBS_F_TL
Job Translation
Job Evaluation
Job EFF Info
Job Legislative Info
Job EIT Category Info
Job Views
Job Family
PER_JOBS_F
PER_JOBS_F_TL
Job Translation
Job Evaluation
PER_JOB_EVALUATIONS
PER_JOB_EXTRA_INFO_F
Job Legislative Info
Job EIT Category Info
PER_JOBS_F
PER_JOBS_F_TL
Job Translation
Job Evaluation
PER_JOB_EVALUATIONS
PER_JOB_EXTRA_INFO_F
Job Legislative Info
Job EIT Category Info
PER_GRADES_F
PER_GRADES_F_TL
Grade Translation
Grade EFF Info
PER_GRADE_EXTRA_INFO_F
Grade Legislative Info
Grade Steps Info
PER_GRADE_LADDERS_F
PER_GRADE_LADDERS_F_TL
PER_GRADE_LADDER_LEG_F
PER_GRADES_IN_LADDERS_F
Grade Views
PER_GRADES
PER_GRADES_F_VL
PER_GRADES_IN_LADDERS_X
PER_GRADE_LADDERS_X
PER_GRADES_X
PER_GRADE_SECURED_LIST_V
PER_GRADE_LEG_X
PER_GRADE_STEPS_F_VL
Grades
PER_GRADE_LEG_F
PER_GRADE_STEPS_F
PER_GRADE_STEPS_F_TL
PER_GRADE_STEP_LEG_F
Grade Ladder Info
Core HR Work Structures consists of Locations, Positions, Position Trees, Jobs, Job Families, Grades, Rates,
Organizations, Organization Trees, Actions, Action Reasons etc.
PER_JOB_EVALUATIONS
PER_JOB_EXTRA_INFO_F
PER_JOB_LEG_F
HR_LOCATIONS
HR_LOCATIONS_ALL
HR_LOCATIONS_ALL_F
HR_LOCATIONS_ALL_F_VL
HR_LOCATIONS_ALL_TL
HR_LOCATIONS_ALL_VL
HR_LOCATIONS_ALL_X
HR_LOCATION_EXTRA_INFO
PER_LOC_ADDRESS_USAGES_F
PER_LOC_EIT_CATEGORY
PER_LOCATION_LEG_F
PER_LOCATION_EXTRA_INFO_F
PER_LOCATION_DETAILS_F_TL
Text
in India by Sricharan Monigari (Oracle ACE)Made with♥  https://fusionhcmknowledgebase.com/

2. PER_LEGISLATIVE_DATA_GROUPS
Legislative Data Groups
Legislative Data Groups Translation
PER_LDG_SECURED_LIST_V
Legislative Data Secured View
PER_LEGISLATIVE_DATA_GROUPS_VL
Legislative Data Groups View
PER_LEGISLATIVE_DATA_GROUPS_TL
PER_RATES_F
Rates
Rates Translation
PER_GRADES_F
Grades
PER_RATE_VALUES_F
Rate Values
PER_RATES_F_TL
PER_GRADE_STEPS_F
Grade Steps
PER_LEGISLATIVE_DATA_GROUPS
Organizations
HR_ALL_ORGANIZA TION_UNITS_F
HR_ORGANIZATION_UNITS_F_TL
Business Units
CLASSIFICATION - FUN_BUSINESS_UNIT
Departments
CLASSIFICATION - DEPARTMENT
Divisions
CLASSIFICATION - HCM_DIVISION
Unions
CLASSIFICATION - HCM_PSU
Legal Entities
CLASSIFICATION - HCM_LEMP
PER_DEPARTMENTS
HR_ORG_UNIT_CLASSIFICA TIONS_F
Payroll Statutory Unit
CLASSIFICATION - HCM_PSU
Reporting Establishment
CLASSIFICATION
- HCM_REPORTING_EST ABLISHMENT
Legal Reporting Unit
CLASSIFICATION - HCM_LRU
Tax Reporting Unit
CLASSIFICATION - HCM_TRU
XLE_ENTITY_PROFILES
XLE_REGISTRATIONS
FUN_ALL_BUSINESS_UNITS_V
HR_ORG_CLASSIFICA TIONS
HR_ORG_CLASSIFICA TIONS_TL
HR_ORGANIZATION_INFORMATION_F
Organization Translation
Organization Classification
Organization Classification Setup
Organization EFF Info
in India by Sricharan Monigari (Oracle ACE)Made with♥  https://fusionhcmknowledgebase.com/
Grades
CORE HR WORK STRUCTURES T ABLE RELATIONSHIPS

3. PER_ACTIONS_B
Actions
Actions Translation
PER_ACTIONS_TL
PER_ACTION_REASONS_B
Action Reasons
Action Reasons Translation
PER_ACTION_REASONS_TL
PER_ACTION_TYPES_B
Action Types
Action Types Translation
PER_ACTION_TYPES_TL
PER_ACTION_REASON_USAGES
PER_COL_AGREEMENTS_F
Collective Agreements
Collective Agreements Translation
PER_COL_AGREEMENTS_TL
HR_DOCUMENTS_OF_RECORD
Document of Records
Documents Table
FND_ATTACHED_DOCUMENTS
HR_DOCUMENT_TYPES_B
HR_DOCUMENT_TYPES_TL
Document Types
FND_LOOKUP_TYPES
Lookups
Lookup Types Translation
FND_LOOKUP_TYPES_TL
FND_LOOKUP_V ALUES_B
FND_LOOKUP_V ALUES_TL
Lookup Values
FND_PROFILE_OPTIONS_B
Profile Options
Profile Options Translation
FND_PROFILE_OPTIONS_TL
FND_PROFILE_OPTION_LEVELS
Profile Options Levels
FND_PROFILE_OPTION_V ALUES
Profile Options Values
FND_DOCUMENTS
FND_DOCUMENTS_TL
Documents Table
Action Reason Usages
Lookup Values Translation
in India by Sricharan Monigari (Oracle ACE)Made with♥  https://fusionhcmknowledgebase.com/
CORE HR WORK STRUCTURES T ABLE RELATIONSHIPS