Competency Data Loader Field Reference

Use the reference table below to help you correctly format the competencies data you want to import via the Competency Data Loader.

Administrators with unrestricted access to the Competency Data Loader feature in System Roles (Manage Features > Competency Manager Features) can import competencies.

To import competencies, go to Manage Center > Talent > Competency Data Loader. 

Assigning and De-assigning Learning Modules to and from Existing Competencies

You must populate a row of values for each learning module you want to assign to or de-assign from a competency.

To assign a learning module to a competency, set Action to A, provide the ReferenceCode, the LearningModuleID and the appropriate settings for that module. You can only assign learning modules in the LMS catalog.

To de-assign a learning module from a competency, set Action to D, provide the ReferenceCode and the LearningModuleID.

Table: Competency Data Loader Field Reference

Field	Content (Corresponding Field in the Competency Page)	Data Handling
Action		A for Add, U for Update, D for Delete.
ReferenceCode	Reference Code	A unique reference code (maximum 85 characters). This field is mandatory.
Title	Title	Any text (maximum 85 characters). This field is mandatory when the Action is A.
Model	Model	Any text (maximum 50 characters). To assign the competency to a sub-model, enter the full path to the sub-model and separate levels with the / character. For example, Model/Sub-Model/Sub-Model.You can create new models and sub-models. If no model is specified, it defaults to General. The General model can be deleted, but it must exist if no model is specified in the data loader. If it has been deleted, the import fails.
Description	Description	Any text (maximum 6,000 characters). Enter *NONE* to clear.
Language	Language	The ISO code for the assigned language. For example, en, fr, fr_CA, es_ES. If no language is specified, it defaults to multi-language.
Active	Active	Y for Yes (option checked) or N for No (option unchecked).
ProficiencyLevelGroup	Level Group	An Existing Proficiency Level Group Name. If no proficiency level group is specified, the default proficiency level group is applied.
Training	Training	Y for Yes (option checked) or N for No (option unchecked).
TrainingAllLearningModules Completed	This competency requires that ALL of the assigned learning modules be completed.	Y for Yes (option checked) or N for No (option unchecked).
TrainingTargetLevel	The target level acquired is	An existing Proficiency Level Code.
TrainingNumberOfCompleted LearningModules	of the listed learning modules (including mandatory)	Any number no be greater than the number of assigned learning modules.
DeployAssessment	Deploy Assessment	Y for Yes (option checked) or N for No (option unchecked).
AdHocSelfAssessment	Ad Hoc Self-Assessment	Y for Yes (option checked) or N for No (option unchecked).
AdHocReviewerAssessment	Ad Hoc Reviewer Assessment	Y for Yes (option checked) or N for No (option unchecked).
AdHocAssessmentWaiting Period	Minimum x Day(s) of Waiting Period for Re-Ad-Hoc Assessment	Any number.
AdHocAssessmentWaiting PeriodUnit	Minimum x Day(s) of Waiting Period for Re-Ad-Hoc Assessment	D for day(s) or Y for year(s). If no value is specified, D is used.
AdHocAssessmentValidFor	Ad-hoc Assessment Expiry	N for Does not expire, R for Require assessor to specify, or Y for Expires from date of award.
AdHocAssessmentValidFor Number	Ad hoc assessment valid for	Any number.
AdHocAssessmentValidFor Unit	Ad hoc assessment valid for	D for day(s) or Y for year(s). If no value is specified, D is used.
LearningModuleID	Learning ID	Must be a cataloged learning module ID (maximum 85 characters).
LearningModuleMandatory	Mandatory (for Training)	Y for Yes (option checked) or N for No (option unchecked).
LearningModuleRevision	Revision	Any or Effective (maximum 10 characters). If no value is specified, Any is used.
LearningModuleValidFor	Valid for	Any number (maximum 85 characters). Enter *NONE* to clear.
LearningModuleValidForUnit	Valid for	D for day(s) or Y for year(s). If no value is specified, D is used.
LearningModuleTargetLevel	Target Level	An existing Proficiency Level Code.
GracePeriod	After a new revision of a mandatory learning module requiring the effective revision to be published, allow a grace period of x Day(s) before revoking the competency	Y for Yes (option checked) or N for No (option unchecked).
GracePeriodNumber	After a new revision of a mandatory learning module requiring the effective revision to be published, allow a grace period of x Day(s) before revoking the competency	Any number.
GracePeriodUnit	After a new revision of a mandatory learning module requiring the effective revision to be published, allow a grace period of x Day(s) before revoking the competency	D for day(s) or Y for year(s). If no value is specified, D is used.
RenewalPeriod	For mandatory modules, apply a renewal period and automatically re-enroll learners x Day(s) prior to module expiration	Y for Yes (option checked) or N for No (option unchecked).
RenewalPeriodNumber	For mandatory modules, apply a renewal period and automatically re-enroll learners x Day(s) prior to module expiration	Any number.
RenewalPeriodUnit	For mandatory modules, apply a renewal period and automatically re-enroll learners x Day(s) prior to module expiration	D for day(s) or Y for year(s). If no value is specified, D is used.
ApplyValidityPeriodFrom	During the renewal period, on completion of the learning module apply the validity period from	1 or 2. 1 = The date of completion of the learning module. 2 = The previous module expiration date. If no value is specified, 1 is used.
ReminderDaysBefore Expiration	Send reminder x day(s) before learning module expires.	Any number. Enter *NONE* to clear.
SendNotification	Send notification when this competency has entered the grace period or has been revoked.	Y for Yes (option checked) or N for No (option unchecked).

About the Competency Data Loader

Import Competencies