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 |
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 |
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 |
---|---|
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 |