Upload Workforce Structures Using a Spreadsheet
Using a spreadsheet, you can upload multiple objects at a time, for the following workforce structures:
-
Jobs
-
Locations
-
Departments
For example, to upload multiple jobs at a time:
-
Select Manage Jobs in the Workforce Structures work area
-
Display the Create menu
-
Select Create in Spreadsheet
Uploading Using a Spreadsheet
For each workforce structure, you can do the following:
-
Download a predefined spreadsheet template from the application
-
Work on the spreadsheet offline, and upload the spreadsheet to the application when your changes are complete
-
Upload the spreadsheet multiple times to accommodate revisions
Effective Start Date
Ensure that the effective start date of the workforce structure is same as or earlier than the hire date of persons associated with the workforce structure; for example, enter a job start date earlier than the hire date of persons associated with the job. You may want to consider creating all objects as of a common early date, for example, create all locations with the start date 1-1-1950.
Entering Descriptive Flexfield Values
Use the Attribute columns in the main sheet to enter values for the descriptive flexfields that are already defined for the object. Use the DFF Reference sheet to understand which attribute columns map to which descriptive flexfields, since this information isn't displayed in the main sheet.
Uploading Jobs Using a Spreadsheet
When uploading jobs using a spreadsheet, you:
-
Can't create a new job profile
-
Can only associate an existing job profile
-
Must enter the name of an existing job profile in the spreadsheet