Personal data integration between HR 9.0 and CRM 9.0

Scenario 1
Add a new employee with eff dt (sysdate-3) – back dated row
Result 1
One row each in
BO_CM – start date as (sysdate-3) and end date 12/31/2999
BO_CM_USE - start date as (sysdate-3) and end date 12/31/2999 and for role 4 and primary as ‘Y’
CM
BO_NAME
Two rows in BO_ROLE - Role 1 and 4

Scenario 2
Add a new row with eff dt (sysdate) for name change – today’s date
Result 2
BO_NAME has two rows with sysdate as seq nbr 2 and primary as ‘Y’

Scenario 3
Add a new row with eff dt (sysdate+3) for name change
Result 3
BO_NAME has two rows with 04/23 as seq nbr 3 and primary as ‘N’

Scenario 4
Add a row for phone number – Type Main – Preferred check box ‘Y’
Result 4
It creates one row each in: (There is no Effdt for phone grid, by default it takes system date)
BO_CM – start date as (sysdate) and end date 12/31/2999
BO_CM_USE - start date as (sysdate) and end date 12/31/2999 and for role 4 and primary as ‘Y’
CM

Scenario 5
Add a row for phone number – Type Work- Preferred check box ‘N’
Result 5
It creates one row each in: (There is no Effdt for phone grid, by default it takes system date)BO_CM – start date as (sysdate) and end date 12/31/2999
BO_CM_USE - start date as (sysdate) and end date 12/31/2999 and for role 4 and primary as ‘N’
CM

Scenario 6
Change the row for phone number – Type Work- Preferred check box ‘Y’
Result 6
Updated successfully in CRM

Scenario 7
Add one more effective dated row (sysdate-1) under Home Address type
Result 7
One row is inserted in BO_CM without changing the end date of the previous effective row (!)
In BO_CM_USE the end date of the previous effective row is changed to system date
Also new PROFILE_CM_SEQ is also created

Scenario 8
In Correct History Mode change effective dated row (sysdate-3) under Home Address type – make status as ‘I’
Result 8
In BO_CM the end date of the row is changed to system date
In BO_CM_USE the end date of the row is changed to system date

Scenario 9
In Correct History Mode change effective dated row (sysdate-2) under Home Address type
Result 9
In BO_CM the end date of the row is NOT changed to the new date but is row is updated with the latest timestamp
In BO_CM_USE the end date of the row is changed to the changed date and one more row is inserted for the same profile cm seq number with end date as 12/31/2999

Notes:
When just a person is created BO_CM_USE has Role 1
When a person is created with job data BO_CM_USE has Role 4 only and no role 1