Map the Payslips upload to Payroll Line

  1. On the Payroll Configure page, in the Mapping from Upload File to Payroll Lines section, select New.

    Sage People displays the Map Upload File to Payroll Lines and Items page.

  2. Complete the fields as follows:
    FieldDescription

    Upload Map Name

    The name of the field in the upload file.

    Payroll Line Field

    Picklist. The name of the field in the Payroll Line object you want to use to map Upload Map Name.

    Select the picklist and choose the field.

    If the field is not supplied by default with Payflow you can add it as a custom field.

    Payroll Line Item Field

    Picklist. The name of the field in the Payroll Line Item object you want to use to map Upload Map Name.

    Item Code

    Leave blank.

    Staging Field

    Leave blank

    Type

    Picklist. The type of data this field contains. Select the picklist and choose from:

    • String
    • Date
    • Number
    • Email
    • Boolean

      Not added by default to the picklist. To add Boolean to the picklist:

      1. Go to Setup > App Setup > Create > Objects and select the Upload Map label.
      2. In the Custom Fields & Relationships section select the Type Field Label.
      3. Scroll down to the Picklist Values section and select New.
      4. Add the picklist value Boolean and select Save.

      Boolean is added to the picklist for the Type field.

    Format

    Picklist. The format of the data this field contains. This is a dependent picklist with the content determined by the Type selected.

    Select the picklist and choose the format for the data.

    Data of type Email has no selectable format; the field is expected to contain a valid email address of the form:

    <local_part>@<domain_name>

  3. Select Save.

    Sage People displays the Payroll Configure page.

  4. Repeat to map all fields in the upload CSV file you want to use in Sage People.