Some of the useful Table List in Oracle HCM Cloud environment

Table Name	Description
Table Name : PER_PERSONS Schema : FUSION Object owner : PER Object type : TABLE Tablespace : APPS_TS_TX_DATA Primary Key Name : PER_PERSONS_PK Primary Key Column1 : PERSON_ID Primary Key Column2 : Primary Key Column3 : Primary Key Column4 : Primary Key Column5 :	This table is new for Fusion, and is created to assist BC4J architecture by providing a non-date tracked parent table to act as the parent for all tables in the Person Model, even PER_ALL_PEOPLE_F itself
Table Name : PER_ALL_PEOPLE_F Schema : FUSION Object owner : PER Object type : TABLE Tablespace : APPS_TS_TX_DATA Primary Key Name : PER_PEOPLE_F_PK Primary Key Column1 : PERSON_ID Primary Key Column2 : EFFECTIVE_START_DATE Primary Key Column3 : EFFECTIVE_END_DATE Primary Key Column4 : Primary Key Column5 :	This table will store core personal data that is not expected to vary by Legislation Code, or has need of a global value that is independent of the Legislation Code context. Data is stored with date effectivity, but need not functionally change over time. Values that are static over time will be duplicated to each new date effective instance of a row with the same person_id.
Table Name : PER_ALL_ASSIGNMENTS_M Schema : FUSION Object owner : PER Object type : TABLE Tablespace : FUSION_TS_TX_DATA Primary Key Name : PER_ALL_ASSIGNMENTS_M_PK Primary Key Column1 : ASSIGNMENT_ID Primary Key Column2 : EFFECTIVE_START_DATE Primary Key Column3 : EFFECTIVE_END_DATE Primary Key Column4 : EFFECTIVE_LATEST_CHANGE Primary Key Column5 : EFFECTIVE_SEQUENCE	This stores two levels of the 3-Tier Model: Employment/Placement Terms (Level 2) and Assignments (Level 3). The assignment type is used to differentiate between these two levels as well as it continues to differentiate among employee, contingent worker, applicants, and benefits assignments. This is date-tracked and allows multiple changes in a day.
Table Name : PER_PERIODS_OF_SERVICE Schema : FUSION Object owner : PER Object type : TABLE Tablespace : TRANSACTION_TABLES Primary Key Name : PER_PERIODS_OF_SERVICE_PK Primary Key Column1 : PERIOD_OF_SERVICE_ID Primary Key Column2 : Primary Key Column3 : Primary Key Column4 : Primary Key Column5 :	This table stores all information related to the person?s Work Relationships. An Work Relationship denotes a formal relationship between a person and a legal employer. Therefore, this table will hold information for employees and contingent workers. Current design allows for a person to have multiple active ?periods of service? as long as they are for different legal entities. This is not Effective Dated.
Table Name : PER_ASSIGNMENT_EXTRA_INFO_M Schema : FUSION Object owner : PER Object type : TABLE Tablespace : FUSION_TS_TX_DATA Primary Key Name : PER_ASSIGN_EXTRA_INFO_M_PK Primary Key Column1 : ASSIGNMENT_EXTRA_INFO_ID Primary Key Column2 : EFFECTIVE_START_DATE Primary Key Column3 : EFFECTIVE_END_DATE Primary Key Column4 : EFFECTIVE_LATEST_CHANGE Primary Key Column5 : EFFECTIVE_SEQUENCE	This stores extensible data (Customer, Localization or Verticalization) for Assignments or Sets of Employment/Placement Terms. Changes are related to making this table "Effective Dated".
Table Name : PER_ASSIGNMENT_SUPERVISORS_F Schema : FUSION Object owner : PER Object type : TABLE Tablespace : FUSION_TS_TX_DATA Primary Key Name : PER_ASSIGNMENT_SUP_F_PK Primary Key Column1 : ASSIGNMENT_SUPERVISOR_ID Primary Key Column2 : EFFECTIVE_START_DATE Primary Key Column3 : EFFECTIVE_END_DATE Primary Key Column4 : Primary Key Column5 :	This stores the supervisors associated to a particular assignment. This supports different relationships established between a person and a particular supervisor. One person could have one functional manager (line manager who has absolute control over the person) and a ???project manager??? (project leader who controls a project and organizes resources/people).
Table Name : PER_ASSIGN_WORK_MEASURES_F Schema : FUSION Object owner : PER Object type : TABLE Tablespace : FUSION_TS_TX_DATA Primary Key Name : PER_ASSIGN_WORK_MEASURES_F_PK Primary Key Column1 : ASSIGN_WORK_MEASURE_ID Primary Key Column2 : EFFECTIVE_START_DATE Primary Key Column3 : EFFECTIVE_END_DATE Primary Key Column4 : Primary Key Column5 :	This table holds information about the HR budget values for an assignment. An Assignment may be budgeted using headcount, FTE (full time equivalent), points or any other user defined units. Oracle HRMS sums the budget values held in this table for employee assignment when calculating actual headcount figures. This table has been renamed for Fusion. It was formerly known as PER_ASSIGNMENT_BUDGET_VALUES_F.