How to create Extra information type (EIT) in Oracle HRMS

What is an EIT??

EIT is used to store some extra information about


  • Employee
  • Assignments
  • Jobs
  • Positions
  • Locations
  • Previous Job
  • Contacts
and some other as well.



Features:

EIT is a DFF.

EIT is used to store data, where same data is changed quite often.


EIT can be opened at Multiple levels, so very helpful in storing as detailed data as possible.

How to create an EIT??

Navigation: System Administrator --> Application --> Flexfield -->  Descriptive --> Segments

Search flexfield title by name Extra Person Information, as shown below.

How to create Extra information type (EIT) in Oracle HRMS


Unfreeze the key flexfield and add a new record under the Context Field Values section as shown below.

How to create Extra information type (EIT) in Oracle HRMS Core HR


Press the Segments button

Create the number of segments as desired and attach validation sets to each field accordingly as shown below.


How to create Extra information type (EIT) in Oracle HRMS




Save & Close. Don't forget to Freeze Flexfield Definition.

Now switch to Global HRMS Manager Responsibility.

Now we need to run the concurrent Program named "Register Extra Information Types (EITs)"

How to create Extra Information type (EIT) in Oracle HRMS


After the request is completed successfully, navigate to

Navigation: Global HRMS Manager -->  Security --> Information Types Security

Search for your relevant responsibility, add the EIT under the selected responsibility as shown below.


How to Create Extra Information Type (EIT) in Oracle HRMS

Let’s check that either SIT has been successfully registered or not.

Navigation: Global HRMS Manager --> People --> Enter & Maintain --> Others --> Extra Information

How to create Extra information type (EIT) in Oracle HRMS


Query:

SELECT PEI_INFORMATION1 PASSPORT_NUMBER,
       TO_DATE (SUBSTR (PEI_INFORMATION2, 1, INSTR (PEI_INFORMATION2, ' ') - 1),
                'YYYY/MM/DD'
               ) PASSPORT_EXPIRY_DATE
  FROM PER_PEOPLE_EXTRA_INFO
 WHERE INFORMATION_TYPE = 'XX_EXAMPLE_EIT'




Kindly provide your feedback.


Leave a comment for any query.





7 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Thanks it helped a lot , but you have to put a prefix of the legislation instead of xx in the second screen
    i.e , EG_EXAMPLE_EIT (for Egypt for example)
    PA_EXAMPLE_EIT (for Pakistan for example)

    ReplyDelete
  3. Thank you for sharing this useful information and it is very effective for the people who are all looking to get the details on Human Resource Management System..

    ReplyDelete
  4. can you tell me why we are using SUBSTR (PEI_INFORMATION2, 1, INSTR (PEI_INFORMATION2

    ReplyDelete
  5. good and comprehensive article. helpful for oracle consultant

    ReplyDelete