The layout below can be used to import Positions into the HRIS. Column Headers must be provided in the import file and the order of the columns must match the order specified in the table below. The import file must have the same number of columns as indicated in the table below, as well.
General Information on Importing Data
For general information on importing data including supported formats and common questions see Imports Overview
Location of Data within HRIS
See Performance Management - Positions Overview
When is a Record Added vs Updated?
If an existing record is found using the key fields ([key]) identified below, the HRIS will update that record during import. Otherwise, a new record will be added.
| Column Header | Data Type | Max Field Length | Required | Notes |
|---|---|---|---|---|
| Position | Text |
<=250 |
Yes |
If a the Position is not found within the system, a new record will be added. |
| Location | Text | <=50 | ||
| Pay Type | Text | <=20 | Must be a one of the following: "Annually", "Monthly", "Bi-Monthly", "Weekly" or "Hourly". If left blank, "Annually" will be the default. | |
| Type | Text | <=20 | Must match existing Type in system. If left blank, "Full Time" will be the default. (Types can be setup by navigating to Settings >> Applicant Tracking >> Advanced Settings >> | |
| Pay Status | Text | <=20 | Must be one of the following: "Exempt" or "Non Exempt". If left blank, "Exempt" will be the default. | |
| Grade/Level | Text | <=50 | ||
| Code | Text | <=15 | ||
| Min Pay Range | Numeric | |||
| Mid Pay Range | Numeric | |||
| Max Pay Range | Numeric | |||
| Notes | Text | <=500 | ||
| Active | Yes/No | Must be one of the following: "Yes" or "No". If left blank, "Yes" will be the default. |