Schema Differences Between SEA and SIA Repositories

The following table displays schema differences between the SEA repository and the SIA repository.

SEA Repository	SIA Repository	SEA to SIA Migration Approach
Account Addresses are stored in the S_ADDR_ORG table. Other addresses are stored in the S_ADDR_PER table.	The S_ADDR_ORG table is obsolete. Address data is stored in the S_ADDR_PER table.	Data is converted automatically through upgrade scripts.
Organization Relationships are stored in the S_ORG_REL table. Other party relationships are stored in the S_PARTY_REL table.	All party relationships, including organizations, are stored in S_PARTY_REL. The S_ORG_REL table is obsolete.	Manual data migration required. For instructions see 476479.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 312.
Contact relationships are stored in the S_CONTACT_REL table. Other party relationships are stored in the S_PARTY_REL table.	All party relationships, including organizations, are stored in the S_PARTY_REL table. The S_CONTACT_REL table is obsolete.	Manual data migration required. For instructions see 476479.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 312.
Household relationships are stored in the S_PER_ORG_UNIT table.	Household relationships are stored in the S_PARTY_PER table.	Manual data migration required. For instructions see 476479.1 (Article ID) on My Oracle Support. This document was previously published as Siebel Technical Note 312.