Oracle EBS HRMS Tables

 Oracle EBS HRMS Table Name and Description:-

HR_ALL_ORGANIZATION_UNITS :-  Organization unit definitions.

HR_ALL_ORGANIZATION_UNITS_TL :- Translated organization unit name definitions.

HR_ALL_POSITIONS_F :- Position definition information.

HR_ALL_POSITIONS_F_TL :- Translation table

HR_API_TRANSACTIONS :- Kiosk processes in progress

HR_API_TRANSACTION_STEPS :- Kiosk workflow data rows

HR_API_TRANSACTION_VALUES :- Kiosk workflow data columns and values

HR_ASSIGNMENT_SETS :- Formula definitions that identify sets of assignments.

HR_ASSIGNMENT_SET_AMENDMENTS :- Identifies explicit include and exclude rules for an assignment set.

HR_ASSIGNMENT_SET_CRITERIA :- Identifies individual criteria in the definition of an assignment set.

HR_DM_SEQUENCE_DEFINITIONS :- Table containing Sequence Name information for the PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN applications.

HR_DM_SEQUENCE_HISTORIES :- Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are made to enable sequence historytracking.

HR_LEGISLATION_INSTALLATIONS :- Status of each product/legislation combination installed

HR_LOCATIONS_ALL :- Work location definitions.This table will contain the various LOCATIONS in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct location name from the employee.

HR_LOCATIONS_ALL_TL :- Translated location codes and descriptions.

HR_LOCATION_EXTRA_INFO :- Extra information for a location.

HR_LOCATION_INFO_TYPES :- Types of extra information that may be held against a Location.

HR_NAME_FORMATS :- Contains the format masks used to determine the displayed formats of personal names in Applications. Oracle will seed rows in this table which cannot be deleted,but can be modified by customers. Additional rows can be created.

HR_ORGANIZATION_INFORMATION :- Additional attributes of an organization, dependent on class or organization information type.

HR_ORG_INFORMATION_TYPES  :- Information types that are used to add information for an organization.

HR_ORG_INFO_TYPES_BY_CLASS :- Defines organization information types for specific organization classifications.

HR_SOFT_CODING_KEYFLEX :- Legislation specific information for payrolls, organizations and assignments.

PER_ABSENCE_ATTENDANCES :- Records of absence, or attendance for an employee.

PER_ABSENCE_ATTENDANCES_EFC :- This is a copy of the PER_ABSENCE_ATTENDANCES  table which is populated by the EFC (Euro as Functional Currency) process.

PER_ABSENCE_ATTENDANCE_TYPES :- User defined absence types.

PER_ABS_ATTENDANCE_REASONS :- Valid absence reasons for an absence type.

PER_ABS_ATTENDANCE_TYPES_TL :- Holds translated information for Absence Types

PER_ADDRESSES :- This table will store all the information which is been entered in the employee address form.

PER_ALL_ASSIGNMENTS_F :- Employee and applicant assignment details.This table will store all the information which is been entered in the employee assignment form.

PER_ALL_PEOPLE_F :- DateTracked table holding personal information for employees, applicants and other people.This table will provide us the very basic information about the employee. The very data from the first screen we see when we open the 'People -> Enter and Maintain' form goes into this table.

PER_ALL_POSITIONS :- Dual-maintained position definition information.

PER_ALL_VACANCIES :- Vacancies within a specific requisition.

PER_ANALYSIS_CRITERIA :- Flexfield combination table for the personal analysis key flexfield.

PER_APPLICATIONS :- Applications for employment.

PER_APPRAISALS :- An  appraisal is a record of an evaluation of a person by others.

PER_COMPETENCES :- A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess.

PER_COMPETENCES_TL :- This table is used for language translations

PER_COMPETENCE_DEFINITIONS :- COMPETENCES Key flexfield combinations table

PER_COMPETENCE_ELEMENTS :- A competence element is used to record an individual competence and an evaluation rating.

PER_COMPETENCE_OUTCOMES :- Competence outcomes

PER_COMP_ELEMENT_OUTCOMES :- The outcomes achieved towards a given Competency .

PER_CONTACT_EXTRA_INFO_F :- Extra information for a contact relationship.

PER_CONTACT_INFO_TYPES :- Types of extra information that may be held against a contact relationship.

PER_GRADES :- Grade definitions for a business group.

PER_GRADES_TL :- Trnslated fields for per_grades

PER_GRADE_DEFINITIONS :- Grade key flexfield combinations table.

PER_IMAGES :- Images for a designated row in a designated table.

PER_INFO_TYPE_SECURITY  :- Cross table between Responsibilty and Info_type tables, used to secure info types based on responsibility.

PER_JOBS :- Jobs defined for a Business Group.

PER_JOBS_TL :- Translated  columns for per_jobs

PER_JOB_DEFINITIONS :- Job key flexfield combinations table.

PER_JOB_EVALUATIONS :- Job evaluation details for specific jobs or positions.

PER_JOB_EXTRA_INFO :- Extra information for a job.

PER_MEDICAL_ASSESSMENTS :- Hold Medical Assessment information for one person

PER_PAY_BASES :- Definitions of specific salary bases.This table will contain the various types of PAY BASES in oracle. This table is been linked with the per_all_assignments_f table to retrieve the correct pay basis name from the employee.

PER_PAY_PROPOSALS :- Salary proposals and performance review information for employee assignments.

PER_PERIODS_OF_SERVICE :- Period of service details for an employee.

PER_PERSON_ANALYSES :- Special information types for a person.

PER_PERSON_TYPES :- Person types visible to specific Business Groups.

PER_PERSON_TYPES_TL :- Translated person types information.

PER_PERSON_TYPE_USAGES_F :- This table will store the correct person type of the particluar employee. We should never depend on the person type present in the per_all_people_f table. Instead we need to link the person_id with this table and get the correct person type.

PER_PHONES :- holds phone numbers for current and ex-employees, current and exapplicants and employee contacts.

PER_POSITION_DEFINITIONS :- Combinations of segments stored in the PER_POSTIONS table.

PER_POSITION_EXTRA_INFO :- Extra information for a position.

PER_POSITION_INFO_TYPES :- Types of extra information that may be held against a position.

PER_POSITION_STRUCTURES :- Position Hierarchy names.

PER_POS_STRUCTURE_ELEMENTS :- Position hierarchy details showing parent-child reporting relationships between positions.

PER_PREVIOUS_EMPLOYERS

PER_QUALIFICATIONS :- A record of educational qualification, certificates, licenses, etc that a person holds or is acquiring.

PER_QUALIFICATIONS_TL :- Translated qualification details.

PER_QUALIFICATION_TYPES :- Maintains the list of qualiification types that can be attained.

PER_QUALIFICATION_TYPES_TL :- Maintains the list of qualiification type translations

PER_SPECIAL_INFO_TYPES :- Special information types available to a Business Group.

PER_SPECIAL_INFO_TYPE_USAGES :- Limits usage of special information types to specific windows.

PER_VALID_GRADES :- Lists valid grades for jobs and positions.

PER_WORK_INCIDENTS  :- Holds information on Incidents that happen at work or en route to work, for example, an industrial accident

PER_WORK_INCIDENTS_EFC :- This is a copy of the PER_WORK_INCIDENTS  table which is populated by the EFC (Euro as Functional Currency) process.