< back

BalanceAAP > Data > Export Data

KEY TOPICS:

  • Include or Exclude Data forSelect Export (File) Options
    • Export Compensation Data for OFCCP
  • Select Tables for Export
  • Perform Export Data

Export Data for Use Outside the System

Available from Data > Advanced, Export Data allows Reference and Data Tables to be selected and exported into Excel or text formats.

The results of Batch Operations can also be exported; see: Batch Operations for Data

Select Export (File) Options

Select one of the following file types from the provided drop-down:

  • Excel 2007
  • Excel 97-2003
  • Text file

(Optional) Limit the data to codes in use by checking the box next to the tagline: Only include used codes (for Department Codes, Grade, Job Group, and Job Code tables).

Select Tables for Export

Set the [Custom view]. If a Data or Reference table already has a customized setting, a [Custom view ON] icon will be displayed to right of the table name.

Check off one or more tables you wish to export, and click [Export].

Note: Multiple tables will export as individual sheets in an Excel file, or as multiple text files, depending on the file type selected above.

Export Compensation Data for OFCCP

Cross-reference: This function can also be accessed in balanceAAP at: Reports > Select Reports > Data.

Check the box for:

Perform Export Data

Depending on the number of files and the amount of data, the Export Data process may take some time to complete. You may choose [Run in Background]. A Notification panel at the top of the page will provide a message when the process is complete (or click the Notifications icon in the header bar later).

Use the [Download] to save the exported file to your computer or network.

Quick Tip: The Notifications list stores recent data exports. To save time, use the notification icon Notifications icon instead of the [Export] button.

Export Compensation Data for OFCCP

Cross-reference: This function can also be accessed in balanceAAP at: Reports > Select Reports > Data.