Database System Elements

Database system elements contain payee-related data that is retrieved from HR and commonly used in pay calculations. You don't have to set up these elements or do anything special to resolve them. They are resolved when they're used in a calculation.

These HR tables populate database system elements:

  • PERSON.

  • PERS_DATA_EFFDT (personal data effective date).

  • PER_ORG_ASGN_VW.

  • JOB (including fields from country-specific sub records).

  • PER_ORG_ASGN (person organizational assignment).

  • PER_ORG_INST (person organizational instance).

  • ADDRESSES.

  • CONTRACT_DATA.

  • WKF_CNT_TYPE (workforce contract type).

See Working with System Elements.

Using Address Related System Elements

HR can store several different addresses for a payee. In Global Payroll, you can specify which of these addresses you want the system to use. You do this through the use of a formula and a database system element called ADDRESS TYPE.

When you run the payroll process, the system retrieves the address that was effective as of the end date of the segment or slice.

Note:

The batch process truncates data that is retrieved by system elements when the data exceeds 30 characters (for character fields) or 12.6 (for numeric fields). For example, system elements for the ADDRESS fields can contain up to 55 characters; however, the system truncates the last 25 characters of data during the batch process.

To identify which payee address you want the system to use:

  1. Create a formula that assigns the appropriate character value to the system element ADDRESS TYPE.

    For example, your formula might assign the value HOME to ADDRESS TYPE.

  2. Add the formula to a section of the process list.

Note:

You can view the different address types on the Personal Address Type Table page, which can be found under Set Up HCM, Foundation Tables, Personal, Personal Address Type.

See Application Fundamentals: Defining Personal Address Types.