Resizing Currency Fields by Using the International Field Size Utility

PeopleSoft applications are typically shipped with amount fields that are sized at 15 integer positions and 3 decimal positions. However, some older applications may be shipped with smaller field sizes, and to use a greater precision, you may need to run the International Field Size utility when you install your PeopleSoft system. If the PeopleSoft installation guide for your product requires it, use the Application Engine program Set International Field Sizes (TLSINST1) to increase the length and number of decimal position settings of field definitions. For example, you may need to do this if you process low-value currencies that require numeric fields that are longer than those that are provided in the standard application.

PeopleTools is delivered with the International Field Sizes table (PS_INTL_FLDSIZ_TBL) populated with suggested lengths for numeric fields that may require a large number of digits for certain currencies. You can edit the contents of this table to suit your own requirements, adding and deleting fields and adjusting the new field sizes and decimal positions as necessary.

Keep in mind the limitations on numeric field size and precision imposed by your database platform, and the fact that some numeric fields are used in COBOL and may require COBOL working storage changes in addition to the changes performed by this utility.

To resize international currency fields:

  1. Start the PeopleTools International Field Size utility.

    Select PeopleTools > Utilities > International > Process Field Size to display the International Field Size page. The International Field Size page shows the name of each field that will be adjusted, the current size of the field, and the proposed new size of the field (stored in the International Field Sizes table).

  2. Edit the data in the International Field Sizes table.

    Adjust the new field sizes to meet your own requirements. You can insert or delete rows from the page.

  3. Save your changes.

  4. Run the Process Request Dialog.

    To do this: click Run to open the Process Scheduler Request page. Set the report options, and then click OK to run the Set International Field Sizes process.

    The utility updates the field definitions and creates a report showing all page fields that have been affected by the changes in field size.

  5. Check all affected pages, and rearrange page fields as necessary to rectify overlaps.

    The process does not update page field information such as overlapping fields that may be caused by an increase in field length; however, the system automatically adjusts the sizes of any page fields with a size property of Average or Maximum. If the page field size is Custom, it is not adjusted. If the page field is too small, the larger amount can still be entered; however, users may have to scroll to the right to see the full amount, and the truncated amount may be misleading.

  6. Rebuild (SQL ALTER) any tables that have been affected by the changes in field sizes.

    Use the Application Designer Build feature, with the Alter Tables option, to build any tables (using SQL ALTER) that have been affected by the changes in field size. Use the Find Object References features to determine which tables have been affected, or create a query against the PSRECDEFN, PSRECFIELD, and International Field Sizes tables. For example:

    SELECT DISTINCT A.RECNAME
FROM PSRECDEFN A, PSRECFIELD B, PS_INTL_FLDSIZ_TBL C
WHERE A.RECNAME = B.RECNAME
  AND B.FIELDNAME = C.FIELDNAME
  AND A.RECTYPE = 0