SVC_RESOURCE_SKILLS_
Table that holds information about each agent's skills. An Agent can have one or more Skills, each with its own Proficiency level (if that Skill's Competency allows Proficiency). We may want to give the same skills to multiple agents at the same time, from UI, for example to all agents in one team.
Details
-
Schema: FUSION
-
Object owner: SVC
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
SVC_RESOURCE_SKILLS_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, RESOURCE_SKILL_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RESOURCE_SKILL_ID | NUMBER | 18 | Yes | Auto-generated number and primary key for this table. | |
| DELETED_FLAG | VARCHAR2 | 1 | Indicates whether this record is logically deleted (Y or N). | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| SKILL_ID | NUMBER | 18 | The identifier of the resource's skill. | ||
| RESOURCE_PARTY_ID | NUMBER | 18 | The identifier of the resource. | ||
| PROFICIENCY | NUMBER | 5 | The level of expertise of the resource for the current skill. | ||
| ORIGINAL_SYSTEM_REFERENCE | VARCHAR2 | 255 | Specifies the original system reference if record was imported. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Stores the Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SVC_RESOURCE_SKILLSN1_ | Non Unique | Default | RESOURCE_SKILL_ID, LAST_UPDATE_DATE |
| SVC_RESOURCE_SKILLS_PK_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, RESOURCE_SKILL_ID |
| SVC_RESOURCE_SKILLS_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, SKILL_ID, RESOURCE_PARTY_ID |
| SVC_RESOURCE_SKILLS_U2_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, NVL("ORIGINAL_SYSTEM_REFERENCE",TO_CHAR("RESOURCE_SKILL_ID")) |