Changing data in a column

  1. Select System Administrator > Administration > Mass Maintenance.
  2. Specify the set name and other search criteria, and then click Search.
  3. Click Column Update.
  4. Specify this information:
    Column
    Specify the extraction column to change.
    Change Value
    Specify the new value.
    Search Type
    Select Replace to replace the existing value with the Change Value.
    Select Search and Replace to replace the Search Value with the Change Value.
    Search Value
    If you selected Search and Replace in Search Type, specify the value to search for.
    Row Selection
    Select All Rows in the Set to apply the change to all rows in the set.
    Select Range of Sequence #s to apply the change to only the rows that you specify in the Beginning Sequence # and Ending Sequence # fields.
    Beginning Sequence #
    If you selected Range of Sequence #s in the Row Selection field, specify the first record in the range.
    Ending Sequence #
    If you selected Range of Sequence #s in the Row Selection field, specify the last record in the range.
    Source Records to Be Created
    Select Update to apply the column update to new records that were added to the set through the import process. The new records must be included in the records to update, based on the selection criteria such Search Type and Row Selection.
    Select Ignore to exclude the new records from the update.
  5. Specify printing information for the SA Mass Maintenance Utility Report.
    See information about printing reports in the online help.
  6. Click Save.
  7. Review the SA Mass Maintenance Utility Report.