Fieldname Information

The Translator generates fieldnames in the Master File from COBOL fieldnames using the following procedure:

  1. The Translator processes the Skip 'n' Hyphens option. It removes characters from the left, up to and including the nth hyphen (depending on the value of n you entered on the menu). It then either removes all remaining hyphens or replaces them with underscores, depending on the setting of the menu option Remove Hyphens or Use Underbars. Finally, if the Field Name Length option has been set to 12, the Translator uses only the 12 leftmost characters.
  2. If the name duplicates a previously-generated fieldname, a qualifier is added to make it unique. For example, given the following COBOL structure
  3. 02  EMPL-PORTION.
    03 SOC-SEC-NUM PIC 9(9).
    02 MGR-PORTION.
    03 SOC-SEC-NUM PIC 9(9).

    the Translator will generate SOCSECNUM from the first elementary fieldname and SOCSECNUM2 from the second elementary fieldname.

The following table illustrates the results of the possible combinations of menu options that control fieldname generation.

COBOL Fieldname: PAYROLL-REC-IN-FICA


Fieldname Length

Remove Hyphens or Use Underbars

Skip 'n' Hyphens


Generated Fieldname

12

Remove Hyphens

0
1
2
3

PAYROLLRECIN
RECINFICA
INFICA
FICA

 

Use Underbars

0
1
2
3

PAYROLL_REC
REC_IN_FICA
IN_FICA
FICA

30

Remove Hyphens

0
1
2
3

PAYROLLRECINFICA
RECINFICA
INFICA
FICA

 

Use Underbars

0
1
2
3

PAYROLL_REC_IN_FICA
REC_IN_FICA
IN_FICA
FICA


Information Builders