Data and Related Interface Tables

The process for importing syndicated data takes advantage of the fact that syndicated data is read-only. Because the row ID on the S_SYND_DATA table is never referred to anywhere else in the Siebel data model, it can be populated with dummy values that differ from usual row IDs. The application administrator uses SQL*Loader to populate the ID field with a unique sequential value, a process which provides either full or partial table-level extraction. Using views in the Administration - Syndicated Data screen, you can define complex routing rules for syndicated data.

The following table shows the relationships between the data, interface tables, and base tables.

Data	Interface Table	Base Table	Table Description
Accounts Contacts	EIM_TGT	S_TGT	Accounts Contacts Targeting List
Accounts Contacts	EIM_TGT_ADMIN	S_TGT_ADMN	Targeting Period
Accounts Contacts	EIM_TGT_ADMIN	S_TGT_ITM_ADMN	Accounts Contacts - Targeting Products
Accounts Contacts	EIM_TGT_ADMIN	S_GT_COL_MAP	Targeting Product Column Mappings
Account Details	EIM_ACCNT_DTL	S_ORG_EXT	Organization
Account Details	EIM_ACCNT_DTL	S_ORG_EXT_LSX	1:1 Extension table for Account Types
Account Details	EIM_ACCNT_DTL	S_ORG_EXT_X	1:1 Account Best Times to Visit
Activities	EIM_ACTIVITY	S_EVT_ACT	Activities
Activities	EIM_ACTIVITY1	S_EVT_ACT	Activities Only User Key
Activities	EIM_ACTIVITY1	S_ACT_SIGN	Signatures
Activities	EIM_ACTIVITY2	S_EVT_ACT	Activities Only User Key
Activities	EIM_ACTIVITY2	S_ACT_PRDINT	Activity Products
Activities	EIM_ACTIVITY2	S_ACT_ISS	Activity Issues
Activities	EIM_ACTIVITY2	S_ACT_PROD_ISS	Issues for Activity Products
Addresses	EIM_ADDR_ORG	S_ADDR_ORG	Account Addresses including Bricks
Agreements and Contracts	EIM_AGREEMENT	S_DOC_AGREE	Agreements and Contracts
Agreements and Contracts	EIM_AGREE_LS	S_DOC_AGREE	Contracts
Agreements and Contracts	EIM_AGREE_LS	S_AGREE_PAY	Contract Payments
Agreements and Contracts	EIM__ENTLMNT	S_ENTLMNT	Entitlements and Contract Price Group
Agreements and Contracts	EIM__ENTLMNT	S_ENTLMNT_ITEM	Price Group Products
Agreements and Contracts	EIM__ENTLMNT	S_ENTLMNT_FEE	Nonproduct Fees
Agreements and Contracts	EIM__ENTLMNT	S_ENTLMNT_ITEM_FEE	Product Fee Price Group
Brick	EIM_AREA_LS	S_AREA_LS	Bricks
Chat and Discussions	EIM_DISCN_LS	S_TOPIC_LS	Chat/Discussion Topics
Chat and Discussions	EIM_DISCN_LS	S_TOPIC_CON_LS	Chat User Registration
Chat and Discussions	EIM_DISCN_LS	S_MESG_BRD_LS	Message Board
Clinical	EIM_CL_ACT_LS	S_EVT_ACT	Clinical Activity Columns
Clinical	EIM_CL_DSGN_LS	S_CL_DSGN_LS	Clinical Designs
Clinical	EIM_CL_PGM_LS	S_CL_PGM_LS	Clinical Programs
Clinical	EIM_CL_PGM_LS	S_CL_PGM_ATT_LS	Clinical Program Attachments
Clinical	EIM_CL_PGM_LS	S_CL_PGM_APP_LS	Clinical Program Applications
Clinical	EIM_CL_PTCL_LS	S_CL_PTCL_LS	Clinical Protocols
Clinical	EIM_CL_PTCL_LS	S_CL_PTCL_LSXM	1:M Protocol Extension Table
Clinical	EIM_CL_PTCL_LS	S_CL_PTL_ATT_LS	Clinical Protocol Attachments
Clinical	EIM_CL_PTCL_LS	S_CL_PTL_POS_LS	Clinical Protocol Positions
Clinical	EIM_CL_PTCL_LS	S_CPTCL_DSGN_LS	Clinical Protocol Designs
Clinical	EIM_CL_SUBJ_LS	S_CL_SUBJ_LS	Clinical Subjects
Clinical	EIM_CL_SUBJ_LS	S_CL_SUBJ_ST_LS	Clinical Subject Status
Clinical	EIM_CL_SUBJ_LS	S_CL_SJ_CSNT_LS	Clinical Subject Consent
Clinical	EIM_CL_SUBJ_LS	S_CL_SBJ_ATT_LS	Clinical Subject Attachments
Clinical	EIM_PTL_SITE_LS	S_PTCL_SITE_LS	Clinical Protocol Sites
Clinical	EIM_PTL_SITE_LS	S_PTL_ST_POS_LS	Clinical Protocol Site Positions
Clinical	EIM_PTL_SITE_LS	S_PTL_ST_ATT_LS	Clinical Protocol Site Attachments
Clinical	EIM_PTL_SITE_LS	S_PTL_ST_CON_LS	Clinical Protocol Site Contacts
Clinical	EIM_PTL_SITE_LS	S_PS_STMPVER_LS	Clinical Protocol Site Template Versions
Clinical	EIM_PTL_SITE_LS	S_CL_ACT_EXC_LS	Clinical Protocol Site Activity Exceptions
Clinical	EIM_PTL_SITE_LS	S_CL_PYMNT_LS	Clinical Payments
Clinical	EIM_SBJ_TMPL_LS	S_SUBJ_TMPL_LS	Subject Templates
Clinical	EIM_SBJ_TMPL_LS	S_SBJTMP_VER_LS	Subject Template Versions
Clinical	EIM_TMPL_PLNITM	S_TMPL_PLAN_ITEM	Subject Template Visits
Companies	EIM_ACCOUNT	S_ORG_EXT	Organization
Companies	EIM_ACCOUNT	S_ACCNT_POSTN	Position for Account
Companies	EIM_ACCOUNT	S_ADDR_ORG	Account Addresses
Companies	EIM_ACCOUNT	S_ORG_REL	Account Affiliations
Companies	EIM_ACCOUNT1	S_ORG_EXT	Organization Only User Key
Companies	EIM_ACCOUNT1	S_ACCNT_CLS_RNK	Account Ratings and Rankings
Companies	EIM_ACCOUNT1	S_ACCNT_MED_PROC	Account Medical Procedures
Companies	EIM_ACCOUNT1	S_ACCNT_MED_SPEC	Account Medical Specialties
Contacts	EIM_CONTACT	S_CONTACT	Contacts
Contacts	EIM_CONTACT	S_ADDR_PER	Contact Addresses
Contacts	EIM_CONTACT	S_CONTACT_REL	Contact Affiliations
Contacts	EIM_CONTACT	S_PER_ORG_UNIT	Contact to Account Affiliations and Roles
Contacts	EIM_CONTACT	S_STATE_LIC_LS	Contact State Licenses
Contacts	EIM_CONTACT1	S_CONTACT	Contacts Only User Key
Contacts	EIM_CONTACT1	S_POSTN_CON	Contact Positions
Contacts	EIM_CONTACT1	S_CON_ADDR	Contact Address Usage
Contacts	EIM_CON_DTL	S_CONTACT	Contacts Only User Key
Contacts	EIM_CON_DTL	S_CONTACT_LSX	1:1 Contacts Extension Table
Contacts	EIM_CON_DTL	S_CONTACT_LSXM	1:M Contacts Extension Table
Contacts	EIM_CON_DTL	S_ACCNT_CON_ATT	Accounts Contacts File Attachments
Contacts	EIM_CON_DTL	S_NOTE_ACCT_CON	Accounts Contacts Notes
Formularies	EIM_FRMULRY_LS	S_FORMULARY	Formulary Opportunities
Formularies	EIM_FRMULRY_LS	S_FRMULRY_PROD	Formulary Products
Industry	EIM_INDUSTRY	S_INDUST	Account and Contact Types
Insurance Plans	EIM_INS_PLAN_LS	S_INS_PLAN	Insurance Plans
Medical Education	EIM_ME_EVT_LS	S_ME_EVT_LS	MedEd Events
Medical Education	EIM_ME_EVT_LS	S_ME_EVT_POS_LS	MedEd Event Positions
Medical Education	EIM_ME_EVT_LS	S_ME_EVT_PRD_LS	MedEd Event Products
Medical Education	EIM_ME_EVT_LS	S_ME_EVT_INV_LS	MedEd Event Invitees
Medical Education	EIM_ME_PLN_LS	S_ME_PLN_LS	MedEd Plans
Medical Education	EIM_ME_PLN_LS	S_ME_PLN_MDF_LS	MedEd Plan Funds
Medical Education	EIM_ME_PLN_LS	S_ME_PLN_PRD_LS	MedEd Plan Products
Medical Education	EIM_ME_SES_LS	S_ME_SES_LS	MedEd Sessions
Medical Education	EIM_ME_SES_LS	S_ME_SES_PRD_LS	MedEd Session Products
Medical Education	EIM_ME_SES_LS	S_ME_SES_INV_LS	MedEd Session Invitees
Medical Education	EIM_ME_SES_LS	S_ME_SES_LIT_LS	MedEd Session Literature
Medical Education	EIM_ME_SES_LS	S_ME_SES_MAT_LS	MedEd Session Materials
Medical Procedures	EIM_PROC_LS	S_MED_PROC	Medical Procedures
Medical Specialties	EIM_SPEC_LS	S_MED_SPEC	Medical Specialties
Objectives	EIM_ACCT_SRC	S_ACCNT_SRC	Target Accounts for Objectives
Objectives	EIM_CONTACT2	S_CONTACT	Contacts Only User Key
Objectives	EIM_CONTACT2	S_CAMP_CON	Target Contacts for Objective
Objectives	EIM_SRC	S_SRC	Objectives
Objectives	EIM_SRC	S_SRC_POSTN	Objective Positions
Products	EIM_PROD_INT	S_PROD_INT	Products-Details, Samples, Markets, Lots, and Promotional Items
Products	EIM_PROD_INT1	S_PROD_INT	Products
Products	EIM_PROD_INT1	S_PROD_POSTN	Personal Product List
Products	EIM_PROD_INT1	S_PROD_REL	Product Relations
Samples	EIM_SAMPLE_LS	S_SAMPLE_TXN	Sample Transactions
Samples	EIM_SAMPLE_LS	S_MPL_TXN_ITEM	Sample Transaction Item
Samples	EIM_POSITION	S_POSTN	Positions
Samples	EIM_POSITION	S_STOCK_POSTN	Stock Inventory by Position
Samples	EIM_POSITION	S_STOCK_PERIOD	Stock Period
Signature Disclaimers	EIM_SIGNDIC_LS	S_SIGN_DISC_LS	Signature Disclaimers
Syndicated Data	EIM_SYN_DATA_LS	S_SYND_DATA	Syndicated Data

For further information, see Siebel Enterprise Integration Manager Administration Guide, which lists the contents of each table referred to in the previous table:

• Specific data and file attachments that Siebel EIM can process.

• Names of the interface tables.

• Target base tables mapped to the interface tables.

• Any secondary tables associated with the target tables (where data from the interface tables might ultimately reside).