Share this page
DIM_SKILL
This table stores all the skill information.
Foreign Keys
This table does not have any foreign keys.
These skills can be associated with the resources. Different levels can be defined when a skill is associated with the resource.
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
SCD2 |
|---|---|---|---|---|
|
PK_SKILLS_ID |
Not Null |
INT |
System-generated identifier |
No |
|
MD_BUSINESS_KEY |
Nullable |
VARCHAR (1000) |
Primary key that is mapped to one or more source columns
|
No |
|
MD_ENTERPRISE_KEY |
Nullable |
INT |
Unique identifier for entity |
No |
|
SKILL_NAME |
Nullable |
VARCHAR (260) |
Name given to the skill record |
No |
|
DESCRIPTION |
Nullable |
VARCHAR (650) |
The text that describes this skill record |
No |
|
IS_ENABLED_FLAG |
Nullable |
VARCHAR(1) |
Indicates whether this skill is enabled |
Yes |
|
CATEGORY_CODE |
Nullable |
VARCHAR (255) |
Indicates the category of this skill related to |
Yes |
|
PARENT_SKILL_ID |
Nullable |
INT |
Unique identifier to the parent skill record in the same table. |
Yes |
|
PARENT_SKILL_BUSINESS_KEY |
Nullable |
VARCHAR (1000) |
Foreign key that is mapped to DIM_SKILLS
|
Yes |
|
PARENT_SKILL_ENTERPRISE_ KEY |
Nullable |
INT |
Unique identifier for foreign key
|
Yes |
|
SKILL_SEQ |
Nullable |
INT |
This column is used by hibernate to order the associated skills |
Yes |
|
IS_SKILL_FOLDER_FLAG |
Nullable |
VARCHAR(1) |
Indicates if the skill is a parent skill |
Yes |
|
MD_BATCH_ID |
Nullable |
INT |
ID of data batch |
No |
|
MD_PROCESS_ID |
Nullable |
INT |
ID of ETL process running on a specific task |
No |
|
MD_SOURCE_INSTANCE_ID |
Nullable |
INT |
Content pack ID of source instance |
No |
|
MD_CREATEDDATE |
Nullable |
DATETIME |
Date of the record being inserted |
No |
|
MD_DELETEDDATE |
Nullable |
DATETIME |
Date of the record being deleted |
No |
|
MD_LASTMODDATE |
Nullable |
DATETIME |
Date of the record being updated |
No |
|
MD_TRANSLASTIND |
Nullable |
VARCHAR(1) |
Flags whether it is the latest record after updated by SCD2 |
No |
|
MD_TRANSENDDATE |
Nullable |
DATETIME |
End date of the record being effective |
No |
|
MD_ACTIVESTATUSIND |
Nullable |
VARCHAR(1) |
Flags whether or not the old record is deleted |
No |
|
MD_HASH_CODE_SCD1 |
Nullable |
VARCHAR(40) |
(Only for dimension table) Hash code that is generated by SCD1 columns |
No |
|
MD_HASH_CODE_SCD2 |
Nullable |
VARCHAR(40) |
(Only for dimension table) Hash code that is generated by SCD2 columns |
No |
Projections
This table uses no projections.
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
SKILLS_ENTERPRISE_XREF_SEQ |
MD_ENTERPRISE_KEY |
|
SKILLS_KEY_LOOKUP_SEQ |
PK_SKILLS_ID |
|
SKILLS_HIERARCHY_SEQ |
PARENT_SKILL_ID |
