When you sum the values of a numeric field and the resulting amount is too large to display, FOCUS will display the value as asterisks (*****). This may occur if you are summing data for a large span of time, if you are reporting on systemwide data, or even if you are reporting for a large campus.
In the example below, the designated format for gross pay (PH:GROSSPAY) is P12.2M. Translation: Packed decimal, 12 characters in length, displayed with 2 decimal places and a floating dollar sign. To view the format for a given field, refer to the CIRS Data Element Dictionary.
TABLE FILE PH
If the field to be increased is part of the verb phrase, you can change the length simply by specifying a new format immediately after the fieldname. In the example below, the length is changed from 12 to 16. Note: To change the length of a sort field, you must use a define. Refer to your FOCUS documentation for more information.
Warning! When you create hold files, be sure to verify the results before using the hold file as part of a match request. Otherwise, if your field lengths are not sufficient, the resulting data will be erroneous and FOCUS may NOT display an error message. For example:
ON TABLE HOLD AS PERMRPT
Number of records in table = 79159
To quickly verify the data in your hold file, execute a request that uses a wildcard. For example:
TABLE FILE PERMRPT
For more information on changing the length of fields, refer to your FOCUS documentation or to the material in the Basic CIRS Workbook.
Last Updated: October 2, 2006