EMIS Staff Vacancy Report - Import Data

Use the EMIS Staff Vacancy Report - Import page to import Staff Vacancy records for a selected fiscal year from an Excel file (.xlsx or .xls).

1. On the EMIS Staff Vacancy Report page, select Import.

2. On the EMIS Staff Vacancy Report - Import page, download the sample Excel template from the link in the Information section and select OK. The default file name is Vacancy_Import_Sample.xlsx.

3. Refer to EMIS Staff Vacancy Report - Import Data - File Layout and populate the Excel file.

4. On the EMIS Staff Vacancy Report - Import page, select the Fiscal Year.

5. Select Choose File and navigate to the location of the Excel import file.

6. Select the file, then select Open.

7. Select Load, and then Yes.

Data Storage

Staff vacancy data is stored in a relational database table ohetbl_staffvac. This follows the existing EMIS schema design pattern:

• ohetbl_assign

• ohetbl_bldirn

• ohemis_prof