Preparing the CSV file for census data import

The census import task reads a file that contains the header records for the data to be imported. This topic describes the input file.

These six data elements are required for the CSV file and must occupy the first six, comma-separated positions:
  • TEAM NAME
  • DAY PART
  • DATE: In this format: yyyyMMdd
  • PATIENT COUNT
  • WORKLOAD CENSUS
  • LAST UPDATED DATE: In this format: yyyyMMdd

After the CSV file has been created, make note of the location. You will be required to specify the full path when you run the import task in Job Scheduler.

Optionally, customer-defined data can occupy positions 7-16 of the file. Check the mappings document to view the format. The name of the mapping document is: WFM ES WORKLOAD CENSUS MAPPING and is available from this location: Maintenance > System Administration > Interfaces > Mapping Definitions
Note: If you have multiple census workload import jobs, you can use the same CSV file for each. Each import job must be on a separate line in the CSV file.