Setting Up the Field Definition Table

To set up the Field Definition Table, use the Field Definition Table (INTRFC_FIELD) component.

Page Name

Definition Name

Usage

Interface Field1 Page

PI_FIELD1_PNL

Set up third-party payroll system fields.

Interface Field2 Page

PI_FIELD2_PNL

Set up corresponding PeopleSoft fields.

Use the Field Definition Table component to define the data type and format of the fields that appear in the export file. Any field that is identified in the PS Tables component can be added to the Field Definition component.

Note: The Field Definition Table component and the Definition Table component contain effective-dated entries. You must keep these components synchronized. Be sure that future-dated rows in the Field Definition Table component are not referenced in the Definition Table component before their effective dates. Also, if you mark a field inactive in the Field Definition Table component, be sure that the field is no longer included in the Definition Table component.

See Working with Key Fields.

Use the Interface Field1 page (PI_FIELD1_PNL) to set up third-party payroll system fields.

Navigation

Set Up HCM > Product Related > Payroll Interface > Interface Controls > Field Definition Table > Interface Field1

Image: Interface Field1 page

This example illustrates the fields and controls on the Interface Field1 page.

Interface Field1 page

Field Definition

Field or Control

Definition
Process Type

Select the Payroll Interface process.

Note: Exp/Imp (export/import) can be used as the process type only if the characteristics of the field are the same for both import and export. Otherwise, you need to set up records for each process type. The Employee ID field is the only field that is mapped as both an export and import type; you do not need to define a PS record or field name for it.
External Field ID

If the System Table - Interface System Table 1 page, External Field ID Indicator option is selected, the external field ID becomes by default the value that you enter here. The external field ID can be up to 10 characters.
Type

Select from the following options:

  • Character

    Use the Justification field to specify whether characters are left or right justified.

    Note: When you are mapping from a large field to a smaller field, the results are truncated. For example, if you map '0123456789' from a 10-character field to a 7-character field, the result is '0123456'.

  • Date

    Use the Date Format field to specify the third-party payroll system's date format.

  • Number

    Use the Display Decimal andDecimal Char (decimal character) fields to specify a decimal separator.

  • Signed

    Use the Sign Position field to select the placement of the sign for signed numerical fields.

  • Value

    Select to specify a predefined data item for the Text field. For example, with thePay Run ID field, enter Pay Run ID as the text. (Including Pay Run ID in the header record may help ensure that the correct file is processed.)

    If using the company filtering feature, use the Processing Company or Processing Pay Group values for the Text field.

    See Working with Company Filtering.
Text

Select to enter a translate value.

Note: This field is active only if you have selected Value in theType field.

See Working with Text Translate Values.
External Column Name

Select to enter a name of up to 50 characters if the Interface field is used in a delimited data file structure with a header. The system uses this name to construct the header record.
Default Value

If you use constant in the Text field, the value that you enter here is used.

You can also use a default value for the character type. For example, if the field is part of a header record, you can specify some fixed text as the default value.

Field Format

Use the options in the Field Format group box to define the file's field formats.

Field or Control

Definition
Field Length (in bytes)

For physical file formats, the length determines where the field will be positioned. When you are setting up the Interface Definition Fields page, you can view the exact character position of the field.
Integer Length

The system calculates the integer length to verify that you have set up a numeric field as intended.

For a signed field type, the system subtracts one position from the integer length to allow for the sign. Use Sign Position to specify where the sign goes.
Blank if Zero

This field is active only for number or signed field types. Select if the payroll system uses blanks in place of zeros.

Use the Interface Field2 page (PI_FIELD2_PNL) to set up corresponding PeopleSoft fields.

Navigation

Set Up HCM > Product Related > Payroll Interface > Interface Controls > Field Definition Table > Interface Field2

Image: Interface Field2 page

This example illustrates the fields and controls on the Interface Field2 page.

Interface Field2 page

Field Definition

Field or Control

Definition
PS Record Name and PS Field1 Name, PS Field2 Name, PS Field3 Name

Select the PeopleSoft record and field names that correspond to the third-party payroll system field. If the third-party payroll system field value is derived from multiple PeopleSoft fields, enter the additional field names as well.

Process ID

Select when a COBOL process is required to correctly translate or format a PeopleSoft value to a third-party payroll system value.

Note: Process IDs are defined on the Interface Process Table.
PI Translate Indicator (payroll interface translate indicator)

Select to specify how translate values are handled:

  • No Translate Values

  • Translate All

  • Translate or Use Default Value: Translate if a translate value is found; if not, use the default value that is defined on the Interface Field1 page.

  • Translate or Use PS Value: Translate if a translate value is found; if not, use the PeopleSoft value.
Instance ID

Select to control which values of a field should be mapped to the external payroll system.

Translate Values

Select to translate PeopleSoft field value PS Value 1 (and, if needed,PS Value 2 and PS Value 3) tothe third-party payroll system value, PI Value. For example, if DEDCD (deduction code) is KUDEN9 and DED_CLASS (deduction class) is B (before tax), then the translated value is D1.

Translate values are available for all export fields and for the Currency Code field for import.