Workforce Ready Person Import Column Descriptions

Important Message:
This is very important information because this application contains several ID fields, such as Employee ID, Payroll ID, Badge ID... The Employee ID field in WFR maps to the Employee ID field and Payroll ID field in this application. This means when you are importing data from WFR, that WFR Employee ID field will populate or override values in both the Employee ID field and the Payroll ID field in this application. When integrating with Workforce Ready the Employee ID and the Payroll ID values must match. Preexisting customers who have differing values in the Employee ID and Payroll ID field, you must relocate the value that does not map to the WFR Employee ID field. The interface is designed to import new personnel with the option to create profiles not maintain personnel profiles. The import manager expires the old profile and starts the new profile on the date the import was processed which may or may not correlate with the date and time of the vacancy. This application is a staffing solution and primarily used to staff current and future vacancies or jobs. As such, it is important to keep personnel profiles accurate for the purpose of staffing to prevent personnel from missing a working opportunity as a result of having the wrong profile active, or the wrong primary phone number set during the target date of the vacancy.

Important Message:

This is very important information because this application contains several ID fields, such as Employee ID, Payroll ID, Badge ID... The Employee ID field in WFR maps to the Employee ID field and Payroll ID field in this application. This means when you are importing data from WFR, that WFR Employee ID field will populate or override values in both the Employee ID field and the Payroll ID field in this application.

When integrating with Workforce Ready the Employee ID and the Payroll ID values must match. Preexisting customers who have differing values in the Employee ID and Payroll ID field, you must relocate the value that does not map to the WFR Employee ID field.

The interface is designed to import new personnel with the option to create profiles not maintain personnel profiles. The import manager expires the old profile and starts the new profile on the date the import was processed which may or may not correlate with the date and time of the vacancy. This application is a staffing solution and primarily used to staff current and future vacancies or jobs. As such, it is important to keep personnel profiles accurate for the purpose of staffing to prevent personnel from missing a working opportunity as a result of having the wrong profile active, or the wrong primary phone number set during the target date of the vacancy.

Object Property in this application	Workforce Ready Report Column Name	Required Format in this application	Max Length	Description
Employee ID	*Employee Id	alphanumeric	30	The Employee ID field in WFR maps to the Employee ID field and Payroll ID field in this application. These values must match.
User ID	Username		40
Home Institution	Institution Abbrev.	alpha numeric	10	Sets the Home Institution for the person in an Institution Focus enabled database. When the Workforce Ready Person Import Report exposes the `Institution Abbrev.` and the abbreviation supplied matches an Institution abbreviation in this application then the Home Institution is set for the person being imported. *Available as of application 6.8.5+, and 7.1.1+
Person Status	Employee Status		n/a	Imports personnel based on Workforce Ready Employee Status. If a user is not active in Workforce Ready, the import sets the person as disabled in this application.
Badge	Badge		30
Rank	Cost Center Abbrev.		10	Workforce Ready contains six cost centers. IMPORTANT: You must identify the cost center that maps to a person’s job title and rename that cost center’s column header to Cost Center Abbrev.
Special Date	Date Hired	yyyy-MM-dd	n/a
First	First Name		n/a
Middle	MI		20
Last	Last Name		1
Birthdate	Date Birthday	yyyy-MM-dd	20	This application requires the date in the Workforce Ready report to be formatted as: yyyy-MM-dd.
Address 1	Address 1		40
Address 2	Address 2		40
City	City		40
State	State		2
Zip Code	Zip Code		20
1st Contact 2nd Contact 3rd Contact 4th Contact	One of: Home Phone Work Phone Cell Phone Email Secondary Email	Phone - ###-###-#### Email - _@_._	48	Used to map Workforce Ready contacts with contact methods in this application. IMPORTANT: Be sure to map the 1st Contact Method in this application with the primary contact in Workforce Ready for the purpose of staffing vacancies. Doing so, should prevent users from missing a working opportunity due to an inaccurate primary contact method.

Object Property Home Institution

The Workforce Ready column format required for the import to insert the home institution for the person must be typed as follows:

Institution Abbrev.

Import Behavior

Note the period at the end of the term Abbrev.
Max character length in this application is 10. The abbreviation of the home institution must be equal to or less than 10 characters.
If the home institution abbreviation supplied maps to several institutions in this application, the institution that sorts at the top of the list is used.
If the report exposes multiple institution columns, the import will use the first column found.

Object Property Rank (Cost Center)

The WFR Cost Center Abbrev. column must contain matching Job Title abbreviations; for example, BC=BC and bc=Bc (case insensitive). When importing new personnel a base profile will be created for the person using the job title specified in the Cost Center Abbrev. column. If a profile exists, then this application will expire the old profile one day before the target date of the import and starts the new profile on the date the import processed the record.

Object Property Contact Methods

Staffing Rules in this application globally target the contact methods in sequential order and based on timing, which means the opportunity’s time configured by customer business rules could expire before this application moves on to the next contact method. Most customers configure one primary contact for staffing to get through the list of candidates quicker. Therefore it is very important that the primary contact remains accurate in this application.

For example, if the import manager was used to insert new personnel only, and one of these new users supplies a new contact method for staffing purposes, this application will use the last primary contact supplied. If the Import Manager is then used to update that same person’s profile, the contact methods will change to Workforce Ready supplied contacts, that same person could miss a working opportunity due to a mismatch in primary contacts; this could result in an employee grievance if the employee was not informed to update their contacts in this application.