BRIDGE_SKILL_PROFICIENCY

This table stores all the relationship between skill and skill proficiency.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

DIM_ SKILLS

SKILL _ID

PK_ SKILLS_ID

DIM_RESOURCES

RESOURCE_ID

PK_ RESOURCES _ID

DIM_POSITIONS

POSITION_ID

PK_POSITIONS_ID

Column Descriptions

Column Name

Null?

Data Type

Description

SCD2?

PK_ BRIDGE_SKILL_ PROFICIENCY_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_ID

Nullable

INT

Unique identifier for which skill the proficiency applies

Yes

SKILL_BUSINESS_KEY

Nullable

VARCHAR (1000)

Foreign key that is mapped to dim_skills

 

Yes

SKILL_ENTERPRISE_KEY

Nullable

INT

Unique identifier for foreign key

 

Yes

PROFICIENCY_LEVEL_CODE

Nullable

INT

The code that indicates the skill level for a resource; for example, Level 1, Level 2, and so on.

Yes

PARENT_TYPE_CODE

Nullable

VARCHAR2 (30)

The parent type code is used to identify the type of entity using the proficiency, mostly it is RESOURCE.

Yes

PARENT_ID

Nullable

INT

Depending on the PARENT_

TYPE_CODE this column refers

to different entities. Mostly it

refers to DIM_

RESOURCE. MD_BUSINESS_KEY.

Yes

RESOURCE_ID

Nullable

INT

Unique identifier for which resource the skill is related to

Yes

RESOURCE_BUSINESS_KEY

Nullable

VARCHAR (1000)

Foreign key that is mapped to DIM_RESOURCES

 

Yes

RESOURCE_ENTERPRISE_KEY

Nullable

INT

Unique identifier for foreign key

 

No

POSITION_ID

Nullable

INT

Unique identifier for which position the skill is related to

No

POSITION_BUSINESS_KEY

Nullable

VARCHAR (1000)

Foreign key that is mapped to DIM_POSITIONS

 

No

POSITION_ENTERPRISE_KEY

Nullable

INT

Unique identifier for foreign key

 

No

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

SKILL_PROFICIENCY_ENTERPRISE_XREF_SEQ

MD_ENTERPRISE_KEY

SKILL_PROFICIENCY_KEY_LOOKUP_SEQ

PK_ SKILL_PROFICIENCY_ID

SKILLS_ENTERPRISE_XREF_SEQ

SKILL_ENTERPRISE_KEY

SKILLS_KEY_LOOKUP_SEQ

SKILL_ID

RESOURCES_ENTERPRISE_XREF_SEQ

RESOURCE_ENTERPRISE_KEY

RESOURCES_KEY_LOOKUP_SEQ

RESOURCE_ID

POSITIONS_ENTERPRISE_XREF_SEQ

POSITION_ENTERPRISE_KEY

POSITIONS_KEY_LOOKUP_SEQ

POSITION_ID