< back

BalanceTRAK > Reports > Export (Data)

KEY TOPICS:

  • Choose Job Seekers or Requisitions
  • Determine Filters
  • Save an Export View
  • What Default Exports are Available?
    • Run a Default Export
    • Restore Defaults
  • Run an Existing Export View

Export balanceTRAK Data to Excel

Job Seeker and Requisition data can be made available in Excel for use outside of balanceTRAK, such as for inclusion in a federally required Affirmative Action plan (AAP) or for data research and follow-up.

Under Reports, choose Export from the side navigation menu.

Choose Job Seekers or Requisitions

Using the tab header, choose whether to Export:

  • Job Seekers
  • Requisitions

Determine Filters

Select a File Type to Export to, either:

  • Excel 97-2003
  • Excel 2007

    • OR

  • Text CSV (Comma Separated Values)

Save an Export View

Make selections from the Filter Options menu to hone in on particular Job Seeker data. Options may include those in the following categories:

  • Location, Establishment, Plan Code, Department, or other organizational unit
  • Requisition and/or Applicant Status
  • Posting Start Date, Employee Acceptance Date, and/or other date

Quick Tip: If no criteria are selected or entered within a menu, All is the default selection, creating more results. Any selections made will reduce the number of results.

Further filters are available under Job Seeker Fields and Requisition Fields to organize how the data will be displayed. In the exported file, each Job Seeker will represent a row, or line item, in the exported file. All checked Fields will display as columns, with the Field label as the column header.

When finished, click [Export], and [Open] or [Save] the file.

Requisition data may be exported for use outside of balanceTRAK, in Excel or text formats.

Access Reports from the side navigation menu; and then choose Export from the tab header. The Export Requisitions menu will display.

What Default Exports are Available?

Default Export views are available on the Export > Job Seekers tab, with preselected Filters that produce the most typically needed Job Seeker "snapshots":

  • Job Seekers
  • AAP Import
  • Hires
  • No Disposition Code
  • No Job Seeker Stage

Run a Default Export — Simply expand the tab's upper drop-down, on the right, and make one of the above selections.

The system Checked boxes will displayindicate the Filterscurrent menusettings configuration,for bythe checkDefault box.Export. Review, and edit as necessary. Then select the [Run Export] button from the upper toolbar.

Quick Tip: As described in this article, parameters for Application Date, Posting Start Date, and/or Posting End Date can be added to the Default Export to produce an Export for a particular time period.

Restore Defaults

ChooseTo return to the Default Export after Filters have been change, choose the [Restore Defaults] button from the upper toolbar.

Run an Existing Export View

Using checkboxes, determine whether to Export Requisitions with a Status of:

  • Pending
  • Open
  • Closed

Finally, click [Export], and [Open] or [Save] the file.