key tables in Siebel
There are a large number of tables in Siebel (over 3,000). Unsurprisingly, this can be intimidating to an Oracle DBA who is new to Siebel.
However, a number of these tables are solely used to load data into the Siebel database.
Enterprise Integration Manager (EIM) is the Siebel interface to load, update, and delete data in Siebel. EIM uses a set of interface tables which are populated and processed.
EIM table names are always prefixed 'EIM_' and there are 683 EIM tables in Siebel 7.8.
The core tables of interest are known as base tables and are prefixed 'S_'.
Precisely which base tables will be used is highly dependent on your business and application. The Siebel data model supports vertical industries (Pharmaceuticals, Banking, Public Sector, Automotive).
The key Siebel tables include:
- S_ADDR_PER (Address)
- S_CONTACT (Contact)
- S_BU (Division)
- S_EVT_ACT (Activity)
- S_ORG_EXT (Account)
- S_OPTY (Opportunity)
- S_POSTN (Position)
- S_SRV_REQ (Service Request)
The data model includes various related intersection tables used to model M:M relationships.
- S_ACT_EMP (Activity-Contact)
- S_CON_ADDR (Address-Contact)
- S_POSTN_CON (Position-Contact)