|
|
|
To access a csv file that contains all of the field names listed below, click here.
In order for the Import Learning Records function to be successful, you must enter a minimum of the following:
At least one of Employee ID, Employee Number, Last Name or First Name - something to uniquely identify the Employee
Task Name (and Task Level where appropriate)
Knowledge Completion Date and/ or Capability Completion Date
Data in all other fields is optional, however the column names themselves must exist.
Employee ID - This field must be unique in TRACCESS. It is the information that the Employee uses to enter the system.
Employee Number - Many companies have unique employee numbers for everyone in the organization. This number is often found in an HRIS or ERP system.
First Name, Last Name - In most Western cultures, everyone has both a first and a last name. However, in some Asian cultures, people may only have one name (or Asian companies may not use two name fields - rather enter their entire name into one field). For this reason, neither First or Last name is a required field in order for the Import Learning Records function to work. However, they may serve as a way of identifying a particular individual.
An employee can be identified by Employee ID or Employee Number or First Name or Last Name, or any combination of these. If you enter a single defining field in the import file (i.e., Last name = Smith), the import may return an error message that more than one record matches this information. To prevent this, try to provide as much unique information as possible.
Task Name - This field must be spelled exactly as it appears in TRACCESS. If spelling or spacing is slightly different, the application will interpret this as a different Task, and will not reflect the appropriate information. When entering the Task name in the import file, you may wish to cut/ paste the name directly from TRACCESS CI.
Task Level - This field only applies to a Task with Levels. If you wish to enter a completion date for a Task with Levels, you must enter the name of the Task (in the Task Name field), as well as the specific level in this field. By default, the only values that will appear in this field are Basic, Skilled and Mastery.
To verify the names that are used in your installation, select Tools/ System Options/ Language tab and click the Competence Level Labels button.
Assessor Name - Since the learning record information that your company possesses has likely been gathered over several years, the names of Supervisors or Management personnel who originally signed off on functionality may no longer be with your company. For this reason, the import learning records functionality allows you to enter the name of a person, regardless of if that person's profile exists in the database.
Assessor Employee ID - This field must be unique in TRACCESS. It is the information that the Supervisor (Management) used to enter the system.
Assessor Employee Number - Many companies have unique employee numbers for everyone in the organization. This number is often found in an HRIS or ERP system.
Knowledge Qualification Date - This is the date that the Employee completed the Knowledge component of the Task.
Knowledge Mark - This is the mark that the Employee obtained on the Knowledge component.
Knowledge Attempts - Enter the number of times it took before the Employee successfully completed the Knowledge component.
Capability Qualification Date - This is the date that the Employee completed the Capability component of the Task.
Capability Attempts - Enter the number of times it took before the Employee successfully completed the Capability component.
Comments - The information that you enter in this field is displayed in the Task Status History dialog/ Comments section. You may wish to use this as a tool to show that the Learning was obtained outside of TRACCESS and imported as a way of grandfathering learning information.
|
|
|
|
