Skills & Certifications CSV Field Desc.

The initial import of skills and certifications is performed using the import-skills and-certs -sample.csv format. Columns in the import skills and certs sample file link to fields in the person’s Skills and Certifications tab. If skills or certifications do not exist in the application, then the Import Manager will create these setup items if Create Setup records check box is selected in the Import Manager.

Customers using Dimensions must use Dimensions Integration to manage skills and certifications.

*=An asterisk in the table column name below denotes required data.

Skills and Certs Column Name	Format	Purpose
External ID	String	Contains an ID that matches a disparate system. Must be a unique sequence of characters. This optional ID is usually different than the Payroll ID and unique to the person. When utilized the External ID identifies the person for export. The import manager identifies users in this order: External ID, Payroll ID, Employee ID. Limitation: 40 characters.
Payroll ID	String	A required field that contains your organization’s person Payroll ID and used to identify personnel when importing or exporting data. Must be a unique sequence of characters. The import manager identifies users in this order: External ID, Payroll ID, Employee ID. Limit: 40 characters.
Employee ID	String	Contains your organization’s person Employee ID or Primary System ID. Must be a unique sequence of characters. The import manager identifies users in this order: External ID, Payroll ID, Employee ID. Limit: 40 characters.
Skills:Name	String	The Skills portion identifies the Display Name in the application or the short name. Followed by the Name portion which identifies the Skill Name in the application or the long name. For example, SPA:Spanish
Skills:Status	String	Whether the skill is active if enabled or inactive if disabled. Choices are: Active Inactive
Skills:Effective Date	Date	Used to indicate the start date this skill becomes active for the person and other areas of the application that query Skills, such as People Filter, and Rules.Format: mm/dd/yyyy
Skills:Not in Assignment	Boolean	Used to indicate the person has the selected skill and this skill for this person does not affect shift trades, which means this person may trade with someone who does not have the selected specialty. Choices are: True False Applicable Static Issues: Critical Cover specialties do not match. Critical assigned specialties not met. Critical assigned specialties not met exactly.
Certs:Name	String	The Certs portion identifies the Display Name in the application or the short name. Followed by the Name portion which identifies the Certification Name in the application or the long name. For example, DL:Driver License.
Certs:Proficiency	Integer	Used to indicate a value for the selected certification and add an additional layer of distinction amongst people who have the same certification. Also, used as a tie-breaker when qualifying people to fill positions. This is an optional field. Format: Integer, Limit: +/-32MM.
Certs:Number	Sttring	Used to add a certificate reference number. Limit: 2000 Characters.. For example: TY7869868X8980
Certs:Effective Date	Date	Used to indicate the start date this certification becomes active for the person and other areas of the application that query certifications, such as People Filter, Expiration Report, and Rules. If no effective date is defined then this certification is active through the Expiration Date definition. If neither the Effective Date nor the Expiration date are defined then this certifications is always active.This is an optional field. Format: mm/dd/yyyy.
Certs:Expiration Date	Date	Used to indicate the end date this certification becomes inactive for the person and other areas of the application that query certifications, such as People Filter, Expiration Report, and Rules. If no expiration date is defined then this certification is active as of the Effective Date. If neither the Effective Date nor the Expiration date are defined then this certifications is always active.This is an optional field. Format: mm/dd/yyyy.
Certs:Not in Assignment	Boolean	Used to indicate the person has the selected skill and this skill for this person does not affect shift trades, which means this person may trade with someone who does not have the selected specialty. Choices are: True False Applicable Static Issues: Critical Cover specialties do not match. Critical assigned specialties not met. Critical assigned specialties not met exactly.