Adding Values to the Translate Table
Access the Add Translate Table Value dialog box.
To add translate values to the Translate table:
-
From a field definition window, select
You can also right-click and select Field Properties, or press Alt+Enter.
-
From a record field definition window, right-click the field and select View Translates from the pop-up menu.
-
Select the Translate Values tab.
The Translate Values dialog box displays existing values for the field and enables you to add, change, or delete values. In the Last Updated box, you see information—date, time, and user ID—about the last update for the selected translate value.
-
Click Add to define a new value.
-
Enter the field value, effective date, long name, and short name that your users enter on the page.
Field or Control Description Field Value
Enter the translate value for the field. The system automatically sorts values in ascending order as you enter them. If you enter three translate values with field values A, T, and C, they appear in the Translate Values dialog box as A, C, T.
Effective Date
Enter the date on which you want this value to take effect. The default value is today’s date. If you want the effective date to predate all rows on your database, enter 01011900 (January 1, 1900).
Note: The Add button only allows you to add a new, distinct translate value. To add a different effective date for the same translate value, select the translate value and use the Change button. As long as the effective date is changed, the system saves the modified entry.
Inactive
When a value for a field becomes obsolete, you should select the Inactive check box rather than deleting the value. Deactivating a value enables fields in the database that still contain the value to use the correct long and short names. If you delete an obsolete code from the Translate table and you still have records in the database that contain that value, then you must change all of those values to active values.
Long Name
Enter up to 30 characters.
Short Name
Enter up to 10 characters. If you leave this field blank, the system automatically copies the first 10 characters of the long name into this field. Use mixed case to improve readability.
Note: The recommended character length of translate short name values is six. You can configure PeopleSoft Application Designer to alert you if the recommended length is exceeded.