Competencies

The competency view object provides information about competencies, which are references to existing lists of values. For example, Product, Category, Language, Region, Severity. Some competencies can have one list of values, some can have a parent child combination of two lists of values. This means some competencies are codependent and others are independent.

Data Store Key : CrmAnalyticsAM.ServiceExtractAM.SvcMgmtBiccExtractAM.CompetencyExtractPVO

Primary Keys : CompetencyId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
CanBeRelaxedFlag	Indicates whether the competency can be relaxed.
CanHaveProficiencyFlag	Indicates whether the competency can have a proficiency.
CompetencyId	The unique identifier of the record. This is the primary key for the view object.
CompetencyName	The name of the competency such as Product, Category, Language, Region, and Severity.
CompetencyNumber	The alternate public unique identifier of the record. This is the secondary key for the view object.
CreatedBy	The user who created the row.
CreationDate	The date and time when the row was created.
DataAttribute	Indicates which attribute from the source contains the competency value that will be stored in the skill.
DataDisplayAttributes	Indicates which attributes from the source contain the competency details that will be displayed to the customer.
DataSource	The path to the entity object or the name of the standard lookup.
DeletedFlag	Indicates whether the record is logically deleted.
LastUpdateDate	The date and time when the row was last updated.
LastUpdateLogin	The session login of the user who last updated the row.
LastUpdatedBy	The user who last updated the row.
ObjectVersionNumber	The number of times the row has been updated.
OriginalSystemReference	The alternative identifier in the original reference system, which may not be unique.
ParentCompetencyId	The unique identifier of the codependent competency record.
ParentFilter	The name of the filter to be used to display only some competency values based on the value selected in the parent competency
Priority	The order in which the competencies should be relaxed.
SeedDataSource	The source of seed data record. A value of BULK_SEED_DATA_SCRIPT indicates that the record was bulk loaded. Otherwise, specifies the name of the seed data file.
WorkObjectAttribute	The identifier of the work object field name.