List of HCM SQL Query Tables

PERSON DOCUMENTATION
HR_DOCUMENTS_OF_RECORD
PAY_PAY_RELATIONSHIPS_F
PAY_PAY_RELATIONSHIPS_DN
PER_LDAP_REQUESTS
PER_ACTION_OCCURENCES
PER_CONTRACTS_F
PER_ASSIGN_GRADE_STEPS_F
PER_ASSIGNMENT_SUPERVISORS_F
PER_ASSIGN_WORK_MEASURES_F
PER_ALL_ASSIGNMENTS_M
PER_PERIODS_OF_SERVICE
LOCATION
PER_ACTION_OCCURRENCES
PER_ADDRESSES_F
PER_LOC_ADDRESS_USAGES_F
PER_LOCATIONS_DETAILS_F_TL
PER_LOCATION_EXTRA_INFO_F
PER_LOCATION_LEG_F
PER_LOCATION_DETAILS_F_TL
PER_LOCATION_DETAILS_F
PER_LOCATIONS
PER_LOCATION_DETAILS_F_V
JOBS
PER_ACTION_OCCURENCES
PER_VALID_GRADES_F
PER_JOBS_F_TL
PER_JOBS_F
PER_JOBS_F_VL
JOB FAMILY
PER_ACTION_OCCURENCES
PER_JOB_FAMILY_F
PER_JOB_FAMILY_F_TL
PER_JOB_FAMILY_F_VL
POSITION
PER_POSITION_LEG_F
PER_POSITION_EXTRA_INFO_F
HR_ALL_POSITIONS_F_TL
HR_ALL_POSITIONS_F
HR_ALL_POSITIONS_F_VL
GRADES
PER_ACTION_OCCURRENCES
PER_GRADES_F_TL
PER_GRADES_F
GRADE RATES
PER_RATES_F_TL
PER_RATES_F
PER_RATE_VALUES_F
PER_GRADES_F_VL
BUSINESS UNIT
PER_ACTION_OCCURRENCES
HR_ORG_UNIT_CLASSIFICATIONS_F
HR_ORGANIZATION_INFORMATION_F
HR_ORGANIZATION_UNITS_F_TL
HR_ALL_ORGANIZATION_UNITS_F
FUN_ALL_BUSINESS_UNITS_V
DEPARTMENT
PER_DEPARTMENTS
PER_ACTION_OCCURENCES
HR_ORG_UNIT_CLASSIFICATIONS_F
HR_ORGANIZATION_INFORMATION_F
HR_ORGANIZATION_UNITS_F_TL
HR_ALL_ORGANIZATION_UNITS_F_TL
ELEMENT ENTRY
PAY_ENTRY_PCT
PAY_ELEMENT_ENTRY_VALUES_F
PAY_ENTRY_USAGES
PAY_ELEMENT_ENTRIES_F
PAY_ENTRY_USAGES
PAY_ELEMENT_TYPES_F
Absences Accrual Entries
ANC_PER_ACRL_ENTRY_DTLS, ANC_PER_ACCRUAL_ENTRIES
Absence Plan transaction
ANC_ABSENCE_PLANS_F_TL
Absence Plan Table
ANC_ABSENCE_PLANS_F
Absence Plan Enrollment
ANC_PER_PLAN_ENROLLMENT
Work Schedule
ZMM_SR_SCHEDULES_B
Supervisor
PER_ASSIGNMENT_SUPERVISORS_F
Assignment Information
PER_ALL_ASSIGNMENTS_M
Area of Responsibility
PER_ASG_RESPONSIBILITIES
Personal Data (DOB, DOD, Birth Country)
PER_PERSONS
PER_PERSONS_V
Lookups
FND_LOOKUP_TYPES
FND_LOOKUP_VALUES_TL
HCM_LOOKUPS (view)
HR_LOOKUPS (view)

I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.

Technical Contents
Posted by : Mohammad