Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Enterprise Integration Manager Administration Guide > Importing Data > Special Considerations for Imports >
Importing Party Records
There are columns in the S_PARTY table which must be populated when importing party records such as Contacts, Positions, and so on. The following are the required columns, with their possible values:
- PARTY_TYPE_CD. Indicates the type of party data that is being imported. The PARTY_TYPE_CD column can have the following values:
NOTE: No custom values are allowed in the PARTY_TYPE_CD column. This column must contain one of the values listed above.
- PARTY_UID. PARTY_UID is populated by default through the Siebel upgrade process and the application UI with the ROW_ID of the party record (for example, Contact or Position) that is being created, but you maintain the value for this column. The value does not have to remain identical with the ROW_ID.
With EIM, the PARTY_UID gets populated with the value specified in the EIM table for this column. PARTY_UID may have a calculated value with logic, such as a combination of email and other data. For this reason, PARTY_UID is defined as VARCHAR100.
- ROOT_PARTY_FLG. ROOT_PARTY_FLG supports performance for Oracle. The following are possible queries to get top-level Positions, Organizations, or Access Groups. Try using the first query before the second one:
- WHERE ROOT_PARTY_FLG='Y'. ROOT_PARTY_FLG is set to 'Y' for top-level Positions, Organizations, and Access Groups as it applies only to these party subtypes. It is set to 'N' for other party subtypes.
- WHERE PAR_PARTY_ID IS NULL. Oracle cannot use an indexed access path because there are no index entries for NULL, so ROOT_PARTY_FLG was added.
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Siebel Enterprise Integration Manager Administration Guide Published: 05 January 2004 |