| id | title | date | version | lastAuthor | mimeType | links | source | wikigdrive | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
1EeSZUgogLCUZD4CFQgP3qTtmhXuvTUbD9TY7toefUAQ |
Create Employees File for Import |
2020-03-17T02:34:35.428Z |
45 |
text/x-markdown |
0008bcbb1563384efe0a28ada6f97e9432e65f10 |
This document explains how to import your existing employees into {{% system-name %}} .
What you will need:
- Spreadsheet software (Microsoft Excel or Google Sheets)
- Employees CSV File Example
- {{% system-name %}} end user with administrative rights
- The following table provides optional or required Field Names and Descriptions, as indicated by the Requirement column. Items marked as Best Practice or Optional are not required and may be left blank, or omitted entirely. Employee ID must be the first column in the CSV file. The order of the remaining fields does not matter.
| Field Name | Description | Requirement |
| Employee ID | This field will be used for looking up the chart to insert or update. | Required |
| Birth Date | Employee Date of Birth. Date format should be YYYYMMDD or MM/DD/YYYY. | Required |
| Last Name | Employee Last Name | Required |
| First Name | Employee First Name | Best Practice |
| Email Address | Employee Email Address | Best Practice |
| Position Title | Employee Job Title | Best Practice |
| Employee Work Status | Employee Status (See Specification for Valid Codes) | Best Practice |
| SSO ID / Username | Username used for Patient Portal / Single Sign-on (SSO) | Best Practice |
| Badge ID | The ID used at Check-In kiosks. This is typically the number from an ID card or RFID chip, used at the Check-In kiosk, in a clinic waiting room. If Check-In kiosks are part of the {{% sys-name %}}' deployment, this field is required. Otherwise, this field should be skipped. | Best Practice |
| Supervisor ID | Supervisor Employee ID | Best Practice |
{{% tip %}} For a more comprehensive list of supported fields, please refer to the Human Resources Feed Fields Specification. {{% /tip %}}
- Using the table, above, determine the data to be imported. Starting with the Employee ID field, enter all required and desired data, verifying required data is present. Note that each row represents an employee record. Below is a screenshot of the Employees CSV File Example for guidance.
- Save the file as CSV format.
- Login as a user with administrator rights.
- Navigate to the Control Panel from the side menu.
- Select the Data Import tab.
- Select Chart Data CSV API from the drop-down menu and click Go.
- Select the Employees CSV File and click Upload.
{{% tip %}} For extra information on what happens during the import, click the Verbose* checkbox.* {{% /tip %}}
- Human Resources Feed Fields Specification
- Employees CSV File Example
- Validation script for Employee demographics
Ensure that all of the fields marked as Required have valid content. The file uploaded must be saved as a CSV formatted file. In case of any errors, contact Technical Support.