Derive Payment Sources Example

Use payment criteria to set up your rules to derive payment sources within a single TRU. The prepayments process uses the rules to identify the source bank information from the employee's TRU and any additional payment criteria you define.

This example uses department, but you can use other criteria, such as business unit.

Steps to Derive Payment Sources by Department

You want to pay employees in the Sales and Development departments from separate payment sources. You define the payment rules in organization payment method, create fast formulas get department names from HR and call the employees department names by Assignment ID, and create an element with the default payer information. The default payer element passes the department name as a run result value.

  1. Define the payment rules .in the Organization Payment Method page.

    • Add one payment rule for each department in the Payment Method Rules section, as shown in this table:

      Field

      Development Department

      Sales Department

      Tax Reporting Unit

      TRU 1

      TRU 1

      Payment Criteria

      Development

      Sales

      Payment Source

      Payment Source A

      Payment Source B

      Note:

      In the Payment Sources section, create the payment sources to use in the payment rules, if they don't already exist.

  2. Create the formula to get department names from HR.

    • Enter information on the Fast Formulas page, as shown in this table:

      Field

      Value

      On the Fast Formulas page, create the formula with values as shown in this table:

      XX_Employee_Department

      Formula Type

      Payroll Access to HR

      Description

      Formula to return the department of an employee.

      Effective Date

      01/01/1951

      Note:

      Enter the same date used to create elements during implementation.

    • In the Formula Text section, enter this content:

      Default for PER_ASG_ORG_DEPARTMENT_NAME is ' '
      l_dept_output = PER_ASG_ORG_DEPARTMENT_NAME
      Return l_dept_output
      
    • Click Submit.

    • Click Complete.

  3. Create the formula to get the departments for employees to use as payment criteria value.

    Note:

    This formula calls the department names formula to get employee department by Assignment ID, which are used to find employees values.

    • Enter information on the Fast Formulas page, as shown in this table:

      Field

      Value

      On the Fast Formulas page, create the formula with values as shown in this table:

      XX_Default_Payer_Payment_Criteria

      Formula Type

      Payroll

      Description

      Formula to use the returned Department database item as Payment Criteria input for Default Payer element.

      Effective Date

      01/01/1951

      Note:

      Enter the same date used to create elements during implementation.

    • In the Formula Text section, enter this content:

      Default for ASG_HR_ASG_ID is 0
      SET_INPUT('HR_ASSIGNMENT_ID', ASG_HR_ASG_ID)
      EXECUTE('XX_Employee_Department') /* Formula to retrieve the 
      Employee Department. */
      Emp_Dept = GET_OUTPUT('l_dept_output','Null')
      Return Emp_Dept
      
    • Click Submit.

    • Click Complete.

Create the Element to Derive Payment Source by Department

Create the Default Payer element with the Payment Criteria input value, and automatic element eligibility.
  1. Create an element on the Elements page using the Information primary classification and the values shown in this table:

    Field

    Value

    Name

    Default Payer

    Note:

    This name must match exactly. This name is how the application identifies any existing payment criteria.

    Reporting Name

    Default Payer

    Effective Date

    01/01/1951

    Note:

    Enter the same date used to create elements during implementation.

    What is the earliest entry date for this element?

    First Standard Earnings Date

    What is the latest entry date for this element?

    Last Standard Process Date

  2. Edit the new element to create an input value named Payment Criteria:

    • Click Input Values in the Element Overview section.

    • Select Create Input Values from the Actions menu.

    • Enter values as shown in this table:

      Field

      Value

      Name

      Payment Criteria

      Display Sequence

      10

      Unit of Measure

      Character

    • Click Save.

  3. Edit the new element to create element eligibility that is set to automatic entry:

    • Click Element Eligibility in the Element Overview section.

    • Select Create Element Eligibility from the Actions menu.

    • Enter Payment Criteria Element Eligibility in the Element Eligibility Name field.

    • Select Automatic entry.

    • Click Save.

  4. Edit the new element to create processing rules:

    • Click Status Processing Rules in the Element Overview section.

    • Select Create Status Processing Rules from the Actions menu.

    • Select XX_Default_Payer_Payment_Criteria in the Formula Name field.

    • Add a row in the Result Rules section using the values in this table.

      Field

      Value

      Result Returned

      EMP_DEPT

      Result Rule

      Direct Result

      Target Input Value

      Payment Criteria

    • Click Submit.