Upgrade Planning for Migrating Siebel Address Data
In previous releases, address data was stored as follows:
The relationship between person and address was 1:M and was stored in the table S_ADDR_PER.
The relationship between account and address was 1:M and was stored in S_ADDR_ORG.
Both tables included a column ADDR_NAME, which is a computed value based on other attributes in the address table.
The user key for S_ADDR_PER included PER_ID and ADDR_NAME.