CORE HR: Inserting records into EIT

Another intersting business case that was discussed recently:

Question: Is it possible to insert a row of data in between a set of records in EIT?

Analyst Description: Client has populated five rows for a particular employee in an EIT, one record for each year. After the records were stored, it was then realized that one row was missed out for the third row. Client wants to insert the record in between rows three and four in the existing set. Is it possible to do that?

Answer: It is not possible to ‘insert’ a row in between a set of records. Though it appears that Oracle allows to enter the record in the right spot, once you save the record, you will find that the record is saved at the bottom.

Oracle generates an internal sequence for each row. And as you know the sequence is a running serial number something like 6001, 6002, 6003, 6004 etc. So when you insert a record, the new record will always get the next sequence number and hence will be displayed at the bottom of the heap.

Here’s an example:
Client has a couple of records already inserted ( for Academic for performance and succession) and saved and then realizes that a record which was to be inserted in between.

The client tries to insert a record between the 2000 and 2003 records. Click on the blank field and the DFF will open up. Enter appropriate values and save the record. Select the record and enter the values in the DFF.

Once the values are entered, submit the record.

Save the record and return to the application. You can see the record displayed at the bottom of the set, rather than the place where you inserted it.