Mapping Oracle Real-Time Scheduler Expertise to Siebel CRM Skills

The SBL_Expertise_Code_Definition DVM stores the proficiency values that a skill supports. You must map any value that you define in the SBL_Expertise_Code_Definition DVM to the EXPERTISE_CD list of values in Siebel CRM.

Columns You Use to Map Skills

To map a skill, you use the following columns:

  • Column 1: Expertise Code

  • Column 2: Relative Value

Relative Values Determine Expertise Ranking

The relative value determines expertise ranking. For example, if an Expert must possess a higher proficiency than a Novice, then Expert must include a higher integer value than Novice.

DVM Entries That Map a Skill

The following table lists entries that are predefined in the SBL_Expertise_Code_Definition DVM. One record must hold the Expertise Code as Default_Expertise. The Relative Value for this should be either NOVICE, INTERMEDIATE, or EXPERT. Another record must hold the Expertise Level as Default_Expertise_Level.The Relative Value for this should be any expertise level other than 0. Value 0 will be considered as no skill level and should not be used.

Expertise Code Relative Value

Default_Expertise

Novice

Default_Expertise_Level

1

Novice

1

Intermediate

2

Expert

3

Examples of Mapping a Skill

Expertise Code Relative Value

Default_Expertise

Novice

Default_Expertise_Level

1

Novice

1

Intermediate

2

Expert

3

Incorrect Example 1

Expertise Code Relative Value

Novice

1

Intermediate

2

Expert

3