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

Contnet 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