Creating a set

To find values on the Selection Criteria and Extraction Columns pages, use the sort and filter features that are available for each grid.
  1. Select System Administrator > Administration > Mass Maintenance.
  2. Click Create.
  3. Specify this information:
    Set Name
    Specify a unique alpha-numeric value to identify the set.
    Table Name
    Select the database table from which to extract records. If you do not have the security to access a function, the related table is not available in the field. If you specify an existing set in the Copy Set Name field, the table name associated with the set is displayed.
    Description
    Specify a description that identifies the purpose and content of the set.
    Report Count Limit

    Specify a value to limit the number of records to extract. Leave the default value to set no limit. The maximum number of records that you can extract is 100,000.

    Note: If more than 100,000 records are available for extraction, a warning is included on the SA Mass Maintenance Utility Report. You can create another set to extract the additional records.
  4. To copy the Selection Criteria and Extraction Columns from an existing set, specify the existing set in the Copy Set Name field.
  5. Click Next.
  6. To select records to include in the set, select fields and then specify values to establish parameters. Use the Data Type and Format columns to determine the values that you can specify. You can specify these parameters:
    Single value
    Specify the value in the Beginning Value and the Ending Value fields. For fields with logical values, such as yes or no, specify the value in the Beginning Value field only.
    Range of values
    Specify the range in the Beginning Value and Ending Value fields.
    Multiple values
    Specify the values in the Comma Separated List field. Separate the values by commas.
    Greater than or equal to value
    Specify the value in the Beginning Value field. Leave the Ending Value field blank.
    Less than or equal to value
    Specify the value in the Ending Value field. Leave the Beginning Value field blank.
  7. Click Next.
  8. Select the columns to extract from the database table.
    To select a column, select a row and then click Select/Deselect.
  9. Click Next.
  10. Optionally, select a value in the Create Tab Delimited Output File field to create a tab-delimited file. If you select Send To Email, specify the email address.
  11. Specify printing information for the SA Mass Maintenance Utility Report.
    See information about printing reports in the online help.
  12. Click Finish.
  13. Review the SA Mass Maintenance Utility Report.