Share this page

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

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: