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.