< back

Plan Codes (Master Plan only)

KEY TOPICS:

  • Add Plan Codes
  • Import Plan Codes
  • Determine Job Group Structure
  • Use other Plan Code List Tools

Identify Sub plans by using Plan Codes

If you chose to create Multiple Plans, under Create Plan:

  • The Plan Codes screen will automatically display.
  • A menu item for Plan > Plan Codes will display in the side navigation menu for access.

About Plan Codes

If your organization prepares multiple plans, they may be organized as a set, comprised of an overall Master Plan and including sub plans for location (and/or function). A Plan Code serves as the identifier for each sub plan (and, as applicable, each Functional Plan). The Plan Code list, which can be developed by adding or importing Plan Codes, must be established before importing data into the Master Plan.

Add Plan Codes

Choose the [Add] button from the upper toolbar. When Plan Code information is complete, click [Save] at the bottom of the page. Repeat the process to add further sub plans to the Plan Code list, as necessary.

Enter Required Information

From the Add Plan Code menu, enter the following information:

  • Plan Code— Enter a simple, unique identifier for each sub plan.
  • Company — Retain the default entry from the Master Plan, or enter a different name to appear on reports.
  • Establishment — Enter the establishment name (e.g., "Vienna, VA").

Enter other Location Information

Enter optional information, which will also assist in determining Recruitment Areas:

  • City
  • State
  • County
  • Reasonable Recruitment Area — If provided, entry must match a census statistical area so that plans can be tied to these areas.
  • Zip — Plan Zip codes may be used to build Recruitment Areas.^ Zip codes are also necessary to display the Map view of AAP locations on the BALANCEhub DASH.

^To turn on this setting, see: Create Plan.

Cross-reference: For more information on the end use of these fields, see: External Availability and Recruitment Area Wizard

If the sub plan is not location-based (per OFCCP agreement), check the box for: Functional Plan. If checked, the BALANCEhub DASH will display a corresponding Metrics object.

Import Plan Codes

Use the [Import] button to bring in a list of Plan Codes and corresponding information.

Select the import type, either External File or Existing balanceAAP Plan. If Existing balanceAAP Plan is chosen, select Company, Establishment, and Plan from the drop-downs. Then click [Next].

Import from External File

For the External File, choose the file type:

  • Microsoft Excel (.XLX, .XLSX)
  • Microsoft Access (.MDB)
  • Text (.TXT)

If the incoming file does not contain column headers, uncheck the box for: First Row Headers.

Click [Browse], locate and highlight the file, and click [Open] to add the file to the Upload file list. Click [Next].

Excel users — From the Plan Code menu, select the Excel sheet that contains the Plan Code table. Then, under Match Fields, select the columns in the Excel sheet that correspond to the balanceAAP columns. Review the Preview of Data at the bottom of the page. Click [Next].

Click [Import Plan Codes] to complete the process. The codes will be added to Plan Code list.

Determine Job Group Structure by Plan or Sub plan

Once a Plan Code list is created, the Job Group column will be populated with the default Job Group structure: Corp. The Corp structure suits an organization or location whose staffing numbers warrant breaking up EEO categories by level (e.g., 1A, 1A, 1C).

The alternate option is: EEO. This structure suits an organization or location with a limited number of employees.

Change the structure by clicking the Job Group column entry for a particular sub-plan. From the pop-up menu, select the desired structure. Click [Save] to apply the change.

The Job Group structure will be important later, when census coding is applied, during this step: Establishing External Availability in a Master Plan

Use other Plan List Tools

Search for a Plan Code

To reduce the Plan Code display, enter text in the Search field, and click the search icon Search icon.

Click [Clear] to return display to the full Plan Code list.

Edit a Plan Code

Click the [Edit] icon adjacent to a Plan Code.

Quick Tip: If you have imported a Plan Code list that includes codes for Functional plans, edit one or more Plan Codes to identify those plans.

Delete Plan Code

To delete a Plan Code, check the box next to the plan to be deleted, and click the [Delete] button.

Important Caution: Because data records with the assigned Plan Code will be moved from the Data Tables to Errors, delete a Plan Code only if:

  • No data are currently assigned to the Plan Code.
  • Data will be moved to a new or existing Plan Code. Once the target sub plan is identified, access Data > Errors to update the affected records.
  • Data for the Plan Code are to be deleted. You can also access Data > Errors to delete the data.