Mass Maintenance

Template (External Request Scenario Column)

Use this page to Map Columns from the Template to Columns from the Excel File .

To access this page:

  1. Select Mass Maintenance > Team in the Navigation pane.
  2. Click Templates for a team.
  3. Click Vertical View for a template that uses an external request scenario to produce Excel-initiated requests.
  4. Click Configuration tab.
  5. Click External Request Scenarios.
  6. Click Vertical View for a scenario that has the EXCEL ALLOWED check box enabled.
  7. Click the Advanced tab.
  8. Click Map Sheet Columns.

Field

Description

COLUMN NAME

Displays the name of the table’s column in the template.

DESCRIPTION

Displays the description of the table’s column in the template.

STAGING COLUMN NAME

Displays, for an external request scenario that creates an Excel-initiated request, either the column name from the Excel file to use to map the values, or a fixed value to include for the column in the staging table.