There are hundreds of tables in Oracle E-Business Suite HRMS, but some are used more frequently than others. When querying, it is important to not only know the common tables that are used, but also to understand how the tables link together. Some of the common tables are listed below.
Common HRMS Tables
The chart above shows some of the most common tables that are used in Oracle HRMS. Often, a column in one table will link to a column in a different table. For example, the primary key PERSON_ID in the PER_ALL_PEOPLE_F table will link to the foreign key PERSON_ID in the PER_ALL_ASSIGNMENTS_F table to connect people to their appropriate assignments. The Entity Relationship Diagram (ERD) below reflects Oracle’s Logical Data Model which illustrates the connections between each table (Click to enlarge).
Here are a few examples of interpretations:
- “A person may have one or many assignments, but an assignment must be assigned to a person”
- “A position must have only one organization, but an organization has one or many positions”
- “A position may be in many assignments, but an assignment be only be linked to one position”