Mass Maintenance

Template Role (Finish Columns) H

Template Role (Finish-Columns) V

Use this page to Register Tables for Download as a Finish Process.

To access this page:

  1. Click Mass Maintenance > Team on Navigation pane.
  2. Click Templates for a team.
  3. Click Roles for a template.
  4. Click Vertical View for the Post role.
  5. Click the Approve and Finish Settings tab.
  6. Click Finish Tables.
  7. Click the Source Filter Columns or the Target Filter Columns icon.

Field

Description

FILTER

Displays filter placed on the source or target database table to download specific columns.

Template Role (Finish-Columns) V (All Tabs)

Template Role (Finish-Columns) H

Use this page to Set a Filter Column and Use Custom Syntax.

This page contains the following tabs:

Column Filter tab

Field

Description

Column

Column Name

Displays name of column being filtered on when the table is downloaded from the source database during the Finish process. The column name contains the values to use for the Where clause.

Data Source ID

Displays name of the database that contains the table where the column is located.

Table Name

Displays name of the table that contains the column being filtered.

Mapped Value

Displays mapped value for the column. If a mapped value is selected, when the Finish process runs,Mass Maintenance selects all values from the mapped value binding on RequestID and RoleID (if they exists in the database object) and forms an IN statement for selection from the source to the target database.

Fixed Value

Displays the value used as the condition of the matching value for download.

Custom

If enabled, custom syntax can be entered for the finish process. These settings are used in the case that the schema cannot be determined for either the source or the target.

Custom Settings

Beginning Qualifier

Displays character placed around the values downloaded during the finish process when custom syntax must be used.

Ending Qualifier

Displays character placed around the values downloaded during the finish process when custom syntax must be used.

Separator

Displays character used for data values downloaded during the finish process when custom syntax must be used.

Where Statement

Displays format of the where clause. Mass Maintenance allows two dynamic substitution values to be used in the Where Statement: #ColumnName# is the name of the column and #Data# is the list of values separated by the character in the Separator field.

Where Clause Filter tab

Use this tab to Enter a Where Clause.

Field

Description

Manual Where Clause

Where Clause

Displays where clause used to limit columns downloaded during the Finish process.