personal data change

[Mandar]

hi all
i am inthe process of exctactingdata from oracle database for hrms
i want to extract only the personal data of the employee which has been changed for that pay period
please help me as to how to go about it
if there are any documents available for it please forward me t
thanks
Mandar

[safdar_hassan]

Hi Mandar,

In HRMS most of the tables are date tracked i.e. when ever u make a change in the record a new record is inserted with new date (effecting_start_date) and the previous record is updated with end date(effecting_end_date).

for example you want all the persons personal data changed in the month of feb 2007. following query might help u to understand the idea.

select *
from per_all_people_f papf where
papf.effective_start_date between '01-FEB-2007' and '28-FEB-2007'

[key]

hi hassan,

good explanation, but how do we know that what changes are made ???

[eng_ahmad_2007]

Dears,

Through Datetracking you can follow the historical changes made on Employees Records. When you are using Forms interface, You can use the datetrack history icon to see the changes made.

But if you want to use a query in the database that retrieves all the records for a single assignment then compares the columns one by one and distingusishes the changed values.

I hope this is useful...

Regards,

Ahmad Ghanem
Senior Oracle HRMS Consultant