There is no easy way to find out the underlying tables from the application pages. This post serves as a handy reference to the most frequently used business objects and tables list.
Table of Contents
Table Naming Convention in Cloud Applications
If you are new to the table naming convention, please check this post to understand the tables and views naming convention:
Most Important Tables list across modules
| BUSINESS OBJECT | BASE RECORDS |
| PERSON | PER_DRIVERS_LICENSE_TYPES |
| PER_DRIVERS_LICENSES | |
| PER_PERSON_DLVRY_METHODS | |
| PER_IMAGES | |
| PER_CITIZENSHIPS | |
| PER_PASSPORTS | |
| PER_VISAS_PERMITS_F | |
| PER_SHARE_INFORMATION | |
| PER_DISABILITIES_F | |
| PER_CONTACT_EXTRA_INFO_F CEI | |
| PER_CONTACT_RELSHIPS_F | |
| PER_PERSON_TYPE_USAGES_M | |
| PER_RELIGIONS | |
| PER_PHONES | |
| PER_NATIONAL_IDENTIFIERS | |
| PER_PERSON_NAMES_F | |
| PER_PEOPLE_LEGISLATIVE_F | |
| PER_PEOPLE_EXTRA_INFO_F | |
| PER_ETHNICITIES | |
| PER_EMAIL_ADDRESSES | |
| PER_ADDRESSES_F | |
| PER_PERSON_ADDR_USAGES_F | |
| PER_ALL_PEOPLE_F | |
| PER_PERSONS | |
| PERSON DOCUMENTATION | HR_DOCUMENTS_OF_RECORD |
| WORKRELATIONSHIP BY PERSON | HRC_LOADER_BATCH_KEY_MAP |
| PAY_REL_GROUPS_F | |
| PAY_REL_GROUPS_DN | |
| PAY_PAY_RELATIONSHIPS_F | |
| PAY_PAY_RELATIONSHIPS_DN | |
| BEN_REL_ASSIGNMENTS_F | |
| BEN_BENEFIT_RELATIONS_F | |
| PER_LDAP_REQUESTS | |
| PER_ACTION_OCCURRENCES | |
| 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_LOCATION_DETAILS_F_TL | |
| PER_LOCATION_EXTRA_INFO_F | |
| PER_LOCATION_LEG_F | |
| PER_LOCATION_DETAILS_F_TL | |
| PER_LOCATION_DETAILS_F | |
| PER_LOCATIONS | |
| JOBS | PER_ACTION_OCCURRENCES |
| PER_VALID_GRADES_F | |
| PER_JOBS_F_TL | |
| PER_JOBS_F | |
| JOB FAMILY | PER_ACTION_OCCURRENCES |
| PER_JOB_FAMILY_F JOBF | |
| PER_JOB_FAMILY_F_TL JOBF_TL | |
| POSITION | PER_POSITION_LEG_F |
| PER_POSITION_EXTRA_INFO_F | |
| HR_ALL_POSITIONS_F_TL | |
| HR_ALL_POSITIONS_F | |
| BUSINESS UNIT | PER_ACTION_OCCURRENCES |
| HR_ORG_UNIT_CLASSIFICATIONS_F | |
| HR_ORGANIZATION_INFORMATION_F | |
| HR_ORGANIZATION_UNITS_F_TL | |
| HR_ALL_ORGANIZATION_UNITS_F | |
| DEPARTMENT | PER_ACTION_OCCURRENCES |
| HR_ORG_UNIT_CLASSIFICATIONS_F | |
| HR_ORGANIZATION_INFORMATION_F | |
| HR_ORGANIZATION_UNITS_F_TL | |
| HR_ALL_ORGANIZATION_UNITS_F | |
| GRADES | PER_ACTION_OCCURRENCES |
| PER_GRADES_F_TL | |
| PER_GRADES_F | |
| GRADE RATES | PER_RATES_F_TL |
| PER_RATES_F | |
| PER_RATE_VALUES_F | |
| ELEMENT ENTRY | PAY_ENTRY_PCT_DIST |
| PAY_ELEMENT_ENTRY_VALUES_F | |
| PAY_ENTRY_USAGES | |
| PAY_ELEMENT_ENTRIES_F | |
| CALCULATION CARDS | PAY_DIR_CARDS_F |
| PAY_DIR_CARD_COMP_DEFS_VL | |
| PAY_DIR_CARD_DEFINITIONS_VL | |
| PAY_DIR_CARD_COMPONENTS_F | |
| PAY_CALC_TYPES_VL | |
| PAY_RANGE_ITEMS_F | |
| PAY_VALUE_DEFINITIONS_VL | |
| PAY_DIR_COMP_DETAILS_F | |
| PAY_DIR_REP_CARDS_F | |
| BENEFITS ENROLLMENT | BEN_PRTT_ENRT_RSLT |
| Benefit Plan | BEN_PL_F |
| Benefit Plan Options | BEN_OPT_F |
| BEN_PRTT_RT_VAL | |
| BEN_ACTY_BASE_RT_F | |
| BEN_PER_BENEFIT_GROUP_F | |
| BEN_BENFTS_GRP | |
| BEN_LER_F | |
| BEN_PER_IN_LER | |
| Plan Type Record | BEN_PL_TYP_F |
| Dependent Record | BEN_ELIG_CVRD_DPNT |
| Beneficiary Record | BEN_PL_BNF |
| Absence Accrual Entries | ANC_PER_ACRL_ENTRY_DTLS |
| Absence Plan Translation | anc_absence_plans_f_tl |
| Absence Plan Table | anc_absence_plans_f |
| Absence Accrual Entries | ANC_PER_ACCRUAL_ENTRIES |
| Absence Plan Enrollment | ANC_PER_PLAN_ENROLLMENT |
| Time Card Entries | HWM_EXT_TIMECARD_DAY_V |
| Work Schedules | ZMM_SR_SCHEDULES_B |
| Reference Data Set | FND_SETID_SETS_VL (join where setup table SET_ID = SET_ID of RDS table) |
| System Person Type (e.g., Employee, Contingent Worker, Nonworker) | PER_PERSON_TYPES (join on assignment person_type_id, select SYSTEM_PERSON_TYPE) PER_PERSON_TYPES_VL (view) |
| User Person Type (Empl Class in PeopleSoft) | PER_PERSON_TYPES_TL (join on assignment person_type_id, select USER_PERSON_TYPE) PER_PERSON_TYPES_VL (view) |
| Supervisor | PER_ASSIGNMENT_SUPERVISORS_F (find person_id of supervisor then join to per_person_names to get supervisor’s name) |
| Assignment Information | PER_ALL_ASSIGNMENTS_M |
| Assignment Information (last sequence row) | PER_ALL_ASSIGNMENTS_F |
| LOOKUP Tables | FND_LOOKUP_TYPES FND_LOOKUP_VALUES_TL HCM_LOOKUPS (view) HR_LOOKUPS (view) |
| Job Function | HR_LOOKUPS (select meaning where lookup_type = ‘JOB_FUNCTION_CODE’, join on job_function code) |
| Personal Data (DOB, DOD, Birth Country) | PER_PERSONS PER_PERSONS_V (view) |
| Area of Responsibility | PER_ASG_RESPONSIBILITIES |
| Actions and Action Reasons | PER_ACTIONS_B (stores actions and has a foreign key of action type) PER_ACTIONS_TL (translated description of the action, i.e., the action name rather than code; contains languages) PER_ACTION_TYPES_TL (stores action types which allow the grouping of the actions; contains languages) PER_ACTION_TYPES_B (stores Action Types which are the predefined business processes seeded by Oracle and not customer extensible) PER_ACTION_REASON_USAGES (intersection table to have many to many relationships between Actions and Action Reasons) PER_ACTION_REASONS_B (stores reasons for all actions) PER_ACTION_REASONS_TL (translated description of the reason, i.e., the reason name rather than code; contains languages) |
| Audit Tables | If there is one, it’s the regular table name followed by an underscore “_” ex. PER_ALL_ASSIGNMENTS_M_. Auditing must be turned on first |
Core HR Work Structures Entity Relationship Diagrams
Core HR Transactional Tables Entity Relationship Diagrams
Payroll Element Entry Entity Relationship Diagram
SQL Developer like tool for HCM Cloud for FREE
If you are looking for a SQL Developer like tool for HCM Cloud, please check out the FREE tool available on cloud from DataFusing team.
FREE HCM Cloud DEMO Vision Instance
If you are looking for a DEMO VISION instance access, please check out this post:
Note: This list is not the exhaustive list of tables.
If you want the complete list of tables, you can refer the below links:
Tables and Views for Human Resources 20A
Tables and Views for Common Features 20B
Geat one!!