Use the reference table below to help you correctly format the competency expiry data you want to import via the Competency Expiry Data Loader.
Administrators with unrestricted access to the Competency Expiry Data Loader feature in System Roles (Manage Features > Competency Manager Features) can import competencies.
To import competencies, go to Manage Center > Talent > Competency Data Expiry Loader.
Table: Competency Data Loader Field Reference
Field | Content | Data Handling |
UserID | User ID | The User ID of the learner with the competency. |
CompetencyCode | Reference Code | This is the Reference Code of learner's competency you want to update the expiry date for. |
LearningID | Learning ID | Module ID of learning module in the specified competency you want to update the expiry date for. If the learner has more than one module expiry date recorded against the specified competency, this row in the CSV file is ignored. |
Expiry | Expiry |
One of:
Where dd can be replaced by the number of days (up to 9999) after the module completion or ad hoc assessment for expiry, y can be replaced by the number of years (max 100) after module completion or ad hoc assessment for expiry, and yyyy-MM-dd HH:mm:ss can be replaced by a fixed date for expiry in the yyyy-MM-dd HH:mm:ss format. |
AssignmentID | Assignment ID. This is mandatory only if the learner has more than one job assigment. | The Assignment ID of the specified User ID. |
Additional Information