For Oracle's Siebel Applications customers, the table 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 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 must create an extension table. For instructions, refer to the documentation about configuring tables and columns for Oracle's Siebel business applications.
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 |
|
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 |