Siebel Innovation Pack 2016: 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.

Table 24 shows the relationships between the data, interface tables, and base tables.

Table 24. Data and Related Interface Tables
Data	Interface Table	Base Table	Table Description
Accounts Contacts	EIM_TGT	S_TGT	Accounts Contacts Targeting List
	EIM_TGT_ADMIN	S_TGT_ADMN	Targeting Period
		S_TGT_ITM_ADMN	Accounts Contacts - Targeting Products
		S_GT_COL_MAP	Targeting Product Column Mappings
Account Details	EIM_ACCNT_DTL	S_ORG_EXT	Organization
		S_ORG_EXT_LSX	1:1 Extension table for Account Types
		S_ORG_EXT_X	1:1 Account Best Times to Visit
Activities	EIM_ACTIVITY	S_EVT_ACT	Activities
	EIM_ACTIVITY1	S_EVT_ACT	Activities Only User Key
	EIM_ACTIVITY1	S_ACT_SIGN	Signatures
	EIM_ACTIVITY2	S_EVT_ACT	Activities Only User Key
		S_ACT_PRDINT	Activity Products
		S_ACT_ISS	Activity Issues
		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
	EIM_AGREE_LS	S_DOC_AGREE	Contracts
	EIM_AGREE_LS	S_AGREE_PAY	Contract Payments
	EIM__ENTLMNT	S_ENTLMNT	Entitlements and Contract Price Group
		S_ENTLMNT_ITEM	Price Group Products
		S_ENTLMNT_FEE	Nonproduct Fees
		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
		S_TOPIC_CON_LS	Chat User Registration
		S_MESG_BRD_LS	Message Board
Clinical	EIM_CL_ACT_LS	S_EVT_ACT	Clinical Activity Columns
	EIM_CL_DSGN_LS	S_CL_DSGN_LS	Clinical Designs
	EIM_CL_PGM_LS	S_CL_PGM_LS	Clinical Programs
		S_CL_PGM_ATT_LS	Clinical Program Attachments
		S_CL_PGM_APP_LS	Clinical Program Applications
	EIM_CL_PTCL_LS	S_CL_PTCL_LS	Clinical Protocols
		S_CL_PTCL_LSXM	1:M Protocol Extension Table
		S_CL_PTL_ATT_LS	Clinical Protocol Attachments
		S_CL_PTL_POS_LS	Clinical Protocol Positions
		S_CPTCL_DSGN_LS	Clinical Protocol Designs
	EIM_CL_SUBJ_LS	S_CL_SUBJ_LS	Clinical Subjects
		S_CL_SUBJ_ST_LS	Clinical Subject Status
		S_CL_SJ_CSNT_LS	Clinical Subject Consent
		S_CL_SBJ_ATT_LS	Clinical Subject Attachments
	EIM_PTL_SITE_LS	S_PTCL_SITE_LS	Clinical Protocol Sites
		S_PTL_ST_POS_LS	Clinical Protocol Site Positions
		S_PTL_ST_ATT_LS	Clinical Protocol Site Attachments
		S_PTL_ST_CON_LS	Clinical Protocol Site Contacts
		S_PS_STMPVER_LS	Clinical Protocol Site Template Versions
		S_CL_ACT_EXC_LS	Clinical Protocol Site Activity Exceptions
		S_CL_PYMNT_LS	Clinical Payments
	EIM_SBJ_TMPL_LS	S_SUBJ_TMPL_LS	Subject Templates
	EIM_SBJ_TMPL_LS	S_SBJTMP_VER_LS	Subject Template Versions
	EIM_TMPL_PLNITM	S_TMPL_PLAN_ITEM	Subject Template Visits
Companies	EIM_ACCOUNT	S_ORG_EXT	Organization
		S_ACCNT_POSTN	Position for Account
		S_ADDR_ORG	Account Addresses
		S_ORG_REL	Account Affiliations
	EIM_ACCOUNT1	S_ORG_EXT	Organization Only User Key
		S_ACCNT_CLS_RNK	Account Ratings and Rankings
		S_ACCNT_MED_PROC	Account Medical Procedures
		S_ACCNT_MED_SPEC	Account Medical Specialties
Contacts	EIM_CONTACT	S_CONTACT	Contacts
		S_ADDR_PER	Contact Addresses
		S_CONTACT_REL	Contact Affiliations
		S_PER_ORG_UNIT	Contact to Account Affiliations and Roles
		S_STATE_LIC_LS	Contact State Licenses
	EIM_CONTACT1	S_CONTACT	Contacts Only User Key
		S_POSTN_CON	Contact Positions
		S_CON_ADDR	Contact Address Usage
	EIM_CON_DTL	S_CONTACT	Contacts Only User Key
		S_CONTACT_LSX	1:1 Contacts Extension Table
		S_CONTACT_LSXM	1:M Contacts Extension Table
		S_ACCNT_CON_ATT	Accounts Contacts File Attachments
		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
		S_ME_EVT_POS_LS	MedEd Event Positions
		S_ME_EVT_PRD_LS	MedEd Event Products
		S_ME_EVT_INV_LS	MedEd Event Invitees
	EIM_ME_PLN_LS	S_ME_PLN_LS	MedEd Plans
		S_ME_PLN_MDF_LS	MedEd Plan Funds
		S_ME_PLN_PRD_LS	MedEd Plan Products
	EIM_ME_SES_LS	S_ME_SES_LS	MedEd Sessions
		S_ME_SES_PRD_LS	MedEd Session Products
		S_ME_SES_INV_LS	MedEd Session Invitees
		S_ME_SES_LIT_LS	MedEd Session Literature
		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
	EIM_CONTACT2	S_CONTACT	Contacts Only User Key
	EIM_CONTACT2	S_CAMP_CON	Target Contacts for Objective
	EIM_SRC	S_SRC	Objectives
	EIM_SRC	S_SRC_POSTN	Objective Positions
Products	EIM_PROD_INT	S_PROD_INT	Products-Details, Samples, Markets, Lots, and Promotional Items
	EIM_PROD_INT1	S_PROD_INT	Products
		S_PROD_POSTN	Personal Product List
		S_PROD_REL	Product Relations
Samples	EIM_SAMPLE_LS	S_SAMPLE_TXN	Sample Transactions
	EIM_SAMPLE_LS	S_MPL_TXN_ITEM	Sample Transaction Item
	EIM_POSITION	S_POSTN	Positions
		S_STOCK_POSTN	Stock Inventory by 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 Table 24:

Siebel Life Sciences Guide		Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices.