Spell Check System Dictionary

PeopleSoft PeopleTools provides personal and system-level dictionaries. End users and system administrators can add words to the dictionary for use with the spell check feature. Typically, system administrators add words to the system-level dictionary that are used company-wide; end users add additional role-specific terminology to their personal dictionaries.

Select PeopleTools, and then Utilities, and then Administration, and then Spell Check System Dictionary to access the system-level dictionary.

Select the All Languages page to enter words that are valid across all languages. Select the Language Specific page for those words that are valid to a specific language:

To add words to the system dictionary by language:

  1. Select Language Specific on the Spell Check System Dictionary page.

  2. Select the desired language from the Spell Check Language drop-down list box.

  3. Select Use session language from the Spell Check Language drop-down list box to add a word to the current session's spell check dictionary. After saving this word, the language field refreshes to the current spell check language.

  4. Enter the word (maximum 40 characters) that is to be added in the Spell Check Word field.

  5. Save your changes.

Case Sensitivity for Spell Check

The words that you add to your personal dictionary are case-sensitive and are validated by the following rules:

  1. If the added word is all lower case, such as worklist, then the following are considered valid:

    • Exact match, all lower case (worklist).

    • All uppercase (WORKLIST).

    • Initial capitals (Worklist), regardless of its position in the sentence. Mixed case (WorkList) is considered incorrect.

  2. If the added word is all uppercase, such as CRM (customer relationship management), then only an exact match is valid.

  3. If the added word is in initial capitals, such as California, then only an exact match and all upper case (CALIFORNIA) are considered valid.

  4. If the added word contains an embedded capital letter, such as PeopleSoft, then only an exact match is valid. Therefore, if case is not relevant to the validity of the word, use all lower case.

Table Structure for Word Storage

System and personal words are stored in the database in the PSSCWORDDEFN table with the following fields:

  • SCOPRID indicates whether a word is a system word or a user's personal word.

  • SCLANG stores the dictionary language for which the word is considered valid. If the system administrator chooses to store the word for all languages, this field is left blank.

  • SCWORD stores the actual word, with a maximum length of 40 characters.

  • SCNEGWORDFLG is a flag used to determine if a word is negative (incorrect) or not. Values can be 'N' or 'Y'. PeopleSoft does not currently use this feature, so the value should always be set to 'N'.

To load values in bulk into PSSCWORDDEFN:

  1. Using the method of your choice (as in a SQL script), issue SQL similar to the following:

    insert into PSSCWORDDEFN (SCOPRID, SCLANG, SCWORD, SCNEGWORDFLG)
values ('SYSTEM', 'SC00', 'nnn', 'N')

    Note:

    For each word you want to add to the library, you need a separate insert command, and the value 'nnn' will be changed in each of those insert statements to be the next value in the list of words you want to add.

  2. Add a value (any value) to the Language Specific tab and click Save.

    This alerts the runtime system to update the cached version of the PSSCWORDDEFN table.

Note:

In the current release, the maximum number of rows in the PSSCWORDDEFN table should not exceed 2,850.