G Preconfigured Mappings for Siebel System Subject Area

This appendix describes the preconfigured mappings for the Siebel Applications system subject area.

This appendix applies to Siebel source systems only.

G.1 About Preconfigured Mappings for Siebel System Subject Area

For Oracle's Siebel Applications customers, Table G-1 describes the preconfigured mappings for the SA system subject area. Fields that are not available in the Siebel transactional database will default to values shown in the table.

• Overriding Defaults. You can add user-specific values for these fields, by creating an extension table to the S_USER table. to store the user-specific defaults for these fields. Additionally, you can change any of the default values. The metadata for the following logical table can be modified to include any physical extension table.

  SA User.(User)
  

  For instructions, refer to the documentation about configuring tables and columns for Oracle's Siebel Business Applications.

• Setting Provider Information. Typically, the cell phone and the fax numbers in the Oracle Business Analytics Warehouse do not contain a provider name. Therefore, the Pager will typically be a numeric value such as 555-483-3843. To append a provider to this address, use the following guidelines:

  • If the entire company has the same provider, then you can append the provider in the column mappings.

  • If users can have different providers, you need to create an extension table. For instructions, refer to the documentation about configuring tables and columns for Oracle's Siebel business applications.

Table G-1 Preconfigured Mappings for the User Table in the SA System Subject Area

Logical Column	Physical Table	Expression	Comments
Cell Phone		''	It might be mapped to S_CONTACT.CELL_PH_NUM if this field contains SMTP address.
Cell Phone Priority		''	Defaults to N
Display Name	S_CONTACT	"Real Time OLTP"."".SIEBEL.S_CONTACT_User.FST_NAME || ' ' || "Real Time OLTP"."".SIEBEL.S_CONTACT_User.LAST_NAME	First Name concatenated with Last Name
Email	S_CONTACT	EMAIL_ADDR
Email Priority		'HNL'	Defaults to N
Email Type		'html'	Defaults to HTML
Group Name	S_RESP	NAME
Handheld		''	Defaults to an empty string
Handheld Priority		''	Defaults to an empty string
Language		'en'	Defaults to 'en'
Locale		'en'	Defaults to 'en'
Logon	S_USER	LOGIN
Pager		''	It could be mapped to S_CONTACT.PAGER_PH_NUM if this field contains SMTP address
Pager Priority		''	Defaults to N
Time Zone	S_TIMEZONE	NAME