Oracle Core HR‎ > ‎

Summary







Technical Aspect of Core-HR

 

Let’s see the tables that are used in Core-HR.

Note:

  • In the table below, if the Date tracked column is marked as Yes, assume the Primary key to be Composite. The given Primary will bind with the two date tracked columns to make the Composite Primary key.
  • Some of the values in the column Table could be a view / synonym.

 

 Table Name

 Date Tracked?

 Primary Key

 Description

HR_ALL_ORGANIZATION_UNITS

No

ORGANIZATION_ID

Stores the details of the Organizations defined in the system, including the type and BUSINESS_GROUP_ID.

HR_LOCATION_EXTRA_INFO

No

LOCATION_EXTRA_INFO_ID

Location EIT table

HR_LOCATIONS_ALL

No

LOCATION_ID

Stores the locations defined in the system with address.

HR_ORGANIZATION_INFORMATION

No

ORG_INFORMATION_ID

Stores the EIT attached to HR Organization Classifications.

PER_ADDRESSES

No

ADDRESS_ID

It is a DATE_TO table and stores the address of persons with Primary flag and address style.

PER_ALL_ASSIGNMENTS_F

Yes

ASSIGNMENT_ID

Stores the assignment details of the Person. More details can be found in Lexicons.

PER_ALL_PEOPLE_F

Yes

PERSON_ID

Stores the person related information. More details can be found in Lexicons.

PER_ASSIGNMENT_EXTRA_INFO

No

ASSIGNMENT_EXTRA_INFO_ID

Stores the Assignment EITs

PER_BUSINESS_GROUPS

No

BUSINESS_GROUP_ID

Stores the Business Group information, it is a DATE_TO table

PER_GRADES

No

GRADE_ID

Sores Grades related information

PER_JOB_EXTRA_INFO

No

JOB_EXTRA_INFO_ID

Stores the Job EIT

PER_JOBS

No

JOB_ID

Stores the Job related information

PER_ORGANIZATION_STRUCTURES

No

ORGANIZATION_STRUCTURE_ID

Stores the Organization hierarchy

PER_PAY_BASES

No

PAY_BASIS_ID

Stores the Pay Basis related information along with the Annualization factor

PER_PAY_PROPOSALS

No

PAY_PROPOSAL_ID

Stores the Salary of the Employees along with approval details.

PER_PERIODS_OF_SERVICE

No

PERIOD_OF_SERVICE_ID

Stores the service related information, from hire to termination.

PER_PERSON_TYPE_USAGES_F

Yes

PERSON_TYPE_USAGE_ID

This table stores the user Person type with a link to the PERSON_ID for the person. So if we wish to see the valid person types of one person as of a date, this is the table we should look for.

PER_PERSON_TYPES

No

PERSON_TYPE_ID

This table stores the valid System and user person types, along with the BUSINESS_GROUP_ID

PER_PHONES

No

PHONE_ID

This table stores the phone numbers of persons.

PER_POSITION_EXTRA_INFO

No

POSITION_EXTRA_INFO_ID

Stores Position EIT

PER_POSITIONS

No

POSITION_ID

Stores Position details.

PER_SECURITY_PROFILES

No

SECURITY_PROFILE_ID

Stores the security profiles.

 

Although we have considered all the important concepts of Core-HR there are a lot to it. However those functionalities are there to help certain modules only. Hence the attempt was to add those functionalities with the modules they are used for. So keep on turning the pages and there are a lot to come with Core- HR.

 

Summary

In this chapter we discussed about the basic of Core HRMS including the concepts like date tracking, how E-Biz stores different data, Person types and the different flex fields used in Core-HR. We then moved our focus towards the Implementation steps, we discussed about the job, position, locations and grades. We also discussed about different Organization classifications and Organization hierarchy. We then moved to salary administration techniques, and discussed the different tools used in Oracle Core-HR to make the administration simple and elementary. We discussed about the Multi-Org architecture and how is it used to help big enterprises. Finally the underlying tables are discussed with their usage and relationship with others.

Comments