Most frequently used Tables list in Fusion HCM
Most frequently used Tables list in Fusion HCM

 4,066 total views

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.

Want to learn Fusion Technical tools? Checkout this article

BUSINESS OBJECTBASE RECORDS
PERSONPER_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 DOCUMENTATIONHR_DOCUMENTS_OF_RECORD
WORKRELATIONSHIP BY PERSONHRC_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
LOCATIONPER_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
JOBSPER_ACTION_OCCURRENCES
 PER_VALID_GRADES_F
 PER_JOBS_F_TL
 PER_JOBS_F
JOB FAMILYPER_ACTION_OCCURRENCES
 PER_JOB_FAMILY_F JOBF
 PER_JOB_FAMILY_F_TL JOBF_TL
POSITIONPER_POSITION_LEG_F
 PER_POSITION_EXTRA_INFO_F
 HR_ALL_POSITIONS_F_TL
 HR_ALL_POSITIONS_F
BUSINESS UNITPER_ACTION_OCCURRENCES
 HR_ORG_UNIT_CLASSIFICATIONS_F
 HR_ORGANIZATION_INFORMATION_F
 HR_ORGANIZATION_UNITS_F_TL
 HR_ALL_ORGANIZATION_UNITS_F
DEPARTMENTPER_ACTION_OCCURRENCES
 HR_ORG_UNIT_CLASSIFICATIONS_F
 HR_ORGANIZATION_INFORMATION_F
 HR_ORGANIZATION_UNITS_F_TL
 HR_ALL_ORGANIZATION_UNITS_F
GRADESPER_ACTION_OCCURRENCES
 PER_GRADES_F_TL
 PER_GRADES_F
GRADE RATESPER_RATES_F_TL
 PER_RATES_F
 PER_RATE_VALUES_F
ELEMENT ENTRYPAY_ENTRY_PCT_DIST
 PAY_ELEMENT_ENTRY_VALUES_F
 PAY_ENTRY_USAGES
 PAY_ELEMENT_ENTRIES_F
CALCULATION CARDSPAY_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 ENROLLMENTBEN_PRTT_ENRT_RSLT
Benefit PlanBEN_PL_F
Benefit Plan OptionsBEN_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 RecordBEN_PL_TYP_F
Dependent RecordBEN_ELIG_CVRD_DPNT
Beneficiary RecordBEN_PL_BNF
Absence Accrual EntriesANC_PER_ACRL_ENTRY_DTLS
Absence Plan Translationanc_absence_plans_f_tl
Absence Plan Tableanc_absence_plans_f
Absence Accrual EntriesANC_PER_ACCRUAL_ENTRIES
Absence Plan EnrollmentANC_PER_PLAN_ENROLLMENT
Time Card EntriesHWM_EXT_TIMECARD_DAY_V
Work SchedulesZMM_SR_SCHEDULES_B
Reference Data SetFND_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)
SupervisorPER_ASSIGNMENT_SUPERVISORS_F (find person_id of supervisor then join to per_person_names to get supervisor’s name)
Assignment InformationPER_ALL_ASSIGNMENTS_M
Assignment Information (last sequence
row)
PER_ALL_ASSIGNMENTS_F
LookupsFND_LOOKUP_TYPES
FND_LOOKUP_VALUES_TL
HCM_LOOKUPS (view)
HR_LOOKUPS (view)
Job FunctionHR_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 ResponsibilityPER_ASG_RESPONSIBILITIES
Actions and Action ReasonsPER_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 TablesIf there is one, it’s the regular table name followed by an underscore “_” ex. PER_ALL_ASSIGNMENTS_M_. Auditing must be
turned on first
Tables list

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

Join our fastest growing technology social groups to interact with experts in the Fusion space and get your queries resolved – Telegram group, Facebook Page and LinkedIn Group

The following two tabs change content below.
Sricharan is a Fusion HCM Solution Architect with over 13+ years of overall experience and 5+ years of Fusion experience. He is passionate about technical aspects of Fusion HCM and writes interesting articles on HCM Extracts, HCM Data Loader, Fast Formula, BI Publisher, Integrations and Automation etc.

This Post Has One Comment

Leave a Reply