Where can we track the Address Change Details either through forms or tablesHow can we differentiate the old and new addresses
Thanks in advance
Check the table per_addresses.
Addresses table is not date-tracked, but it is a dated-table, you will see two columns Date_From & Date_To
Thanks for the reply.
can a person have two different mailing addresses irrespective of old and new address.
How can we track which employee has a secondary (i.e., mailing address)
select person_id, count(*)
where trunc(sysdate) between date_from and nvl(date_to,sysdate)
group by person_id
having count(*) > 1;
check columns ADDRESS_TYPE & PRIMARY_FLAG.
These determine whether the address is primary or not, and also what type of address it is.